Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I am using AX 2009. I want to know where the item price for an item is updated from. I have activated Latest cost price and Latest purchase price in item master. Is there way I can trace back which transaction update the price?
The last activation happened 2nd December.
Can you have a look at the item transactions that were posted on that day for this item?
Hi Eric Chie,
Do you want to track the cost of inventory item? It will depend on the item costing method you are using. Which costing method are you using currently.
Thanks for the fast reply. We did the inventory closing on 2/12/2019. What I more concern is the price change on 28/11/2019.
From the inventory transaction on 15/11/2019 my physical cost per unit is 65.03 but it was just to 82.79 on 28/11/2019. This 82.79 match back with the item price value registered on 28/11/2019.
My user query where this 82.79 value came from since only 1 purchase order for this item on 8/11/2019.
Thanks for the reply. We are using Weighted average date.
The price for 2nd December seems ok then, right?
I could see that you are doing some calculations in Excel where you recalculated this cost price.
On 28 november the price was first 64.71 but I cannot see the value directly in your screenprint.
Is it possible that you copy and paste those values in here so that I can add them into my excel workbook?
otherwise, I have to jump back and forth trying to calculate what you see.
I have issue to turn on rich formatting to attached in the file. Please find the shared file here drive.google.com/.../view
please let me know if the file sharing is not work.
My purchase order physical cost should be 6,318.14 and financial cost is 6,470.52 with adjustment value of 790.89. So I am expecting 72.6141 for my item cost. Actual invoice date is on 28/11/2019 but the posting date is 8/11/2019.
Good Morning Eric,
What I can follow up is the following
Cost price 2nd December:
86.76 = 433.82 / 5
Last cost price on 28 November:
82.79 = 165.57 / 2
Do you know what kind of transfer was recorded here? Is this a transfer between different inventory sites?
What I cannot really follow up is the price of 64.71. It seems to come from the inventory close/recalculation but if I try calculating the weighted average lines in the xls sheet then I don't calculate the same amount. Question:
Can you have a look at the inventory closing and adjustment form and the voucher that is created? Also, in this form there is an adjustment report available that might give you additional insights into the price adjustments calculated. You might be able to see where and how the 64.71 come from.
I found out that 64.71 is created the same time when the purchase order was invoiced.
Transfer order on 28/11/2019 is put way process to move stock between location in the same warehouse. But the data I same in the transfer journal having 64.71 as the cost but having different price when posted to inventtrans.
I search in the forum and found that cost will be search again for those transaction with negative quantity. And I match back the 82.79 cost price created the same date and time as the transfer journal posting time. So if the item price for 82.79 that created on 28/11/2019 was due to the posting of transfer journal, where does the cost for transfer journal came from? This is the missing part that I not able to find. And this happen before the inventory closing.
Below is the record I extract from transfer journal.
Date Item number Cost price Cost amount Quantity
28/11/2019 TYL07A-4031C-ROND 64.71 -129.42 -2.00
28/11/2019 TYL07A-4031C-ROND 64.71 -258.84 -4.00
Business Applications communities