Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Stock Write Downs

Posted on by 389

Hi,

We have never done this yet, how do we update unit costs of our items for our stock write-down process? The accountants have updated the unit costs of a spread sheet so how can i now use this spread sheet to import and update into NAV? Is it via Revaluation Journals?

I tried to do a test on one item and changed the cost from 0.708 to 0.6 however when checking the item card it's 0.60033. Why would this be?

*This post is locked for comments

  • Verified answer
    tpupko Profile Picture
    tpupko 2,048 on at
    RE: Stock Write Downs

    Hi,

    Steps:

    1. Run Adjust Cost - Item Entries

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

    2. Fill entries in Revaluation journal and post

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

    3. Run Adjust cost - Item Entries one more time

    Check what setting do you have in Item Ledger Setup for field Automatic Cost Adjustment?

    if Automatic Cost Adjustment = Always do only step 2 in other cases do 1-3 steps.

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Stock Write Downs

    Yes you should do this before revaluing the cost.

  • CILGroup Profile Picture
    CILGroup 389 on at
    RE: Stock Write Downs

    If we use average cost method and 'Automatic Cost Adjustment' is on, do we still need to run the batch job?

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Stock Write Downs

    You can indeed use Revaluation Journals for that. Check how "How Microsoft Dynamics NAV Calculates the Unit Cost on the Item Card": www.archerpoint.com/.../how-microsoft-dynamics-nav-calculates-unit-cost-item-card

    Have you run Adjust Cost – Item Entries batch job ? Please refer here: msdn.microsoft.com/.../hh169034(v=nav.90).aspx

  • CILGroup Profile Picture
    CILGroup 389 on at
    RE: Stock Write Downs

    Sorry forgot to mention we use the Average Costing method on a item level.

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Stock Write Downs

    Which costing method are you using? If you are using standard please follow this link

    https://msdn.microsoft.com/en-us/library/hh168409(v=nav.90).aspx

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans