Compensated for rounding error in invoice (merged invoices).

This error would usually occur due to a rounding error on multiple lines on either an Invoice or Purchase Order, in most cases the rounding amount will only be a few cents eg. ($-0.01).

However if the error is more than one significant rounding amounts eg. ($-190.09) and ($-18.14) this means as the 2 Purchase Orders were syncing to Xero have merged into one. This error is not frequent has not been able to be traced or identified in connectwise.

Error Text:  Warning: Compensated for rounding error in invoice ($-190.09). Compensated for rounding error in invoice ($18.14).

Solution

Information you'll need..

1. Both Purchase order numbers that merged causing the error.

Steps to take

From the Bills section in Xero follow these steps:

1.1 Search for the 1st Purchase Order number that has caused the error.

1.2 Click into Bill Options & click on Void

1.3 Repeat this for the 2nd Purchase Order (please note: only one Purchase order will have gone through to Xero however its better to check)

From the Purchase Order screen in ConnectWise follow these steps:

2.1 Un-receive the 1st PO in the Purchase tab of the Purchase Order by un-ticking the check box, then click Save

2.2 In the Products tab of the Purchase order un-receive all the products by clicking into them individually (changing them back to Open). Un-tick the check box, delete the Packing Slip, delete the Received Qty & Save

3.1 Go into the ConnectWise Accounting Interface screen & click on the Open Batches tab2.3 Un-receive the 2nd PO the same was as the 1st.

3.2 Enter the 1st Purchase Order number with asterisks on both sides & click Search

3.3 If the PO Batch appears click Delete

3.4 Delete the 2nd PO in the same way if it appears.

4.1 In the SyncTool, perform a Unposted Itens Sync for Inventory (this will clear out the merge error)

5.1 Go back into the Purchase Order screen, for the 1st PO, refresh the screen by clicking Search 

5.2 Re-receive all products in the Products tab, closing the 1st Purchase Order

5.3 Re-sync the 1st PO only to Xero

6.1 Go back into the Purchase Order screen, for the 2nd PO, refresh the screen by clicking Search 

6.2 Re-receive all products in the Products tab, closing the 2nd Purchase Order

6.3 Re-sync the 2nd PO only to Xero

The PO's should now appear in Xero separately.