RE: A/R customer balance

SLP06/07 and SLP10/11 balances are updated through transaction entries.
Closing a period doesn't update the balances, but 
does mean that new SLP10/11 records are created for the month just opened.

I run a set of queries over SLP06, SLP07, SLP10, SLP11 and SLP15 which I run
regularly. These create output files containing one record per account
giving
the Base balance and where appropriate, the Prime balance.

These files can then be easily be joined by account highlighting any
differences which arise, which are then easily fixed through DFU.

In practice, I get maybe one or two corrections in a month, sometimes none,
though when I go to a new client site I sometimes find a 
large number of discrepancies that have built up over time. These can be
caused by power failures at 'inappropriate' times, user error 
(such as closing the 'window' in the middle of a session and so on. 

While the system is quite robust, these things can and do happen.

The rebuild option doesn't always work and can be a pain in the a$$ to run.
Personally I found that the queries and the odd DFU is quicker at
identifying the
problems and in fixing them.

The above relates exactly to Purchase Ledger also, with PLP06, PLP07, PLP10,
PLP11 and PLP15.

Garry Clarke
Director
Bluetech Limited
Ireland




-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of
GManoovaloo@xxxxxxxxxxxxx
Sent: 16 July 2003 13:05
To: System 21 Users
Subject: RE: [SYSTEM21] A/R customer balance






Hello Garry
Thks for your input . Correcting the files SLP06 & SLP07 thru their proper
logicals does modify the display of open items enquiry .
But looking at files SLP10 & SLP11  does not reveal inconsistencies , say
from period 01 to current period this year .  I mean that in somes cases ,
where
the current outstanding should be 0 , yet is not , the balance is in fact
the opening balance of the year . I have left these files untouched ,
waiting for your kind reply to this mail . My apprehension is that the
issue may reappear after period 07 closure if the system somehow uses SLP10
/ SLP11 to update SLP06 /SLP07 . This is pure conjecture on my part and
would be glad to have more enlightened opinions from the community .
Thks and regards

EXAMPLE ( SLP06 & SLP07 DFU'D ):


15:44:00
 Customer Enquiry...Item Details - Open Items for All Periods (Prime)
 Account . . ? CAS00104 xxxxxxxxxxxxxx
 Currency. . ? MUR      Rs.
 Period. . . : 0000
 Position to :             Total               .00  Revalued
.00
 X T Type/Ref.    Doc           Original       Outstanding  P  Perd  Due
Cur
     UC 20101697 150703           561.00-           561.00-    0307 150703
MUR
     IN F483541  150703           561.00            561.00     0307 200703
MUR
****************************************************************************
*****
 WORK WITH DATA IN A FILE                       Mode . . . . :   CHANGE
 Format . . . . :   SLR06                       File . . . . :   ACSUMMAR
 Co. No.:                            FZ
 Customer Account Number:            CAS00104
 Statement Balance (Base):
 Last Statement Run No.:                  47
 Date of Last Stment.:               1030430
 Last Stmnt Sess. by A/c:               2300
 Date of Last Sale:                  1030715
 Date Last Payment Received:         1030715
 Current Balance (Base):
 Outstanding Orders Value (Base):
 Revaluation of Outstanding Orders:
 Current Period:
 Latest Revaluation in Base:
 Base Outstanding B.O.E:
 Revalued Outstanding B.O.E:
 Base Goods Despatched Not Invoiced:        22040915-
 No.Invoices Outside Cred.Terms:
****************************************************************************
*****
  WORK WITH DATA IN A FILE                       Mode . . . . :   CHANGE
 Format . . . . :   SLR07                       File . . . . :   SLCBLCUR

 Co. No.:                             FZ
 Customer Account Number:             CAS00104
 Curr. Code:                          MUR
 Current Balance (Prime):
 Outstanding Orders Value (Prime):
 Current Balance (Base):
 Outstanding Orders Value (Base):
 Revaluation of Outstanding Orders:
 Latest Revaluation in Base:
 Prime Outstanding B.O.E:
 Base Outstanding B.O.E:
 Revalued Outstanding B.O.E:
 Prime Goods Despatched Not Invoiced:        22040915-
 Base Goods Despatched Not Invoiced:         22040915-
 Prime Overdue Bucket 1:
 Prime Overdue Bucket 2:
 Prime Overdue Bucket 3:
****************************************************************************
*****
QRY OF SLP10 FOR ABOVE ACCOUNT :

(See attached file: E174852.TXT)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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

######################################################################################