RE: SLP15/SLP20 Out of balance -- SYSTEM21

Charlie, 

We also struggle to keep the A/R, A/P, and G/L files in balance.  It's a
daily process for us to recover failed sessions in all 3 applications.
However, I'm concerned about your comments regarding the JBA rebuild
programs.  We execute the A/R and A/P rebuild programs religiously every
month-end, and execute the G/L rebuild program as needed.  They seem to work
as well as can be expected, and without them we'd be in a world of hurt!
The only problems we've encountered to date include the incorrect year-end
update of Net Profit/Retained Earnings mentioned below, and a Y2K bug in the
A/R rebuild prompt program SL816.  We've also executed the G/L Hierarchy
rebuild for our Belgium location, and it appears to work reasonably well.

We're currently on release 3.5.0, so perhaps these rebuild problems
mentioned at the JBA Financials conference are "provided" in future
releases.  Could you please send me any information you have about all the
known problems and PTFs concerning these rebuild programs?  We'd be very
appreciative, and will gladly pass on any session recovery information we
have that might help you out.

Thanks in advance!

Glenn R. Schreiner
Hach Company
Sr. Programmer Analyst
Information Services & Technology
(970) 663-1377, ext. 2509


       

-----Original Message-----
From: cmassoglia@voyager.net [mailto:cmassoglia@voyager.net]
Sent: Monday, November 01, 1999 5:11 AM
To: JBAUSERS-L@midrange.com
Subject: Re: SLP15/SLP20 Out of balance


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