ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> YE post to RE messed up!
http://www.istechforum.com/YaBB.pl?num=1073695086

Message started by cathyh on 01/09/04 at 16:38:06

Title: YE post to RE messed up!
Post by cathyh on 01/09/04 at 16:38:06

:'( HelP! WE have a major YE problem. Our accounting person was posting transactions after we had done the year end routine. She printed and posted one type (RP) and then before exiting the program, GL-O, printed and posted another type(GL). DBA took the Retained earnings amount from the first batch and added it to the second batch's posting to retained earnings. She did this three different times on three different days, all with the same results. Needless to say, we are out of balance. I made a test company and changed the totals for the transactions to RE in maintain database but this did not change the situation. Anyone have a solution?

Title: Re: YE post to RE messed up!
Post by aricon on 01/09/04 at 17:37:46

Post correcting transactions that zero out the effect of those erroneous transactions. Then go to UT-A and run program GLEREDO. You may also want to recalulate the GL chart of accounts (UT-something or other...)

Title: Re: YE post to RE messed up!
Post by Lynn_Pantic on 01/12/04 at 10:57:29

Actually, if all the erroneous transactions are YE type, all you need to do is UT-A, GLEREDO.

I had seen prior reports of this for a couple of years (old DBA bug) but nobody could clearly explain what they did or could duplicate. Thanks to your description, I think we can now get this old bug fixed! Thanks!

Title: Re: YE post to RE messed up!
Post by cathyh on 01/13/04 at 11:31:01

HI Lynn, glad we could give some details that will help fix this. I reproduced the event in a test company just now so that I could run that utility and had a problem with it. When I went to post the year end journal entries that it produced for the past 3 years(!) I got an error message that about half of the 230 transactions had an invalid date, 12/31/2002, so I exited since this is only a test company and not the real thing!
We had already fixed the error in the real company by isolating the transaction in the RE account and editing it in maintain database, BKGLTRAN, and then running UT-K-D for the RE GL account. This worked. I just don't know if we cleaned it up completely. Would this error be kept in any other records?
P.S. I love this forum! ;D

Title: Re: YE post to RE messed up!
Post by Lynn_Pantic on 01/13/04 at 16:53:44

Editing BKGLTRAN and then running UT-K-D will take care of it, no other filesw affected. The other would have worked too, you just need to set the GL Close date in AM-A back prior to the oldest entry so you can post them. GLEREDO regenerates all the closing entries back to the beginning of 2 years past.