Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Inventory Quantities Problem

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

1. Have you experienced a NEGATIVE (-) ALLOCATION? How can this happen?

2.  Given this scenario : Item A has stocks in both  Site 1 and Site B with "0" and "100" cases respectively, with Site 1 as the default site ID.  A Sales Order encoder accidentally picked Site 1 with "0" quantity and he was able to complete transaction until posting. He said there was no error advice or whatsoever. How can this happen when the Inventory Control Setup clearly prohibits this to happen. I mean we checked all possible settings that will allow such transaction, but it happens.

Hoping to hear from our GP Experts. Thanks in advance!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Quantities Problem

    Thank you Harry and Shan for the tips.

    Actually, what we would really like to find out what's really causing this ever recurring problem.  Sounds like it is a GP issue as well in other users and has been around from sometime.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Quantities Problem

    Hi,

    It could be a posting interruption when user posting their transactions. As explained by Harry, in GP there are setting to prevent the user. In order to solve this problem you need to run the reconcile for the SOP,POP & Inventory. If you have the basic modules installed.

    Note: Take a backup before doing the process.

    Kindly take a look at the link provided will give you more details about your issue and  how to process the reconcile.

    support.microsoft.com/.../850365

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Inventory Quantities Problem

    There are numerous settings in Sales Order Processing setup, to control the allocation of Inventory to Sales Orders.  If they are configured as you describe, then when an allocation at the line item level drove the Quantity on Hand negative, the user should have encountered a dialogue, which asked them what to do about the shortage (i.e. sell the balance, cancel the balance, override the shortage, etc.)

    The first step in this process, were I tasked with sorting it out, would be to create a test database and exhaustively test the scenario to validate what the user is telling you. This will ensure you're not chasing your tail.

    I would also recommend you run the Inventory Reconciliation Utility, which should straighten out any problems with Inventory allocations.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans