Quantity Discrepancy when Releasing a Material Stock Request (MSR) Before Adjusting the Available Quantity to '0' (Zero)
Last updated on FEBRUARY 01, 2018
Applies to:PeopleSoft Enterprise SCM Inventory - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.
When a demand line for an Item is reserved between the creation and the save of an Adjustment for that same Item to bring the available quantity down to '0' (zero), you end up with a negative available quantity while the Business Unit does not allow negative quantities.
The 'Inventory Balance Report' (INS9090) does not report the negative quantity and if you create an Express Putaway for the Item and Business Unit and a quantity > negative quantity, all quantities are back to normal.
Steps to reproduce the issue:
- Start creating an Adjustment for an Item and Business Unit to decrease available quantity to '0' (zero) but do NOT save it.
- Open a new window, create a Material Stock Request (MSR) for the Item and Business Unit, and reserve it.
- Go back to the Adjustment and save it > the available quantity gets a negative value = MSR quantity, while the Business Unit does not allow negative quantities.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms