Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Inventory with incorrect cost on inventory transactions

Posted on by 761

We have some inventory adjustments that were added to BC and they did not have the correct cost.  What is the best way to correct this?  Do you have to reverse the entry and redo the adjustment?

Thanks,

Tanya

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Inventory with incorrect cost on inventory transactions

    Just to add to what the other people wrote.

    If the item ledger entries created from the original adjustment is still open and have full renaming qty. i would reverse and redo.

    If you have transaction that have reduced the open qty on the adjustment transactions i would do item revaluation.

    I have described the revaluation process in this blog post.

    bc365.co/.../

  • tlhgolfer Profile Picture
    tlhgolfer 761 on at
    RE: Inventory with incorrect cost on inventory transactions

    This is what I did for these because they actually for this purposes did not have a GL impact as we are doing beginning balances.  I was just wondering for future what is everyone else doing to fix these types of issues.  GP used to let you actually change the amount of the inventory transaction and then you had to post the gl entry to fix gl, but it fixed your cost layer.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Inventory with incorrect cost on inventory transactions

    Keep in mind, that all item entries will have a financial/accounting impact.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    RE: Inventory with incorrect cost on inventory transactions

    Hi, If the adjustment occurred in the current month, and the month has not been closed, I personally recommend using the same cost to reverse it. This will make it clearer in future investigations.

    Also, as mentioned by BenDB, you can use Item Revaluation Journal to appreciate or depreciate an item.

    More details: https://docs.microsoft.com/en-us/dynamics365/business-central/inventory-how-revalue-inventory

    pastedimage1650416781897v1.png

    Hope this also helps.

    Thanks.

    ZHU

  • BenDB Profile Picture
    BenDB 45 on at
    RE: Inventory with incorrect cost on inventory transactions

    Hi,

    Without knowing anything really about how you have setup inventory in your system, you could consider the use of  the 'revaluation journal' functionality to correct specific Item Ledger Entries.

    On the 'revaluation journal' you will set the 'Applies-to Entry' field to be the posted item adjustment entry that you want to change.

    Keep in mind that the 'Unit Cost (Revalued)' value is the correct cost per unit and not the difference between the posted 'adjustment' value and the value that you want the cost to be.

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