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 “BG: GL Update if Inwards Goods Failed on…” – double click it to show error message. Make sure it’s is actually in General Ledger Log select * from "General_Ledger_Log" where "Trn_Ref" = 100000xxxxx and "Trn_Source" = 'C' Make sure it’s actually in Product Stock table select * from "Product_Stock" where "Trn_Ref" = 100000xxxxx and "Trn_Source" = 'C' If above queries get results then update to finished update "Inw_Goods_Main" set "Status" = 8, "Err_Type" = 0 where "Ref_Number" = 100000xxxxxx