Skip to Content
avatar image
Former Member

sql query to find the unit cost of items in a PO (A/P)

I'm trying to get the cost of an item at the point of time the PO was placed. I'm confused because the item's cost can't be dependent on a price list after the PO is cut; otherwise, the cost would be constantly changing when you looked up a past PO.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 17, 2017 at 10:45 PM

    Hi,

    Have you tried with Last price report? Use Ctrl + Tab at unit price field to get Last price report.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded