Purchase Order Contrib help

[Guest]

I have installed the purchase order contribution but am unsure how to edit the database. I am new at this, so if someone could tell me how to edit the database properly I would be very grateful. I would be using phpmyadmin to do the changes.

 

 

HELP!!!!!!!!! :huh:

[loner]

I just added it to mine also it can be a little confusing.

 

As long as you edit the pages that is stated in the help files then update the database it works fine.

 

Open up the database tables then click on SQL query and paste the information below and it will add the tables to the databse

 

Add these 3 fields to table orders by running these lines in phpmyadmin or what ever you prefer.

# Add customers purchase orders values to each order

ALTER TABLE `orders` ADD `account_name` VARCHAR( 32 ) NOT NULL AFTER `currency_value` ;

ALTER TABLE `orders` ADD `account_number` VARCHAR ( 20 ) AFTER `account_name` ;

ALTER TABLE `orders` ADD `po_number` VARCHAR ( 12 ) AFTER `account_number` ;

[Guest]

Hey..... Thanks Ron, I will give it a try. Great !!!!!