4Reports and Inquiry
Option 10Customer Credit
Use this function to print credit information by customer. You can print the transaction detail, if you choose. The following processing steps accomplish this job.
- Step 1You can use this function to choose whether or not to print the transaction detail for each customer on this report.
On the following pages, the screen displayed by this function is shown.
The screen shown below allows you to choose either the detail or the summary Customer Credit report.
Transaction Processing menu
Data items for the preceding screen are described below:
- Print Transaction Detail?
Y or N Required
Specify whether or not transaction detail should be printed for each customer on the report. The default value is ‘Y’. The display may be changed:
- Y
- Print transaction detail.
- N
- Do not print transaction detail.
Press ENTER to save the information on this screen.
- Step 2In preparation for performing a sort/selection process on the Customers information, this step provides you with a default sequencing of data records by Customer Alpha and Customer, with the option to change modifiable parameters at run time. Selection of data records is provided by Customer Alpha, Customer, Credit Status, Area, Type, Division, Terms Code, Salesperson, and On Order, with the option to enter user-specified comparisons at run time.
- Step 3This is the standard disposition used for all reports not printed on special forms.
- Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 5In order to print the Customer Credit report, this step formats the Customers information. The following data items are shown: Customer, Name, Customer, Credit Limit, Customer High Balances Per Quarter, Average Days for Payment, First Transaction, Customer MTD Sales, Contact, Balance, Last Transaction, Customer YTD Sales, Phone, Available Credit Amount, Last Payment, Customer Pervious Year Sales, Credit Status, Invoice Date, On Order, and Comments.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:15 LGG Page: 1
Customer Credit
As Of 8 / 89
Cust No Customer Name Cr Limit High Balance Average First Trx MTD Sales
Contact Balance Last 4 Quarters Days to Pay Last Trx YTD Sales
Phone No Available Last 4 Qtrs Last Pay Prev Yr Sales
Comment Cr Status Oldest Inv On Order
=================================================================================================================================
00000060 Hale’s Interiors 9999.00 15786.00 54 04/05/89 .00
Helen Walls 3339.69 .00 0 08/12/89 14210.16
(212) 767-5666 6659.31 .00 0 08/11/89 .00
OK .00 0 05/28/89 2370.00
New customer as of April 1989. Limited credit until 9/1/89.
00000100 Highland Park Variety Shop 9999999.00 11321.00 54 4380.50
.00 2614.00 8 17160.61
(414) 555-1122 9999999.00 2715.00 6 32485.00
OK 2297.00 7 3940.00
00000130 Commonwealth Kennel LTD 9999999.00 .00 0 .00
.00 .00 0 .00
(303) 333-2345 9999999.00 .00 0 .00
OK .00 0 .00
00000090 Marsh & McLennan, Inc. 9999999.00 .00 0 .00
.00 .00 0 .00
(333) 456-1223 9999999.00 .00 0 .00
OK .00 0 .00
00000020 Master Sellers Company 1000.00 20581.00 47 11/01/88 5408.00
Rich Gonzales 3895.71 1589.00 45 04/15/90 19567.20
(516) 561-7654 2895.71- 2008.00 31 08/11/89 11320.00
BAD 2312.00 30 05/15/89 .00
Late on payments.
00000030 Pool and Associates 9999999.00 .00 0 12/20/88 .00
Shelly Hodges 2894.01 5100.00 15 07/31/89 .00
(804) 887-9836 9997104.99 4729.00 13 08/11/89 20782.63
OK 4890.00 18 07/21/89 .00
Good Customer. Also our ad agency.
00000070 Richards & Wright, PC 9999999.00 14695.00 0 06/10/89 1684.10
Les Thompson 6462.30 .00 0 08/11/89 16804.11
(804) 334-4554 9993536.70 .00 0 07/15/89 .00
OK .00 0 06/30/89 .00
May require special delivery.- Step 6In preparation for performing a sort/selection process on the Transactions information, this step provides you With a default sequencing of data records by Customer Alpha and Customer, with the option to change modifiable parameters at run time. Selection of data records is provided by Customer, with the option to change modifiable parameters at run time. Selection of data records is provided by Customer, Apply To, Transaction Date, Invoice Due Date, Post Month, Post Year, Operator ID, and Control No, with the option to enter user-specified comparisons at run time.
- Step 7This is the standard disposition used for all reports not printed on special forms.
- Step 8According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 9In order to print the Customer Credit (Detail), this step formats the Transactions information. The following data items are shown: Operator ID, Transaction No, Transaction Type, Apply To, Transaction Description, Order Number, Invoice or Check Number, Transaction Date, Invoice Due Date, and Amount.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:16 LGG Page: 1
Customer Credit (Detail)
As Of 8 / 89
=================================================================================================================================
Customer 00000010 Cr Limit 9999999.00 High .00
Contact Balance .00 Balance .00
Phone ( ) - Available 9999999.00 Last .00
Cr Status OK 4 Quarters .00
Comment
First Trx MTD Sales .00 Average 0
Last Trx YTD Sales .00 Days to Pay 0
Last Pay Prev Yr Sales .00 Last 0
Oldest Inv 05/04/89 On Order .00 4 Quarters 0
Error - Unexpected Error READ CUSTOMER
ID Trx Type Apply To Description Ord No Inv/Chk Trx Date Due Date Amount
——————————————————————————————————————————————————————————————————————————————————————————————————————————
SRR 0001 SVC 0040 Service Charge S0100 06/10/89 06/10/89 16.84
SRR 0001 INV 1001 6/6/89 Supply shipment 000101 1001 06/10/89 07/10/89 758.92
SRR 0001 PAY 1001 6/6/89 Supply shipment 6130 08/11/89 08/11/89 778.92-
SRR 0003 INV 1013 chair shipment 6/12/89 1013 06/21/89 07/21/89 1296.87
SRR 0006 INV 1016 shelving units shipped 6/13/89 1016 06/21/89 07/21/89 1368.54
SRR 0004 ADJ 1018 correction 1018 08/12/89 08/12/89 275.98
SRR 0001 DEP 102 Deposit on Special Order 05/10/89 05/10/89 750.00-
SRR 0001 INV 102 Special order shipment 000102 3001 08/11/89 09/10/89 750.00
SRR 0002 INV 2002 7/6/89 shipment 2002 07/10/89 08/09/89 1782.90
SRR 0002 INV 2022 7/26/89 shipment 2022 07/31/89 08/30/89 1896.55
SRR 0001 INV 3001 Special order shipment 000102 3001 08/11/89 09/10/89 778.92
SRR 0002 INV 3002 8/2/89 shipment 3002 08/11/89 09/10/89 1396.88
SRR 0001 INV 401 Opening Entry 006981 401 05/04/89 05/14/89 1350.54
SRR 0002 SVC 401 SERVICE CHARGES 401 06/30/89 06/30/89 20.26
SRR 0001 SVC 401 SERVICE CHARGES 401 07/31/89 07/31/89 20.56
SRR 0001 PAY 401 Opening Entry 6130 08/11/89 08/11/89 1391.36-
SVC 401 Svc Charge Write Off 401 06/30/89 20.26-
SVC 401 Svc Charge Write Off 401 07/31/89 20.56-
SRR 0001 DEP 7210 deposit 6082 07/31/89 07/31/89 1200.00-
SRR 0001 DEP 7211 deposit 6082 07/31/89 07/31/89 1700.00-
SRR 0002 INV 89071000 Monthly shipment 89071000 07/10/89 08/09/89 600.00
—————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
Customer 00000040 Burlington Enterprises Cr Limit 9999999.00 High 17737.00
Contact Molly Mogan Balance 12696.33 Balance 15983.00
Phone (205) 787-9987 Available 9987302.67 Last 12128.00
Cr Status OK 4 Quarters 15467.00
Comment Valued customer. President is on our Board of Directors. Do not offend.
First Trx 09/03/87 MTD Sales 5814.50 Average 53
Last Trx 08/12/89 YTD Sales 18580.69 Days to Pay 7
Last Pay 08/11/89 Prev Yr Sales 64747.04 Last 6
Oldest Inv 05/05/89 On Order 2930.00 4 Quarters 6
ID Trx Type Apply To Description Ord No Inv/Chk Trx Date Due Date Amount
——————————————————————————————————————————————————————————————————————————————————————————————————————————
MRC 0002 OEI 100001 P10982 100001 1003 08/12/89 09/11/89 100.00
MRC 0002 OEI 1003 P10982 100001 1003 08/12/89 09/11/89 831.05
SRR 0003 INV 1023 6/28/89 shipment 1023 06/30/89 07/30/89 957.45
SRR 0002 ADJ 1023 order cancelled-apply deposit 1023 08/12/89 08/12/89 900.00-
SRR 0002 DEP 111 deposit - order 05/05/89 05/05/89 900.00-
SRR 0001 ADJ 111 order cancelled-apply deposit 111 08/12/89 08/12/89 900.00
SRR 0004 INV 2004 7/7/89 shipment 000789 2004 07/10/89 08/09/89 2743.40
SRR 0002 PAY 2004 7/7/89 shipment 11603 08/11/89 08/11/89 2743.40-
SRR 0005 INV 2005 7/9/89 shipment 000412 2005 07/10/89 08/09/89 368.55
SRR 0002 PAY 2005 7/9/89 shipment 11603 08/11/89 08/11/89 368.55-
SRR 0003 INV 2013 7/19/89 shipment 000985 2013 07/21/89 08/20/89 1267.58
SRR 0006 INV 2016 7/19 shipment 000663 2016 07/21/89 08/20/89 3954.25
SRR 0003 INV 3003 8/5/89 shipment 006541 3003 08/11/89 09/10/89 4589.65
SRR 0004 INV 3004 8/10/89 shipment 022216 3004 08/11/89 09/10/89 1896.35
SRR 0003 SVC 404 Service charge S0102 06/10/89 06/10/89 22.22
SVC 404 Svc Charge Write Off 404 06/10/89 22.22-
SRR 0002 SVC 604 Service charge S0101 06/10/89 06/10/89 101.90
SVC 604 Svc Charge Write Off 604 06/10/89 101.90-