You must add an order prefix or suffix at the end of orders Xero exports into QuickBooks, so the numbers from QB and the numbers from your order management solution are different. Overlapping orders can cause orders to fail to export or payments to be matched incorrectly.
Some customers have order numbers in their order management system and QuickBooks overlap. Here is an example:
- On November 1, 2014, you enter invoice #1 into QuickBooks for John Smith. It has a balance of $100 and its total was $100 because it was never paid.
- Your order management solution sends Cloud Cart Connector order #1 for Jane Jones.
- Our system asks QuickBooks if there is an order #1.
- QuickBooks responds with John Smith order #1.
- Cloud Cart Connector skips the order.
- Cloud Cart Connector inserts the payment for John Smith order #1 because it thinks it order #1 for Jane Smith.
You might experience orders failing to reach QuickBooks, payments failing to be applied or payments matching to the wrong invoices.
If you go to your transaction log, located at the gear > transaction log, you will see these messages:
- Order 0 has failed to export into QuickBooks. Duplicate Document Number Error : You must specify a different number. This number has already been used.
- Order 12490 has a 0 balance and QuickBooks cannot create a payment.
Adding a Prefix or Suffix
Here are the steps:
- Login to cloudcartconnector.com.
- Click submit on the my connections page.
- On the configure page, click the order export tab
- Under order prefix, enter IS-. This will prefix all orders with IS- and then the order number:
- Click save and sync.