This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I can't change the location on a line item (sales order) after I've created a fulfilment, does anyone know why this is?

Also, the location select box is greyed out on the fulfilment request recird but not on the item fulfilment record (if you create the IF straight from the SO).

I appreciate that the commitment was made against a specific location when the SO was created.

If possible, you must delete the IF, update the SO, create the IF again.

<@UFAHSLYJ1> That is the intended behavior, your Sales Order represents a commitment/promise with no real GL Impact(In Pending Fulfillment Status), the Fulfillment consumes the inventory which is sitting in a Location(the one coming from the Sales Order line) at creation time.
There is no good way to update the Sales Order line location after the Fulfillment was already created for many reasons:
• The new location may not have enough inventory available etc.
• Locations in NetSuite behave as costing centers under the hood, accounting wise.
This is why NetSuite does not allow you to change the location of a line that is already fulfilled.

Does the line have any quantity fulfilled or that line does not have any fulfilled quantity?

You would need 2 lines in a SO if you are fulfilling from 2 locations, even if the item is the same in both lines

If lets you change the location, IFR does not

Maybe IF is wrong and IFR is imposing the correct/intended behavior.

In the case of the location being changed on the IF, I see they’ve hit negative inventory and of course the original commitment is gone.



With the location being locked on the SO, this is after IFR creation, even though no fulfillment has happened.

What is IFR (Item Fulfillment Requisition)?

That might make sense because nobody could be bothered to write code to update the IFR of the location changes on the SO

If the IFR requires committed inventory or if that is a General Preference/Setting that can be set, then it makes sense that you can't change the location, because the IFR that you created for Location A because you had committed quantity may no be possible to be created or exists at all in Location B because you don't have anything available to be committed.
I think that is a very good decision.
Negative inventory should not be a thing at all... you can't sell something you don't have, you can't deduct/consume something that does not exists...

May advice is that they create another line and commit from the new location whenever they want to fulfill a partial line from another location.

Then usecase is one fat SO which they fulfill from over the course of a year.

It would be nice to change the location on the SO without having to create a new line though, one line may take 2 years to fully fulfill and inventory doesn’t have to come from the same location for each fulfillment. I’m sure there’s some 2nd and 3rd order impacts that I’ve not thought about there though 

image.png

Or, stop NS caring too much about the commitment because if a line will take 1 - 3 years to fulfil, I doubt the initial commitment really matters.