Troubleshooting Negative Total Error

If you get the error The total cannot be negative, it means NetSuite calculated the total of the order data from NetSuite Connector and the total came out negative. This topic includes the common causes for this error.

NetSuite Automation

You might have automations in NetSuite that subtract things like sales commissions. If an order comes in with a $0 total (fully discounted), the script could subtract more and make the total negative.

Make sure you either exclude the records NetSuite Connector syncs or update the automation so it doesn't subtract enough to make the order negative.

Discount Items

If the order has a discount, make sure the discount item is set as nontaxable in NetSuite. This is crucial if the discount is posting as a line item. Usually, charging tax will make the order total in NetSuite not match your storefront total. Sometimes, charging tax can make the total negative and cause it not to post. If the discount is a line item, the order will have a negative amount. If you assign tax to that negative amount, you'll get a negative tax value. For example, a line item discount of –$1.00 with a 10% tax rate would result in –$0.10 tax. If you've completely discounted the order ($0 total), the negative tax amount subtracts from zero and makes the total negative. The same thing happens if the order total is low enough that the negative tax amount pushes it below zero.

To fix this, change your discount item to not use a tax schedule or set it to a nontaxable schedule. You can set this in the Accounting subtab of the item record.

Note:

It is possible that an item is assigned to a tax schedule named non-taxable to still have tax charged to the item. Only having the name as non-taxable is not sufficient. The tax schedule and designated area (like state, county, city, or province) must also be set to not charge tax.

To check if the discount item isn't taxed, manually create an order shipping to the same address as the one with the error. Enter the discount item and see if NetSuite adds tax to it. If yes, then one of the following is true:

Related Topics

General Notices