Reporting Currency: If you want to maintain your ledger transactions in multiple currencies, you can use reporting currencies.Reporting currencies are additional currency representations of primary or secondary ledgers. Reporting currencies can be used for supplementary reporting purposes, such as consolidation or management reporting.
Reporting currencies can be maintained at the following currency conversion levels:
• Balance Level: The Balance level reporting currency is maintained only for GL account balances by using translation to convert the balances from the ledger currency to the reporting currency. Balance level reporting currencies can be assigned to primary and secondary ledgers using Accounting Setup Manager, or they can be system-generated the first time you run translation using a different currency.
• Journal Level: The Journal level reporting currency is maintained for GL journal entries and balances when you post journals in your primary or secondary ledger.
This type of reporting currency is maintained using the General Ledger Posting program.
Each time you post a journal entry in the associated primary or secondary ledger, another journal is created and posted to the Journal level reporting currency within the same journal batch.
• Subledger Level: The Subledger level reporting currency is maintained for primary ledgers only. They maintain a currency representation of the primary ledgers' subledger journals, journal entries, and balances. This type of reporting currency is maintained by Oracle Subledger Accounting (SLA) and the GL Posting program.
If it is Balance level then it can be achieved by using Translation process.Generate Trial balance in reporting currency.
If the details level information such as Subledger or Journal then it would be achieved through Multi reporting Currency (MRC).
Reporting Currency Functionality in R12 is combination of both MRC and Reporting currency in 11i.
When to Use Reporting currency: Out of the Ledger 4C's only Currency would be different from Primary Ledger.
Secondary Ledger (MAR)
Multiple Accounting Representation (MAR), as the name suggests meant for Multiple Account representation for the various Accounting governing bodies requirements. The governing bodies could be US GAAP,IASB,IFRS and local authorities. Secondary Ledgers can be unlimited as per the requirement.
In AX Countries there is a concept called Dual posting, where we can enter in Global chart of Accounts and post in Local COA.
Eg: If there is a Business Unit in France, and the reporting Organisation is in UK then we would need two COA's. One COA to meet the local Govt rules and the other COA to maintain the uniformity across the Global Business Unit which inturn would be helpful for the Management reporting.
In this case dual posting is used to enter in a COA and post the same in the other COA. But this is only meant for the following Subledgers:
- Oracle Inventory
- Oracle Receivables
- Oracle Payables
In R12 this can be achieved through seconday Ledger where we can have different COA than the primary Ledger and with help of SLA we achieve all the statutory required to the organisation.Also in R12 this is available for almost all modules like AP,AR,FA,GL,etc..
Secondary ledgers can be used to represent your primary ledger's accounting data in another accounting representation that differs in one or more of the following from the primary ledger:
• Chart of accounts
• Accounting calendar/period type combination
• Subledger accounting method
• Ledger processing options
When to Use Secondary Ledger :
- For example, if a legal entity must perform corporate and statutory reporting, you can use the primary ledger to satisfy corporate reporting requirements and then use a secondary ledger to satisfy statutory reporting requirements.
- If a legal entity is a subsidiary of a parent company and must produce its financial results according to the parent company's reporting requirements in addition to its own local reporting requirements, then a secondary ledger may be used to satisfy the additional reporting requirement.
• Balance: The balance level secondary ledger maintains your primary ledger account balances in another accounting representation. This type of secondary ledger requires you to use Oracle General Ledger Consolidation to transfer your primary ledger balances to this secondary ledger.
• Subledger: The Subledger level secondary ledger maintains subledger journals, general ledger journal entries, and balances in the additional accounting representation. This data conversion level uses both Oracle Subledger Accounting and General Ledger Posting to create the necessary journals in both your primary and secondary ledgers simultaneously.
• Journal: The journal level secondary ledger maintains your primary ledger journal entries and balances in an additional accounting representation. This type of secondary ledger is maintained using the General Ledger Posting Program. Every time you post a journal in your primary ledger, the same journal can be automatically replicated and maintained in the secondary ledger for those journal sources and categories that are set up for this behavior.
• Adjustments Only: The Adjustments Only Secondary Ledger is an incomplete accounting representation that only holds adjustments. The adjustments can be manual adjustments or automated adjustments from Oracle Subledger Accounting.
This type of ledger must share the same chart of accounts, accounting calendar/period type combination, and currency as the associated primary ledger. To obtain a complete secondary accounting representation that includes both the transactional data and the adjustments, you must then combine the adjustments-only secondary ledger with the primary ledger when running reports.
Difference between Reporting Currency and Secondary Ledger (MAR)
- Reporting currency is used only when the Currency of Primary Ledger need to be changed for reporting purpse.This can be used to capture the information in reporting currency at Balance level,Subledger level and Journal level.
- Secondary Ledger could be used when you need to change the Chart of Aaccounts and Accounting convention method to meet the stattutory and corporate requirements.This is used primarily where the organisation need to report in diffrent autorities like Local authorites,US GAAP,IFRS,IASB etc.
Summary: If the business requirement is to have diffrent Currency from Primary Ledger then we can choose Reporting currency where as if we need to have different COA or SLA ,Calendar Method then use Secondary ledger.
Arun kumar Tangudu