4Reports and Inquiry
Option 3Unpaid Invoices
Use this function to print an itemized list of all unpaid invoices, providing totals by customer. Fully paid invoices are excluded from this report. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Unpaid Invoices information, this step provides you with a default sequencing of data records by Customer, Apply To, Balance Due, and Invoice Due Date, giving additional sort order choice by Receivable Account, with the option to change modifiable parameters at run time. Selection of data records is provided by Receivable Account, Customer, Apply To, Invoice Due Date, Invoice Date, and Balance Due, with the option to enter userspecified comparisons at run time.
- Step 2This is the standard disposition used for all reports not printed on special forms.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Unpaid Invoices report, this step formats the Unpaid Invoices information. The following data items are shown: Apply To, Description, Receivable Account, Account Description, Invoice Date, Invoice Due Date, Order Number, Credit Receivable, Discount Given, Service Charge, Write Off Service Charge?, and Balance Due. As appropriate, group headings appear whenever a change occurs in Customer. If requested, totals appear whenever a change occurs in Customer. When totals are specified, the following items are accumulated: Total Balance.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 14:58 LGG Page: 1
Accounts Receivable Unpaid Invoices
Invoice Due Order Invoice Discount Service Write
Apply To Description Account Number Date Date Number Amount Given Charge Off?
Balance
=================================================================================================================================
Customer 00000010 Alexander's, Inc.
0040 Service Charge 1030001001WH Accts Receiv, Sale 06/10/89 06/10/89 16.84 .00 16.84 N 16.84
1001 6/6/89 Supply sh1030001001WH Accts Receiv, Sale 06/10/89 07/10/89 758.92 .00 .00 N 20.00-
1013 chair shipment 61030001001WH Accts Receiv, Sale 06/21/89 07/21/89 1296.87 .00 .00 N 1296.87
1016 shelving units s1030001001WH Accts Receiv, Sale 06/21/89 07/21/89 1368.54 .00 .00 N 1368.54
1018 correction 1030001001WH Accts Receiv, Sale 08/12/89 08/12/89 275.98 .00 .00 N 275.98
2002 7/6/89 shipment 1030001001WH Accts Receiv, Sale 07/10/89 08/09/89 1782.90 .00 .00 N 1782.90
2022 7/26/89 shipment1030001001WH Accts Receiv, Sale 07/31/89 08/30/89 1896.55 .00 .00 N 1896.55
3001 Special order sh1030001001WH Accts Receiv, Sale 08/11/89 09/10/89 778.92 .00 .00 N 778.92
3002 8/2/89 shipment 1030001001WH Accts Receiv, Sale 08/11/89 09/10/89 1396.88 .00 .00 N 1396.88
401 Opening Entry 1030001001WH Accts Receiv, Sale 05/04/89 05/14/89 006981 1350.54 .00 .00 Y 40.82-
7210 deposit 2051000000 Sales Deposits 07/31/89 07/31/89 1200.00- .00 .00 Y 1200.00-
7211 deposit 2051000000 Sales Deposits 07/31/89 07/31/89 1700.00- .00 .00 Y 1700.00-
89071000 Monthly shipment1030001001WH Accts Receiv, Sale 07/10/89 08/09/89 600.00 .00 .00 N 600.00
——————
— Customer Totals —> 6452.66
============
Customer 00000020 Master Sellers Company
1004 P3050 1030001001MA Accts Receiv, Sale 08/15/89 09/14/89 344.27 .00 .00 N 688.54
2006 7/2/89 shipment 1030001001WH Accts Receiv, Sale 07/10/89 07/10/89 1465.23 .00 .00 N 1465.23
2021 7/26/89 shipment1030001001WH Accts Receiv, Sale 07/31/89 07/31/89 1560.33 .00 .00 N 1560.33
3005 special order sh1030001001WH Accts Receiv, Sale 08/11/89 08/11/89 1685.63 .00 .00 N 1685.63
333 Opening entry 1030001001WH Accts Receiv, Sale 05/20/89 05/20/89 000333 200.00 .00 .00 Y 95.98
89071001 Monthly shipment1030001001WH Accts Receiv, Sale 07/10/89 07/10/89 200.16 .00 .00 N 100.00-
——————
— Customer Totals —> 5395.71
============
Customer 00000030 Pool and Associates
2012 7/13/89 shipment1030001001WH Accts Receiv, Sale 07/21/89 08/20/89 1721.58 .00 .00 N 1721.58
BF890731 BALANCE FORWARD 1030001001WH Accts Receiv, Sale 07/31/89 07/31/89 4172.43 .00 .00 Y 1172.43
——————
— Customer Totals —> 2894.01
============
Customer 00000040 Burlington Enterprises
100001 P10982 1030001001WH Accts Receiv, Sale 08/12/89 09/11/89 000001 100.00 .00 .00 N 100.00
1003 P10982 1030001001WH Accts Receiv, Sale 08/12/89 09/11/89 000001 831.05 .00 .00 N 831.05
1023 6/28/89 shipment1030001001WH Accts Receiv, Sale 06/30/89 07/30/89 957.45 .00 .00 N 57.45
2013 7/19/89 shipment1030001001WH Accts Receiv, Sale 07/21/89 08/20/89 1267.58 .00 .00 N 1267.58
2016 7/19 shipment 1030001001WH Accts Receiv, Sale 07/21/89 08/20/89 3954.25 .00 .00 N 3954.25
3003 8/5/89 shipment 1030001001WH Accts Receiv, Sale 08/11/89 09/10/89 4589.65 .00 .00 N 4589.65
3004 8/10/89 shipment1030001001WH Accts Receiv, Sale 08/11/89 09/10/89 1896.35 .00 .00 N 1896.35
——————
— Customer Totals —> 12696.33
============
Customer 00000050 Miscellaneous Customer
1005 1030001001MA Accts Receiv, Sale 08/20/89 09/19/89 610.23 .00 .00 N 1220.46
2015 7/19/89 shipment1030001001WH Accts Receiv, Sale 07/21/89 07/21/89 4897.65 .00 .00 N 4897.65
3006 8/4/89 shipment 1030001001WH Accts Receiv, Sale 08/11/89 08/11/89 6548.95 .00 .00 N 6548.95
8002 special order-NW2051000000 Sales Deposits 08/11/89 08/11/89 2000.00- .00 .00 Y
2000.00-
——————
— Customer Totals —> 10667.06
============