Billed Revenues by Rate - CI_BILREV
Parameters
Parameter | Parameter Code | Description |
Accounting Period | P_ACCT_PERIOD | Defines the accounting period used for the report. A valid fiscal year and accounting period for a valid accounting calendar must be provided. |
Account Type Characteristic | P_CHAR_TYPE | Defines a Characteristic Type for a characteristic linked to the Distribution Code to define an Account Type. |
Account Type | P_REV_ACCTY_CHAR | Account Type Char Value for Revenue related GL Accounts. The char type defined for this parameter should match the Char Type code defined as parameter #2. The parameter value indicated for this parameter should be one that represents revenue accounts. |
Report Description
This is an analysis report for the billed revenues for an accounting period according to the various rates, which were in effect in the system. The information in this report helps to adjust rates in order to achieve better financial results and comply with regulations and market trends.
This report selects all records in the financial transaction GL collection that satisfy the following criteria:
• The financial transaction is frozen.
• The Accounting Date on the financial transaction within input accounting period (parameter 1)
• The distribution code associated with the GL entry has a characteristic type and value that matches the input Account Type Characteristic and Account Type (parameters 2 & 3)
Note:
Performance Consideration. If your implementation chooses to use this report, you may consider adding an index to the CI_FT table on ACCOUNTING_DT to aid in performance. When making this decision, carefully weigh the benefit of improving report performance against the possible degradation to the performance of day-to-day processing as a result of defining a new index. In addition, many companies opt to create a reporting database that is a shadow of production to ensure that indexes defined to benefit reports may be created without any affect on the production environment.
Parent topic