Open Invoice List
Open Invoice List
Open Invoice List
Module: Accounting
Overview
Use the Open Invoice List to view unpaid invoices.
To access this report, select Open Invoice List (report #1178) from the main menu of SBN.
The Open Invoice List Report
This window contains two panes: use the upper pane to define the contents of the report; use the lower pane to define the job output - how, when, and where you want the report printed.
Note: See Report Parameters Pane for information on the fields in the lower pane, which are the same in every report.
Field Descriptions
The following table describes the fields used in the upper pane of this report.
Note: You can use wildcard characters in selected fields. For more information on using wildcards, see Searches.
Field |
Wildcards Allowed |
Description |
Invoice Date Range |
||
Date - From |
No |
You may select a range of dates to limit the report to open invoices with a transaction date that occurred during the range. Select the beginning date of the range. O This field defaults to today’s date. |
Date - To |
No |
You may select a range of dates to limit the report to open invoices with a transaction date that occurred during the range. Select the ending date of the range. O This field defaults to tomorrow’s date. |
Past Due Date Range |
||
Date - From |
No |
You may select a range of dates to limit the report to open invoices with an invoice due date that occurred during the range. Select the beginning date of the range. O This field defaults to today’s date. |
Date - To |
No |
You may select a range of dates to limit the report to open invoices with an invoice due date that occurred during the range. Select the ending date of the range. O This field defaults to tomorrow’s date. |
Minimum Balance |
No |
You may type a minimum open balance to limit the report to invoices with open balances equal to or greater than the minimum. O This field defaults to 0.01. |
Group By |
No |
You must select a grouping parameter for the report: l Branch l Dealer l Group1 l None |
Masks |
||
Ctr Group 1 |
Yes |
You must either select a Contract Basics Group 1 to limit the report to accounts associated with that group, or use the % wildcard to include all Contract Basics Group 1 groups. (This menu originates from program #1868.) |
Exclude |
No |
You may exclude a Contract Basics Group 1 from the report by selecting the group and then entering a check mark in this box. |
Ctr Group 2 |
Yes |
You must either select a Contract Basics Group 2 to limit the report to accounts associated with that group, or use the % wildcard to include all Contract Basics Group 2 groups. (This menu originates from program #1868.) |
Exclude |
No |
You may exclude a Contract Basics Group 2 from the report by selecting the group and then entering a check mark in this box. |
Branch Range |
||
Branch |
No |
You may select up to three ranges of branches to limit the report to branches within the ranges. Select the beginning branch number of the range. (These menus originate from program #1530.) O If option rptprof is on, SBN limits report results to those within the user’s branch profile. |
Branch |
No |
You may select up to three ranges of branches to limit the report to branches within the ranges. Select the ending branch number of the range. (These menus originate from program #1530.) |
Exclude |
No |
You may exclude ranges of branches from the report by selecting the ranges of branches and then entering check marks in these fields. |
Dealer Range |
||
Dealer |
No |
You may select up to three ranges of dealer IDs to limit the report to dealer IDs within the ranges. Select the beginning dealer ID of a range. (These menus originate from program #1537.) |
Dealer |
No |
You may select up to three ranges of dealer IDs to limit the report to dealer IDs within the ranges. Select the beginning dealer ID of a range. (These menus originate from program #1537.) |
Exclude |
No |
You may exclude ranges of dealer IDs from the report by selecting the ranges of dealer IDs and then entering a check mark in this box. |
Running and Viewing a Report
For information on running and viewing a report, see Common Functions in SBN.
Report Example
The following graphic shows an example of the output of the Open Invoice List report.
Column Descriptions
The following table describes the columns used in the output of the report.
Column |
Description |
Dynamic label |
Depending on the grouping parameter you selected, this column may display one of the following: l Branch ID and name. l Dealer ID and name. l Group |
Invoice |
Invoice number. |
Contract # |
Contract number. |
Dealer |
ID of the dealer associated with the contract. |
Account |
Billing account number. |
Transaction Date |
Date the invoice was created. |
Due Date |
Date on which payment for the invoice was due. |
Amount |
Amount of the invoice. |
Balance |
Unpaid balance on the invoice. |
Total (Dynamic label) |
|
Total - Amount |
Displays the subtotal of invoice amounts for the grouping parameter you selected. |
Total - Balance |
Displays the subtotal of the balances for the grouping parameter you selected. |
Grand Total |
|
Total - Amount |
Displays the total of all invoice amounts. |
Total - Balance |
Displays the total of all balances. |
Button Functions
The following table displays the buttons, describes the shortcut keys, actions, and functionality.
Button |
Name |
Shortcut Key |
Action |
Description |
|
Open fields for recurring/template reports |
alt+f1 |
Open fields for recurring/template reports. |
|
|
Exit without saving |
esc |
Exit without saving changes to selected record. |
|
|
Save Existing Record |
enter |
Save changes to selected record. |
Modifications and Updates to Open Invoice List
The following table lists modifications and updates to the Open Invoice List document.
Mod Number |
Date |
Description |
n/a |
8/06/14 |
Images updated. |