Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Inventory corrections

Posted on by 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans