We had a problem a few days ago when we were posting the GL batches for cash receipts.
 
In order to be able to post the batch, the asst. controller printed the out of balance report.  She then went into the GL-P edit GL batches, and made the entry that was causing the GL out of balance.  It was debit to undeposited bank account.  She then went back into GL-O and printed and posted the batch that was now balanced.  It all looked fine.  
 
But, when accounting went to transfer the funds out of undep funds into the bank account, the balance included the corrected entry AND the original entry (which did not appear when they tried to post the batch) so that bank account has $157.25 more in it than it should.  And when the asst controller printed out all the entries made that day in the GL, we are now out of balance by this amount.
 
Accounting proceeded by going into Maintain database and deleting the duplicate entry (bkgltrans I think).  Now the bank is in balance if you look at the trial balance.  However, when they go into GL-K the amount to transfer still has that amount in it.  ???
 
How do we clear this amount?  Do we again use maintain DB to fix?  If so, we are not sure what tables to go into to delete it.    Or do we fix by some other means?  Should MDB not have been used in the first place?
 
TIA,
 
Val

Sometimes things happen where entries need made to straighten out GL bank balances, but the check registers are okay.  In that case, when creating a GJ entry, use transaction type 1, not 2 or 3 so it posts to GL but not the check register.