Negative Inventory Validation

On supported transactions, this feature restricts the entry of an item quantity that is more than the on-hand inventory across locations.

Note:

Item quantities in transactions must not exceed six decimal places.

Posting and Nonposting Transactions

The SuiteApp checks for negative inventory differently for posting and non-posting transactions when you modify item quantities in a transaction record.

For posting transactions where the original item quantity is immediately fulfilled, the SuiteApp validates only the additional quantity requested. For example, a cash sale transaction has an item quantity of 10. When you edit the transaction and change the item quantity to 12, the popup message shows Requested: 2 ; On Hand: 0.

For nonposting transactions where the original item quantity is not immediately fulfilled, the SuiteApp validates the total of the original and additional quantity requested. For example, a sales order transaction has an item quantity of 10. When you edit the transaction and change the item quantity to 12, the popup message shows Requested: 12 ; On Hand: 10.

The Enhanced Validations and Defaulting SuiteApp can validate the posting and nonposting transactions as shown in the following table.

Posting Transactions

Nonposting Transactions

Cash Sale

Sales Order

Invoice

Work Order

Inventory Adjustment

Transfer Order

Note:

For invoice, validation is available for both standalone invoice and invoice from a sales order.

Multi-Location Inventory Feature is Enabled

If the Multi-Location Inventory feature is enabled in your account, you can select different locations for each line item that you are add to the transaction. The SuiteApp then validates the inventory in each specified location to verify enough stock for the line item.

If the item quantity entered results in negative inventory, the Negative Inventory Validation prevents saving of the record. A message appears to show how many stock there is currently on-hand for the item. This occurs when the Prevent Negative Inventory preference is enabled for Negative Inventory Validation.

When this preference is not enabled, you can save the transaction even with negative inventory. The SuiteApp displays a warning message to show the negative inventory. To review information about this preference, see Setting the Prevent Negative Inventory Preference.

Multi-Location Inventory Feature is Not Enabled

When the Multi-Location Inventory feature is not enabled, the SuiteApp validates inventory across all locations when you add line items. A message appears when you enter an item quantity that is more than the on-hand inventory. The item quantity must be changed before you can add the item to the transaction.

A warning message is also displayed when you add multiple items to a transaction. The message identifies which items don't have enough on-hand inventory. It also shows the number of available items for a selected location. You can then change the item quantity or select a different location for each item before you can add the item to the transaction.

For more information about Multi-Location Inventory, see Multi-Location Inventory.

Transformed Transactions

The Negative Inventory Validation feature of the Enhanced Validations and Defaulting SuiteApp supports the following transformed transactions:

  • Cash Sale to Invoice

  • Sales Order to Invoice

Related Topics

General Notices