Skip to main content

Notifications

Announcements

No record found.

Supply Chain Management forum
Suggested answer

Cost price not updating while doing movement journals

Posted on by 30
Hi team,
     On client UAT while doing a movement journal cost price column showing empty. Is there any parameter need to enable? 
 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Cost price not updating while doing movement journals
    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.
  • Manekesavan Profile Picture
    Manekesavan 30 on at
    Cost price not updating while doing movement journals
    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. 
     
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Cost price not updating while doing movement journals
    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.
  • Manekesavan Profile Picture
    Manekesavan 30 on at
    Cost price not updating while doing movement journals
    Hi Bill, 
       Yes, it has latest cost price under manage cost fast line
  • Manekesavan Profile Picture
    Manekesavan 30 on at
    Cost price not updating while doing movement journals
    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. 
     
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,277 Super User 2024 Season 2 on at
    Cost price not updating while doing movement journals
    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?
  • BillurSamdancioglu Profile Picture
    BillurSamdancioglu 13,600 Most Valuable Professional on at
    Cost price not updating while doing movement journals
    Hi,
     
    Does item have a cost?

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans