Sunday 23 August 2015

New General ledger customization and account splitting in sap CO


NEW GENERAL LEDGERS ( ECC 6 NEW FEATURES)

New  general ledger (Multiple ledgers)

Accounting group V3 India group    April –March   B1 Leading ledger –0L
Accounting group K4              US Group       Jan –Dec         K4 Non leading ledger –M1
Accounting group V6  UK Group      July-June         V6 Non leading ledger 2 –M2

When we create ledgers automatically ledger group will be created

We can assign in ledger group number of legers for 0L we can assign all and M2

At the time of posting –If we don’t specify ledger group –It updates all legers.

FC (Foreign currency)Revaluation –Gain /Loss to charge to P & L account  -For leading ledger 01 and non leading ledger M1-For UK group purpose it is to be added to asset and calculate depreciation for ledger group 0L-Assign M1 ( 0L is already assigned) –At the time posting it updates ledgers 0L and M1

Representative ledger and non-representative ledger  

When we create legers ledger group will be created that ledger will be called representative ledger – we are assigning for 0L ledger group M1 –This is called non representative ledger.

At the of posting system checks representative ledger periods are open or not –we need not open non-representative ledgers periods.

Eg: Ledger GRP (Group)-0L

Ledger 01        Representative ledger
                        (April 2008- March 2009)
January 2009   period should be open
Ledger M1      Non-representative ledger
January 2009 –December 2009
January 2009 period can be closed.

We are creating M1 ledger –Automatically M1 ledger GRP is created –we are assigning ledger 0L (0L=Leading ledger) –Always leading ledger only should be the representative ledger.

Document types and no.ranges are required non-leading ledgers –All non-leading ledgers we specify all document types and given only one number range –we give number range interval only for one number range.


CUSTOMIZATION

Activate new general ledger accounting:

Path :SPRO-Financial accounting –Financial accounting global settings –Activate new general ledger accounting 

Select new general ledger active check box
Save
(This is one time job work at client place)

Define ledgers for general ledger accounting

Path :SPRO-Financial accounting (new) -Financial accounting global settings (new) –Legers –Ledger-Define ledgers for general ledger accounting

Select new entries button
Ledger             :M1 ( Text filed)
Ledger name   :Non leading ledger for BIL
Totals table      :FAGLFLEXT
Ledger             :M2
Ledger name   :Non leading ledger for BIL
Totals table      :FAGLFLEXT
Save
Save in your request
Ignore the message press enter

Define and activate non-leading ledgers:
Same path

Give the ledger           :M1
Enter
Select new entries button
Company code            :BIL
Fiscal year variant       :K4
Posting period variant :BIL
Save
Press enter to save in your request
Select back arrow

Give the ledger           :M2
Enter
Select new entries button
Company code            :BIL
Fiscal year variant       :V6 (July to June)
Posting period variant :BIL
Save

Define ledger group:
Same path

Select ledger group     :0L
Double click on ledger assignment folder
Select new entries button
Ledger                         :M1
Deselect representative ledger check box
Save
Ignore the warning message press enter
Press enter to save in your request

Define document types for entry view in a ledger

Path :SPRO-Financial accounting (new)-Financial accounting global settings (new) –Document –Document types –Define document types for entry view in a ledger.

Give the ledger           :M1
Enter
Select new entries button
Type                            Number range
SA                               40 (give it any number range)
KR                              40
DR                              40
WE                              40
WA                             40
RE                               40
RV                              40
WI                               40
AA                              40
WL                              40
Save
Press enter to save in your request
Select back arrow

Give the ledger           :M2
Enter
Select new entries button

Type                            Number range
SA                               41
KR                              41       
DR                              41
WI                               41
WA                             41
WE                              41
WL                              41
RE                               41
RV                              41
AA                              41

Save

Define document types for general ledger view
Same path
Give the ledger           :M1
Enter
Select new entries button
Type                            Number range
SA                               45
KR                              45
DR                              45
WA                             45
WI                               45
WL                              45
WE                              45
RE                               45
RV                              45
AA                              45
Save

