basic setting gl

8/2/2019 Basic Setting GL

1/21

1

BASIC SETTING

1. Company Creation

Step 1.1: Creation of Company T Code OX15

Path: SPRO Enterprise Structure Definition Financial Accounting DefineCompany

Click on New Entries

Company =Company Name =City =Country =Language Key =

Currency =

Click on SaveClick on Create Request Short Description =Click on Save and Click Enter .

Step 2: Define Company Code T Code OX02

Path: Same as above, Click on Edit, Copy, Delete, Check Company CodeDouble Click on Edit Company Code data

Click on New Entries

Company Code =Company Name =City =Country =Currency =Language =Click on SaveTitle =Country =

Click on Save and Click Enter Step 2.1: Assign company code to company T Code OX16

Path: SPRO Enterprise Structure Assignment Financial Accounting Assigncompany code to companyClick on Position, Company code = Click Enter

@ Piyush Kumar


2/21

2

Company = Click SaveStep 3: Define Business Area T Code OX03

- 2 - 1

Path: SPRO Enterprise Structure Definition Financial Accounting DefineBusiness Area

Business Area =Description =Click Save .

4. Fiscal Year Variant

Step 4.1: Define Fiscal year variant T Code OB29

Path: SPRO Financial Accounting Financial Accounting Global Settings Fiscal Year Maintain Fiscal Year Variant

Step 4.2: Assign Company Code to Fiscal year variant T Code OB37

Path: Same as above

Click on Position. Company code = Click EnterFiscal year variant = Click Save

5. Posting period variant

Step 5.1: Definition of Posting Period Variant T Code OBBO

Path: SPRO Financial Accounting Financial Accounting Global Settings DocumentPosting periods Define variants for open posting periods

Click on New entriesVariant =

Name = Posting period variant for Click on Save

Step 5.2: Assign Posting Period Variant To Company Code T Code OBBP

Path: Same as above

Click on Position buttonCompany Code = Click EnterVariant = Click Save

1

@ Piyush Kumar


3/21

3

Step 5.3: Open and close posting periods T Code OB52

Path: Same as above

Click on New entriesVariant =Account Type =From period = 1 Year =To period = 12 Year =

6. Field Status Variant

Step 6.1: Definition of field status variant T Code OBC4

Path: SPRO Financial Accounting Financial Accounting Global Settings Document

Line Item Controls Maintain Field Status Variant

Select 0001 Field Status Variant lineClick on Copy as buttonFSTV =Field status name = Field Status Variant for Click EnterClick on Copy all , Click Enter on message.Select Field Status Variant lineDouble click Field Status Groups

Double Click G001

Double Click General DataSelect Required Entry against Text Field Click Save

Double Click G001Double Click Additional Account AssignmentsSelect Required Entry against Business Area field Click Save

Double Click G005Double Click General DataSelect Required Entry against Text Field Click Save

Double Click G005Double Click Additional Account AssignmentsSelect Required Entry against Business Area field Click Save

Double Click G005Double Click Payment transactionsSelect Required Entry against Value date field Click Save

@ Piyush Kumar


4/21

4

Step 6.2: Assign Company Code to Field Status variant T Code OBC5

Path: Same as aboveClick on PositionCompany Code = Click EnterField Status Variant = Click Save

7. Chart of Account

Step 7.1: Define Chart of Accounts T Code OB13

Path: SPRO Financial Accounting General Ledger Accounting G/L AccountsMaster records Preparations Edit Chart of Accounts List

Click on New EntriesChart of Accounts =Maintenance language =Length of GL A/c No. =Controlling integration = Click Save

Step 7.2: Assign Company code Chart of Accounts T Code OB62

Path: Same as above

Click on Position. Company Code = Click EnterChart of Accounts = Click Save

Step 8: Define Account Groups T Code OBD4

Path: Same as aboveClick on New entries

Char of Accounts

Account Group Name From A/c To A/c

SCPL Share Capital 100000 100099RSPL Reserves & Surplus 100100 100199ACDN Accumulated Depreciation 100200 100299SCLN Secured Loans 100300 100399UNSL Unsecured Loans 100400 100499CLPR Current Liabilities & Provn 100500 100599FAST Fixed Assets 200000 200199

@ Piyush Kumar


5/21

5

CAST Curr. Assets, Loans & Adv 200100 200199SALE Sales 300000 300099OTHR Other Income 300100 300199INCR Incr/Decr. Of Stock 300200 300299RMCN Raw material consumption 400000 400099

PRSN Personnel Cost 400100 400199MFRG Manufacturing Cost 400200 400299ADMN Administration Cost 400300 400399INTR Interest 400400 400499DEPR Depreciation 400500 400599

Click Save.

Step 9: Define Retained Earnings Account T Code OB53

Path: Same as above

Chart of Account = Click Enter

P&L Statement a/c type = xAccount = 100100 Click Save

Warning message appears , Click Enter again

Step 10: Tolerance Groups

Step 10.1: Definition of Tolerance Groups for G/L Accounts T Code OBA0

Path: SPRO Financial Accounting General Ledger Accounting Business transactionsOpen item clearing Clearing Differences Define tolerance groups for G/L Accounts

Click on New entriesCompany Code =Tolerance Group = Blank

Name = Tolerance group for Click on Save

Step 10.2: Definition of Tolerance Groups for Employees T Code OBA4

Path: Same as above

Click on New entriesGroup = Blank Company Code =

@ Piyush Kumar


6/21

6

Amount per document = 99999999999Amount per open item = 999999999Cash discount per line item = 10% Click Save

Step 11: Document Types and Number Ranges T Code OBA7

Step: Creation of number range for document type SA T Code FBN1


Document Header Define document types

Click on Position buttonDocument type = SA Click EnterSelect SA document type lineClick on Details button

Notice the Number rangeClick on Number range informationCompany Code =Click on (Change) Intervals buttonClick on (Insert) Interval button

No = 01Year =From Number = 1To Number = 10000Click on Insert (Enter) buttonClick on Save and on OK button on the warning message

Step 12: Global parameters

Step: Enter global parameters T Code OBY6

Path: SPRO Financial Accounting Financial Accounting Global Settings CompanyCode Enter Global parameters

Click on Position buttonCompany Code = Click EnterSelect line itemClick on Details button

@ Piyush Kumar


7/21

7

Select Business area financial statementsSelect Propose fiscal year Select Define default value dateSelect Negative postings allowed Click Save

GENERAL LEDGER ACCOUNTING

Creation of GL Master

1. Creation of Surplus in P&L Account T Code FS00

Check up Account Groups under which we have to create GL Master OBD4

Path: Accounting Financial Accounting General Ledger Master RecordsIndividual Processing Centrally

GL Account Number =Company Code =

Go to Menu G/L Account Create

Account Group = P&L Statement Account Balance Sheet Account

Short Text =Long Text =

Go to Control Data Tab

Account Currency = Only balances in local currency

Open item management Line item display

Sort Key = 001

Go to Create/Bank/Interest Tab

@ Piyush Kumar


8/21

8

Field Status Group =

Additional Selections

Save.

2. Creation of Equity Share Capital Account: T Code FS00



GL Account Number =Company Code =

Go to Menu G/L Account Create

Account Group P&L Statement Account

Balance Sheet Account

Short Text =Long Text =

Go to Control Data tab.

Account Currency Only balances in local currency Open item management Line Item display

Sort Key

Go to Create/Bank/Interest Tab

Field Status Group:Additional Selections

Save.

3. Creation of Cash Account: T Code FS00

@ Piyush Kumar


9/21

9



GL Account NumberCompany Code

Go to Menu GL Account Create

Account Group P&L Statement Account Balance Sheet Account

Short Text=

Long Text =

Go to Control Data tab.

Account Currency = Only balances in local currency Open item management Line item displaySort Key =

Go to Create/Bank/Interest tab.

Field Status Group =

Additional Selections:

Relevant to cash flow

Save.

4. Posting of G/L Transactions: T Code: F-02

Path: Accounting Financial Accounting General Ledger Document entry GeneralPosting

Document Date = (Short Cut Key: F4 and F2 for current date )Doc. Type =Company Code =

@ Piyush Kumar


10/21

10

Posting Date =Period =Currency =

Posting Key = ( 40 = Debit G/L Account )

Account = Click Enter

Amount =Business Area =Text =

Posting Key = ( 50 = Credit G/L Account )Account = Click EnterAmount =Business Area =Text =

Go Menu Document Simulate or Shift+f2Make corrections if necessary and Save.

