ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> GL-K problem
http://www.istechforum.com/YaBB.pl?num=1131640310

Message started by gtladmin on 11/10/05 at 08:31:50

Title: GL-K problem
Post by gtladmin on 11/10/05 at 08:31:50

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

Title: Re: GL-K problem
Post by gtladmin on 11/10/05 at 09:08:50

Got our answer from Lynn - UT-K-D, and then rebuild the balance for that account.

Thanks, Lynn! ;D We'll give it a try.

Regards,

Val

Title: Re: GL-K problem
Post by Karen Mason on 11/10/05 at 13:46:29

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.

Title: Re: GL-K problem
Post by gtladmin on 11/15/05 at 10:07:10

Hi Karen,

Thanks for that piece of info, I think we actually just had that happen at our sister company (waiting for confirm on). That's helpful to know for future reference. UT-K-D in this case fixed it.

Thanks everyone for your help! ;D

Regards,

Val