EBS General Ledger (GL)

Flexfield
1. Descriptive Flexfield – Capture additional information. Stored in attributes. Display in form as [ ]. DFF’s are of two types:
a) Global : Always appear on form
b) Context-Sensitive : May/ may not appear. Depends on form field

2. Key Flexfield – Predefined by Oracle. Made up of segments where each segment has value and meaning. Set of segments is called Code Combination

Tables: fnd_flex_value_sets and fnd_flex_values

General ledger application >> Accounting Flexfield >> Structure >> Segments >> Segment Values

We create the structure using Accounting Flexfield (KFF) in General Ledger. Each structure can have max 30 segments and min 2 segments (Company and Accounts). Say we have Tata as structure and this consists of three segments like Company, Department and Account. Each segment will have values like for Company C01, C02, C03 and for Department like Education & Research, Sales, Marketing, Finance, HR and for Account Expense, Revenue, Assets, Liability and Ownership.
We define these values under value set. {In case min & max value are not specified and the max size is defined as 3 having NUMBER format type, then system automatically defaults the min value to 001 and max value to 999. Similarly if the format type is CHAR with max size as 3 then we n number of combinations for min & max value, like 001-999, AAA-ZZZ, A01-A99, B01-B99, AB1-AB9, 1DA-9DA & so on}.

Value Set Navigation:
Setup >> Financials >> Flexfield >> Validation >> Sets
(or)
Application Developer >> Application >> Validation >> Sets

Creation of Company, Department and Account value set
GL_1
GL_2
GL_3

Assigning values to each value set:
Setup >> Financials >> Flexfields >> Key >> Values >> Select Value set >> Query for value set name >> Click on Find >> Enter values for Company
GL_4

Similarly enter values for Department
GL_5

Similarly enter values for Account and assign segment qualifiers as this is mandatory for Account segment. We have following account types under segment qualifiers: Asset, Liability, Expense, Revenue, Ownership/ Stockholder’s Equity, Budgetary (CR), Budgetary (DR)
GL_6
GL_7
GL_8

General Ledger is an application.
Ledger is an entity where we record the business information like selling and purchasing details. We define 4C’s in Ledger.
1. Chart of Accounts: Here we define structure, segments and segment values (attaching value set)
2. Currency: INR, AUD, USD, GBP
3. Calendar: We have two types
a. 01-Jan-2015 to 31-Dec-2015 — Calendar
b. 01-Apr-2015 to 31-Mar-2015 — Fiscal (Any calendar other than calendar {like above} is Fiscal calendar)
4. Convention: Also called Accounting method. We have two types
a. Cash Basis of Accounting – As on when transaction takes place. Immediate settlement.
b. Accrual Basis of Accounting – Not immediate settlement. Pay later.

Defining structure and segments:
General Ledger Super User responsibility >> Setup >> Financials >> Flexfields >> Key >> Segments >> Query for Application ‘General Ledger’ and Flexfield Title ‘Accounting Flexfield’
GL_9

Create your Structure as highlighted below and click on Segments
GL_10

Creation of Segments and assigning value set to each segment
GL_11

Click on Flexfield Qualifiers >> For Company select Balancing Segment >> For Department select Cost Center Segment >> For Accounts select Natural Account Segment
Flexfield Qualifier – Defines behavior of each segment.

After including the flexfield qualifiers come to main page. Check Allow Dynamic Inserts and Freeze Flexfield Definition and click on Compile. With this COA gets completed.

Currencies:
General Ledger Super User >> Setup >> Currencies >> Define >> Check the Enabled field for the currencies which you want to use. Also we can create our own currency if required.
GL_12

Calendar:
We have two types:
1. Accounting Calendar (Mandatory) 2. Transaction Calendar (Optional)

Accounting Calendar are of two types
1. Calendar – 01-Jan-2015 to 31-Dec-2015
2. Fiscal Calendar – 01-Apr-2015 to 31-Mar-2016

General Ledger Super User >> Setup >> Financials >> Calendars >> Types >> Create your custom period type
GL_13

General Ledger Super User >> Setup >> Financials >> Calendars >> Accounting >> Create custom calendar
GL_14

In case you would like to have adjustment period then create period having periods per year as 13 so that you can have the adjustment period in calendar.

When trying to close the form you have validation message. Go ahead and select Current. Ensure the program successfully gets completed.

Creation of Ledger
Along with three C’s, we need to have following six mandatory accounts.
1. Retained Earnings (Ownership) — Mandatory = Accumulated profit
2. Suspense Account (Asset/ Liability) = Whenever user is going to enter debit w/o credit or credit w/o debit then that missed entry hits suspense account. In case we don’t define suspense account we get Error6: No suspense account defined.
3. Rounding Difference (Expense/ Revenue) = Round off value to nearest integer (<50 then 0; >=50 then 1)
4. Translation Adjustment (Ownership/ Revenue) = Localization of currency
5. Net Income/ Net Earnings (Expense/ Revenue) = Current year profit
6. Reserve for Encumbrance (Ownership) = Whenever user is going to enter debit w/o credit or credit w/o debit for BUDGET JOURNAL then Reserve for Encumbrance line added by Posting

Actuals – Day to day transactions are Actuals. Like Salary A/C Dr to Suspense A/C; Rent A/C Dr to Suspense A/C; Purchase A/C Dr to Suspense A/C.
Budgets – Future/ Forecasting transactions are Budgets. Like 2016 or 2017 transactions, when we don’t have Dr or Cr entry then we get Reserve for Encumbrance.
Creation of Ledger = Accounting Setup + Accounting Options (or) Ledger Options
Accounting Setup = Ledger Name + 3 C’s (COA, Currency, and Calendar)
Ledger options = Mandatory accounts like Retained earnings, Suspense account, Rounding difference, Translation adjustment, Net income, Reserve for encumbrance

General Ledger Super User >> Setup >> Financials >> Accounting Setup Manager >> Accounting Setups >> Click on Create Accounting Setup >> Legal Entity creation can be taken later so click Next >> Enter details as below
GL_15

Click Next >> Click Finish >> In case you are willing to define accounting options then click Define Accounting Options else choose Return to Accounting Setups. Here I opted to create accounting options.
GL_16

Click on update against Ledger Options >> Just review the values
GL_17

Click on Next >> Under Retained Earnings Account >> Select the values from LOV and ensure you selected retained earnings account value under Accounts segment. We can choose any company/ department >> Click on create to generate code combination
GL_18

Similarly for Suspense account select the values
GL_19

Similarly for rounding differences select the values
GL_20

Similarly for Translated adjustment account
GL_21

Click on Next >> Include Reserve for Encumbrance account if required >> Click on Next >> Review the details and click on Finish >> The status against Tata Ledger has to be Tick marked. And observe the difference which is highlighted with previous page. Earlier we have Ledger option which is now modified to Tata Ledger
GL_22

Click on update against Reporting Currencies >> In case you use other reporting currencies then click on Add Reporting Currency, else click on Complete >> Ensure the status of Reporting Currencies to be Completed.

Click on update against Balancing Segment Values >> Click add balancing segment value >> In case we don’t select all values then we wont be able to use within this Ledger >> Select all balancing segment values and click on Complete >> Ensure the Balancing segment value to be in completed status.

Click on update against Sequencing >> Change the status from In Progress to Complete and click on Apply >> Ensure the status to be Completed.
GL_23

Click on Complete for Ledger creation.

Now assign the created ledger to profile option: GL: Data Access Set
General Ledger Super User >> Other >> Profile >> Enter the ledger name under user value for GL: Data Access Set

The priority will be given to User Value. If no user value then default value will be picked.
GL_24

Now verify which ledger we are connected to.
General Ledger Super User >> Journals >> Enter >> We should find the Ledger Name at Top of form.
GL_25

Open a Period:
General Ledger Super User >> Setup >> Open/ Close
GL_26

Click on Find >> Here you find First Period as ‘Jan-15’ >> This value can be changed. General Ledger Super User >> Setup >> Financials >> Accounting Setup Manager >> Accounting Setups >> Open the first ledger setup. There we have field as ‘First Ever Opened Period’ >>
If you want to proceed with ‘Jan-15’ click on Open >> Choose Yes >>
GL_27

Here we have the Future – Entry for Feb since we gave Number of Future Enterable Periods as 1 in Accounting Setups

Opened the month of Feb
GL_28

Open the month of May, leaving Mar and April unopened. Still all the periods get opened which are in between.
GL_29

Journal Entry Structure
1. Batch Name (Optional) Expense Batch
2. Journals like Rent Journal, Salary Journal
3. Journal Lines like Office Rent, Salary to Office staff, Factory Rent, Salary to Factory staff,
Godown Rent, Salary to Godown staff, Guest House Rent, Salary to Guest House staff
Entering a Journal:
General Ledger Super User >> Journals >> Enter >> Click on New Batch >> Enter values as given below
GL_30

Effective date in Journals:
1. Whenever user is going to enter journal for any previous period, system will consider the effective date as last date of previous period.
2. Whenever user is going to enter journal for any future period, system will consider the effective date as first date of future period.
3. Whenever user is going to enter journal for current period, system will consider the effective date as current date of current period.

Category in Journals:
Purpose of the Journal entry. Ex: Payments, Payroll

Click on Journals >> Enter details as below >> Save
GL_31

We have the above violation message as we have difference in Control Total amount and Batch amount.
Click on Yes and save the transaction.
Create new Salary Journal as below and save the transaction. Observe the difference in message. In the above image we have journal batch but here we have journal.
GL_32

Now changes the Dr/ Cr amounts to 10,000 and save. Here we don’t have any violation message.
Coz we have Batch control of 20,000. We created a rent journal of 10,000 and salary journal with 10,000 so when saving second record salary journal, we don’t have any violation.
GL_33

Verifying the existing of Journals:
General Ledger Super User >> Journals >> Enter >> Find >> Here we should find the two Journal entries
GL_34

Posting Rent Journal
Under Payments category >> Click on >> Review Journal >> Click on Post.
Here you find both the batch status as Posted since both the journals belong to same batch (Expense Batch)
GL_35

Create individual batch for each journal in case you want to get posted all journals.

Suspense Journal
———————–
General Ledger Super User >> Journals >> Enter >> New Journal >> Enter details as below and save
GL_36

After saving the transaction click on Post

The Journal entry gets posted as below.
GL_37

Since we have suspense account enabled for Tata Ledger, we have suspense account triggered.
If the suspense account is not enabled in accounting setup while creating ledger then we wont be able to post the entry. The concurrent program errors out and we have Error 6
GL_38

In case you have Dr entry without Cr entry and you don’t want to hit suspense account, rather you want cash account to trigger. Then follow below set up
General Ledger Super User >> Setup >> Accounts >> Suspense >> This works only when the entry is Manual and Category is Payments
GL_39

In case Cr without Dr or Dr w/o Cr, since we defined the suspense account the source as manual and category as payments, we get cash account rather than suspense account. If any other mode we have suspense account.

The below example provide more details:
Created a Rent Journal account with category as Payments and source as Manual without Cr entry and posted. Then instead of default suspense account we have cash account. Anyother category or source we get suspense account (M03).
GL_40

Document Sequence:
—————————–
Auto assigning of sequential numbers while creating Journals

By default we have Budget beneath effective date.
GL_41

General Ledger Super User >> Other >> Profile >> For profile Sequential Numbering enter Partially Used value
GL_42

Now query for new journal where you find Document Number in the place of Budget.
GL_43

Now assigning initial value to document number. Here we have initial value as 100
General Ledger Super User >> Setup >> Financials >> Sequences >> Document >> Define
GL_44

General Ledger Super User >> Setup >> Financials >> Sequences >> Document >> Assign
In Document Tab
GL_45

In Assignment tab
GL_46

Now create a journal having Payments category and save the details to get the document number
GL_47
GL_48

Auto Posting
—————–
Create a two new journals for posting.
GL_49
GL_50

General Ledger Super User >> Setup >> Journal >> AutoPost

Here we have category as Payment for period Feb-15, whereas we created a journal with category as Payroll for period Feb-15 so the below entry wont get posted.
GL_51

This gets posted for the newly created journals
GL_52

Also we have option as ALL which picks all unposted journals irrespective of source, category and periods >> If required enter the Journal effective dates which indicates post the unposted journals between these dates >> Click on Submit
GL_53

Now check the status of unposted journals which have been modified to Posted.
GL_54

Recurring Journals
————————-
Recurring journals are of three types:
1. Standard: User knows the entry and also the amount
Rent A/C Dr 1000/-
To Cash A/C 1000/-

2. Skeleton: User knows only the Entry, but don’t know the amount
Telephone Bill A/C Dr XXXX
To Cash A/C XXXX

3. Formula: User is going to use some formula (like +, -, *, /) within the journal
Rent A/C Dr 2400000/12 20000/-
To Cash A/C 20000/-
Standard recurring journal
———————————–
General Ledger Super User >> Define >> Recurring >> Enter values as below
GL_55

Click on Lines and create two lines as below
GL_56
GL_57

Now generate this setup
Journals >> Generate >> Recurring >> Enter details as below
GL_58

