Invoice Register Report
Invoice Register Report
Invoice Register Report
Module: Accounting
Overview
Use the Invoice Register Report to print a register of an invoice batch.
To access this report, choose Extra Print from Invoice Manager (program #1557) or select Invoice Register Report (report #1152) from the main menu of SBN.
The Invoice Register Report
This report contains two panes: use the upper pane to define the content of the report; use the lower pane to define the job output - how, when, and where you want to print the report.
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 the Invoice Register Report.
Field |
Description |
Batch No - From |
You must select the batch number for which you want to run the report. |
Group By |
You must select a grouping parameter for the report: l Branch l None |
Use Branch From |
You must select the category of branches to use in the report: l Accounts l Contract O If you select Contract while using account consolidated invoicing, the resulting invoice q Does not display a branch q Is only included if br = blank is legal for the user |
Branch Ranges |
|
Branch |
You may select up to three ranges of branches - from the category you select in the Use Branch From parameter - to limit the report to branches within the ranges. Select the beginning branch number of a range. (These menus originate from program #1530.) O If you leave the fields blank, the report includes all branches in your user profile that match the selected Use Branch From parameter. O If option rptprof is on, branch restrictions apply. |
Branch |
You may select up to three ranges of branches - from the category you select in the Use Branch From parameter - to limit the report to branches within the ranges. Select the ending branch number of a range. (These menus originate from program #1530.) O If you leave the fields blank, the report includes all branches in your user profile that match the selected Use Branch From parameter. O If option rptprof is on, branch restrictions apply. |
Exclude |
You may exclude ranges of branches from the report by selecting the ranges and then entering a check mark in the corresponding Exclude box. |
Dealer Ranges |
|
Dealer |
You may select up to three ranges of dealer IDs - from the same category that you select in the Use Branch From parameter - to limit the report to dealer IDs within the ranges. Select the beginning dealer ID of a range. (These menus originate from program #1537.) O If you leave the fields blank, the report includes all dealers in your user profile that match the selected Use Branch From parameter. O Dealer restrictions apply. |
Dealer |
You may select up to three ranges of dealer IDs - from the same category that you select in the Use Branch From parameter - to limit the report to dealer IDs within the ranges. Select the ending dealer ID of the range. (These menus originate from program #1537.) O If you leave the fields blank, the report includes all dealers in your user profile that match the selected Use Branch From parameter. O Dealer restrictions apply. |
Exclude |
You may exclude ranges of dealer IDs from the report by selecting the ranges and then entering a check mark in the corresponding Exclude 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 Invoice Register report.
Column Descriptions
The following table describes the columns used in the output of the report.
Column |
Description |
Batch |
SBN-assigned invoice batch number. |
Created By |
ID of the user who created the batch. |
Batch Text |
Text description of the batch. |
System Date |
Date on which the batch was created. |
Transaction Date |
Date on which the transaction occurred. |
Invoice |
Each invoice number included in the batch. |
Ext Invoice |
External invoice number for the invoice, if any. |
Contract # |
The contract number for the invoice, if any. Invoices generated by reminders may not reference a contract. |
Dealer |
ID of the dealer associated with the contract. SBN displays the dealer stamped on the invoice, which may differ from the current dealer associated with the contract. |
Account |
Account number for the invoice. |
Amount |
Amount of invoice. |
Paid Amount |
Any amount paid against the invoice. |
Due Date |
Date on which payment is due. |
Ws |
Invoice status flag:
|
Branch |
This column appears when you select Branch as the Sort by parameter. Branch and city of branch associated with the contract. SBN displays the branch stamped on the invoice, which may differ from the current branch associated with the contract. |
Grand Total |
Counts the number of invoices in the batch and sums their invoiced and paid amounts. |
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 Invoice Register Report
The following table lists modifications and updates to the Invoice Register Report document.
Mod Number |
Date |
Description |
n/a |
8/04/14 |
Images updated. |