Hi all,
We have had supply allocation enabled for 1 year. (whew it is a lot to deal with and I'm very much second guessing that decision. I can find very few true experts on Netsuite's supply allocation). We are allocating sales orders upon save. We also have an allocation schedule running once per night. And we often use the Allocate Orders and Reallocate Items pages to manage the exceptions to our Order Allocation Strategy (which is essentially by transaction date, include future inventory, and allocate supply as close as possible to the supply required by date).
The problem we are having is when we need to ration our inventory across multiple sales orders. In otherwords, let's hypothetically say we have 500 Sales Orders for qty of 10 Widgets each for a total of 5000 Widgets. Each sales order is to a different dealer. The problem is we only have 2500 Widgets available and we want to ration out this inventory. For simpliclity, let's just say we want 5 widgets to commit to each sales order so that it is a more fair rationing of our invnetory. We can do this using the "Reallocate Items" Page, no problem, but there is not a way on the this page to Set the Commitments as "Firm". The only way we know of natively to "Firm" these commitments is using the UI to edite each transaction (on 500 different sales orders!). The "Allocate Ordres" Page allows you to "SET ORDER LINE TO FIRM" which is what we want to do. But the problem is that the "Allocate Orders" Page will only allocate via the sorting options or the allocation process options. None of these allow us to commit 5 widgets per sales order in the example above.
I'm looking for suggestions on how to deal with this limitation. I don't understand why there is not a "Set Order Lines to Firm" option on this "Reallocate Items" Page.
One thought was to see if we could create a workflow that runs on a schedule and marks sales order lines as firm based on a saved search. Creating the saved search based on the business need is no problem. But I'm not sure how to create such a workflow.
Another thought was to add a "Set all Order Lines to Firm" button on the sales order such that at least it could be done more easily than editing the sales orders line by line which would take a very long time. I'm not sure how to do this type of workflow either, nor creating a button to execute.
Any other thoughts or suggestion are very much appreciated.
Also, I notice that with supply allocation enabled, the "Reallocate Items" Page DOES INDEED respect the "Firm" commitment on a sales order lines despite all Nesuite documentation that I can find claiming the contrary. If anyone knows anything abou this, please let me know.
Best,
Adam