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
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