Inventory Quantities Problem

(0) Share

Report

Posted on by Community Member 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

All responses (3)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 12,931 on at

Like (0)

Report

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.