Location is Mandatory when Multi-Location Inventory is Enabled

Once Multi-Location Inventory (MLI) Feature is enabled in a NetSuite account under Setup > Company > Enable Features > Items & Inventory, then the Location field is set to mandatory by default in transaction forms

The standalone Vendor Bills, Customer Invoices, and Cash Sales mentioned in Article 27868 (Location field is mandatory in transaction form (i.e Invoice, Cash Sale, Vendor Bill) even if Accounting Preferences and form customization has a field set to non-mandatory) are just examples. This does not necessarily mean that it is only required for stand-alone transactions.

The Location field is mandatory for all posting transactions. Although, when not stand-alone, this may not be a problem as long as the Source transaction has a location field populated on it.

For example, when billing POs, MLI is enabled:

A. Scenario 1:  PO Location is populated with FLORIDA.

When you bill the PO, you will not receive an error since Bill’s location already has a value coming from the PO.

B. Scenario 2: PO Location is blank.

When you bill the PO, you will receive the error because the system cannot pick up any value from the Source transaction (PO) just like in stand-alone transactions.

To avoid the error, you have two options:

A. Hide the Location field on your preferred forms for Posting Transactions like Bills, Invoices, Cash Sales, etc.

  1. Go to Customization > Forms > Transaction Forms
  2. Edit the Preferred Bill form
  3. On Screen Fields > Main, uncheck Show box for Location
  4. Save

B. Have a Workflow action of Set Field Value for Location and select a default value.

Leave a comment

Your email address will not be published. Required fields are marked *