Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Item Purchase Price - History

(0) ShareShare
ReportReport
Posted on by Microsoft Employee
Is there a way to have tracking or a history of Item price changes in AX 2009?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Purchase Price - History

    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.

  • dslotboom Profile Picture
    dslotboom 60 on at
    Re: Item Purchase Price - History

    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

     

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans