Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Unit cost

Posted on by

Hi,

an item has irrelevant unit cost in Navision 5.0.

I can see right values in Average Cost. Calc. Overview, but on item card there is too high value (35 714 285 714 285)... Inventory is 0 since 2013.

Do you have any idea, why this value is so high? How can I correct it? It's not an editable field because there are posted ledger entries.

Thank you very much!

Amy

*This post is locked for comments

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Unit cost

    By standard, the Unit Cost field is filled by the following formula: Unit cost = inventory value of items on hand (expected cost + invoiced cost) / quantity on hand . It can be the case that the inventory is very small but still is not zero. Please refer to more information on how this field is filled: msdn.microsoft.com/.../hh169034(v=nav.90).aspx

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Unit cost

    Run Adjust Cost - Item Entries Batch job for that item.

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Unit cost

    Amy Racz  ,

    unit cost may vary but not this much most probably some one on your company edit run some unwanted programs (not related to them)

    you can use Adjust Item Costs/Prices  entry to correct this [refer below link]

    msdn.microsoft.com/.../hh168436(v=nav.90).aspx

    Please make sure your users having permissions to unrelated areas , control their accessible areas with permission sets / permissions properly , this is definitely user error

    do not let your users to go unwanted setup programs 

  • Amy Racz Profile Picture
    Amy Racz on at
    RE: Unit cost

    *irreal unit cost, sorry

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans