Missing & Incorrect Orders Troubleshooting
  1. Help Center
  2. General Troubleshooting Guide
  3. Missing & Incorrect Orders Troubleshooting

Transaction amount must be positive

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.

Problem

Your total discounts, refunds, and fees exceed the total sale.

Description

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.

Solutions

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:

  1. On the Connex configure page, expand orders > sync orders to QuickBooks > summary sale.
  2. 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:

    1. On the Connex configure page, expand orders > sync orders to QuickBooks > merchant fees.
    2. 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:

    1. Login to Connex.
    2. Click manage.
    3. 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:

    1. Under sales tax, check the add tax as a line item.
    2. Expand orders > sync orders to QuickBooks > sync manually to QuickBooks.
    3. In the order list field, enter your order number.
    4. Click save.
    5. Run your web connector.
    6. 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.

    1. Login to Connex.
    2. Click rules engine and my rules.
    3. Click add new rule.
    4. Click next.
    5. As the action, choose remove order discount.
    6. In comparisons, enter coupon code, is not, and test.
    7. Click finish.

    Delete shipping rules

    Delete rules that remove the shipping cost and shipping amount, if there are unnecessary. 

    1. Go to the rules engine.
    2. Find the shipping rules.
    3. Click export to excel, in case you need to reexport.
    4. 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.