Logic –

• Find the Oversold SKUs
• Look for the SKUs with the same Plant, Style, Size with alternate label where some On hand Stock or PO.

Data required –

Sales

• SKUs with Open Qty greater than the Stock available.

Inventory –

• Stock (i.e, Unrestricted Stock less Allocated + Inpick) to be less than the Sales Open Qty for the SKUs that are to be substituted.
• Stock for different label with the same Plant, Material and Size same as of the oversold SKUs.

Supply –

• POs with some Open qty and Intransit Qty with the SKUs that can be substitute the Oversold SKUs