Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Cost price not updatin...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Cost price not updating while doing movement journals

(1) ShareShare
ReportReport
Posted on by Manekesavan 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... 291,642 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... 291,642 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... 291,642 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 15,811 Most Valuable Professional on at
    Cost price not updating while doing movement journals
    Hi,
     
    Does item have a cost?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans