Symptom
You are seeing either of the below error messages after trying to publish an invoice.
Line Item Net does not match Invoice Net
Line Item Total does not match Invoice Total
Applies To
Purchase/Sales invoices.
Cause
This means that the invoice summary net/total does not match the line item summary net/total. See example below:
This can happen if the VAT code has been changed, causing the figures to recalculate, or if any of the figures have been edited. Another common cause is incorrect field values. The Net amount cannot be edited directly, but adjustments can be made to other fields, such as tax/VAT and Total, depending on whether the invoice is tax-inclusive or tax-exclusive. Ensure that any edits align with the original invoice data before publishing. Additionally, rounding differences may occur when publishing invoices to Sage 50 Canada. These discrepancies, typically 1–2 cents, arise due to how Sage 50 Canada calculates and splits tax rates (e.g., GST and PST). AutoEntry does not recalculate the Net, VAT, or Total figures unless manually adjusted by the user.
Resolution
In order to rectify this you can either edit the line items or the invoice summary so they match. The error will then automatically clear!
Steps to Correct Invoice Discrepancies
Adjusting Field Values
Identify the fields that need correction (e.g., tax/VAT or Total).
Edit these fields to align with the original invoice data.
Verify that the calculated total matches the sum of the line items before publishing.
Resolving Line Item Discrepancies
Check the amounts used in the calculation.
If the calculated total matches the sum of the line items but differs from the invoice total, amend the relevant fields so the calculated total aligns with the line-item total.
Publish the invoice once all amounts are accurate.
Handling Rounding Differences
Understand that rounding differences (1–2 cents) may occur when publishing to Sage 50 Canada due to its tax calculation methods.
These differences are expected and cannot be adjusted automatically by AutoEntry.
Please note that if there are Units/Prices contained in your line items, those will need to be amended instead of any incorrect net/total amounts.
Correcting Totals After VAT Changes
Manually edit the line items or invoice summary to ensure the Net, VAT, and Total amounts match.
Focus on adjusting units or prices in line items rather than directly editing the Net or Total amounts in the invoice header.
Limitations of AutoEntry
AutoEntry does not automatically recalculate the Net, VAT, or Total figures after manual adjustments.
Rounding differences caused by external systems like Sage 50 Canada cannot be prevented by AutoEntry.
