Invoice Analysis Report
Invoice Analysis Report
Invoice Analysis Report
Module: Accounting
Overview
Use the Invoice Analysis Report to view an audit trail by installation branch for
Revenue type
Distribution to general ledger accounts
User’s branch restrictions apply.
To access this report, choose Invoice Analysis Report (report #2083) from the main menu of SBN.
The Invoice Analysis 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.
Field |
Description |
Fiscal Period |
|
Date
- From |
You must select a range of fiscal dates to limit the report to invoices with fiscal dates within the range. Select the beginning fiscal date of the range. |
Date
- To |
You must select a range of fiscal dates to limit the report to invoices with fiscal dates within the range. Select the ending fiscal date of the range. |
Branch Range |
|
Branch
- From |
You may select a range of branches to limit the report to invoices associated with branches within the range. Select the beginning branch of the range. (This menu originates from program #1530.) O Branch restrictions apply. |
Branch
- To |
You may select a range of branches to limit the report to invoices associated with branches within the range. Select the ending branch of the range. (This menu originates from program #1530.) O Branch restrictions apply. |
Revenue Types Range |
|
Rev
Type - From |
You may select a range of revenue types to limit the report to invoices associated with a revenue type within the range. Select the beginning revenue type of the range. (This menu originates from program #1512.) O If you leave these fields blank, the report includes all revenue types. |
Rev
Type - To |
You may select a range of revenue types to limit the report to invoices associated with a revenue type within the range. Select the ending revenue type of the range. (This menu originates from program #1512.) O If you leave these fields blank, the report includes all revenue types. |
Amount Range |
|
Amount - Minimum (No label) |
You may type a range of amounts to limit the report to invoices for amounts within the range. Type the minimum amount of the range. O If you leave these fields blank, the report includes all amounts. |
Amount - Maximum (No label) |
You may type a range of amounts to limit the report to invoices for amounts within the range. Type the maximum amount of the range. O If you leave these fields blank, the report includes all amounts. |
Include Details |
Enter a check mark in this box to include all transaction details in the report. O If you leave this field blank, the report displays a summary version that includes totals for revenue type and GL accounts by branch. |
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 Analysis Report with details.
Column Descriptions
The following table describes the columns used in the detail version of the output of the report.
Column |
Description |
Tran Dt |
The date of each invoice transaction, in chronological order from oldest to newest. |
User |
The ID of the user who created the invoice batch. |
Inst# |
The installation number associated with the invoice. |
Name |
The installation name. |
Inv No# |
Number of the invoice that included the selected transaction. |
Acc# |
Account number to which the invoice was applied. O This report now includes account consolidated invoices. |
Type |
Identifies the revenue type for the invoice transaction. O This report now includes invoices for reminder charges and rounding. |
Description |
Text description of the revenue type. |
Amount |
Amount of the invoice transaction. |
Revenue Type |
Displays each revenue type for the specified period with l Description l Subtotal |
GL Account |
Displays each GL account number for the specified period with l Description l Subtotal |
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 Analysis Report
The following table lists modifications and updates to the Invoice Analysis Report document.
Mod Number |
Date |
Description |
n/a |
8/04/14 |
Images updated. |