Page 1 of 1

Average cost column on purchase order

Posted: Wed Jan 10, 2007 3:36 pm
by Paul
I would like to add an average cost column to my purchase orders so I can see what the average cost is as well as the last cost I bought the item for. In stock control database field "C" holds my average cost. Is this possible? Can a column be added like this?

Posted: Wed Jan 10, 2007 3:40 pm
by COBS Tech Support
Using Notepad create a text file holding these characters:

Code: Select all

Return { "Average Cost", "Average Cost", 10, 2, 2, "Str(Stock->C, 10, 2)" }


Place the above text file in your \CAPITAL folder, then rename the file to: R-POCOL0.MAC

Start CAPITAL and open a purchase order. From the menu select Customise|Column Options|Complete Column List. Near the bottom of the list you'll find a new user column called "Average Cost". Select this to add it to your transaction screen.