720
Hi All,
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?
Thanks.
Hi Ludwig,
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
Thanks
Hi Ludwig,
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
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.
Best regards,
Ludwig
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.
Best regards,
Ludwig
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.
Best regards,
Ludwig
Hi Ludwig,
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.
Thanks.
Hello Eric,
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.
many thanks,
Ludwig
Hi Ludwig,
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.
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.
Warm Regards,
Zain
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