Click on Generate
Query for Journal and you find an unposted journal
GL_59
GL_60

We have Cash amount under Dr, which has to be under Cr.
To make that change, go to Journals >> Define >> Recurring >> Query for Rent Recurring Batch >> Lines >> For cash account enter amount as -12000
GL_61

Now go to Journals >> Generate >> Recurring >> Select Period as Feb-15 >> Generate
GL_62

Now search for Journal with period Feb-15 and you should have 12,000 under Cr.
GL_63

2. Skeleton Recurring Journal
—————————————
Journals >> Define >> Recurring
GL_64

Lines >> Enter two lines
GL_65
GL_66

Now generate a journal >> Journals >> Generate >> Recurring >> Enter Period as Jan-15 >> Click on Generate
GL_67

Now query for journal . Here we have information only about accounts but no amount.
GL_68

Now suppose I delete the rent recurring batch and purchase recurring batch from recurring journals.
Journals >> Generate >> Recurring >> Delete Rent Recurring Batch and Purchase Recurring Batch

Now query for journals which were created under those batches. Still you find the journals though we deleted recurring batches.
GL_69

Only Unposted journals can be deleted. In case you want to delete, then select each journal and delete manually.

3. Formula Recurring Journal
—————————————
Journals >> Define >> Recurring
GL_70

Lines
GL_71

Ensure you use line number as 9999
GL_72

Now generate this entry.
Journals >> Generate >> Recurring >> Generate for Jan-15 period.
GL_73

Search for Journal entry
GL_74

Security Rules
——————-

General Ledger – (Application)
Responsibilities
1. General Ledger Super User – Has 8 Sub menus
2. General Ledger Supervisor – 5
3. General Ledger Controller – 4
4. General Ledger Budget User – 3
5. General Ledger User – 2
Here we are trying to secure account values so go to Account value set which is ‘Tata Account Value Set’ and modify the security type ‘Hierarchical Security’
GL_75

Now to go Structure. General Ledger Super User >> Setup >> Financials >> Flexfields >> Key >> Segments >> Query for Tata Structure >> Unfreeze flexfield definition >> Segments >> Select Accounts segment >> Click on Open >> Enable Security Enabled >> Save
Freeze the Structure and compile

General Ledger Super User >> Setup >> Financials >> Flexfields >> Key >> Security >> Define >> Enter values as below and click on Find
GL_76

Enter name and message. First include all the values under Include type then select the values which you want to exclude.
GL_77

Here we excluded 2 assets and 3 liabilities.
Click on Assign >> Enter values as below
GL_78

Now create a journal entry to test the above security values. Here we don’t find the values which were excluded.
GL_79

To revoke back those values go back to Tata Structure >> uncheck Security enabled
And on Tata Account Value Set change the security type to No Security

Cross Validation Rules
——————————
Say we have 5 companies and 5 departments. Except C02 all companies have all 5 departments. The company C02 has only D01 and D02

C01 D01
C02 D02
C03 D03 X
C04 D04 X
C05 D05 X

Go to Tata Structure >> Unfreeze >> Check Cross Validate Segments >> Now freeze and compile
Now go to Setup >> Financials >> Flexfields >> Key >> Rules >> Enter values as below

Here company C02 is not allowed to enter departments D03, D04 and D05
GL_80

Now test the journal entry for C02 and D03 department.
GL_81

In case you don’t want the cross validation rule then uncheck in Tata Group Structure.

Calculation of Total Expenditure for a particular month
————————————————————————-
General Ledger Super User >> Inquiry >> Account >> Enter details as below
Here E01-E03 are expense account type.
GL_82

We need to calculate the totals manually by selecting show balances. For system calculation go to Setup >> Financials >> Flexfields >> Key >> Values >> Enter values as below and click on Find
GL_83

Create a new line as below and select Parent type
GL_84

Now keeping the cursor at Total Expense line, click Define Child Ranges >> Enter range from E01 to E03 >> Save

Now go to Setup >> Financials >> Flexfields >> Key >> Groups >> Enter details as below and click on Find
GL_85

Create a new rollup
GL_86

Now again go back to values and assign the newly created group
GL_87

Now go back to Structure >> Uncheck freeze and check freeze rollup groups >> Again Freeze and compile>> After Compilation we have Expense Rollup group gets uneditable
GL_88

Summary Accounts
Setup >> Accounts >> Summary >> Enter the period as Jan-15 >> Save
GL_89

Now go to Inquiry >> Account >> Enter Jan-15 period and select Expense Summary under Summary Template
GL_90

