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.