|
midrange.com
Hi Guys
Thought I might throw my 2 cents worth in.
Before I start I must state that I am quite prepared to be corrected on
this suggestion and would welcome any further dialogue.
We too had this problem last February (2001) and an ex JBA consultant,
contracting for another part of our company, corrected it.
I THINK (not sure) that he restored the GL balance files from before the
rebuild, reset the UPDNOG in FLP007 and FLP008 and called the GLUPDAT
program. Obviously UPDNOG was only reset for transactions created since the
backup of the restored balances file.
Sounds a bit simple and I would welcome comments
BR
Rick Allen
To: "jbausers-l@midrange.com"
<jbausers-l@midrange.com>
cc:
Michael Berman Subject:
Re: JBA ML - GL - Rebuild
<mxb1@start.com.au>
Sent by:
jbausers-l-admin@midrange.com
06/02/2002 03:19 PM
Please respond to jbausers-l
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
_______________________________________________
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
