If a customer has an unallocated amount on their Trial Balance and the total balance is off by that amount, you can use this script to locate the entry on the backend.
Select 'Invalid Account ID' As 'Problem', * From GL_Register glr Where Register_ID <> 1 and Amount <> 0 and Amount <> 0 And
(Account_Id = 1 or not Exists (Select Account_Id from GL_Account Where Account_Id = glr.Account_ID) )
