One sided entries are one of the most common causes of out of balance issues on the Trial Balance report. Instead of running the full GL issues, running just this script may be more efficient on companies with massive databases.
Select 'One Sided Posting' As 'Problem', * From GL_Register Where Register_ID <> 1 and Amount <> 0 And
Register_Number in
(Select Register_Number
from GL_Register GLR
Group By Register_Number
Having ( (Select COUNT (*) From GL_Register Where register_number = GLR.Register_Number Group By Register_Number) < 2) )
