Creating Consolidation Journals
You use Consolidation journals to enter adjustments to account balances and maintain an audit trail of changes to your data. They indicate which user made adjustments and which accounts, entities, and time periods are affected.
To create a journal, you must be assigned the application role of Consolidation Journals - Create. If you also have the predefined role of User, Power User or Service Administrator, you must have write access to the members in the journal.
You create journals by entering a journal label and description, Point of View for the data, adjustment amounts, and optional journal group that you can use to filter and sort journals. You can create a new journal, or create a journal from an existing journal template. If you use a template, by default, the journal label created will be the same as the template label.
If you enabled additional cubes in the application, a Cube dropdown is displayed on the Manage Journals page, where you can select the cube for the journals, as each cube will have a different list of journals. When you create a journal, the cube name that you selected will be displayed, but not editable. By default, the cube is Consol. For information on enabling cubes, see "Adding Application Cubes in in Administering Financial Consolidation and Close.
During application creation, the system creates the FCCS_Journal Input seeded member as a level 0 descendant under FCCS_TotalInputAndAdjusted in the DataSource dimension. It is automatically assigned Journal as the Source Data Type attribute and Entity Currency as the Source Currency attribute.
You can create journals using the Entity Currency of the Currency dimension as well as Input Currencies for both Entity Input and Translated Currency Input.
If you want to create journals that use Input Currencies, you must first create a custom Data Source member. The member must be a level 0 descendant of FCCS_TotalInputAndAdjusted. You then specify Journal as the Source Data attribute, and select an Input Currency for the Source Currency Type.
Note:
You must first set up currencies before you can create a custom Data Source member and assign a currency attribute. After you have created journals that use the new Data Source member, you cannot modify the currency assignment.
For Entity Input journals, either Entity Currency or an Input Currency can be used. You must select a matching Data Source member that was previously defined as either Entity Currency or one of the Input Currencies. If an Input Currency is used, the system reverse translates the currency into the Entity Currency and then processes the journal during the consolidation and translation process.
For Translated Currency Input journals, only Input Currencies can be used. You must select the matching Data Source member that was previously defined. The entered data is then copied to the relevant and matching Parent Currency or Reporting Currency members after translation / FX / CTA has been calculated.
You can select the FCCS_Translated Currency Input member when you create journals, journal templates, and journal reports, and export and import journals. To use the FCCS_Translation Currency Input member, you must enable the Translated Currency Input option during application creation.
You can create Periodic or Year-to-Date journals. See Periodic, Year-to-Date, and Journal-to-Date Consolidation Journal Entries.
After you create a journal, its status is set to Working.
Watch the following videos about creating journals:
To create a journal: