× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.