Scrol

SAP Trainings contact sap.sreeram@gmail.com or 091-9916083157, 001-210-399-8414

GENERAL LEDGER MASTERS CREATIONS


GENERAL LEDGER MASTERS CREATIONS


1
2
3

Chart of Accounts level
Company code level
Centrally
1
GL Account Number
Account currency

Chart of accounts fields


2
Company code
Only balances in local currency
3
Account group
Tolerance group
+
4.
Whether it s P & L Account
Line item display
Company code fields
5
Whether it is a Balance Sheet A/c
Open item Management

6.
Description
a)    Short text – Max 20
b)    Long text –Max20

Sort key



Field status group




Accounts to be created:
  1. Surplus in P & L Account – Reserves & Surplus
  2. Equity share capital – Share capital
  3. Cash account –current assets, loans & advances

To check accounts groups for giving account numbers.

Path: SPRO – Financial Accounting – General ledger accounting – GL Accounts –Master Data- Preparations- Define Account group (Tr.Code:OBD4)

Select position button
Give your chart of accounts AML
Enter
Reserves & Surplus                                    100100-100199
Share capital                                    100000-100099
Cash account-current assets        200100-200199

  1. To check account-Group for giving account numbers.
  2. Creation of General

CREATION OF GENRAL

Path : Accounting-Financial accounting –General Ledger-Master records –GL Accounts-Individual Processing –Centrally (Tr. Code is FS00)

Give the GL account 100100
Company code AML
From the menu select  -> GL Account create

Account group: select reserves & surplus

Select balance sheet account radio button
Short text: surplus in P & L Account
GL Account Large text: Surplus in profit & Loss Account
Select control data tab
Select only balances in local currency in check box
We have
Tolerance group: Blank
Select line item display check box
Short key select 001 posting data
Select create / bank / interest
Field status group G001 General (with text, allocation)
Save
GL Account                           :100000
Company code                     : AML
Select with template button
GL Account                           :100100 (Surplus in P & L Account)
Company code                     : AML
Enter
By mistake save button
Your can not save
Change account group to Share capital
Select balance sheet a/c radio button
Change short text to equity Share capital
Change GL account long text to Equity share capital
Other filed common select save button
GL Account 200100
Company code                     :AML
Select with template button
Give the GL Account 100100 surplus in P & L account
Company code                     : AML
Enter
Change account group to current assets, loans & advances
Change short text to Cash account
Select balance sheet a/c radio button
Change GL account long text to Cash account
Select create / bank / interest tab
Change filed status group to G005 bank accounts (Obligatory value date)
Select relevant cash flow check box,
Select save button or Ctrl+S
To view the accounts created
Select drop down button beside GL account

Match Code:
Give the company code                  : AML
Enter
Short text                                           : At the time of entry
GL account long text                       : At the time of General ledger display




Posting of transactions

Path: Accounting – Financial Accounting –General ledger –posting –General posting (Tr.Code is F-02)

Posting transaction             :10/07/2008
Document date                    : In case of purchases document date will be party bill date- we can enter manually 30.09.2008 or select F4- It gives calendar and select F-2 – It selects today’s date .
Posting date                          : Ledger updation   will be based on posting date period will  appeal automatically based on
Posting date                          : 30.09.2008
Reference                             :Party bill No.
Doc No                                   :1
Normal cases
Document date (F4)                        :30.09.2008
Posting date: will come automatically this is server date.
Type                                       :SA
Company code                     :AML
Currency                               : INR
System does not know debits and credits to differentiate between debit and credit SAP
Has given posting keys
Posting key               40        GL account Debit
Positing key              50        GL Account Credit
Posting key: Select 40
Account select the drop down button
GL long text                           :*Cash*
Company code                     : AML
GL Account                           : Z*
Enter

Select account No.200100
Enter

200100 Cash account – Filed status GRP-G005

Text                 Business Area          Value date                 Required
In enter global parameters select define default value date check box
Amount                                  :400000
Business area                      :AMLH
Text                                         : Equity share capital receipt
Posting key                           : Select 50
Account select drop down button
Give the company code AML and press enter
Select account                     :100000 Equity share capital
Press enter
Amount enter                       :*(star)

Note:   * (star)  Means debits and credits equal

Cash A/c                    Dr                    500000
            To Equity                               300000
            To Preference                       *
Business area                      :AMLH
Text Enter                              : +
‘ +  ‘(plus) mean copies the last line item narration in the same document.

Salaries                     A/c      Dr        100000
(Salaries provision for Sep.)

Wages                        A/c      Dr
(Wages provision for Sep.)
            To outstanding Exp
We can not use *
Press enter

From the menu select document simulate (Shift +F9)
In one document we can have 999 line items.

Debit will be posted without any assign and credit amount will be posted with minus sign.

Select save button or Ctr+S

We get a message document 1 was posted in company code:AML

How to view the last posted document 1.

From the menu select document display.

Select display document header button or (F5)

Display document

Path: Accounting – Financial accounting – General ledger-Document –Display (Tr.Code:FB03)

Select document list button
Give the company code                              :AML
Document type                                             :SA
Select executive button (F8)
To view last one week posted document 24/09/2008 to 1/10/2008

Select execute button
To view self (documents posted by us)
Select own documents only check box
To view documents posted by a specific user

From the menu select –> Edit –> Dynamic –> Selections (Shift +F4)
User name :SAPUSER
Select execute (F8) button
Double click on document no.1

Change document :

Path: Accounting – Financial Accounting –General ledger-Document –Change (Tr.code is FB02)

Document No.                                  :1
Company code                                 :AML
Fiscal year                                         :2008
Enter
Double click on first line item cash account
We can change only value date filed assignment filed and text filed.

Account display:

Path: Accounting – Financial Accounting –General ledger – Account – Display balances ( Tr.code is FS10N)

 To view more than one account transactions select multiple selection button beside GL Account no.

We want to view random account numbers transactions.

Press select single value tab.

Give the account no.100100
                                      200100

Select copy button

To view continuous account numbers transactions

Press select intervals tab  
Low limit        :100000
Upper limit     :100099

Select copy button

Account no.100050
To exclude an account from the range
Select exclude single value tab
Singe value :            100050

Select copy button

To exclude a range of accounts    :select exclude intervals tab
Low limit                                            :100050
Upper limit                                         :100059
Select copy button
To view only one account
Select drop down button beside GL Account
Give the company code                  :AML
Enter
Select account no.100000 Equity share capital
Company code                                 :AML
Fiscal year                                         :2008
Business area                                  :AMLH
Select execute (F8) button
Double lick on cumulate balance amount
Double click on document No.1
Select call up document overview button (F9)
Select back arrow (F3)

Document Number                         Posting date              Text                 Amount
1                                                                                                                                             100000
2                                                                                                                                             200000
3                                                                                                                                             300000
-----------
Total Amount                 600000
======
We can create our own line layout