RE: [SYSTEM21] 41/GLE shows ledger not in balance

[mslayton@xxxxxxxxxxx]

No, it should not matter.  If the line in FLP008 already has an updnog 
number in it, it will not update again.  Only the ones that have zero in 
the updnog field will update.  If it has the same reference number on all 
the transactions in FLP008 that are zero, you will only need to zero the 
updnog field for that reference in FLP007.  All this does is force the 
flp008 records to post.  We have had this happen to us before but have 
never found a reason for it.  Someone at (JBA) way back when told us to 
run that query every night in day.  We also do one for AP and AR.  We have 
never had it happen to us in anything but GL. 
Thanks,  Margaret 



"Kincer, Alan" <akincer@xxxxxxxxx> 
Sent by: system21-bounces@xxxxxxxxxxxx
03/24/2004 04:06 PM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>


To
system21@xxxxxxxxxxxx
cc

Subject
RE: [SYSTEM21]   41/GLE shows ledger not in balance






26/GLU reported no unprocessed transactions in FLP007 or FLP008.

I have 24 lines from the third period of this fiscal year that match up 
with
the query you suggested over FLP008. The total of those lines is zero and
they all have the same Document Ref.

Out of curiosity I ran a query over the Document Ref. to see if there were
others that were NE zero. There were and the UPDNOG field was populated 
with
an incremental seven-digit number. Should that be a concern if I update 
the
respective updnog flag in FLP007?

Also should either the total debit or credit I'm seeing in FLP008 total 
the
amount of the discrepancy?

Thanks!

Alan

________________________________________
From: mslayton@xxxxxxxxxxx [mailto:mslayton@xxxxxxxxxxx]
Sent: Wednesday, March 24, 2004 2:29 PM
To: akincer@xxxxxxxxx
Subject: Fw: [SYSTEM21] 41/GLE shows ledger not in balance


Do you run  26/GLU to see if all transactions have been posted?  If they
have, run a query over file FLP008 and select the updnog field equal to
zero.  IF it is, go into the corresponding record in flp007 and remove the
updnog flag and it will then post.  You will need the session number that 
is
not completely posted.  The Document reference number in FLP008 will be 
the
same document reference number in FLP007.
Thanks,  Margaret
----- Forwarded by Margaret Slayton/AMBRAKE on 03/24/2004 02:23 PM -----
"Kincer, Alan" <akincer@xxxxxxxxx>
Sent by: system21-bounces@xxxxxxxxxxxx
03/24/2004 02:14 PM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>

To
System 21 Users <system21@xxxxxxxxxxxx>
cc

Subject
[SYSTEM21]   41/GLE shows ledger not in balance







In running 41/GLE (Print Trial Balance) I have a significant difference
between Cumulative Debits and Cumulative Credits. Can someone tell me 
where
I can check to reconcile this?

Thank you...

Alan


=== [ KI (USA) Corporation - http://www.kiusa.com ]
======================================
Tel. 859.986.1420  --  Fax. 859.986.1485
This e-mail, including any attachments, contains information from KI (USA)
Corporation that may be confidential or privileged. Mail is intended only
for those to whom it is addressed. If you are not the intended recipient 
do
not copy, distribute, or take any action in reliance on the contents of 
this
message.
If you have received this e-mail in error notify the sender immediately 
then
delete or destroy all electronic and hard copies of this communication,
including attachments.
KI (USA) Corporation's anti-virus system checks for known viruses. However
you are advised to run your own virus check before opening any attachments
received. KI (USA) Corporation will not accept any liability once an 
e-mail
and/or any attachment is received.
Views expressed in the e-mail are those of the author and not necessarily
those of KI (USA) Corporation.
============================================================================



_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.