Finance | Project Operations, Human Resources, ...

Inventory corrections

(0) Share

Report

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...

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
nuttka 130 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good morning nuttka,

Have you been able to do some testing?

Were your tests successful?

Best regards,

Ludwig

Was this reply helpful? Yes No
nuttka 130 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
nuttka 130 on at

Like (1)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Inventory corrections

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Inventory corrections

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates