Supply chain | Supply Chain Management, Commerce

Cost price not updating while doing movement journals

(1) Share

Report

Posted on by Manekesavan

Hi team,

On client UAT while doing a movement journal cost price column showing empty. Is there any parameter need to enable?

I have the same question (0)

All responses (7)

Answers (0)

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

Hi,

Does item have a cost?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Manekesavan,

Can you provide more information? What is the costing model and what cost do you expect? Are there other inventory transactions for this item having a cost price?

Was this reply helpful? Yes No
Manekesavan 30 on at

Like (0)

Report

Hi Andre,

I'm using FIFO costing module and cost price which is available under Manage cost fast tab is the latest cost price of the item.

It's a new item which has one purchase transaction right now.

Was this reply helpful? Yes No
Manekesavan 30 on at

Like (0)

Report

Hi Bill,

Yes, it has latest cost price under manage cost fast line

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Manekesavan,

In this scenario, it will use the cost from the available on-hand inventory transactions. Depending on the settings (physical cost enabled on item model group or not) and the status of the purchase order it will directly have a cost price based on a current known average cost price. When the purchase order is invoiced, the inventory recalculation and closing will adjust the cost price according to the FIFO principle.

Was this reply helpful? Yes No
Manekesavan 30 on at

Like (0)

Report

Hi Andre,

I have already enabled include physically value under cost price in item model group.

is there any other parameter needs to enable here, pls suggest.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Manekesavan,

If this parameter is enabled, still there can be scenarios where a cost price will be zero when posting the movement journal as mentioned before. If at the moment of receipt, there was no purchase price known, the value could be zero. Can you check all related inventory transactions for the current status? In case also the PO is invoiced, try to run an inventory recalculation and check the result. Please test this in a non-production environment first.

Was this reply helpful? Yes No