Creditor Invoice - Totals do not match
v7,v6
Problem: BG : Audit Log Update Failed on Cr Invoice 100000xxxxx. Invoice total do not match to the item total. Difference is x.xx There is probably an extra item on the invoice. If you check the invoice the difference usually equals the total of one item. To fix; Confirm you are fixing the right thing. 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 100000xxxxx” – double click it to show error message. If error says “Invoice total do not match to the item total. Difference is x.xx" then proceed with below. Select * from "Inw_Goods_Main" Where "Ref_Number" = 10000xxxxxx Set the invoice to open again (set "Status" = 5, "Err_Type" = 0), then get clinic to check the invoice and remove the double up and finish invoice again. Update "Inw_Goods_Main" Set "Status" = 5, "Err_Type" = 0 Where "Ref_Number" = 10000xxxxxx