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.