Skip to Content
Former Member
May 27, 2015 at 08:47 PM

Query: Last actual purchase cost of item number


I would like a query that can show me the last price we paid for a specific item on an invoice on a per unit basis. So it is basically like the "last price report" but for all item numbers.

A huge bonus would be if I could also get a column of data that shows the HIGHEST purchase price per unit for that item.

Thank you,