web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Quantities P...
Microsoft Dynamics GP (Archived)

Inventory Quantities Problem

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • 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.

  • Verified answer
    Community Member Profile Picture
    Community Member 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

  • Community Member Profile Picture
    Community Member 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans