Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Inventory corrections
Finance | Project Operations, Human Resources, ...
Suggested answer

Inventory corrections

(0) ShareShare
ReportReport
Posted on by nuttka 130

Hello Everyone!

I have quite complicated issue. Could you please help me? Client has done some very wrong corrections, which have turned the inventory value into minus few millions on 3 items - wrong pricing has caused recalculation of transactions back in time. Adjustment was done (Closing and Inventory -> Adjustment), but after recalculation it is back to negative value :< Do you know how can I fix this? Below transactions and On-hand value for one of those three. I think all started with not Invoiced PO back in 2018... 

pastedimage1600335229746v1.png

pastedimage1600335296706v2.png

  • nuttka Profile Picture
    nuttka 130 on at
    RE: Inventory corrections

    Dear Ludwig, dear All!

    I went with my scenario, so one more time:

    1. Inventory adjustment correction, I did it with cost price taken from last income (not sure if this Cost price is correct, but I didn't have another idea);

    2. Counting journal with amount, which was not invoiced on PO, Cost price the same as for Inventory adjustment correction (still not sure if this Cost price is correct);

    3. PO into minus with not invoiced items -> post Product receipt;

    4. Invoice on 0,00;

    5. Inventory recalculation...

    2 Items fixed, one has now incorrect Unit price, but I am getting closer... :D

  • nuttka Profile Picture
    nuttka 130 on at
    RE: Inventory corrections

    Dear Ludwig, yes, I did some testing, but with other scenario:

    1. withdraw Inventory adjustment, which in my opinion was done wrong I did it with cost price taken from last income; 2. Counting journal with amount, which was not (198) invoiced; 3. PO into minus with not invoiced items (unfortunately I can't mark them :<); 4. Credit note for that quantity (Invoice for 0,00) 5. Inventory recalculation...

    Still checking with a client, it is something, but still not it. Tomorrow I will check your scenario, and let you know!

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory corrections

    Good morning nuttka,

    Have you been able to do some testing?

    Were your tests successful?

    Best regards,

    Ludwig

  • nuttka Profile Picture
    nuttka 130 on at
    RE: Inventory corrections

    Thank you Ludwig, I will try this today. I have copy from yesterday :) Keep you informed!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory corrections

    Hi nuttka,

    Have you tried running an inventory close and then adjust the financial amount for this item?

    Adjustment/on-hand/adjustment/value

    Test this carefully based on a copy of your current system where you see the error to avoid that things get even worse from making further tests in the live environment.

    Best regards,

    Ludwig

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,754 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans