Skip to Content
Former Member
Apr 03, 2006 at 03:10 PM

How to obtain last purchased price of an item


How can i obtain the last purchased price of an item? There seems to be an 'LastPurPrc' field in the OITM table, but this does not seem to be exposed in the DI api. The last purchased pricelist is an 'internal' pricelist so cannot be used in the pricelists selection. Is there another way then just retrieving the value with a direct database Sql query?