By Adriana-Oracle on Jul 03, 2016
The Secondary Ledgers store additional accounting representations of the information present in the Primary Ledger. There are different levels of detail in which this information is stored, which are called Conversion levels. Even though Secondary Ledgers are optional, they are intensively used in order to fulfill various business needs.
Secondary Ledgers can differ from Primary Ledgers in one or more of the following components:
- Chart of Accounts
- Accounting Calendar / Period Type Combination
- Subledger Accounting Method
- Ledger Processing Options
Reconciliation is performed usually at period end, users attempt to verify the balances or transactions transferred between ledgers. Depending on setup differences between Primary and Secondary Ledgers, setup complexity, especially where the Chart of Accounts is different between ledgers, also depending on the volume of data and summarization options, Reconciliation process can be difficult and time-consuming.
To support such activities, we have released a New Diagnostic that would help point out the main issues that could cause differences in balances between Primary and Secondary Ledgers.
Relevant validations are performed, suggestions to resolve the reported issues offered.
Find it here: Primary Ledger to Secondary Ledger Diagnostics with Pointers to Reconciliation (Doc ID 2137066.1)
Very helpful SQL Diagnostic, download it today!