Finance | Project Operations, Human Resources, ...

what is the purpose for ticked Latest Cost Price it's mandatory when setup item

(0) Share

Report

Posted on by atef@83

805

dear all

what is the purpose for click

Latest Cost Price in relase product i know if i click it it will display last cost price when making movement or count but if i want to display only the average cost this will display or not

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

The latest cost price check box does not provide resp. display you the average cost of the item.

The so-called running average cost price can be found in the on-hand form at the bottom of the second tab.

It's a current indication of the average price, which might, however, differ from what AX calculates as weighted average, date cost price.

Best regards,

Ludwig

Was this reply helpful? Yes No
atef@83 805 on at

Like (0)

Report

thanks Dr. Ludwig Reinhard for reply

so if i want to display the cost price in the form that represent the average here in this form what is display in cost amount represent the last cost price but when i post the journal i found it post with different cost from on hand so if i want to display it directly do i need to make customization

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi atef083,

When there is outbound transaction, the cost will be the current cost price (average) e.g. in your form above and we can't change it. Only change allowed on price is when qty is +ve.

On item master, you see latest cost. If you want to see average cost, it needs customization which is not recommended. If you need to see average cost price use on-hand form instead. Given the flexibility of the system, it can get very complicated to state what is average cost price. Do you maintain inventory financially at warehouse level or below, if yes..what's your average cost price and what you want to show. It's easier only only when financially inventory is maintained at site level. Think through before making customization.

Thanks,

Satish Panwar

Please take time to click yes against the answer that help guide you in right direction.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi atef083,

If you create a inventory journal with a negative quantity, and if you are using an Actual Costing method, AX will use the running average cost price at the time you POST the journal. Whilst you might normally create the journal and post it straight away, it is perfectly possible to create the journal and post it some time later. It means that ANY cost price you show on the journal line might not be the price that is used when you post the journal.

And in any case, if you are using an Actual Costing method, AX might change the cost later, when Inventory close is run.

In summary, if you are using an Actual Costing method, AX does not know the actual cost of the inventory journal at the time you create it, or even at the time you post it. I would accept that any price you show will be an approximation until after Inventory close has been run and move on!

Was this reply helpful? Yes No