Hi guys,
I wanted to check something with on the Commit Order Schedule and the functionality it can provide us as an organization and business process.
Currently, the NS system behaves in a 'first come, first serve' manner. Meaning that the first SO which is created and approved will consume the On-Hand quantity of the inventory location.
Our preference setting are set to commit line items when SO is approved.
This creates an issue on our end since some of the SO which have been created are only expected to receive the Inventory later on in the year, while others need it prior.
The way our supply chain handles this, is by changing the SO line Items 'Available QTY' --> 'Do Not Commit' for the SO that is planned for the far future. This is done in order to free the up the consumption of the 'On Hand QTY' so it can be reassigned to the SO that is planned for the near future.
Our point of reference to prioritizing the Inventory shipments is custom line item column by the name: Requested Date (that is the label name, the field name is: Expected Delivery Date, which is usually close in dates to the 'Expected Ship Date'
Example:
SO1: A sales order has been created yesterday with multiple Inventory line items and the Requested Date is the same for all and is set for Nov-1-2022
SO2: A sales order has been created today with the same multiple line Items as yesterday and the Requested Date is the same for all and is set for Sep-1-2022
In the use case, what will happen is that SO1 will consume (commit) the QTY for the line Items and by thus, potentially, no On Hand QTY will be available for SO2, which needs to Fulfilled and Shipped before SO1
BTW, the same example is also applied to Transfer Orders, same issue.
Our goal is to have the SO reassigned automatically rather then SC doing this procedure manually when the Inventory On Hand QTY is not enough to cover the SO's. We were hoping to achieve this by Commit Order Schedule which according to our testing is not working, below you will find screenshots attached to the Commit Order Schedule setup.
If you are able to shed some light on this we would greatly appreciate this, thank you.