Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Beginning Inventory Balance Descrepancy

Posted on by 1,175

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?

*This post is locked for comments

  • Tim W Profile Picture
    Tim W 2,925 on at
    Re: Beginning Inventory Balance Descrepancy

    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

     

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans