Chapter 2: Initial Setup File Maintenance
Option 22Customer History List
Use this function to print a list of the Customer History file. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Customer History by Month Information, this step provides you with a default sequencing of data records by Customer, Year, and Month, with the option to change modifiable parameters at run time. Selection of data records is provided by Customer, with the option to enter user-specified comparisons at run time.
Step 2 this is the standard disposition used for all lists of master files.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Customer History List, this step formats the Customer History by Month information. The following data items are shown: Customer, name, Month, Year, High Balance, Days to Pay, Number of Invoices, Sales, and Margin.
A sample output is shown below.
Expert Computing, Inc.
10/10/94 11:54 LGG Page: 1
Customer History List
Customer High No
Cust Name Month Balance Days Inv Sales Margin
====================================================================================================================================
00000020 Master Sellers Company 3 89 1955 41 2 2066.00 187.00
00000020 Master Sellers Company 4 89 1814 44 1 945.00 140.00
00000020 Master Sellers Company 5 89 2312 38 2 2099.00 230.00
00000020 Master Sellers Company 6 89 1564 36 1 994.00 126.00
00000020 Master Sellers Company 7 89 2008 40 2 1841.00 209.00
00000020 Master Sellers Company 8 89 1996 41 1 866.00 118.00
00000020 Master Sellers Company 9 89 1453 42 1 917.00 121.00
00000020 Master Sellers Company 10 89 1589 30 0 .00 .00
00000020 Master Sellers Company 11 89 612 30 1 752.00 99.00
00000020 Master Sellers Company 12 89 752 30 1 840.00 111.00
00000020 Master Sellers Company 1 90 20581 251 5 10599.60 2212.06
00000020 Master Sellers Company 2 90 10375 197 4 3559.60 384.46
00000020 Master Sellers Company 3 90 5316 64 2 5408.00 1438.96
00000020 Master Sellers Company 4 90 3896 0 1 360.00 359.50
00000020 Master Sellers Company 8 90 1830 0 0 .00 .00
00000020 Master Sellers Company 11 90 3551 0 0 360.00 346.50
00000030 Pool and Associates 3 89 6420 22 2 3256.00 267.00
00000030 Pool and Associates 4 89 4890 20 3 4050.00 299.00
00000030 Pool and Associates 5 89 3866 28 1 1789.63 115.00
00000030 Pool and Associates 6 89 4280 22 0 .00 .00
00000030 Pool and Associates 7 89 4729 23 3 3967.00 284.00
00000030 Pool and Associates 8 89 3625 18 2 2288.00 202.00
00000030 Pool and Associates 9 89 4011 25 0 .00 .00
00000030 Pool and Associates 10 89 3820 20 1 1222.00 91.00
00000030 Pool and Associates 11 89 5100 24 3 4210.00 309.00
00000030 Pool and Associates 12 89 4587 17 0 .00 .00
00000040 Burlington Enterprises 3 89 13844 16 4 9052.66 348.00
00000040 Burlington Enterprises 4 89 15467 13 2 5841.24 212.00
00000040 Burlington Enterprises 5 89 11892 15 4 9412.19 361.00
00000040 Burlington Enterprises 6 89 13874 16 2 5966.32 223.00
00000040 Burlington Enterprises 7 89 10770 12 3 7256.33 303.00
00000040 Burlington Enterprises 8 89 12128 14 2 5774.18 204.00
00000040 Burlington Enterprises 9 89 11561 12 1 3841.00 168.00
00000040 Burlington Enterprises 10 89 9866 14 0 .00 .00
00000040 Burlington Enterprises 11 89 13398 15 4 10553.27 351.00
00000040 Burlington Enterprises 12 89 15983 17 3 7049.85 287.00
00000040 Burlington Enterprises 1 90 17737 230 5 4678.11 1145.16
00000040 Burlington Enterprises 2 90 15321 341 5 8088.08 1265.98
00000040 Burlington Enterprises 3 90 14877 64 2 5814.50 722.71
00000040 Burlington Enterprises 4 90 12696 0 2 1758.26 1268.06
00000050 Miscellaneous Customer 3 89 1055 10 0 .00 .00
00000050 Miscellaneous Customer 4 89 586 12 1 591.32 68.00
00000050 Miscellaneous Customer 5 89 0 0 0 .00 .00
00000050 Miscellaneous Customer 6 89 0 0 0 .00 .00
00000050 Miscellaneous Customer 7 89 1254 10 2 1895.66 152.00
00000050 Miscellaneous Customer 8 89 1389 8 1 897.64 85.00
00000050 Miscellaneous Customer 9 89 542 10 0 .00 .00
00000050 Miscellaneous Customer 10 89 1147 11 2 1755.68 147.00
00000050 Miscellaneous Customer 11 89 982 0 0 .00 .00
00000050 Miscellaneous Customer 12 89 674 10 1 608.41 70.00