There are three summarization options in SLA:
-
Merge Matching Line option in Journal Line Type
-
GL Transfer option in Journal Line Type
-
General Ledger Journal Entries Summarization option in Subledger Accounting Options in Accounting Setup Manager
Merge Matching Lines
Merge Matching Line option is selected at the JLT, it determines whether lines are summarized within a subledger journal. Options are ‘All’, ‘Dr/Cr’, or ‘No’. This affects subledger journal entries in SLA. Journal lines with same values in merge criteria are merged into single line if Merge Matching Line is set to Yes. Merge criteria are listed in the Subledger Accounting Implementation Guide page 2-36. If option Dr/Cr is chosen, lines with same side are merged. If option All is chosen, lines are merged regardless if its dr/cr.
Example: Invoice #ABC has 3 lines;
1 $100
2 $200
3 $50
Assuming all the journal lines created have same values in all the merge criteria.
GL Transfer
This controls how journals go to GL and is set on the JLT. This works along with GL Journal Entry Summarization option and they affect GL journal entries transferred from SLA.
-
Detail to maintain the same level of detail in GL and SLA.
-
Summary to create summarized journal in GL. In this case, subledger journal entry lines are summarized by Accounting Flexfield.
General Ledger Journal Entry Summarization
This option is defined in Accounting Setup Manager Subledger Accounting Options. Available options are:
-
Summarize byGL Period- all subledger entry lines with the same GL period, journal category, account, entered currency, side(dr/cr), and balance type are summarized into a single General Ledger journal
-
Summarize by GL Date- all subledger entry lines with the same GL date, journal category, account, entered currency, side(dr/cr), and balance type are summarized into a general ledger journal
-
No Summarization- subledger journal entries in Subledger Accounting and General Ledger will have the same journal detail
Examples on how all of these options work together.
submitted by MirandaH, you can tell its not me, cuz its soo detailed
