Notifications
Announcements
No record found.
*This post is locked for comments
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
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
