There are times wherein businesses would not want to allocate all available inventory to an existing orders. They would like to keep/retain some of your available items for future orders, hence, partially committing the said order and reserving their items as a buffer. For instance, if they have 10 available for Item A and Sales Orders which requires 5 pieces, they would only want to commit 3 of these and retain the remaining 2 uncommitted for future sales orders (hence reserving 7 pieces available).
Reallocate items page is an automatic feature that reallocates available quantities to all non special orders. The standard behavior of the system is that when the quantity being committed to Sales Orders is less than the Quantity that is available, the Items left uncommitted will be allocated to remaining Sale Orders based on the priority set. In simpler terms, if the quantity available is greater than the quantity required, then all orders will be committed.
The ability to commit partially even if the item still have sufficient available quantities is not possible within NetSuite. Setting the Perform Item Commitment After Transaction Entry unchecked would only allow users to manually choose and commit the orders they want, but the system does not have the ability to set the specific quantity desired as commitment. This functionality to partially commit and to set the desired quantity to be committed is logged under enhancement: 436748 Perform Item Commitment After Transaction Entry = F > Transactions > Inventory > Schedule Commit Orders > Run Now > Ability to Set Quantity to be Committed.
Due to this, users may utilize the Commitment preference available in Sales Orders. The system's current Commitment Preferences includes "Available Qty" , "Complete Qty" and "Do Not Commit" (the default value in the Sales Order can be set under the Accounting Preferences).
When the preference is set to "Available Qty", the system automatically commits whole quantities of orders.
Example: Order Quantity is 3 | Available Quantity is 2
Result: Quantity Committed will be automatically 2 which is its current available quantities.
When it is set to "Complete Qty", it will only commit if the available quantities will complete the whole ordered quantities.
Example: Order Quantity is 3 | Available Quantity is 2
Result: Quantity Committed will be 0 as its current available quantity is not enough for the ordered quantity of 3.
When it is set to "Do not Commit", it will not commit at all until the setting changes.
Thus, we can uncommit the item from a Sales Order by changing the Commit column to Do No Commit (this is not applicable for Kit/Packages item types). This would set the commitment of the line item to 0 even if there are available units that can cater the order. The order would then treat the item as backordered.
Moreover, to partially commit a single item, a workaround for this would be to update the Sales Order (which can be done through CSV import) and set separate line items. The first line item is set to Do not commit and the other one to Available Qty for commitment.
E.g. Let us say that the Item has 60 units available, with Sales Order that needs 50 units, but only 25 is desired to be committed. Users can edit/update the Sales Order to have separate line items for the committed and the de-committed items
So, in the SO, it would look like this:
Another business model as well for this use case would be to create a new Location that would serve as the Holding/Receiving Location. This location will hold/reserve available quantities which will be utilized for transfers should the need arises.
For instance, there is a Holding location in Ohio, all of the received quantities will be logged in this one. If there are three New York orders for 30 pieces in total (and the Item has 30 available), whereas only 15 will be fulfilled/committed, the user can conduct Inventory transfers from the receiving location to the Sales Orders' location for 15 units. From here, they can now utilize the reallocation page to set as to which orders will be committed.
Are there other approaches you utilize in your business for the said scenario? Feel free to share your experiences and thoughts that in the comments section
--
Herdi Rana-Oracle Ask A Guru