Finance | Project Operations, Human Resources, ...

Trace Inventory Item Price

(0) Share

Report

Posted on by Eric Chie

722

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.

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Eric,

The last activation happened 2nd December.

Can you have a look at the item transactions that were posted on that day for this item?

Best regards,

Ludwig

Was this reply helpful? Yes No
Zain Mehmood 4,189 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Eric Chie 722 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Eric Chie 722 on at

Like (0)

Report
Copy link

Link copied!

Hi Zain,

Thanks for the reply. We are using Weighted average date.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Eric Chie 722 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Eric Chie 722 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No