The Document total does not equal the sum of the lines.

This error can occur due to a rounding error in the Purchase Order.


Error Text:  Error Updating Xero: Xero Validation Error: The Document total does not equal the sum of the lines.


Solution

Information you'll need..

1. Purchase order number that has caused the error.


Steps to take


From the Purchase Order screen in ConnectWise follow these steps:

1.1 In ConnectWise un-receive the PO in the Purchase tab of the Purchase Order by un-ticking the check box, then click Save



1.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


2.1 Go into the ConnectWise Accounting Interface screen & click on the Open Batches tab


2.2 Enter the Purchase Order number with asterisks on both sides & click Search


2.3 If the PO Batch appears click Delete

3.1 Go back into the Purchase Order screen, refresh the screen by clicking Search 


3.2 Round down all the Unit Costs in each Product individually in the Products tab to whole numbers


3.3 Calculate the difference between the initial Purchase Order total & the rounded down balance.


3.4 Add in a product called Rounding with the Unit Cost as the difference between the 2 totals to bring your Purchase Order back up to the correct amount


If you don't already have a Rounding Product in your ConnectWise Product list you will need to add this to your products list in the Product Setup screen in ConnectWise.


4.1 Re-receive all products in the Products tab, closing the Purchase Order


5.1 Re-sync the PO to Xero