Re: Rebuild balances -- SYSTEM21

Further to Gary's note where we spent many hours verifying the Memo Net
Profit Account and the Retained Earnings Account.

The main problem with rebuilding the balances is that changes to the chart
of accounts (eg extention codes etc) and the purging of transactions.  If
you have purged or changed extention code, the 'missing' acocunt postings
will be rebuilt to the Rounding Error Accounts.
With the purge, the transactions are not available to rebuild.

If any of these have ocurred - DO NOT rebuild the balances.

The Memo Net Profit Account has no postings and the balance(s) can be
amended by DFU.
The same thing for the Retailed Earnings Account, but please ensure that
any real postings to this account are included in your calculations.  The
file to DFU is PERBAL or FLP004, and it must be done for all incorrect
periods excluding the current open period.

The Memo Net Profit Account can be thrown out by failed GL transactions.
The proper correction for these transactions (FLP008 records with no
UPDNOG), may not update the Net Profit Account.

I hope this helps.

Michael





Gary.Brown@appliedchemicals.com on 21/07/2000 09:53:41

Please respond to JBAUSERS-L@midrange.com
                                                              
                                                              
                                                              
 To:      JBAUSERS-L@midrange.com                             
                                                              
 cc:                                                          
                                                              
                                                              
                                                              
 Subject: Re: Rebuild balances                                
                                                              










We have just had the 'pleasure' of running a balances re-build. We actually
ended fixing up the problems manually.

We found a couple of things to watch out for.

Take the validation reports with a grain of salt, i.e. make sure you
understand
the errors the reports say exist.
In our case report GL226 claims that some accounts payable invoice postings
are
in error/out of balance when they in fact they are not and report GL085 has
a
documented problem and incorrectly reports that the net profit account is
out of
balance.

One real problem that we encountered is that we use extension codes on some
of
our accounts, e.g. mobile phone numbers for phone expenses. Our GL people
had
been vigilant and when a mobile phone was stolen or no longer used the
phone
number was removed from the extension codes. When we now run the re-build
option
we get a lot of account posting errors because the extension code that is
on the
record is no longer valid.


+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---



+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---