Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Unit Cost is not Updated

Posted on by Microsoft Employee

Hello,

I got a problem on Item Card. Here is the detail:

On Item Card, the Costing Method is FIFO, Quantity on Hand is 20, but the Unit Cost is 0.

The Replenishment System is Assembly and it is "Make-to-Stock".

When I create an Assembly Order and fill out lines, the Unit Cost on Assembly Order is 0. After posting the Assembly Order, the Unit Cost on Item Card is still not updated.

Can anyone help me?  

*This post is locked for comments

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Unit Cost is not Updated

    in general field "unit cost" is not very informative. better use the statistics window.

    for calculation the item's "unit cost" follow

    msdn.microsoft.com/.../hh168041(v=nav.70).aspx

    when posting an assembly order the item's "unit cost" is not updated, but the fields "Rolled-up Material Cost" and "Single-Level Material Cost", because only material costs incur.

    additional follow http://dynamicsuser.net/forums/t/88057.aspx

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: Unit Cost is not Updated

    Hi Allen,

    You can find the Assembly BOM from the Item card on the Navigate tab, along with the Calc Standard Cost and Calc Unit Price functions.

    Also you'll need to learn about Work Centers/Machine Centers so you can then build your Routings. You can find all of these using the search bar at the top right of NAV. Depending on your manufacturing processs... you'll most likely need to set up at least a Work Center to use in your Routing for each Item you are producing (you may not need Machine Centers).

    After you create the Assembly BOM link it to the Item from the Item card; after you create the Work Center and the Routing, then link that Routing to the Item there on the Item card too.

    Regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unit Cost is not Updated

    Hi Jonathan,

    Why do I need to create Production BOM? Or you mean Assembly BOM?

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Unit Cost is not Updated

    as alex suggests try to create a routing and a production bom for that item, then try again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unit Cost is not Updated

    Hi Alex,

    Thank you for your response. The Production BOM No. and Routing No. are blank field.

    Assembly_2D00_BOM.PNG

    Could you give more specific instructions? And How to configured Bill of Materials and Routing(s) for this item?

    Thank you!

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: Unit Cost is not Updated

    Have you configured your Bill of Materials and Routing(s) for this Assembled Item? If so, you can try the Calculate Standard Cost option from the Item Card.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans