RE: A/R customer balance

The most common problem I have found is that the STSF20 on SLP20 hasn't been
updated but the session has been updated to complete - meaning that some
transactions will have no impact on the balances.

I wish I knew why too.

I would also use the unprocessed transactions report and a query showing
SLP20 transactions with STSF20 <> '1'

Again DFU'ing will only cause you grief unless you are 120% sure of what you
are doing.

It will also bite you hard at year end when you have the GL/AR/AP
Reconciliation report.


Regards

Michael Berman


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]On
Behalf Of Richard_Caldicott@xxxxxxxxxxxxxxx
Sent: Wednesday, 16 July 2003 11:34 PM
To: System 21 Users
Subject: RE: [SYSTEM21] A/R customer balance

DFUing a financial file!!!! - I'd be very careful with that, especially
with the current attitude that auditors have.

The rebuild programs are pretty robust and apart from a couple of issues
for people using alpha delivery sequences they run without problem.  (An
exception is a US fix that came out with SP4 that screws up SLP10).  Usually
there is good
reason for balances not updating correctly.  Have you run 13/ARU - first 2
reports only.  They will tell you if there is a problem between SLP15 and
SLP20 - balances are built from the SLP20 and one of your inquiries is
looking at the SLP15.  Also it will tell you if you have a balance problem
and need to rebuild.  This option is pretty fast and doesn't need
exclusive use.

Richard





Garry Clarke <garry@xxxxxxxxxxx>
Sent by: system21-bounces@xxxxxxxxxxxx
07/16/2003 03:00 AM
Please respond to System 21 Users


        To:     "'System 21 Users'" <system21@xxxxxxxxxxxx>
        cc:
        Subject:        RE: [SYSTEM21]   A/R customer balance


Common problem in System 21 Accounts Receivable and Accounts Payable.

Assuming there's only a few accounts involved, the easiest option is a DFU
on the balances file.
SLP06 - Base Balances
SLP07 - Prime Balances

Also check total balance due on SLP10 (Base Period Balances) and SLP11
(Prime Period Balances)

Of course, you must check first that the transaction balances are correct,
but they usually are.

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of
GManoovaloo@xxxxxxxxxxxxx
Sent: 16 July 2003 07:24
To: jbausers-l@xxxxxxxxxxxx
Subject: [SYSTEM21] A/R customer balance






We have the following situation : some customer accounts ( A/R ) show
discrepancies between outstanding trans. amount andf balance upon enquiry
(
3/ARE , F13 ) .
Below is an example :

 SL202                 XX - ...................................... User
JBAMGR     14/07/03
15:17:08
 Customer Enquiry...Item Details - Open Items for All Periods (Prime)
 Account . . ? CAS00104       XXXXXXXXXXXX
 Currency. . ? MUR      Rs.
 Period. . . : 0000
 Position to :             Total           2583.20- Revalued
2583.20-
 X T Type/Ref.    Doc           Original       Outstanding  P  Perd  Due
Cur
     IN F482857  120703          1280.00           1280.00     0307 170703
MUR
1=Full details 5=All transactions 6=Creation event details  8=Text
F3=Exit       F4=Prompt       F12=Previous       F14=All items    F24=More
Keys

There is no  Incomplete session nor any duplicate allocatiion for the
company . We have also rebuilt  balances for the company ( 11/ARU )
without
any improvement .
Thank you for any suggestion .

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


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail message has been scanned for Viruses and Content and cleared
by the Mail Marshal Filtering System
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

############################################################################
#########
Internet Communications are not secure and therefore Dimpco do not accept
any liability for the contents of this message. Any views or opinions
presented are solely those of the author and do not necessarily represent
those of Dimpco.

The contents of this email message are private and intended solely for the
named recipient. Unauthorised access of this email is prohibited. If you
are not the intended recipient of the message please notify the sender
immediately.


This e-mail message has been scanned for Viruses and Content and cleared
by Dimpco's Mail Filtering System

############################################################################
##########
_______________________________________________
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.



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