In case we don’t need to access the roll up group then unfreeze the structure and uncheck the freeze rollup groups

MRC (Multi Reporting Currency)
——————————————-
Create a new Ledger for this activity
Setup >> Financials >> Accounting Setup Manager >> Accounting Setups >> Create Accounting Setup >> Next >>
GL_91

Click on Add Reporting Currency
GL_92

Click Next and Finish
GL_93

Go to Accounting Options >> Click on Update against Ledger Options >>
GL_94

Enter Retained earnings account C01-D01-M02 >> Next >> Next >> Finish

Now click on update against Reporting Currencies >> Update >> Enter the default rate type as Corporate and click on Apply
GL_95

Click on Complete
GL_96

Now click on update against Balancing Segment Value Assignments >> Click Add Balancing Segment Value >> Select All companies >> Complete
Now click on update against Sequencing >> Modify the status to Complete >> Apply
Once all the Setup steps are completed >> Click on Complete button
Here we created a Ledger Tata MRC Ledger and system has dynamically created a ledger Tata MRC Ledger(USD)

Now assign the Tata MRC Ledger to profile value GL: Data Access Set
GL_97

Now open periods for new ledger.
Setup >> Open/ Close, say till Mar-15

Create another user and assign profile value of Tata MRC Ledger(USD) to GL: Data Access Set
And open periods for Tata MRC Ledger(USD), say till Mar-15

Corporate rate is fixed by Corporate head quarters.
Now create dollar rates in new user.
Setup >> Currencies >> Rates >> Daily >> Enter values as below (The below rate is applicable only for 31-JAN-2015)
GL_98

Come back to old user and create a new ledger as below. Save and Post
GL_99

Here the 2,75,000 INR gets converted into USD amount. Login to new user and search for Journal. There we will find both INR and USD values.

IntraCompany Journals
——————————-
When the transaction takes place between two companies then it is IntraCompany

For example:
C01 Purchase A/C Dr 5000/-
C01 Cash A/C Cr 5000/-

C02 Cash A/C Dr 5000/-
C02 Sales A/C Cr 5000/-
Here the C01 Cash A/C Cr and C02 Cash A/C Dr gets nullified and we get only
C01 Purchase A/C Dr 5000/-
C02 Sales A/C Cr 5000/-

Setup:
Open the ledger >> Click on update against Tata Ledger >> Next >> In step 2 of 4 check the ‘Enable Intracompany Balancing’ >> Finish >> Click on Return to Accounting options >> Click on update against Intracompany Balancing Rules >> Define Rules >> Create Rule >> Enter the details as given below
GL_100

Now in options tab enter details and click on Apply >> Done
GL_101

Now create a Journal and post
GL_102

After posting we have below accounts enabled due to Intracompany balancing.
GL_103

Ledger Set and Data Access Set
—————————————–
Other than TATA Ledger, create 2 more ledgers.

Tata Ledger 1
GL_104

Define Accounting Options
GL_105

Enter the Retained Earnings Account C01-D01-M02 >> Next >> Finish
For Reporting Currencies click on Complete
For Balancing Segment values click on Add Balancing Segment value and select all >> Click Complete
For Sequencing >> Modify the status from In Progress to Complete >> Apply
Finally click on Complete
Now create one more Ledger Tata Ledger 2
Ledger Set: Setup >> Financials >> Ledger Sets
GL_106
GL_107

Now go to Other >> Profile >> for GL: Data Access Set enter user value as Tata Ledger Set 1

Now enter a Journal >> Here we have Default ledger as Tata Ledger with multiple ledgers assigned under Ledger field
GL_108

Similarly change the profile value of GL: Data Access Set to Tata Ledger Set 2
Now enter a Journal >> Here we don’t have any default ledger but have multiple ledgers assigned under Ledger field
GL_109

Data Access Set: Setup >> Financials >> Data Access Sets
GL_110

Now go to Other >> Profile >> for GL: Data Access Set enter user value as Tata Data Access Set
Now enter a Journal >> Here we are able to find all 5 ledgers with the respective ledgers which are assigned under ledger set 1 and ledger set 2
GL_111

The difference between ledger access set and data access set is we have read/ write or read only mode in data access set.


FSG (Financial Statement Generator)

Mandatory Steps Optional Steps
1. Define Row Set
2. Define Column Set
3. Define Report (Row set + Column set = FSG report)
1. Define Content Set
2. Define Row Order
3. Define Display Set