Oracle E-Business Suite R12 Financials: August 2013

HOW TO CREATE GENERAL LEDGER STEP BY STEP SCREEN SHOTS

To define primary ledger:-

Setup financials accounting setup manager accounting setup

Click on accounting setup, click on create accounting setup

Click on next

Primary ledger will open, give the required parameters and if we want to add reporting currency. Click on add reporting currency.

Click on add another row

*Give the reporting currency required and currency conversion level as journal and click on apply.

Click on next and click on finish.

Then primary ledger will be created and automatically reporting ledger will be system it self

It will give a confirmation message that an accounting option is required. So click on define accounting option. (or) click on return to accounting setups query your ledger and click on update accounting option.

In ledger option click on update accounting option.

Click on next and in the ledger option give the retained earnings account in accounts segment, then click on next and click on finish.

Now ledger is defined. One we define the ledger we cannot change the currency, coa, calendar. But we can change the accounting method.

· If we query the ledger we will have the primary ledger, reporting currency, balancing segment value assignment, sub ledger accounting options and sequencing setup steps.

· Click on reporting currency then click on update, take default rate type and click on apply. Now click on complete.

Enter all the required fields as follows

DEFINING LEGAL ENTITY

Setupàfinancialsàaccounting setup managerà legal entity.

· Click on legal entities.

· Click on create legal entity.

· Legal entity window will be open. Give the mandatory fields. Create a legal address.

· Click on apply.

Enter the Mandatory fields

· Click on accounting setups.

· Query your ledger.

· Select the required ledger and click on update on the primary ledger.

· Click on add legal entity.

· Find the legal entity and select the required legal entity.

· Then click on apply.

· Now operating unit’s setup step will be added.

· Click on update balancing segment values.

· Click on add balancing segment values.

· Select the required companies i.e. balancing segment values.

· Click on apply.

· Now inter-company accounts setup step will be added.

· Click on operating unit update button click on complete.

· Click on inter-company account update button click on complete.

· Click on sub ledger accounting update button click on complete.

· Click on sequencing update button click on complete.

· Click on balancing segment values update button click on complete.

· It will show a warning that your ledger is about to save, if u saves this you can’t do any more modifications in the ledger.

· Click on yes.

· Now your primary ledger and reporting currencies status is complete.

Return to Accounting Setups

See Whether All Accounts are updated ie in not in progress or incomplete, and close Window

Create responsibility and assign primary ledger to the responsibility:-

· Go to system administrator

· Create the responsibility for GL.

· Go to the profile options and assign primary ledger value to the profile option GL ledger name for your responsibility.

Create a user and assign responsibility to the user:-

· Create a user in the system administrator.

· Assign the GL responsibility and system administrator to the user.

· Need to Query your account so press F11

· Enter your user name , enter first three or four letter of your user name (Ex: User Name : IND% put percentage symbol and then press Ctrl+F11, then your user name will be displayed, use UP and DOWN arrow keys to select the correct user ie starting with IND there will lot more other users so select your user by using arrow keys

· While assigning system administrator to your responsibility in r12 system will difficultly assign application diagnostics to your responsibility.

To open periods:-

Navigation: - setupàopen/close

· While opening the periods give the ledger name for what we want to open the periods.

· Give the first period name of our calendar.

Click on Find

Click on Open

· Now first period of the calendar will be open.

· To open next period click on next period.

· Here in r12 we are having the target period give the current period up to which we want to open.

· Then it will automatically open the periods up to the target period.

· A program will be running while opening the periods.

Enter month that you want to open Ex: 01-Jul-2013

Click on yes

Press Alt+V+R to see the program status

All These Dates are entered previously in the Calender (few other steps required to add this dates) There will be 12 months and 1 extra day is added its not updated here, it is the adjusting day it would be from 31-Dec-2013 to 31-Dec-2013, ie only one day , and at the end of the 13 slot we need to Enable

Reporting currency in R12:-

· For mrc in r12

· We have to create the GL responsibility for reporting currency.

· Then we have to assign reporting ledger to the profile option GL ledger name for the reporting GL responsibility.

Enter The same Details and just save and close

In Responsibility Screen

Add these details

èCreate a user for the reporting currency and assign reporting GL responsibility to that user:-

· Create user and assign reporting GL responsibility to that user

· Open the reporting user and open periods as mentioned for the primary ledger user.

Because now all these time we have added our personal ledger, so we need to open the dates.

Click on the 6th icon beneath the toolbar, it is used to Switch responsibilities
Now select the Responsibility that we created, and open it.Here we opened SAN Primary Ledger, Previously all this time we worked in System administrator, from now we work in our on ledger that is SAN PRIMARY LEDGER