Last Purchase Price


Can anybody tell me “How to get Last Purchase Price of all Items” ???

The latest purchase price can be stored by using "Latest Purchase Price" option in Products. When this is used the the system will insert the records into InventItemPrice table with the latest purchase price. You can get the records with PriceType = Purch and CostingType = Last. You need to get records sorted by Activation dates, as there is a chance of storing the history (depending on the Inventory parameter Last Price History).

Thank you Kranti