RE: [SYSTEM21] A/R customer balance

[Garry Clarke <garry@xxxxxxxxxxx>]

I presume it SHOULD work, but I've had many an occasion where it didn't.

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of Duncan, Helen (LPG)
Sent: 16 July 2003 13:54
To: System 21 Users
Subject: RE: [SYSTEM21] A/R customer balance


Can the rebuild be run if some of the transactions for the customer have
been archived?  Or do all transactions have to be restored before a
re-build?

Thanks for any suggestions/answers.

Regards
Helen Duncan

-----Original Message-----
From: Wood, Rob (GECP, OTHER, 093249) [mailto:ROB.WOOD@xxxxxxxxxxx]
Sent: 16 July 2003 13:35
To: 'System 21 Users'
Subject: RE: [SYSTEM21] A/R customer balance


It sounds like you have an out of balance situation within the SLP files..
Like I said earlier you might want to try the AR rebuild..  It will complete
wipe out the SLP06, SLP07, SLP10, SLP11 file and rebuild using SLP20...
After that all Balances should equal between the SLP20 and the other SLP
files above.  You will need to enter a starting rebuild period..

Rob

-----Original Message-----
From: GManoovaloo@xxxxxxxxxxxxx [mailto:GManoovaloo@xxxxxxxxxxxxx]
Sent: Wednesday, July 16, 2003 8:05 AM
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 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

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