Scenario:
The user has set the Item Commitment Transaction Ordering Preference to “by Expected Ship Date”, and while this works as expected for Sales Orders, it doesn’t appear to apply consistently to Cash Sale transactions.
Solution:
This behavior is working as designed in NetSuite. While Sales Orders follow the Item Commitment Transaction Ordering Preference, Cash Sales behave differently because of their immediate nature.
Why This Happens
- Sales Orders are typically fulfilled later, and their item commitments are prioritized based on the Expected Ship Date or whatever rule is set in Setup > Accounting > Preferences > Order Management > Item Commitment Transaction Ordering.
- Cash Sales, on the other hand, are considered immediate fulfillment transactions where the payment is made up front. Because of this:
- The system prioritizes Cash Sales over Sales Orders, even if the item is already committed to a Sales Order.
- As a result, if there is limited inventory, the system may reallocate or uncommit inventory from a Sales Order and commit it to the Cash Sale instead.
- This can cause the affected Sales Order to reflect a Backordered status for the item.
-----
If you find this information useful, let us know by reacting or commenting on this post!