Report on latest purchase price

Finance and Operations/AX Developer Forum
1

Hi

Is there any report to display the latest purchase price of items.

Thanks

Priyanka

2

Hi,

Yes, Follow the following path :

IM-> Reports-> Price/Discount-> base price/discount setup in that you have to select all items in masters or particular item. you’ll get item sales, purchase and inventory price.

Regards,

Kiran

3

Thanks Kiran for a quick response. But this report mentioned by you prints the details from Price/Discount tab of item master.

I am looking for a report which displays the latest rate of item purchsed from real transaction data.

Regards

4

Do an AutoReport on the InventTableModule Table from inside the AOT.

Price can be displayed for each Item Number as shown in Released Product Details under FastTabs for Purchase, Sell and Manage Costs. After you run the AutoReport, then you can export the data to Excel. Within Excel, you can filter to view the Purchase Order prices only.