Press enter to save in your request
Select back arrow

Ledger                         M2

Enter
Select new entries button

Type                            Number range
SA                               46
KR                              46
DR                              46
WA                             46
WE                              46
WI                               46
WL                              46
RE                               46
RV                              46
AA                              46
Save

Define document number ranges for entry view:

Path :Up to document the path is same – Document number rages –Documents in entry view –Define document number ranges for entry view

Give the company code          :BIL
Select change intervals button
Select interval button
No.range                                 :40
Year                                        :2009
From no.                                  :1100001
To no.                                      :1200000
Enter
Select interval button
No.range                                 :41
Year                                        :2008
From no.                                  :1200001
To no.                                      :1300000
Enter and save
Ignore the warning message press enter

Define document no.range for general ledger view:

Path :Up to document the path is same –Document no.rages –Documents in general ledger view –Define document no.range for general ledger view

Give the company code                      :BIL
Select change intervals button
Select interval button
No.range                                 :45
Year                                        :2009
Form number                           :500001
To number                               :600000
Enter
Select interval button
No.range                                 :46
Year                                        ;2008
From number                           :600001
To number                               :700000
Enter & save
Ignore the warning message press enter

END USER AREA

Posting of transaction :

1          Path :Accounting –Financial accounting-General ledger –Posting –Enter general posting for ledger group  (Tr code is FB01L)


Give the document date                     :Today’s date
Type                                                    :SA
Ledger group                                      :blank
Company code                                    :BIL
Posting key                                         :40
Account number                                 :200100 Cash A/c
Enter
Give the amount                                 :100000
Business area                                       :BILH
Text                                                     :Equity share capital receipt
Posting key                                         :50
Account no.                                        :100000 Equity share capital
Enter
Amount                                               :*
Business area                                       :BILH
Text                                                     :+
Document –Simulate & Save
Document date                                   :Todays date
Type                                                    :SA
Ledger group                                      :0L
Company code                                    :BIL
Posting key                                         :40
Account no.                                        :200100 Cash A/c
Enter
Amount                                               :50000
Business area                                       :BILH
Text                                                     :Equity share capital receipt
Posting key                                         :50
Account no.                                        :100000 Equity share capital
Enter
Amount                                               :*
Business area                                       :BILH
Text                                                     :+
Document –Simulate & Save


0L Leading ledger      April 2008- March 2009 10th Period 105000              2008

M1 Non-leading ledger Jan 2009-Dec 2009 1st Period 105000                     2009

M2 Nonleading ledger July 2008 –June 2009 7th Period 100000                   2008


To view the ledger

Path :Accounting –Financial accounting –General ledger –Account –Display balances (new) (Tr cod is FAGLB03)

Account number         :100000
Company code            :BIL
Fiscal year                   :2008
Ledger                         :0L
Execute
Double click on balance 105000
To view the document
Select document no.check box
Select display document button
Select call up document overview button
Select back arrow 3 times
Select choose ledger button
Change the ledger to M1
Enter
Change the Fiscal year to 2009
Execute
Select back arrow
Select choose ledger button
Change the ledger to M2
Enter
Change the fiscal year 2008
Execute
Segments Creation

Scenario                                                         Future scenario
Company code            :BIL                            Company code            BIL
            |                                                                       |
Business area               :HYD                          Segment                      HYD
            |                                                                       |
Profit centers               :Cement, Steel             Profit center                Cement , Steel

In future there will not be any developments                         Segments will be assigned in the for Business areas                                                 profit center

In case of automatic line items generation business  
Area will not be picked up
Profit center –through derivation rules
Profit center is updated automatically segment also will be updated.



Segment creation

Path :SPRO-Enterprise structure –Definition –Financial accounting  -Define segment

Select new entries button

