ZENITH PAINTS
UPDATED CUSTOMER MASTER FILE REPORT (Program 4 output) DATE: 26-11-00
PAGE 1
CUSTOMER CREDIT LAST
CODE NAME ADDRESS BALANCE(£) LIMIT(£) MOVEMENT DATE
-------------------------------------------------------------------------------------------------------
00990 valid record-5 address line-1 3.40 20100 26-11-00
address line-2
01007 Record processed ADDRESS-LINE-1 476.00 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
01015 Record processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
01023 Record processed ADDRESS-LINE-1 1.00 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
01031 Record processed ADDRESS-LINE-1 513.50 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
03166 Cus already exists ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
03263 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
03662 valid record-4 address line-1 3.40 20100 26-11-00
address line-2
address line-3
05142 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
BALANCE CARRIED FORWARD: £ 2001.30
BALANCE BROUGHT FORWARD: £ 2001.30
PAGE 2
CUSTOMER CREDIT LAST
CODE NAME ADDRESS BALANCE(£) LIMIT(£) MOVEMENT DATE
-------------------------------------------------------------------------------------------------------
07269 Record processed ADDRESS-LINE-1 301.00 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
07358 valid record-1 address line-1 1234.56 1000000 26-11-00
address line-2
address line-3
address line-4
07528 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
08168 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
10103 Record processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
11568 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
12572 Record processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
13498 valid record-2 address line-1 1.00 100000 26-11-00
address line-2
address line-3
address line-4
13749 Record processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
BALANCE CARRIED FORWARD: £ 5043.86
BALANCE BROUGHT FORWARD: £ 5043.86
PAGE 3
CUSTOMER CREDIT LAST
CODE NAME ADDRESS BALANCE(£) LIMIT(£) MOVEMENT DATE
-------------------------------------------------------------------------------------------------------
16250 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
16870 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
16888 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
17752 Not in stocklist ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
17884 Record processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
18899 Non-zero D-error ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
19127 Record processed ADDRESS-LINE-1 49.00CR 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
19453 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
19852 Record processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
BALANCE CARRIED FORWARD: £ 7002.86
BALANCE BROUGHT FORWARD: £ 7002.86
PAGE 4
CUSTOMER CREDIT LAST
CODE NAME ADDRESS BALANCE(£) LIMIT(£) MOVEMENT DATE
-------------------------------------------------------------------------------------------------------
20133 Record processed ADDRESS-LINE-1 271.00 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
2992X Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
33332 Record processed ADDRESS-LINE-1 248.50 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
36676 Non-zero D-error ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
37672 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
>>> 39721 Debtor ADDRESS-LINE-1 25.00 0 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
EXCESS BALANCE: £ 25.00
40045 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
40177 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
40525 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
BALANCE CARRIED FORWARD: £ 9053.36
BALANCE BROUGHT FORWARD: £ 9053.36
PAGE 5
CUSTOMER CREDIT LAST
CODE NAME ADDRESS BALANCE(£) LIMIT(£) MOVEMENT DATE
-------------------------------------------------------------------------------------------------------
40649 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
4077X Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
44873 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
45454 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
5620X Processed ADDRESS-LINE-1 2049.80CR 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
56448 Processed ADDRESS-LINE-1 143.00 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
57177 Processed ADDRESS-LINE-1 237.00 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
57991 Processed ADDRESS-LINE-1 212.50 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
60771 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
BALANCE CARRIED FORWARD: £ 8851.06
BALANCE BROUGHT FORWARD: £ 8851.06
PAGE 6
CUSTOMER CREDIT LAST
CODE NAME ADDRESS BALANCE(£) LIMIT(£) MOVEMENT DATE
-------------------------------------------------------------------------------------------------------
61131 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
61182 valid record-3 address line-1 3.40 20100 26-11-00
address line-2
address line-3
address line-4
6119X Processed ADDRESS-LINE-1 482.00 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
71404 Processed ADDRESS-LINE-1 293.00 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
71510 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
71722 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
71838 Processed ADDRESS-LINE-1 1815.00CR 1500 26-11-00
ADDRESS-LINE-2
ADDRESS-LINE-3
>>> 72044 Debtor ADDRESS-LINE-1 251.00 0 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
EXCESS BALANCE: £ 251.00
72150 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
BALANCE CARRIED FORWARD: £ 9069.46
BALANCE BROUGHT FORWARD: £ 9069.46
PAGE 7
CUSTOMER CREDIT LAST
CODE NAME ADDRESS BALANCE(£) LIMIT(£) MOVEMENT DATE
-------------------------------------------------------------------------------------------------------
72265 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
7237X Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
72486 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
72591 Not processed ADDRESS-LINE-1 251.00 1500 21-10-00
ADDRESS-LINE-2
ADDRESS-LINE-3
ADDRESS-LINE-4
-------------------------------------------------------------------------------------------------------
TOTAL BALANCE = £ 10073.46
TOTAL NUMBER OF RECORDS PRINTED = 58
TOTAL NUMBER OF DEBTORS = 2
>>> = CUSTOMER WITH DEBIT BALANCE THAT EXCEEDS CREDIT LIMIT. CR = CREDIT BALANCE
*** END OF REPORT ***
|