---
title: SQL - Creditor Error - Totals Do Not Match - Extra Item in the Invoice
description: VetLinkPro SQL - Creditor Error - Totals Do Not Match - Extra Item in the Invoice
---
# VetLink PRO
Connecting Veterinary Professionals with Smarter Solutions
[Skip to content](https://help.vetlinkpro.com/vetlinkpro/sql-creditor-error-totals-do-not-match-extra-item-in-the-invoice#main-content)
English - Australia
Show submenu for translations
Open main navigation
Close main navigation
- English - Australia
Show submenu for translations
- Contact us
Contact us
How can we help you?
- There are no suggestions because the search field is empty.
1. [VetLink PRO](https://help.vetlinkpro.com/vetlinkpro)
2. [Support](https://help.vetlinkpro.com/vetlinkpro/support)
3. [Creditors](https://help.vetlinkpro.com/vetlinkpro/support#creditors)
# SQL - Creditor Error - Totals Do Not Match - Extra Item in the Invoice
## v7,v6
There’s a bug in version 5.1 where they delete an item but then when they finish it comes back again without them realising. So there’s basically an extra item on the invoice, so the items then don’t add to the total. I think razal has fixed in version 6. It usually happens when they add an item with a similar name to what they actually wanted. So they delete incorrect item but then it comes back… The way to check is to; Clear the error from error information screen and process BG Click the BG errors button There will be an error saying “Audit Log Update Failed on CR invoice xxxx” – double click it to show error message. You can then check invoice and you will probably see an item matching that amount Check that the Invoice state is saying Closed and Stock Upd Pending If it is then to fix you can just open the invoice again by update "Inw\_Goods\_Main" set "Status" = 5, "Err\_Type" = 0 where "Ref\_Number" = xxxxx Contact the clinic and tell them to go into Unfinished Invoices -\> delete the incorrect item -\> finish the invoice again.
- [Support](https://help.vetlinkpro.com/vetlinkpro/support#main-content)
- [Client Portal](https://help.vetlinkpro.com/vetlinkpro/support#client-portal)
- [Creditors](https://help.vetlinkpro.com/vetlinkpro/support#creditors)
- [Upgrade](https://help.vetlinkpro.com/vetlinkpro/support#upgrade)
- [Payments](https://help.vetlinkpro.com/vetlinkpro/support#payments)
- [Patient](https://help.vetlinkpro.com/vetlinkpro/support#patient)
- [Product](https://help.vetlinkpro.com/vetlinkpro/support#product)
- [Xero](https://help.vetlinkpro.com/vetlinkpro/support#xero)
- [Clinical History](https://help.vetlinkpro.com/vetlinkpro/support#clinical-history)
- [RDS Setup](https://help.vetlinkpro.com/vetlinkpro/support#rds-setup)
- [Client](https://help.vetlinkpro.com/vetlinkpro/support#client)
- [Diary](https://help.vetlinkpro.com/vetlinkpro/support#diary)
- [Mailers](https://help.vetlinkpro.com/vetlinkpro/support#mailers)
- [Exports](https://help.vetlinkpro.com/vetlinkpro/support#exports)
- [Stocktake](https://help.vetlinkpro.com/vetlinkpro/support#stocktake)
- [Reports](https://help.vetlinkpro.com/vetlinkpro/support#reports)
- [EOP / Statements](https://help.vetlinkpro.com/vetlinkpro/support#eop-statements)
- [Eforms / Digital Forms](https://help.vetlinkpro.com/vetlinkpro/support#eforms-digital-forms)
- [Other](https://help.vetlinkpro.com/vetlinkpro/support#other)
- [Printing](https://help.vetlinkpro.com/vetlinkpro/support#printing)
- [Email](https://help.vetlinkpro.com/vetlinkpro/support#email)
- [Server / Technical](https://help.vetlinkpro.com/vetlinkpro/support#server-technical)
- [Insurance](https://help.vetlinkpro.com/vetlinkpro/support#insurance)
- [Bill](https://help.vetlinkpro.com/vetlinkpro/support#bill)
- [Vac Reminders](https://help.vetlinkpro.com/vetlinkpro/support#vac-reminders)
- [Online Booking](https://help.vetlinkpro.com/vetlinkpro/support#online-booking)
- [Mobile Billing](https://help.vetlinkpro.com/vetlinkpro/support#mobile-billing)
- [Barcoding](https://help.vetlinkpro.com/vetlinkpro/support#barcoding)
- [SMS](https://help.vetlinkpro.com/vetlinkpro/support#sms)
- [General Ledger](https://help.vetlinkpro.com/vetlinkpro/support#general-ledger)
- [Staff](https://help.vetlinkpro.com/vetlinkpro/support#staff)
- [Telemedicine](https://help.vetlinkpro.com/vetlinkpro/support#telemedicine)
- [Manual](https://help.vetlinkpro.com/vetlinkpro/manual#main-content)
- [6.1](https://help.vetlinkpro.com/vetlinkpro/manual#6-1)
- [7.0](https://help.vetlinkpro.com/vetlinkpro/manual#7-0)
[](https://www.vetlinkpro.com)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, VetlinkPRO