english

Ever wonder why the GL Date for a transaction in the Oracle subledger isn’t actually the GL date when the transaction is posted in the GL?

The General Ledger Journal Entry Summarization option determines whether subledger journal entries are summarized when they are transferred to General Ledger as described in the table below.

General Ledger Journal Entry Summarization Options

Option

Description

Summarize by GL Period

Default option; indicates that all subledger entry lines with the same GL period, General Ledger journal category, account, entered currency, side and balance type are summarized into a single General Ledger entry; disabled if ledger uses daily balancing
The GL effective date defaults to the last date of the accounting period.

Summarize by GL Date

Indicates that all subledger entry lines with the same GL date, General Ledger journal category, account, entered currency, side and balance type are summarized into a general ledger entry; default value if Summarize by GL period is disabled.
The GL effective date is equal to the subledger GL date.

No Summarization

Indicates that the subledger journal entries in Subledger Accounting and General Ledger will have the same level of detail.
The GL effective date is equal to the subledger GL date.

The table below describes the impact of the summarization options based on whether the journal line type is Summary or Detail.

Impact of Summarization Option

Option

Journal Line Type - Summary

Journal Line Type - Detail

Summarize by GL Period

One journal entry per period; journal entry lines summarized.

One journal entry per period; journal entry lines not summarized.

Summarize by GL Date

One journal entry per day based upon the GL date; journal entry lines summarized.

One journal entry per day based upon the GL date; journal entry lines not summarized.

No Summarization

Level of detail in General Ledger is the same as the level of detail in Subledger Accounting.

Level of detail in General Ledger is the same as the level of detail in Subledger Accounting.

I’m sure all users would want to have the "No Summarization" option enabled but this is a business decision that will be impacted by the volume of transactions. Perhaps with disc space and memory becoming so cheap we should challenge the default. What do you think?

 

This website uses cookies. Cookies remember you so we can give you a better service online.

By using this website, you are agreeing to our Cookies Notice. Dismiss