|
midrange.com
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) QUERY NAME . . . . . ARBALANCES
LIBRARY NAME . . . . WORKJBA
FILE LIBRARY MEMBER
FORMAT
SLP10 OSLSLF3 SLP10
SLR10
DATE . . . . . . . . 03/07/16
TIME . . . . . . . . 15:55:34
SLP10 - PERIOD OPEN/CLOSE BAL
RECON
03/07/16 15:55:34
PAGE 1
PER OPENING DEBITS CREDITS CLOSING CALC CLO
YTD DR YTD CR
10301 3863.20- 29727.40 50002.50- 24138.30- 24,138.30-
29727.40 53865.70-
10302 24138.30- 60302.26 40027.16- 3863.20- 3,863.20-
90029.66 93892.86-
10303 3863.20- 53546.16 53546.16- 3863.20- 3,863.20-
143575.82 147439.02-
10304 3863.20- 51415.41 51415.41- 3863.20- 3,863.20-
194991.23 198854.43-
10305 3863.20- 70837.30 70837.30- 3863.20- 3,863.20-
265828.53 269691.73-
10306 3863.20- 94030.16 94030.16- 3863.20- 3,863.20-
359858.69 363721.89-
10307 3863.20- 36889.39 36889.39- .00 3,863.20-
396748.08 400611.28-
* * * E N D O F R E P O R T * * *
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
