Accounts Receivable: Invoice Proof Listing

This report is a list of Account Receivable Invoices. These are the invoices which have been entered,but not yet posted. This printout is useful as a verification or proof list of the invoice entries so that corrections can be made before posting. Use this option to print an Invoice Proof Listing of the tagged Batches. When the Proof List Tagged Batches button is pressed, the following screen will come into view.

Click on any column header to sort the listed items. This will be useful when the list of reports has grown.

Add or Change (button)

To modify the information used in generating the report, press the Add button. Highlight the desired report title and press the Change button. For more information, see Add or Change an Invoice Proof Listing.

Delete (button)

Press the Delete button and the following screen comes into view. Press the Yes button and the highlighted report will be deleted. If the No button is pressed, the program returns to the previous screen.

Print (button)

To print a report, press the Print button. For more information, see Printing Reports.

Note: If the message "Nothing to Print"comes into view when the print button is pressed, there are two main causes:
 A. There is no information within the selected limits. Remove all limits, then reinsert the limits one at a time. If the report still will not print, insert a new report title.
 B. No report title is selected. The report title is used to store the selected limits. A report title must be selected in order for the report to print.

There are two reports possible.

1.

Report Description: Trade Invoice Proof Listing

 

Report Sample: Trade Invoice Proof Listing

2.

Report Description : A/R Progress Billing Proof Listing

 

Report Sample: A/R Progress Billing Proof Listing

Close (button)

This button closes the program and returns to the main screen.

Help (button)

see How to use help

Add or Change an Invoice Proof Listing

To Add or Change a report, press the appropriate button and the following screen will come into view. This screen displays the possible limits that may be set. No limits should be set if a complete listing of every unposted invoice is desired. Several limits may be set to narrow the list down to a very small range of invoices.

Following is a description of each of the limits. Check the appropriate boxes and enter the desired limits. When all desired limits have been set, press the OK button to save the settings. Press the Cancel button to return to the browse screen without saving the settings.

Report Title

The title of the report. Warning: The title is used to store the selected limits. If no title is entered for the report, the message "Nothing to Print" will come into view when trying to print the report.

User

Enter the User ID of the report creator.

Lock (check box)

If this option is selected, only the User listed in the User field can change or delete this report.

Customers

Use this section to limit the report by customer. Use the Range setting to set a range of customer numbers. Use the List setting to specify a list of customers to be included.

All, Range, List (radio buttons)

Select the All radio button to ignore Customer reporting limits. Select Range to enter a range of Customers in the From and To fields. Select List to report on a list of selected Customers.

These fields will be available if the Range radio button is selected.

From

Enter the customer number. Press the lookup button and the Customer Entry screen comes into view. Highlight the desired customer and press the Select button.

To

Enter the customer number. Press the lookup button and the Customer Entry screen comes into view. Highlight the desired customer and press the Select button.

Edit Customer List (button)

Click the Edit Customer List button to add or remove Customers from the list of Customers to be included in the report. The following screen will come into view.

Retrieve a Saved List / Save This List for Future Use (buttons)

Use these buttons to save the current list of included records for future use, or to retrieve a previously saved list. See Saved Report Limit Lists for more details.

Available Records

All Available Customers that are not included in the list are displayed in these columns.

Included Records

All Included Customers are listed in these columns. Use the arrows to move selected records or all records between the Available and Included areas

Reference Numbers

Select References (check box)

This allows the invoices to be limited by reference number. Enter the first and last reference numbers of the invoices to be printed.

From

Selects the first reference number in a range of reference numbers or a single reference number. Enter the reference number.

To

Selects the last reference number in a range of reference numbers or a single reference number. Enter the reference number.

Print Order

Select the desired order either Entry Order or Customer Order.

Entry Order (radio button)

This is the order in which the invoices were entered into the system.

Sort by Customer Name (radio button)

This prints the report by customer name in alphabetical order.

Orientation

Portrait (radio button)

Specifies how the report is positioned on the page when printed. Portrait is the standard. Portrait is printed vertically.

Landscape (radio button)

Specifies how the report is positioned on the page when printed. Landscape is printed horizontally.

Job

Use this section to limit the report by Job. Use the Range setting to set a range of Job ID numbers. Use the List setting to specify a list of Jobs to be included.

All, Range, List (radio buttons)

Select the All radio button to ignore Job reporting limits. Select Range to enter a range of Jobs in the From and To fields. Select List to report on a list of selected Jobs.

These fields will be available if the Range radio button is selected.

From

Selects the first job in a range or a single job. Enter the job number. Press the lookup button and the Job Setup screen comes into view. Highlight the desired job and press the Select button.

To

Selects the last job in a range or a single job. Enter the job number. Press the lookup button and the Job Setup screen comes into view. Highlight the desired job and press the Select button.

Edit Job List (button)

If the List radio button is selected, this button will be available. The following screen will come into view when the Edit Job List button is pressed.

Use the arrows to move Jobs from the Available list to the Included list. All Jobs in the Included Records section will be included on the report. Use the tabs to sort each section by Job Number or by Job Name.

Invoice Types

Choose the Invoice Types to be included on the listing by checking the desired button.

Trade Invoices (radio button)

Selecting this option includes Trade Invoices. Trade Invoices are invoices for items and services sold independently of any job. They are also for work that is paid on a Time and Materials basis.

Progress Billing (radio button)

Selecting this option includes Progress Billings. Progress Billings are invoices or periodic billings sent out to the contract holders of the jobs and are based on the job’s contract price. The billing amount is determined by the percentage of the job that has been completed.

Both (radio button)

If this option is chosen, both Trade and Progress Billings Invoices will be printed.

Report Description - A/R Trade Invoice Proof Listing

The A/R Trade Invoice Proof Listing contains information about each of the trade invoices in the current Batch. The Listing contains all the information found on the Invoice.

Customer Information

The Customer Name is listed along with the Customer ID number and Customer Type (Balance Forward or Open Item).

General Invoice Information

The Invoice Number, Issue Date, Due Date, Work Order number and Purchase Order number are listed here.

Line Item Disbursement Detail

The remaining columns deal with the individual line items found on the invoice. These include Item ID, Description, Quantity, Unit Price, Amount, and General Ledger Income Account.

Invoice Totals

Below the line item detail, the system prints other pertinent information about the invoice, including Payment Terms, Discounts, Taxes, Shipping Charges, Other Charges and the Invoice Total.

Batch Totals

When all the invoices have printed, the system will print a group of Batch Totals. These can be used to check the accuracy of the invoice information entered into the Batch.

Report Description - A/R Progress Billing Proof Listing

This proof listing contains information about each of the progress billings in the current Batch. The customer, billed amount, retained amount, job information and due dates are listed.

Customer Information

The Customer Name and ID number are listed first.

General Invoice Information

The Invoice Number, Issue Date and Due Date are listed here.

Job Information

The Job Number, Description, and Current Contract amount are listed here.

Billing and Retention Information

The remaining columns deal with the actual billing amounts. There are two rows, one for the current billing and one for the contract to-date. Each row will include the amount billed, the percentage of the contract the billing amount represents, the amount retained, and the percentage of the billed amount that retention represents.

Report Sample - A/R Trade Invoice Proof Listing

Report Sample - A/R Progress Billing Proof Listing