Your order total minus discounts is a negative number. If there is tax on the order, then there is tax on the discount. This error is common with 100% discounts.
Your total discounts, refunds, and fees exceed the total sale.
In your Connex log, you see this error:
Error 3180 : While trying to Add a(n) Sales receipt with order number of , QB responded There was an error when saving a SalesReceipt. QuickBooks error message: Transaction amount must be positive.
Disable fix rounding errors
At times, QuickBooks can calculate a different order total than your website. Connex adds or removes an amount from the sale. To deactivate the setting, read this guide.
Map Sales Tax
If you mapped no tax codes and you said add no tax on the sale, this error can occur. If you had a 100% discount and you mapped no tax, then the sale would sync as negative. Log into Connex. Click manage. Click sales tax. Map tax codes or check add tax as a line item.
Tax on Order Incorrect
Check the sale. Is there tax? If so, should the order have tax? Contact support from your e-commerce solution about removing unnecessary tax.
Keep sales and refunds separate on summary sales
If you sync individual sales, skip this section. If you use the Amazon settlement report or summary sale integration, uncheck merge refunds. Connex will merge the fees, sales, and refunds onto a single sale. If you refunded more money than you earned, then the sale would show negative:
- On the Connex configure page, expand orders > sync orders to QuickBooks > summary sale.
- Uncheck merge refunds.
Remove merchant fees
If you never use Connex to add merchant or Amazon fees, skip this section. If your merchant fees plus refunds exceed your sales, then the sale could show negative:
- On the Connex configure page, expand orders > sync orders to QuickBooks > merchant fees.
- Clear the merchant fee item box.
Map tax codes
This usually happens when you map a 6% tax code in QuickBooks, but your website calculates 7% and your gift card offers a 100% discount:
- Login to Connex.
- Click manage.
- Expand sales tax. Look at the mappings. Is the tax rate in QuickBooks and your website identical?
If so, try adding tax as a line item:
- Under sales tax, check the add tax as a line item.
- Expand orders > sync orders to QuickBooks > sync manually to QuickBooks.
- In the order list field, enter your order number.
- Click save.
- Run your web connector.
- Return to sales tax and uncheck tax as a line item. This will enable Connex to map your tax codes again.
Remove grouped discounts
If your order contains grouped items, go to lists > item list in QuickBooks. Double click the item. Remove any discounts in the group. It is possible that a discount is double applied.
Remove discounts from the order
You can add a rule that removes all discounts, so the sale will balance.
- Login to Connex.
- Click rules engine and my rules.
- Click add new rule.
- Click next.
- As the action, choose remove order discount.
- In comparisons, enter coupon code, is not, and test.
- Click finish.
Delete shipping rules
Delete rules that remove the shipping cost and shipping amount, if there are unnecessary.
- Go to the rules engine.
- Find the shipping rules.
- Click export to excel, in case you need to reexport.
- Delete them:
Clear Out Any Discounts
In some cases, particularly for grouped items, the only line items that will be sent to QuickBooks are the Shipping and Handling and Discount ones. It is paramount that the grand total of all incoming line items are positive, and if they are not, the error will occur.
In this case, you will need to ensure that Shipping and Handling has a higher absolute amount than the Discount. One way to do this is by going into our Rules engine, and adding a rule to set the Discount Amount to 0.
If this cannot be done, then please reach out to your web developer, and work with them to effectively weave the discounts into the order products' amounts, and ensure that no discount code will be on the sale, thus preventing our software from trying to map it over to begin with.
Update Grouped Items Price
In this example, the sum of the grouped items is $110. The total discount is $120. The order says -10:
In QuickBooks, go to list > item list. Find the items inside the group and update the price:
Resync your sale.