*This post is locked for comments
In AX 2012, one method would be to go to Inventory On-Hand Inquiry. Select a line. Then click text button for Transactions. You can view Reference Type and Number (Examples: Purchase order, Sales order, Inventory adjustment) along with fields like Quantity and Cost amount.
That depends on what the purpose is for tracking.
* You can register the purchases via the trade agreements per vendor, were you can use the from/to date fields. However if also line discount is used and you may want to track the actual nett purchase price
* you can track the latest purchase price via the inventtable Form. Switch on the parameter for Latest Purchase price and the nett value per pcs will be updated after posting the purchase invoice.
* you can make a report based on the InventTrans for all transactions related to Purchase and have a financial date and use the field CostAmountPosted divided by the Qty field to have the nett purchase price per piece thoughout time.
* You can use database log on the inventtablemodule to track the changes, but getting the data out is nasty.
So there are more ways to track and there are problably 10 other ways to get the info you need.
Kind regards,
Dennis
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156