Setting up for journal chronology

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

Structure format is modifiable. To modify the structure format after the process has already been performed, you must 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 locale’s statutory reporting.
    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 all posted journals in general ledger. The reference number is sequential based on the posting date.
      Reset Numeric Sequence
      This field is available if you selected the Assign Journal Reference check box. Blank is the default value. Use this to reset the sequence by accounting entity.

      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 you selected the Assign Journal Reference check box.

      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 each fiscal year.
      000000000009
      Padded 12-digit sequence number. This number is reset to 1 each fiscal year.
      999999
      6-digit sequence number. This number is reset to 1 each fiscal year.
      000009
      Padded 6-digit sequence number. This number is reset to 1 each fiscal year.
      Ledger
      Use to represent the ledger code.
      System
      Use 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
      If you select Current Year, then another field for period end date is available. If you select a date that is within the current year, then the period end date is derived based on the selected date.

      If you select Previous Year, then reference numbers for journal records in the previous year are re-sequenced.

      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 you select this option.

      Last Run Date
      This field is used to track when the process was last performed.
      Last Period End Date Processed
      The Assign Journal Reference Number action is available for reporting. This field is used to track the last period end date that was used to process journal reference numbers.
    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 and select DrillAround > Global Ledger Journal Reference.
  5. DrillAround from the Journal Control.
    1. SelectProcessing > Journal > Journals.
    2. On the Posted tab, select the journal record.
    3. Right-click and select DrillAround > Global Ledger Journal Reference.