Segment                      Description
BGL                            Bangalore segment
HYD                           Hyderabad segment
Select save button or Ctrl+S
Press enter to save in your request

Assign segment in profit centers:

Path :Accounting –Controlling profit center accounting –Master data profit center –Individual processing change (Tr code is KE52)

Profit center                            :select Steel
Enter
Segment                                  :select HYD
Enter
Select activate button             (Shift +F1)

One more profit center
Profit center                            :Cement 
Enter
Segment                                  :select HYD
Select activate button
DOCUMENT SPLITTING

In document splitting, line items are split according to selected dimensions –so that we can draw financial statements for the selected dimensions at any time.

Eg: Profit Center wise, Segment wise

Sales
Party X Account         Dr       100000
                        To Sales Steel              80000 Steel profit center
                        To Sales cement          20000  Cement profit center

Due to document splitting
Party X Account         Dr        80000  Steel
Party X account          Dr        20000  Cement
            To Sales Steel              80000   Steel
            To Sales Cement         20000  Cement

Creation of 3GL masters :FS00

A) Sales –Steel                        Sales
B) Sales –Cement                   Sales
C)Zero balance clearing a/c current liabilities & provisions



FS00

GL Account no.          :300010
Company code            :BIL
Select with template button
Give the Gl A/c No.    :300005 Sales local own goods
Company code            :BIL
Enter
Change short text and GL account long text to sales Steel
Save
Select edit cot element button
Valid from 01.04.2008 to 31.03.9999
Enter
Cost element category            :11 Revenues
Save

Second a/c
Give the GL A/c No.              :300011
Company code                        :BIL
Select with template button
Give the GL A/c                     :300010
Company code                        :BIL
Enter
Change short text and GL a/c long text to sales Cement
Save

Select edit cost element button
Cost element category            :11 Revenues
Save

GL A/c No.                             :100530
Company code                        :BIL
Select with template button
Give the GL A/c No.100505 VAT payable
Company code                        :BIL
Enter
Change short text and GL account long text to Zero balance clearing
Select create /Bank /Interest tab
Change field status group to G067 (Reconciliation account)
Save

Classify G/L Accounts for document splitting:

Path :SPRO-Financial accounting (new)-General ledger accounts(new) –Business transactions –Document splitting-Classify G/L accounts for document splitting

Give your chart of accounts    :BIL
Enter
Select new entries button

Account from              Account to      Category                     Description
100000                        299999            01000                          Balance sheet account
300000                        399999            30000                          Revenue
400000                        499999            20000                          Expense
Save
Press enter to save in your request


Define Zero balance clearing account
Same path

Select account key      :000
Double click on accounts folder
Chart of Accounts      :BIL
Enter
Select new entries button
Give the G/L account             :100530 Zero balance clearing A/c
Save
Press enter to save in your request

Activate documents splitting
Same path
Select document splitting check box
Save
Press enter to save in your request


END USER AREA

Posting of sales (F-22)

Give the document date                     :Todays date
Type                                                    :DR
Company code                                    :BIL
Posting key                                         :01
Customer Account                              :100000
Enter
Amount                                               :80000
Business area                                       :BILH
Text                                                     :Sales invoice posting
Posting key                                         :50
Account                                              :300010 Sales Steel
Enter
Business area                                       :BILH
Text                                                     : +
Select profitability segment button (right arrow button profit center steel)
Ignore the warning message press enter
Give the profit center Steel
Select continue button

One more item

Posting key                                         :50
Account no.                                        :300011 Sales Cement
Enter
Amount                                               :*
Business area                                       :BILH
Text                                                     :+
Select profitability Segment right arrow button
Give the profit center                          :Cement
Select continue button
Document –Simulate
From the menu select Document –Simulate
General ledger button
Save
From the menu select Document –Display

Select general ledger View button

1 comment:

  1. This is an excellent post I seen thanks to share it. It is really what I wanted to see hope in future you will continue for sharing such a excellent post. asterisk dialer

    ReplyDelete