Dynamics Community Forum Thread Details

Beginning Inventory Balance Descrepancy

We found the inventory descrepancy, and the descrepancy seemed to be happened systematically.

Item was 8,000 different than physical counts, but it descrepancy somehow came from the initial inventory balance. On inventory inquiry, inventory was adjusted to increase 40,000. Howeer, the balance said 48,000. We checked the stock status at the end of last month, and then confirmed beginning balance was 40,000.

How the balance updated automatically? I would like to know how this thing happened... Is this a system bug? Does anyone have this problem before?

I'd say you don't have nearly enough data points here for an accurate analysis but I'll take a guess based on what I see.

Perhaps Invoice IV000836 was from an order entered before your adjustment was done that had allocated 8000 of this item such that the quantity on hand was 8000, qty allocated 8000 and qty available was zero. When you did the adjustment you might have thought qty on hand was zero as that was the available qty but maybe there was already 8000 on hand which was previously allocated.

That's how your screen reads to me, I've seen allocated amounts get off on occasion but don't usually see or have not seen the on hand be incorrect as those transactions are ultimately GL transactions.

The path I would use to reconcile to look at the IV10200 table for this item and sort through the in's and outs. select * from iv10200 where itemnmbr = '7318166600'. You could also do the same reconcile using the Item Transaction window from Inventory-> Inquiry -> Item Transaction

Regards

Tim

Quick Links

Leaderboard