Journal reports
Financial Consolidation
The journal reports page uses a view that specifies the default settings and the allowed members used on the report pages.
Using one view means that the Audit by Journal Name, and Journal Definition, Reconciliation reports share the same view settings. To set up different view settings for each, you need to create additional views with different names and use those names for the View parameter.
The ShowJournalID parameter enables you to include the journal ID on the Journal Definition, Audit by Journal Name, and Reconciliation reports. If the ShowJournalID parameter is missing or set to N, the journal ID is not shown on the report. The journal ID is automatically generated when a journal is created. You can use the journal ID as an audit trail to account for all journals by reviewing the Journal table.
You can include notes on the Journal Definition and the Audit by Journal Name reports by specifying the Notes parameter.
The user can override this parameter by changing the options for the report. The override lasts for the duration of the session. If the Note parameter is not specified, the reports do not include either type of notes.
This table show all options for the Notes parameter:
| Value | Description |
|---|---|
| AllBeg | Include both journal and adjustment notes. Journal notes display at the beginning of each journal. |
| AllEnd | Include both journal and adjustment notes. Journal notes display at the end of each journal. |
| JrnlBeg | Include only journal notes, which display at the beginning of each journal. |
| JrnlEnd | Include only journal notes, which display at the end of each journal. |
| Adj | Include only adjustment notes. |
| None | Do not include either type of notes. |
Standard Report Format
The standard reports provided with Financial Consolidation each have an associated xsl file that describes how to format the report. These are the corresponding xsl files:
- The Audit by Journal Name report uses the CPAudByNameRpt.xsl file.
- The Journal Definition report uses the CPJrnlDefRpt.xsl file.
- The Reconciliation report uses the CPReconRpt.xsl file.
The content of each report is described using XML. While users familiar with XML could customize these reports, we do not recommend that you do so. You can have problems when upgrading to a later release, as you may lose your customizations.
Dimension information
| Dimension specifications | Applicable dimensions |
|---|---|
| Use allowed members to limit selection | Accumulation Method
Category Currency Other Period Period / Year Rate Set Schedule Unit Version Year |
| Set on-grid members to specify a default selection | Category
Other Schedule Unit |
| Set off-grid members to specify a default selection | Accumulation Method
Category Currency Other Period Period / Year Rate Set Version Year |
| Set drill mode to Member Select to allow user selection | Category
Other Schedule Unit |
| Set the Dimension Bar layout to Display Button, Display Label, and Member on Label | Category Other |
| Not used | Adjusted State |
Detail information
Page: CPJrnlRptAuditForm.asp (Audit report), CPJrnlRptReconForm.asp (Reconciliation report), CPJrnlRptDefForm.asp (Definition report)
View: CT FP Journal Report
Examples
/CPMx86/Workstation/CPJrnlRptDefForm.asp?View=CT FP Journal Report&ShowJournalID=Y&Notes=AllEnd
/CPMx86/Workstation/CPJrnlRptAuditForm.asp?View=CT FP Journal Report&Sort=Name&Notes=AllEnd&ShowJournalID=Y
/CPMx86/Workstation/CPJrnlRptReconForm.asp?View=CT FP Journal Report&ShowJournalID=Y