Average cost column on purchase order
  • Paul
    Average cost column on purchase order

    by Paul » Wed Jan 10, 2007 3:36 pm

    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?
  • COBS Tech Support
    Posts:683
    Joined:Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Wed Jan 10, 2007 3:40 pm

    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.

Who is online

Users browsing this forum: No registered users and 2 guests