Invoice Register for Period Report
Invoice Register for Period Report
Invoice Register for Period Report
Module: Accounting
Overview
Use the Invoice Register for Period Report create a monthly invoice register or to view revenue information for a specific batch.
To access this report, select Invoice Register for Period Report (report #1194) from the main menu of SBN.
The Invoice Register for Period 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 Accepted |
Description |
Fiscal Period |
||
Date
- From |
No |
You may select a range of fiscal dates to include in the report. Select the beginning date of the range. O Your company must be using Fiscal Control (program #568) to user fiscal periods. O Select either a fiscal period or a transaction period. |
Date
- To |
No |
You may select a range of fiscal dates to include in the report. Select the ending date of the range. O Your company must be using Fiscal Control (program #568) to user fiscal periods. O Select either a fiscal period or a transaction period. |
Transaction Period |
||
Date
- From |
No |
You may select a range of dates to limit the report to invoices that were created or closed during the range. Select the beginning date of the range. O Select either a fiscal period or a transaction period. |
Date
- To |
No |
You may select a range of dates to limit the report to invoices that were created or closed during the range. Select the ending date of the range. O Select either a fiscal period or a transaction period. |
Batch No |
No |
You must type a specific batch number to limit the report to invoices in that batch. |
Include Invoice Details |
No |
Enter a check mark in this box to include the tax details of invoices in the report. |
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 Ranges |
||
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 a range. (These menus originate from program #1530.) O If you leave the fields blank, the report includes all records in the batch. O Branch restrictions apply. |
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 a range. (These menus originate from program #1530.) O If you leave the fields blank, the report includes all records in the batch. O Branch restrictions apply. |
Exclude |
No |
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 |
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.) O If you leave the fields blank, the report includes all records in the batch. O Branch restrictions apply. |
Dealer |
No |
You may select up to three ranges of dealer IDs 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 records in the batch. O Branch restrictions apply. |
Exclude |
No |
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 for Period Report with a specified Fiscal Period.
Column Descriptions
The following table describes the columns used in the output of the report.
Column |
Description |
Branch |
Branch ID. |
Batch |
Batch number. |
Invoice |
Invoice number. |
Contract # |
Contract number. |
Dealer |
Dealer associated with the selected contract. |
Name |
Contract name. |
Tax |
Tax rate. |
Amount |
Amount of selected invoice. |
Discount |
Discount applied to selected invoice. |
Default |
Number of items included in the selected batch. |
Batch Totals |
Totals for all invoices in the selected batch: l Tax l Amount l Discount |
Branch Totals |
Totals for all batches for the selected branch: l Tax l Amount l Discount |
Department |
Prints one line for each general ledger account number/department number combination. |
Revenue Type |
Code that identifies the revenue types included in the batch. |
Income |
Amount of income in the batch that is associated with the selected revenue type. |
Direct Cost |
Amount of Direct Cost in the batch that is associated with the selected revenue type. |
DC% |
Percentage of Direct Cost in the batch that is associated with the selected revenue type. |
Total |
Totals for all revenue types in the batch of l Income l Direct Cost l DC% |
Distribution of Income in Time |
Displays ten (10) months and amounts of the batch distributed over those ten (10) months. |
Branch |
Identifies the branch to which the following totals apply. |
Total |
Totals amounts of the batch that are associated with the selected branch for l Income l Direct Cost l DC% |
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 for Period Report
The following table lists modifications and updates to the Invoice Register for Period Report document.
Mod Number |
Date |
Description |
n/a |
8/04/14 |
Images updated. |