Negative quantity or stale supply records for Purchase Order supply type in YFS_Inventory_Supply table

Root Cause:

When a PO is created with a Buyer and if “Buyer Updates Required” is configured in the Process Type Details, the status changes on the PO are tracked in the YFS_Inventory_Supply table for the receiving Node. Here is an example:
When a PO is created, a PO_Placed record is created with the PO’s receiving node as the Ship_Node in the YFS_Inventory_Supply table.
When the PO status moves to Scheduled, this PO_Placed record is deleted and a new record for PO_Scheduled is created.

At this point, if the “Buyer Updates Required” flag is turned off and the PO status moves to Released, the application will not update the YFS_Inventory_Supply table with PO_Released supply type for this PO. If “Buyer Updates Required” is turned on again, and if the PO is shipped, the application would not find the PO_Released record for the PO and hence creates a record with negative quantity for PO_Released in addition to a new record with SupplyType=Intransit for the PO.

Now, if “Buyer Updates Required” is turned off and if the PO is received, product will not update the YFS_Inventory_Supply table with current PO status.

In YFS_Inventory_Supply table, if Purchase Order (PO) supply records with negative quantity exist or if stale Purchase Order (PO) supply records exist , please contact Sterling Support for assistance.