• Subject: Re: SLP15/SLP20 Out of balance
  • From: cmassoglia@xxxxxxxxxxx (Charles L. Massoglia)
  • Date: Mon, 01 Nov 1999 08:10:56 -0400

Mark,

We check all of the items you mention below.  In addition, we have to check
the file balances I mentioned in my original posting as well as internal
FLP004 roll foward balances and hierarchy balances.

GL hierarchy rebuild flat out does not work.  There are 2 know bugs at this
time.  A PTF is avaiable for one and in process for the other.  Until these
PTFs are applied, hierarchy rebuild should not be run.

We have had problems with G/L balance rebuild.  It appears that most of our
G/L balancing problems started in June when we ran a rebuild.  The consensus
of users to whom I spoke at the JBA Financials conference in Las Vegas was
NOT to run the rebuild.

A zero event number in SLP15, SLP20, PLP15 or PLP20 is a BUG as far as I am
concerned.  We got hit by this problem several times in the past.

A record in FLP008 with a zero UPDNOG with a corresponding record in FLP007
with a  non-zer UPDNOG is also a BUG.

A session in SLP20 in which the sum of the allocation records does not
balance to zero is a BUG.  We have had this problem with sessions involving
cancelled checks and deallocations. 

We also continue to have problems with future sessions.  Users in A/R enter
a period date of 12210 which is interpreted as OCT 2022.

I guess we will just have to continue running our file balance programs and
use SQL, DBU, or DFU as appropriate to fix problems as the crop up.
Patching an amount in error of $305.12 is one thing.  Patching an amount
over $1,250,000.00 is quite another.

>Charlie,
>
>Sometimes these files, or a combination thereof, do become out of sync.
>Usually due to a failed posting session, background subsystem failure or
>screen failure.  You should check the following:-
>
>a)    Status 'I' or 'F' sessions in A/R and A/P.
>b)    S/PLP15/20 with zero event (EVNT) number.
>c)    FLP007/8's with update number of -1.
>d)    FLP007/8's with update number of 0 (taking option 1/GLA will tell you
>if you have any 0 FLP007's)
>e)    Any records in SLP76 (cash allocation work file).
>
>The verification/rebuild utilities usually do a pretty food job of keeping
>transaction and balance information in sync (watch the G/L balance rebuild
>if over year end as it sometimes updates the Net Profit and/or Retained
>Earnings incorrectly) but it will NOT update failed sessions.
>
>The Financial systems are usually pretty good at keeping themselves in
>balance.  Do you have any custom software running that posts into the
>Ledgers?
>
>E-mail me through this list or off-line if I can be off any assistance.
>Hope this gives you a place to start.
>
>Regards,
>
>Mark.
>
>----- Original Message -----
>From: Charles L. Massoglia <cmassoglia@voyager.net>
>To: <JBAUSERS-L@midrange.com>
>Sent: Tuesday, October 26, 1999 9:39 PM
>Subject: SLP15/SLP20 Out of balance
>
>
>> Does anyone else have problems keeping SLP15 (AR Item Summary) and SLP20
>(AR
>> Item Detail) in balance?  Do any of you run balancing programs other than
>> those provided by JBA to insure files are in balance, e.g.
>>     SLP15 to SLP20
>>     PLP15 to PLP20
>>     FLP007 to FLP008
>>     SLP20 to FLP008
>>     PLP20 to FLP008
>>     FLP008 to FLP004
>>     FLP004 to FLP044
>>     etc.
>>
>>
>> Charlie Massoglia, Massoglia Technical Consulting, Inc.
>> PO Box 1065, Okemos, MI 48854, USA
>> 517-676-9700  Fax: 517-676-1006  EMAIL: cmassoglia@voyager.net
>>
>>
>> +---
>> | 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.
>+---
>
>


Charlie Massoglia, Massoglia Technical Consulting, Inc.
PO Box 1065, Okemos, MI 48854, USA
517-676-9700  Fax: 517-676-1006  EMAIL: cmassoglia@voyager.net


+---
| 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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 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].