1. Implementing Accounting Hub
  2. Post Subledger Transactions to the General Ledger

Post Subledger Transactions to the General Ledger

Post subledger journals to the general ledger when you create accounting, or run the Post Subledger Journal Entries process to transfer and post at a later time.

To post to General Ledger:

  • Make sure that the Enable Posting from Subledger option is enabled so that you can automatically post subledger journals to GL.

    Note:

    If the Enable Posting from Subledger option is disabled, you can't post the subledger journal to GL but you can transfer the subledger journal to GL.

  • Alternatively, you must have the privilege to execute this task.

With the required privileges and settings, you can select the Account and Post to Ledger option to create and post journal entries to the general ledger, during the online Create Accounting process.

  • If you don't have the post to GL (GL_POST_JOURNAL_PRIV) privilege, select Account in Final to create journal entries and transfer to General Ledger.

  • You can view the output of the Post Subledger Journal Entries process for the summary of the transfer process.

You can manually run the Create Accounting process to create accounting for a batch of transactions. Set the following parameters to create journal entries and post to the general ledger.

  • Accounting Mode is set to Final.

  • Transfer to General Ledger is set to Yes.

  • Post in General Ledger is set to Yes.

    • If you don't have the post to GL (GL_POST_JOURNAL_PRIV) privilege or posting from the Enable Posting from Subledger option is disabled, the Post in General Ledger parameter isn't available.

Transfer Manual Subledger Journal to General Ledger By Preparer

You can transfer manual subledger journal entries to the general ledger immediately while creating subledger journals using the UI or a spreadsheet. You may also choose to create the manual subledger journal entries in Final status and use the Post Subledger Journal Entries process to transfer the manual subledger journal entries to the general ledger later. Manual journal entries created by different users are split into separate general ledger journal batches. This facilitates routing the journal batches to different approvers or reviewers based on the preparer. You can also choose to transfer all subledger journals or exclude manual journal entries while submitting the Post Subledger Journal Entries process.

Here are the changes applied after enabling this feature:

  • When you create subledger journals using a spreadsheet with Completion Status as 'Final and Transfer' or 'Final and Post,' eligible manual subledger journals created by the same user will only be transferred to the general ledger. Manual subledger journals created by other users will not be transferred.
  • In the Journal Batch field, you can optionally enter any text as a prefix to the General Ledger journal batch.
  • You can select one of the following options from Journal Entries to Transfer while submitting the Post Subledger Journal Entries ESS Parameter:
    • All - Transfer all subledger journals.
    • All except Manual Journals - Exclude manual subledger journals from transferring to the general ledger.
    • Manual Journals created by me - Only transfer manual subledger journals created by the current user.

Tips and Considerations

  • You can also create manual subledger journal entries using the Create Subledger Journal page and group them into one GL batch by posting them using the Post Subledger Journal Entries process. When you select the option Manual Journals created by me, in the Journal Entries to Transfer parameter, all manual adjustments entered through UI or spreadsheet are grouped into one GL batch.
  • To group all non-transferred accounting hub transactions into one GL batch, you can account the transactions in Final status and then submit the Post Subledger Journal Entries ESS program with Journal Entries to Transfer set to All except Manual Journals. This option will not transfer manual subledger journal entries to GL. It will not select eligible journals by the preparer.
  • If a Journal Batch is not specified in the spreadsheet or you're using an old template, a system-generated batch name will be assigned to the GL journal batch. The maximum length for a Journal Batch should be 50 characters or less.

Directly Transfer Subledger Entries to General Ledger

You can transfer subledger accounting entries directly to General Ledger without running the Post Subledger Journal Entries and Journal Import processes.

Create Accounting generates subledger accounting entries, which are summarized and transferred to the General Ledger through the Post Subledger Journal Entries process and its subsequent Journal Import process.

When you submit the Create Accounting process with the Transfer to General Ledger parameter set to Yes, the Create Accounting sub-process summarizes and transfers the subledger accounting entries to General Ledger without launching the Post Subledger Journal Entries and Journal Import processes. If you submit the standalone Post Subledger Journal Entries process, the subledger accounting entries are transferred to General Ledger without launching the Journal Import process.

This feature also includes the following changes:

  • When a subledger accounting entry points to an invalid account but an alternate account is specified, the system automatically switches to the alternate account for General Ledger journal creation.
  • In cases where validation errors occur while creating General Ledger journal batches from subledger accounting entries, only the valid entries are moved to the General Ledger, excluding any invalid entries.
  • Validation errors encountered during the subledger accounting entries' transfer to the General Ledger can be examined on the Manage Accounting Errors page.

These enhancements lead to quicker processing times for accounting and journal postings, optimizing the utilization of system resources.

Steps to Enable

Here are the steps to enable this feature for all Subledger and Accounting Hub applications:

1. Navigate to Setup and Maintenance.

2. Select the Setup Offering: Fusion Accounting Hub.

3. Click on the Functional Area: Accounting Transformation.

4. Click on the Setup Task: Manage Subledger Accounting Lookups.

5. Search the Lookup Type: ORA_XLA_PROMOTIONAL_OPTIONS.

6. Define the following Lookup Code under the above Lookup Type –

  • Lookup Code: XLA_PROMO_31776850_ON
  • Reference Data Set: Common Set
  • Enabled: <Checked>
  • Meaning: Skip Post Subledger Journal Entries and Journal Import

7. Save the changes.

Considerations

This feature does not apply under any of the following conditions:

  • When accounting entries are directly submitted online from the Transaction pages.
  • During the submission of the Multiperiod Accounting process, which doesn’t skip the Post Subledger Journal Entries process but does skip the Journal Import process.

For subledger accounting transfers outside of Fusion General Ledger, such as EBS General Ledger and PeopleSoft General Ledger.

Related Topics