Dynamics Community Forum Thread Details

Inventory Adjustment Assistance

Hello,

Need some guidance here please! I am not sure what to do with the adjustment that was created for 95k and if this would be the end of this mess or if we need additional adjustments?

Here are some of the details:

A user accidently removed 153 pieces of MISCELLANEOUS from SITE ID MO. However…we only had 9 available at that point. So we reversed the original entry that was created, but now it seems like it’s still popping up in places. My guess is that every time we received MISCELLANEOUS after the user accidently made their adjustment but before we made the fix the system is trying to “fix” the users adjustment of 144 pieces too many at $3195 each. I just need help running it down to make sure it's fixed all the way through. Since the user removed too many, GP adjusted most of them out at the last purchase price, which was $3195/each, so I’ve had huge swings in my over/short account.

I made the correcting transaction today, except I used the actual cost calculation that came out which was $3075.14 @ 153 pieces. This completely reversed the adjustment that Tim made originally, please see IVADJ00001016 (fix) and IVADJ0000955 (original). Mirror images. Re-ran my January financials and they appear to be more “normal”.

Ran the February financials, and I have a large adjustment again that I can trace back to these same MISCELLANEOUS pieces.

POPRCT30390 on 2/2/18 shows receipt of 30 pieces of “MISCELLANEOUS” on PO329124, a total of $286.56. I pulled the original receiving documentation to check, they agree:

31273.Capture2.JPG