Invoice upload failed - Total number of lines doesn't match

SmartSync can occasionally fail to upload invoices from SmartSoft Invoice with the following message:

"Invoice '447443' failed to upload to Zahara Total number of lines in table doesn't match total on invoice table: 12/04/2019 at 17:12"

The main cause of this issue is when a user deletes the empty "New" line in SmartSoft Invoices before exporting. By removing the line, the line above becomes the "New" Line. This causes the line item to be missed on export.

For reference, this is the correct format of the Items or VAT SUMMARY window:

This is the incorrect format, that will cause this error in SmartSync:

If you have already exported a number of invoices and they have this issue, you will need to reprocess them. This can either be done in SmartSoft Invoices by loading the invoice back up again, or from within SmartSync.

Find the invoice in the SmartSync Log, tick and edit it. You will see the line items that have been exported:

You can add the missing line and then SmartSync will attempt to push the invoice up on next run. If you need to see the invoice to find the detail of the missing line, you can you the "Files" tab to see the pdf of the invoice:

• Related Articles

• Adhoc invoice approvals

  What are Ad Hoc Approvals? In Zahara you can create as many pre-determined Approval processes as you need – for purchases and for invoices. These rely on logic to determine who the approver is or indeed if the Purchase or Invoice needs to go for ...

• QBO: Invoice Number not being exported into Bill Number

  Symptom If you notice that the invoice number from Zahara is not being exported to QBO, it is simply due to a setting in your QBO system being disabled. Resolution To allow Zahara to push the invoice number into QBO, you need to enable "Custom ...

• Invoice Processing In Zahara

  Overview  In Zahara you can record two types of invoices - standalone and those that relate to a purchase order. There are several different ways of recording an invoice in Zahara and there are two applications you can use to scan / load invoices - ...

• Invoice Matching

  When recording an invoice, you can match it against an order. This means that the line items from the order can be imported saving you having to type them in. Watch the video below to see how Invoice Matching works. One very important thing to know: ...

• Invoice PDF saving using Zapier

  Pre Requisites  You will need a paid for account at Zapier - www.zapier.com Currently this starts at $19.99 per month. Create an account if you don't  already have one.  You will need the preview link for Zahara which is here:  ...