Revenue Report (KKR023)
-
Print
-
DarkLight
-
PDF
Revenue Report (KKR023)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A custom report that provides revenue estimates, revenue recognized, and revenue collected by Fund, Budget Entity, Category, and Account code by ChartField combinations.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
Suggested Report Frequency
- Ad Hoc
Business Process Models
This report can be found in the following business processes:
- 20.1.4 Agency Estimated Revenue
- 60.1.1 Record AR
- 60.1.2 Refund AR
- 60.1.3 Write-Off AR
- 60.2.1 Direct Journal Deposits
- 60.2.2 AR Deposits
Report Prompts
The report data can be filtered by the following report prompts:
| Parameter Name | Default Value | Column in Subject Area | Required (Y/N) | User Input |
|---|---|---|---|---|
Budget Period | N | WC_LEDGER_KK_D.FISCAL_YEAR | Y | Y |
Business Unit | N | WC_LEDGER_KK_D.BUSINESS_UNIT | N | Y |
Organization | N | WC_LEDGER_KK_D.DEPTID | N | Y |
Account | N | WC_LEDGER_KK_D.ACCOUNT | N | Y |
Fund | N | WC_LEDGER_KK_D.FUND_CODE | N | Y |
Budget Entity | N | WC_LEDGER_KK_D.BUDGET_REF | N | Y |
Category | N | WC_LEDGER_KK_D.PRODUCT | N | Y |
State Program | N | WC_LEDGER_KK_D.CHARTFIELD2 | N | Y |
Grant | N | WC_LEDGER_KK_D.PROGRAM_CODE | N | Y |
Contract | N | WC_LEDGER_KK_D.CHARTFIELD1 | N | Y |
OA1 | N | WC_LEDGER_KK_D.CLASS_FLD | N | Y |
OA2 | N | WC_LEDGER_KK_D.CHARTFIELD3 | N | Y |
Project | N | WC_LEDGER_KK_D.PROJECT_ID | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | WC_LEDGER_KK_D.BUSINESS_UNIT |
Account | WC_LEDGER_KK_D.ACCOUNT |
Account Description | WC_GL_ACCOUNT_TBL_D.DESCR |
Fund | WC_LEDGER_KK_D.FUND_CODE |
Budget Entity | WC_LEDGER_KK_D.BUDGET_REF |
Category | WC_LEDGER_KK_D.PRODUCT |
Budget Period | WC_LEDGER_KK_D.FISCAL_YEAR |
Organization | WC_LEDGER_KK_D.DEPTID |
State Program | WC_LEDGER_KK_D.CHARTFIELD2 |
Grant | WC_LEDGER_KK_D.PROGRAM_CODE |
Contract | WC_LEDGER_KK_D.CHARTFIELD1 |
OA1 | WC_LEDGER_KK_D.CLASS_FLD |
OA2 | WC_LEDGER_KK_D.CHARTFIELD3 |
Project | WC_LEDGER_KK_D.PROJECT_ID |
Revenue Estimated | NVL(SUM(CASE WHEN kk.LEDGER = 'C_REV_EST' THEN legfac.POSTED_TOTAL_AMT END), 0) |
Revenue Recognized | CASE WHEN NVL(SUM(CASE WHEN kk.LEDGER = 'C_REV_REC' THEN legfac.POSTED_TOTAL_AMT END), 0) < 0 THEN NVL(SUM(CASE WHEN kk.LEDGER = 'C_REV_REC' THEN legfac.POSTED_TOTAL_AMT END), 0) * -1 ELSE NVL(SUM(CASE WHEN kk.LEDGER = 'C_REV_REC' THEN legfac.POSTED_TOTAL_AMT END), 0) END |
Revenue Collected | CASE WHEN NVL(SUM(CASE WHEN kk.LEDGER = 'C_REV_COL' THEN legfac.POSTED_TOTAL_AMT END), 0) < 0 THEN NVL(SUM(CASE WHEN kk.LEDGER = 'C_REV_COL' THEN legfac.POSTED_TOTAL_AMT END), 0) * -1 ELSE NVL(SUM(CASE WHEN kk.LEDGER = 'C_REV_COL' THEN legfac.POSTED_TOTAL_AMT END), 0) END |
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the data values is included here: Configuration Data Values.
More information about the ChartFields and related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
|---|---|
| 01/31/2025 | Original Version |
| 04/09/2025 | Added content to Report Sample Layout, Report Prompts, and Report Columns section. |
Was this article helpful?
