Creating journal chronology

You must enable journal reference in the reporting basis for the statutory report for the locale. The calendar that is used to assign journal reference numbers is the associated global ledger calendar that is on the basis. Only ledgers and accounting entities that are associated with the basis are processed.

The structure format is modifiable. To modify the structure format after the process is performed, rerun the process to apply the changes.

  1. Enable journal reference in the reporting basis:
    1. Select Setup > Finance Enterprise Group > Maintenance.
    2. Open the Finance Enterprise Group.
    3. On the Reporting Basis tab, open the reporting basis that is identified for the statutory reporting for the locale.
    4. In the Global section, specify this information:
      Assign Journal Reference
      Select this check box to create a system-generated journal reference number to track posted journals in general ledger. The reference number is sequential and based on the posting date.
      Reset Numeric Sequence
      This field is available if the Assign Journal Reference check box is selected. Select the method to reset the numeric sequence from these options:

      Select Per Ledger to reset the sequence by accounting entity and by ledger.

      Select Per System to reset the sequence by accounting entity and by subsystem.

      Select Per Ledger And System to reset the sequence by accounting entity, by ledger, and by subsystem.

      Journal Reference Format
      This field is available if the Assign Journal Reference check box is selected.

      To provide the journal reference format, press ctrl + shift + right-click in the field and select Text Variable Replacement. A list of valid variables is displayed. Select the variable or variables to use to create strings, for example,

      {YEARYYYY}{000000000009} 2017000000000001

      {YEARYYYY}{MONTHMM}-{999999} 201701-1

      {SYSTEM}{YEARYYYY}-{000009} GL2017-000001

      Year YYYY
      4-digit number to represent year.
      Year YY
      2-digit number to represent year.
      Month MM
      2-digit number to represent month.
      999999999999
      12-digit sequence number. This number is reset to 1 every fiscal year.
      000000000009
      Padded 12-digit sequence number. This number is reset to 1 every fiscal year.
      999999
      6-digit sequence number. This number is reset to 1 every fiscal year.
      000009
      Padded 6-digit sequence number. This number is reset to 1 every fiscal year.
      Ledger
      Use this field to represent the ledger code.
      System
      Use this field to represent the sub system source code.
    5. Click Save.
  2. Assign the journal reference number:
    1. Select Processing > Reporting Basis > Reporting Basis.
    2. Select the basis that is enabled for journal reference.
    3. Click the Assign Journal Reference Number button.

      This action is available for the reporting basis that is configured for the journal numbering. Run this action to assign a sequential number to posted journals. Numbering is sequential by global ledger post dates and is reset every fiscal year.

    4. Specify this information:
      Year Option
      Select Current Year to show another field for period end date. If you select a date that is within the current year, then the period end date is derived based on the selected date.

      Select Previous Year to update the sequence of reference numbers for journal records in the previous year.

      Accounting Entity Option
      Select All to assign journal reference numbers for entities that are associated in the reporting basis.

      Select Single to assign journal reference numbers for a single entity. Another field for accounting entity is available if this option is selected.

      Last Run Date
      The date when the process was last performed is displayed in this field.
      Last Period End Date Processed
      The Assign Journal Reference Number action is available for reporting. The last period end date that was used to process journal reference numbers is displayed in this field.
    5. Click OK.
  3. View the Global Ledger Journal Reference Summary Report:
    1. Select My Reports > Journal Reference Report.
    2. Use the search criteria to filter the records.
    3. Open the basis record.
  4. DrillAround from the reporting basis:
    1. Select Processing > Reporting Basis > Reporting Basis.
    2. Select the basis that is enabled for journal reference.
    3. Right-click the basis and select DrillAround > Global Ledger Journal Reference.
  5. DrillAround from the journal control:
    1. Select Processing > Journal > Journals.
    2. On the Posted tab, select the journal record.
    3. Right-click the record and select DrillAround > Global Ledger Journal Reference.