OPM Inventory Close Writing Negative On hand

OPM Inventory Close Writing Negative On hand 

I am running OPM Inventory Close for last month, I have the Profile Option 'Allow Negative Inventory' set to 'No', and I know that no onhand quantity for any OPM Item ever went negative during that Period


When I run the Inventory Close process, however, there are rows written to IC_PERD_BAL where the LOCT_ONHAND figure is negative.

Solution

This is not a problem in the OPM Inventory Close code, which calculates the Period-End balance of an Item/Lot by starting at today's Onhand Quantity and then working backwards through all Completed transactions in IC_TRAN_PND and IC_TRAN_CMP adding or subtracting the transaction quantity against the current onhand until the relevant Period-End date is reached.

If a negative onhand quantity has been written to IC_PERD_BAL, then the above calculation has resulted in a net increase in the Stock figure for this Item/Lot since the end of the Period to be closed, and this increase is greater than the current onhand figure.

What has probably happened is that you have an issue or allocation transaction which you thought was in the current Period, but which actually fell in the previous Period.

This can occur if, for example, you added a new Ingredient to a Batch or changed an Ingredient quantity at the beginning of this month, but the Batch was already Released at the end of the previous month.

In the above case, the 'PROD' allocation row written to IC_TRAN_PND will have CREATION_DATE in the current Period but TRANS_DATE will be in the previous Period, and this could be enough to (apparently) drive Stock negative at the end of the previous Period.