One of the main problem I have with Netsuite when it comes to order fulfilment is that I cannot filter which lines to fulfill. (Even though pre sales people told me I could before we subscribed)
The way our distribution business works is that customers place orders to us and expect items to be delivered at a specific date in the future, which obviously means not past this date but not before either. Orders are not expected to be fulfilled ASAP as it could be the in other businesses (B to C for example).
Here is an example of a Sales Order :
Column in yellow is a custom field that I called “Requested ship date” which is the date the customer expects shipment to be made on the PO he sends to us.
Column in blue is the system Expected Ship Date , which we then use to confirm or not the requested ship date. The blue date might be at a later date if for example the lead time makes item receipt past the expected ship date.
So as you can see in this example, items are expected to be shipped at different dates. The last line for example is due to be shipped in June 2022, even though the quantity for this line is already in stock and committed. Following this example you will understand why I unfortunately cannot use the system function: Transaction / Order Management / Fulfill orders.
If I use this function the system will basically make me fulfill all the SO lines which have committed quantity.
As a workaround I have created a saved search of all items that could be fulfilled and sort lines according to expected ship date, and then manually go to each SO and tick lines to be fulfilled today and untick lines due in the future.
This is a quite time consuming task and could also generate mistakes.
To be more more precise, I have around 7000 open SO lines in my system. If I use “fulfill orders” function in NS, the system will probably fulfill around 3000 lines which are already fulfillable (quantity in stock and committed) but today I only had to fulfill 10 of them, because of the date customers wanted.
I read other threads about adding a filter to the "fulfill orders" page , but all these filters are at the SO level and not line level.
Also I tried in my sandbox to enable "supply allocation" feature which looks good for me as I can replace my custom field "requested ship date" by "supply required by date" field. Then I tried to set allocation strategy and schedule but still cannot succeed.
Basically netsuite lets you fulfill all committed items in the same PO without being able to choose.
Sorry about this super long post, but the operating problem is big for us.
Thanks a lot for any feedback,
Julien