5. Display of document: T Code: FB03

Path: Accounting Financial Accounting General Ledger Document Display

Go to Menu Document Display

Document Number =

Company code =Fiscal Year = Click Enter

6. Display of GL Account Balance: T Code: FS10N

Path: Accounting Financial Accounting General Ledger Account Display balances

GL Account =Company Code =Fiscal Year= Click Execute

Double Click on Period line item to display documents posted in that Period/Month. Double Click Document line item to display the document.

7. GL Account Line item display: T Code FBL3N

@ Piyush Kumar


11/21

11

Path: Accounting Financial Accounting General Ledger Account Display Changeline items

GL Account =Company Code =

Open items Cleared items All items

Click Execute (F8) and Double Click on line item to display the document.

Hold Document :

Step 1: Holding a G/L Document: T Code F-02

Path: Accounting Financial Accounting General Ledger Document Entry GeneralPosting

Document Date = (Short cut key: F4 and F2 for current date)Doc. Type =Company Code =Posting Date =Period =Currency =

Posting Key =Account = Click Enter


Go to Menu Document Hold

Provide Temporary Identification to save the Hold Document.

Step 2: Posting of Held Document: T Code F-02

@ Piyush Kumar


12/21

12

Menu Document Get Held DocumentTemporary Document Number = Click Enter

Posting Key =

Account = Click EnterAmount =Business Area =Text =Go to Menu Document Post (Ctrl + S )

Step 3: Display of GL Account Balance: T Code: FS10N

Path: Accounting Financial Accounting General Ledger Account Display balances

GL Account =Company Code =Fiscal Year= Click Execute (F8)

Parking of Document :

Step 1: Create Park Document: T Code: F-65

Path: Accounting Financial Accounting General Ledger Document Entry GeneralDocument Parking

Document Date =Doc. Type =Company Code =Posting Date =Period =Currency =




@ Piyush Kumar


13/21

13


Click on Overview Icon (Shift+f2)

Make corrections if necessary and Save .

Step 2: Verify whether balances are updated or not in GL Account: T Code: FS10N

Step 3: Display/Change a Park Document:

To display a park document, go to FBV3To change a park document, go to FBV2

Step 4: To Post Parked Document: T Code: FBV0

Path: Accounting Financial Accounting General Ledger Document ParkedDocuments Post/Delete.

Company Code =Document Number =Fiscal Year = Click Enter

Double click Debit/Credit line items to make any modifications.

Go to Menu Document Post.

Business Area = Click Enter

Step 5: Verify whether balances are updated or not: T Code: FS10N

Sample Documents :

Step 1: Creation of Number range interval for Document Type X : T Code FBN1


Document Number Ranges Define Document Number Ranges

Company Code =

Click on the Change Intervals buttonClick on the Insert Intervals button

@ Piyush Kumar


14/21

14

No Year From number To number Current number Ext

X2 2009 xxxxxx xxxxxxClick on the Insert button, Save .

Step 2: Posting of Sample Document: T Code: F-01

Path: Accounting Financial Accounting General Ledger Document entryReference documents Sample document






Go Menu Document Simulate .Put corrections if necessary and Save.

Step 3: Display Sample Document: T Code: FBM3

Path: Accounting Financial Accounting General Ledger Document ReferenceDocuments Sample Document Display

Company Code =Document Number =Fiscal Year = Click ExecuteDouble Click on the Document to open.

@ Piyush Kumar


15/21

15

Step 4: Posting of Sample Document: T Code: F-02

Go to Menu Post with reference

Document Number =

Company Code =Fiscal Year = Select Display Line item Click Enter

Double Click on the document to open, make modifications necessary and Click on Save.

Recurring Document :

Step 1: Creation for No. Range for Recurring Document: T Code: FBN1

Company code=

Click on the Change Intervals buttonClick on the Insert Intervals button

No Year From number To number Current number ExtX1 2009 xxxxxx xxxxxx

Click on the Insert button.

Step 2: Creation of Recurring Cycle: T Code: FBD1

Company code =

First run on =Last run on =Interval in months =Run date =

Document type =Posting key =Account =Amount =

Business Area =Text =

Next line item

Posting key =Account =

@ Piyush Kumar


16/21

16


Click on Display Document Overview button to see the document before posting.

