Ledgers – Ledgers are the financial reporting entity within organization. It is a unique combination of 3 components. In R12 a fourth component is introduced that gives flexibility to control sub ledgers (OM/AR/AP etc.) accounting.
- Chart of Account
- Currency
- Calendar
- Sub Ledger Accounting
All the accounting entries are captured in Ledgers. In 11i its called Set of Books having 3 components (Chart of Account, Currency and Calendar).
If we look at the structure of our implementation we need 3 Ledgers because the currency is different in all 3 countries. The thumb rule is that if any of the 3Cs (Chart of Account, Calendar and Currency) is changing we need a new ledger. Lets get going with Ledger creation. Make sure to use the custom responsibility that you created earlier while creating Business Group.
Before you start setting up the ledger you should have 3Cs created. If you already have it created then proceed else follow the below post to create and configure 3Cs.
Navigate to – XX GL Super User –> Setup –> Financials –> Accounting Setup Manager –> Accounting Setups
This will open a web page. Click on Create Accounting Setup.![Image 234 Image 234](http://lh6.ggpht.com/-BocoWN_GDpo/VM02vTs32rI/AAAAAAAAKbk/SVQEfGTSRqE/Image%252520234_thumb%25255B32%25255D.png?imgmax=800)
First setup is to create / add legal entities. I prefer to skip this step and Create Legal Entities separately and add them later. So click on Next.
![Image 235 Image 235](http://lh3.ggpht.com/-pkU1yR-QTiA/VM02wD057cI/AAAAAAAAKb0/IMKBtWyoNk4/Image%252520235_thumb%25255B3%25255D.png?imgmax=800)
Enter the required Details :
Name : OAF_Corp_USD_P
Chart of Accounts : OAF_CORP_COA
Accounting Calendar : OAF_ACC_CAL
Currency : USD
Click Next and Review the details. If it looks fine click on Finish.
![Image 236 Image 236](http://lh6.ggpht.com/-BcwDikNLXhU/VM02w6f5ViI/AAAAAAAAKcE/FYnikIAiMXk/Image%252520236_thumb%25255B4%25255D.png?imgmax=800)
![Image 237 Image 237](http://lh6.ggpht.com/-GFBK1EE-xz4/VM02xzzp5aI/AAAAAAAAKcU/6mEwSvSiagQ/Image%252520237_thumb%25255B3%25255D.png?imgmax=800)
Once finished system gives you message that Accounting Options are not setup, only the structure is created now. Before we start using the Ledger we need to complete the Accounting Options setup.
Click on Define Accounting Options.
![Image 238 Image 238](http://lh6.ggpht.com/-okMrOrTINdI/VM02yoPqxvI/AAAAAAAAKck/nTa7lBgTxoE/Image%252520238_thumb%25255B3%25255D.png?imgmax=800)
Click on
![Image 167-UpdateIcon[8] Image 167-UpdateIcon[8]](http://lh6.ggpht.com/-jN90T-_j0gQ/VM02zb6je4I/AAAAAAAAKc0/1j1GHiHLCY8/Image%252520167-UpdateIcon%25255B8%25255D_thumb%25255B1%25255D.png?imgmax=800)
![Image 239 Image 239](http://lh3.ggpht.com/-ztpy70ZNkvk/VM021P7tRKI/AAAAAAAAKdE/rg_i6U8bV0c/Image%252520239_thumb%25255B5%25255D.png?imgmax=800)
Validate the details and click on Next
![Image 244 Image 244](http://lh4.ggpht.com/-lUluYW35zKY/VM021kzkrXI/AAAAAAAAKdU/1gb6stNgRdU/Image%252520244_thumb%25255B2%25255D.png?imgmax=800)
In the next screen, choose the Retained Earning Account. While we define the accounting structure we should have defined all these account. Since for my Chart of Account ‘Dynamic Insert’ is enabled I create the account on the fly.
![Image 249 Image 249](http://lh4.ggpht.com/-PzwwbYxC8Bw/VM022t3ML6I/AAAAAAAAKdk/RzGv5nZSTw0/Image%252520249_thumb%25255B2%25255D.png?imgmax=800)
![Image 250 Image 250](http://lh5.ggpht.com/-SStJ9TzeUG8/VM023npd5EI/AAAAAAAAKd0/je3B2gxd45k/Image%252520250_thumb%25255B2%25255D.png?imgmax=800)
If you want you can create and enter accounts for Suspense Account and Rounding Differences Tracking Account. I opted to enter those later. In the next screen update Advanced Options as you needed for your configuration.
![Image 251 Image 251](http://lh4.ggpht.com/-1dI8a61m6SM/VM024c7FjYI/AAAAAAAAKeE/8OYNjoBhAow/Image%252520251_thumb%25255B2%25255D.png?imgmax=800)
![Image 252 Image 252](http://lh4.ggpht.com/-I7hPTOBuNN8/VM025OKeWiI/AAAAAAAAKeU/oy5qQAH_ZIo/Image%252520252_thumb%25255B3%25255D.png?imgmax=800)
Since I used intercompany accounts while defining my accounting structure, its asking to complete Intercompany Balancing Rule. Return to Accounting Options to complete rest of the configuration.
![Image 254 Image 254](http://lh6.ggpht.com/-zttZ1AFcZZA/VM026OhIpJI/AAAAAAAAKek/nUnZM3sTzpY/Image%252520254_thumb%25255B2%25255D.png?imgmax=800)
The first thing I did is to add Legal Entity to the Ledger. Click on Add Legal Entity button and select the correct legal entity for the ledger. Click on Apply to add the legal entity to the ledger. It will again take you to the Ledger Option.
![Image 256 Image 256](http://lh5.ggpht.com/-WVXAaneucwo/VM026_j466I/AAAAAAAAKe0/8xGnjHZJk_U/Image%252520256_thumb%25255B3%25255D.png?imgmax=800)
![Image 257 Image 257](http://lh4.ggpht.com/-4wSTRuOzzRk/VM027rFkABI/AAAAAAAAKfE/d-C6coNzJQo/Image%252520257_thumb%25255B2%25255D.png?imgmax=800)
Now its turn to create and add operating units. Click on
against Operating Units. Enter the Name and Shot Code for the Operating Unit. Under the assignment section add the Business Group and Default Legal Context. This will create the hierarchy that this operating units is under which business group and Legal entity.
![Image 167-UpdateIcon[12] Image 167-UpdateIcon[12]](http://lh4.ggpht.com/-ZQxOUUzVhQg/VM028oGwX_I/AAAAAAAAKfU/2EqzxJyu6Zk/Image%252520167-UpdateIcon%25255B12%25255D_thumb%25255B1%25255D.png?imgmax=800)
Once done click on Apply
![Image 258 Image 258](http://lh4.ggpht.com/-ZvhJ08a1_sI/VM029YPtCOI/AAAAAAAAKfk/PfGDZxRwxbs/Image%252520258_thumb%25255B2%25255D.png?imgmax=800)
If you don’t want to add more operating unit under this ledger then click on Complete.
![Image 259 Image 259](http://lh3.ggpht.com/-7pBnlkXBhYI/VM02-Zx4giI/AAAAAAAAKf0/14SzBKkKbWE/Image%252520259_thumb%25255B4%25255D.png?imgmax=800)
Click on
![Image 167-UpdateIcon Image 167-UpdateIcon](http://lh5.ggpht.com/-rOA4McbHhvw/VM02_CYPwSI/AAAAAAAAKWY/rrsNxhDetuk/Image%252520167-UpdateIcon_thumb%25255B6%25255D.png?imgmax=800)
- Reporting Currencies
- Balancing Segment Value Assignment
- Intercompany Accounts
- Intracompany Balancing Rules
- Sequencing
![Image 260 Image 260](http://lh6.ggpht.com/-J4X5kvMeR8I/VM02__tFl-I/AAAAAAAAKgE/IyXPPC1ykeY/Image%252520260_thumb%25255B3%25255D.png?imgmax=800)
![Image 261 Image 261](http://lh5.ggpht.com/-zdUi2ZVbEzI/VM03A3Z0jmI/AAAAAAAAKgU/mUqr_ZBDdKM/Image%252520261_thumb%25255B4%25255D.png?imgmax=800)
![Image 262 Image 262](http://lh6.ggpht.com/-Ve-QcMD3Ggg/VM03CCBs8RI/AAAAAAAAKgk/THswcRhQ1eA/Image%252520262_thumb%25255B4%25255D.png?imgmax=800)
![Image 271 Image 271](http://lh5.ggpht.com/-0oqKe9v7He4/VM03CyeMAdI/AAAAAAAAKg0/pr6_om2fqZ4/Image%252520271_thumb%25255B3%25255D.png?imgmax=800)
![Image 272 Image 272](http://lh6.ggpht.com/-12FYi-gwZV4/VM03EMlcFLI/AAAAAAAAKhE/JM5FzlCQJKw/Image%252520272_thumb%25255B2%25255D.png?imgmax=800)
Once done Status against each would be
![Image 169-Icon Image 169-Icon](http://lh5.ggpht.com/-oqciEwkVizI/VM03E9xoT6I/AAAAAAAAKX8/6S0GIMskmTU/Image%252520169-Icon_thumb.png?imgmax=800)
![Image 273 Image 273](http://lh3.ggpht.com/-fRlJSke2Vm4/VM03GTv4RDI/AAAAAAAAKhU/8rPxpzAlhX0/Image%252520273_thumb%25255B2%25255D.png?imgmax=800)
This will submit a concurrent program that will complete the setup.
![Image 276 Image 276](http://lh5.ggpht.com/-i-CF6N_xbEU/VM03HPOLeDI/AAAAAAAAKhk/o-4AEsWYY5c/Image%252520276_thumb%25255B2%25255D.png?imgmax=800)
Requery the Ledger that we just create to validate every thing looks fine. What I see here is that I have missed Balancing Segment Value for the legal entity. Lets add it. Click on Update Balancing Segment Value.
![Image 277 Image 277](http://lh5.ggpht.com/-ZBgfC1zlodg/VM03IJ63KLI/AAAAAAAAKh0/EVBdd-03sGE/Image%252520277_thumb%25255B3%25255D.png?imgmax=800)
Choose the correct Balancing Segment.
![Image 281 Image 281](http://lh5.ggpht.com/-PQVawNeiB4s/VM03I0FQiNI/AAAAAAAAKiE/jSuON9e1GKU/Image%252520281_thumb%25255B2%25255D.png?imgmax=800)
Click on Apply.
![Image 282 Image 282](http://lh5.ggpht.com/-qR3yAMTpSTA/VM03JjxJ59I/AAAAAAAAKiU/i3lGSHagTr8/Image%252520282_thumb%25255B2%25255D.png?imgmax=800)
![Image 283 Image 283](http://lh6.ggpht.com/-RAsGuKR4JMc/VM03KRIb1VI/AAAAAAAAKik/Qb94Pl8VYnI/Image%252520283_thumb%25255B2%25255D.png?imgmax=800)
Update the Intercompany accounts and complete it. Once done it looks all good.
![Image 284 Image 284](http://lh6.ggpht.com/-TkJlIi3tf-0/VM03LhNuI2I/AAAAAAAAKi0/xR61FcmcktA/Image%252520284_thumb%25255B2%25255D.png?imgmax=800)
Similarly create the other two ledgers.
Now all the ledgers are created and configured.
![Image 291 Image 291](http://lh5.ggpht.com/-ZT9slYJeH1w/VM03M6AY8DI/AAAAAAAAKjM/eoz97zyVIyQ/Image%252520291_thumb%25255B2%25255D.png?imgmax=800)
Setup the profile option “GL Ledger Name” for the responsibility to be used with this Ledger.
![Image 293 Image 293](http://lh5.ggpht.com/-GcDATtvKLOI/VM03NmypCZI/AAAAAAAAKjc/dEDTA1bHeDs/Image%252520293_thumb%25255B2%25255D.png?imgmax=800)
Since we created Operating Unit while creating the Ledgers we have to run the concurrent Program “Replicate Seed Data” against each operating unit before we start to use it.
No comments :
Post a Comment