Re: JBA ML - GL - Rebuild

[Michael Berman <mxb1@xxxxxxxxxxxx>]

Ram,
It may be a Y2K problem.
Cant GEAC provide the PTF????
Perhaps get someone to look at the programming side (if you have the
source)

It seems the only alternative is queries to verify the balances.
Retained earnings will need to be done manually. (FLP008 vs FLP004
then FLP004 for the control accounts).
Make sure your Memo Profit & loss are correct before you run Year End.


If it is only a few accounts, I would let it be and amend (dfu) those
that are in error.  You never know what the rebuild will do from Adam
and Eve.

Do you have a test environment/machine where you can trial things out?

Good luck

Michael



Original message from: Ram Hari <RamHari@wasserstrom.com>
>
>
>       Michael,
>       Everything was clean before I ran the rebuild, even after running
>the rebuild I did run Verify balances and unprocessed transaction
report and
>they have no errors, but still my trial balance is out of balance. I
ran
>trial balance for prior closed years and everything has changed (just
couple
>of accounts including my retained earnings !!!!!!!!!!!).
>This is highly unacceptable.
>A Gentlemen form a consulting company sent me an off the list email
saying
>that this problem is fixed in V352 SP3 and the current rebuild
program only
>works till period 9912, probably a Y2K bug but this does not help as
we are
>in V351.
>
>Anyway I have two options now:
>1. Run a rebuild again from the start of time and see what
happens.(before I
>just rebuilt from the period I had problems with)
>2. If option 1 does not work, get into each GL account and get the
balances
>right in FLP004 through DFU/ UPDDTA after doing a couple of quires
with
>FLP007 and FLP008.
>There goes my sleep for the next couple of days, thanks
JBA.................
>
>Please let me know if I need to look into something more
>
>Thanks
>
>
>> -----Original Message-----
>> From:        Michael Berman [SMTP:mxb1@start.com.au]
>> Sent:        Tuesday, February 05, 2002 5:27 PM
>> To:  jbausers-l@midrange.com
>> Subject:     Re: JBA ML - GL - Rebuild
>>
>> Ram,
>> If the rebuild didnt work, throwing out your trial balance, it may
be
>> because of unprocessed GL Transactions.
>>
>> Try 26/GLU Unprocessed transaction reports.  I bet there are one or
>> more transactions that total to your difference in your trial
balance.
>> If so, let me know (this gives me time to ponder a solution)
>>
>> Did these show on the rebuild error report?  What was on the
rebuild
>> error report.
>>
>> I would notmally recommend against a rebuild especially if you use
>> extension codes.
>>
>> How long did the rebuild take?
>>
>> FLP004 is the GL Period Balances File (logical PERBAL)
>>
>>
>> Regards
>>
>>
>> Michael
>>
>>
>>
>>
>>
>> Original message from: Ram Hari <RamHari@wasserstrom.com>
>> >
>> >
>> >I attempted a GL Rebuild over the weekend and the period balances
I
>> had
>> >problems with got fixed but now I have a new problem....
>> >Just a select Balance Sheet account's cumulative balance is not
right
>> and my
>> >trial balance is showing up error.
>> >Just to let you know we do have a copy of the old trial balance we
>> ran
>> >before the rebuild and one now
>> >Please let me know how to get my trial balance report intact.
>> >We are in V351
>> >Thanks
>> >
>> >
>> >Ram S. Hari
>> >Sr. Programmer/Analyst
>> >mailto:ramhari@wasserstrom.com
>> >Voice 614.737.8542
>> >
>> >
>> >
>> >_______________________________________________
>> >This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
>> >To post a message email: JBAUSERS-L@midrange.com
>> >To subscribe, unsubscribe, or change list options,
>> >visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
>> >or email: JBAUSERS-L-request@midrange.com
>> >Before posting, please take a moment to review the archives
>> >at http://archive.midrange.com/jbausers-l.
>> >
>> >.
>> >
>>
>>
>> __________________________________________________________________
>> Get your free Australian email account at http://www.start.com.au
>>
>> _______________________________________________
>> This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
>> To post a message email: JBAUSERS-L@midrange.com
>> To subscribe, unsubscribe, or change list options,
>> visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
>> or email: JBAUSERS-L-request@midrange.com
>> Before posting, please take a moment to review the archives
>> at http://archive.midrange.com/jbausers-l.
>_______________________________________________
>This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
>To post a message email: JBAUSERS-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
>or email: JBAUSERS-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/jbausers-l.
>
>.
>


__________________________________________________________________
Get your free Australian email account at http://www.start.com.au