New General Ledger (Multiple Ledgers): This is the Concept given in ECC6.0 by SAP. For Indian Companies Financial Year is April to March. If an Indian Company is registered in US Stock Exchange, it has to Submit Reports to Stock Exchange according to the Financial Year there in US (i.e., Jan to Dec). If The Same Company had its Group Head Quarters in UK, it has to Submit Reports according to the Financial Year there (i.e., July to June). So For One Company we are Creating Reports according to the Financial Year. In India Period of April is 01 but in US it is ’04’ and in UK it “10”. So When we are posting a Transaction in the Period “04” for the Fiscal Year Variant V3 ( which is for India), it has to update the Posting Period ’01’ for the Fiscal Year Variant K4 (for US) and Posting Period ’10’ for the PP Variant V6(for UK).
Here we have the Concept of Leading Ledger and Non Leading Ledgers.
Example:
Company Location Financial Year FY Variant Ledger Group
In India 1st April to31st March V3 OL Leading Ledger
In US 1St Jan to 31st Dec K4 J1 Non Leading Led
IN UK 1st July to 30th June V6 J2 Non Leading Led
When we create Ledger J1, Automatically Ledger Group J1 will be created and J1 ledger will be assigned. At the Time of Posting, if we do not give any Ledger Group it will updates all the Ledgers.
For Example, Gain on FC Revaluation in India and US it will be transferred to P& L A/c as Other Income. But in UK it will Add to the Fixed Assets and calculate Depreciation over the Life of Asset.
We create a New Ledger Group J3 and assign Ledgers 0L and J1. At the Time of Posting When we give Ledger Group J3, and Post, it updates Ledgers 0L and J1. In Ledger Group One Ledger will be Representative Ledger and others will be Non Representative Ledgers. We have to open the Periods in which Posting is done in Representative Ledgers. Even though the Periods for Non Representative Ledgers is not open, it will update the records. When the Ledger Group is consisting of Ledgers 0L a J1 always 0L will be the Leading Ledger or Representative Ledger When we Post a Document, System will generate Documents in non leading ledgers. In Live Environment, for all document types we will give only One Number Range for No range interval to post in Non Leading Ledgers.
Step 1: Define Ledgers for GL Account:
SPRO⇒ Financial Accounting (New)⇒ Financial Accounting Global Settings(New)⇒ Ledgers⇒ Ledger⇒ Define Ledgers for GL A/c
Select New Entries Button
Ledger Description
J1 (Text Field) Non Leading Ledger 1 for 3300
Totals Table: FAGLFLEXT
Ledger Description
J2 (Text Field) Non Leading Ledger 2 for 3300
Totals Table: FAGLFLEXT
→SAVE →ENTER to SAVE in your Request
Ignore the Warning Message →ENTER Once Again
Ignore the Warning Message →ENTER
Step 2.Define and Activate Non Leading Ledgers:
Same Path ( Next Level to the Old Path)
Ledger : J1 →ENTER
select New Entries Button
Comp. Code Fiscal Yr Variant PPV
3300 K4 3300 → SAVE
→ ENTER to SAVE in your Request
Select Back Arrow Button
Ledger : J2 →ENTER
select New Entries Button
Comp. Code Fiscal Yr Variant PPV
3300 V6 3300 →SAVE
→ENTER to SAVE in your Request
Step 3. Define Ledger Groups: Same Path ( Next Level to Last path)
Select New Entries Button
Ledger Group: J3
Description: Ledger Group for 3300 →SAVE
→ENTER to SAVE in your Request
Select Ledger Group J3
Double Click on Ledger Assignment Folder
Select New Entries Button
Ledger : 0L
Select Representative Ledger Check Box
Ledger: J1
De-select Representative Ledger Check Box →SAVE
Step 4. Define Document Types for Entry View in a Ledger:
SPRO ⇒ Financial Accounting( New)⇒ Financial Accounting Global Settings (New)⇒ Document ⇒ Document Types ⇒ Define Doc. Types for Entry View in a Ledger
Ledger: J1 →ENTER
Select New Entries Button
Type No. Range Type No. Range Type No. Range
SA 61 ER 61 RE 61
AA 61 WA 61 RV 61
KR 61 WE 61 WL 61 →SAVE
→ENTER to SAVE in your Request
Select Back Arrow
Ledger: J2 →ENTER
Select New Entries Button
Type No. Range Type No. Range Type No. Range
SA 62 ER 62 RE 62
AA 62 WA 62 RV 62
KR 62 WE 62 WL 62 →SAVE
→ENTER to SAVE in your Request
IN Live Environment we have to Give Number Range for all 51 Document Types
Select Back Arrow
Step 5. Define Document Types for General Ledger Group:
Ledger: J1 →ENTER
Select New Entries Button
Type No. Range Type No. Range Type No. Range
SA 63 ER 63 RE 63
AA 63 WA 63 RV 63
KR 63 WE 63 WL 63 →SAVE
→ENTER to SAVE in your Request
Ledger: J2 →ENTER
Select New Entries Button
Type No. Range Type No. Range Type No. Range
SA 64 ER 64 RE 64
AA 64 WA 64 RV 64
KR 64 WE 64 WL 64 →SAVE
→ENTER to SAVE in your Request
Step 6. Define Document No Ranges for Entry Group:
Upto Document Path is same ⇒Document No. Ranges ⇒Documents in Entry View ⇒Define Doc. No Ranges for Entry View
Company Code: 3300
Select Change Intervals Button
Select Interval Button
No. Range: 61
Year : 2013
From. No 800001
To No 900000 →ENTER
Select Interval Button
No. Range: 62
Year : 2013
From. No 900001
To No 1000000 →ENTER & SAVE
Ignore Warning Message →ENTER
Step 7. Define Document Number Ranges for General Ledger View:
Upto Document Path is same ⇒ Document Number Range ⇒ Doc. In General Ledger View ⇒ Define Document Number Ranges for General Ledger View
Comp. Code: 3300
Select Change Interval Button
No. Range Year From.No To No
63 2013 1 100000 →ENTER
Select Interval Button
64 2013 100001 200000 →ENTER& SAVE
Ignore Warning Message and Press Enter
As the Company is in India, it has Currency of Indian Rupee. As it is listed in US Stock Exchange, Transactions has to pass to that Ledger in USD. For UK, system should Pass Entries in GBP. So We need to Maintain Group Currency in SAP when we are using New GL Accounts.
Step 8. How to Maintain Group Currency GBP:
Path: Tools⇒ Administration ⇒ Administration ⇒ Client Administration ⇒ Client Maintenance (Sec4)
Select Client: 800
Select Details Button
Menu⇒ Table View⇒ Display/Change
Standard Currency: Change to GBP →SAVE
Step 9. How to Maintain Hard Currency USD per Country India:
SPRO⇒ SAP Net weaver⇒ General Settings⇒ Set Countries⇒ Define Countries in my SAP Systems
Select Position Button
Country: IN (India) →ENTER
Select IN Select Details Button
Language: EN Hard Currency: USD →SAVE
→ENTER to save in your Request.
Step 10. Define Currencies for Leading Ledger:
SPRO⇒ Financial Accounting(New) ⇒ Financial Accounting Global Settings(New)⇒ Ledger⇒ Define Currencies of Leading Ledger
Select Company Code: 3300
Select Copy As Button Change Company Code to: 3300
Select Save or Ctrl + S →ENTER to save in your Request.
Step 11. Define and Activate Non Leading Ledgers: Same Path
Ledger : J1 →ENTER
For Currency 2{C2}: 40(Select for USD) →SAVE
→ENTER to save in your Request.
Select Back Arrow
Ledger : J2 →ENTER
For Currency 2{C2}: 30(Select for GBP) →SAVE
→ENTER to save in your Request.