Re: JBA ML - GL - Rebuild

[Michael Berman <mxb1@xxxxxxxxxxxx>]

Please pay extra attention when amending the UPDNOG!
There are 2 of them one on FLP007 and one on FLP008.

The one of FLP007 controls the Balances Update for all records on
FLP008 that havent been processed (UPDNOG=zero).

It is just one of those things that sends shivers up my spin with the
design, simplicity, danger and power!

Regards

Michael



Original message from: mslayton@ambrake.com
>
>This is a multipart message in MIME format.
>--
>[ Picked text/plain from multipart/alternative ]
>We have had the same problem here.  We ran the rebuild beginning with
the
>month that was out of  balance.  It fixed the balances until
December.
>Then December was out.  We ran the rebuild again beginning with
December
>and it worked.  Also run a query over FLP008 and see if there are
>transaction in there that do not show up on the Unprocessed
Transactions
>report.  If the FLP007 record shows posted, there can also be
transactions
>in FLP008 that do not post.  Check the updnog field in flp008.  We
have
>had this to happen.  If that is the case, clear the updnog flag in
the
>corresponding FLP007 record and it will finish posting the FLP008
records.
>
>
>
>
>
>Ram Hari <RamHari@wasserstrom.com>
>Sent by: jbausers-l-admin@midrange.com
>02/05/2002 11:08 PM
>Please respond to jbausers-l
>
>
>        To:     "'jbausers-l@midrange.com'" <jbausers-l@midrange.com>
>        cc:
>        Subject:        RE: JBA ML - GL - Rebuild
>
>
>
>        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.
>
>
>_______________________________________________
>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