Step 3: To Display the Recurring Document: T Code: F.15

Company code =Document no =Fiscal year =

Click on Execute (F8)

Step 4: To Execute Recurring Entries Cycle: T Code: F.14

Company code =Document no =Fiscal year =

Settlement period =

Batch Input Session Name: Give Your Identification.Click on Execute (F8)

Step 5: To Post the Batch Input Session:

Go to Menu System Services Batch Input SessionSelect Your Batch Input Session line item & click on Process button.

Select Display Errors Only Radio ButtonClick Process Button.Click Exit batch input session Button

Step 6: To Display the Document Posted using Recurring Cycle: T Code: FB03

Document no. =Company code =

Fiscal Year = Click Enter

Interest Calculation :

Step 1: Define Interest Calculation Type: T Code: OB46

@ Piyush Kumar


17/21

17

Path: SPRO Financial Accounting GL Accounting Business Transactions Bank Account interest calculation Interest calculation global settings Define interest calculationtypes

Click New Entries

Insert ID = Name/Description =Calculation type =

Step 2: Prepare Account Balance Interest Calculation: T Code: OBAA

Path: Same as above

Click New Entries

Interest Calculation Indicator =

Interest Calculation Frequency =

Calendar type =

Select Balance plus interest

Step 3: Define Reference Interest Rate: T Code: OBAC

Path: SPRO Financial Accounting GL Accounting Business Transactions Bank Account interest calculation Interest calculation Define reference interest rates

Click New EntriesReference interest rate =Long Text =Short Text =Date from =Currency =

Step 4: Define Time Dependent Terms: T Code: OB81

Path: Same as above

A. Click New EntriesInterest Calculation Indicator =Currency =Effective from =Sequential Number =Term = Credit interest balance interest calculation

@ Piyush Kumar


18/21

18

Reference interest rate = Click Save

B. Click New EntriesInterest Calculation Indicator =Currency =

Effective from =Sequential Number =Term = Debit interest balance interest calculation

Reference interest rate = Click Save

Step 5: Enter Interest Values: T Code: OB83

Path: Same as above

Select New Entries

Reference interest rate =Effective from =Interest rate = Click Save

Step 6: Creation of GL Accounts: T Code: FS00

Interest Account - 400400 under Interest Group

SBI Term Loan - 100300 under Secured LoansField Status Group = G005Interest Indicator =

Step 7: Assignment of Accounts for Automatic Postings: T Code: OBV2

Path: SPRO Financial Accounting GL Accounting Business Transactions Bank Account interest calculation Interest posting Prepare GL A/c balance interest calculation

Click Symbols buttonKeep the cursor on 0002 line items. Click Accounts buttonChart of Accounts = Click EnterAccount symbol = 0002 (Interest)Currency = INR

GL Account = 400400Account symbol = 2000 (Loan)Currency = INR GL Account = 100300 Click Save

Step 8: Term loan Receipt: T Code: F-02

@ Piyush Kumar


19/21

19

Document Date =Doc. Type =Company code =Posting date =Period =

Currency =





Goto Menu Document SimulateMake corrections if necessary and Save.

Step 9: Automate Calculation of Interest: T Code: F.52

Chart of Accounts =

G/L Accounts =Company code =Further Selection:Calculation period =

Output Control:Check the Additional balance line

Posting Control:Check the Post interest settlementsCheck the Update master record

Change the Session Name = Execute

Step 10: To Execute Batch Input Sessions:

Go to Menu System Services Batch input Session

@ Piyush Kumar


20/21

20

Select Your Session Name line item from the list.Click on the Process button

Select the Display errors only radio button Click the Process button

Click the Exit batch input button .

Step 11: To verify the Interest Postings : T Code: FS10N

G/L Account no. =Company code =Fiscal year =Business Area =

Execute

Step 12: To see the Interest Posting Document: T Code: FB03

Step 13: To verify the Updation in Term Loan Account: T Code: FS00

G/L Account no. =Company Code =

Goto Menu G/L account DisplayGoto Create/bank/interest tabObserve the date of last interest run.

Step 14: Term Loan Installment Payment: T Code: F-02




@ Piyush Kumar


21/21

21


Amount =

Business Area =Text =

Goto Menu Document SimulateMake corrections if necessary and Save

Step 15: Repeat the Step No 9 to Step No13 to verify the changes.