RE: JBA ML - GL - Rebuild

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.