sap co Reconcilation Ledger


Reconciliation Ledger

sap co Reconcilation Ledger
à Reconciliation used when
à When number of company codes having one controlling area à2nd scenario
à It generates documents only in FI

à It can be run at controlling area

If salaries paid and posted FI at (F – 02)

             
                             Salaries A/C                     
                                                   
                              100000         
                                                    

            Out of 100000/- salaries 20000 belongs to company code ASL (Dept x) balance 80000/- belongs to company code AML


If we use the reconciliation account at cost centre level and the 20000/- is transferred to company code ASL (Dept x) it passes the entry in Financial automatically

Here
Reports at à No FI records

Co. area

In AML Books

ASL    Dr        20000
    To Salaries A/C       20000

In ASL Books

Salaries A/C    Dr   20000
       To AML A/C             20000



Customization at finance:

Copy company code AML customization including accounting to

Path: SPRO àenterprises structure à definition à financial accounting àedit, copy, delete, check company code

Double click on copy, delete, check company code (T. Code EC01)

From the menu select organization object àcopy organization object

From company code: AML

To company code: ASL

Enter

Select ‘yes’ for the message (For copy the G/L Accounts)

Select ‘No’ button to allocate a different local currency

Ignore the message press enter

Select create request button

Short description, customization for Aravind Steels limited

Press enter

Enter once again to saving the request

Go on press enter till you got the message company code AML copied to ASL with out 75 number range objects.

Ignore the message press enter

Select back arrow

Double click on edit company code data
Select position button
Give the company code: ASL
Enter
Select company code: ASL
Select details button
Change the company name to: Aravind Steels limited
Save & Save in your request
Assign company code to company
Path: SPRO àenterprises structure à Assignment à Financial Accounting àAssign Company code to company

For company code: ASL

Assign company AVG then select

Save button (or) (ctrl + s)

Save in your request

Document type ‘SA’ should allow inter company posting

Use the transaction code: ‘OBA7’

Select position button

Document type: SA

Enter

Select the document type: SA

Select details button

Select inter company posting check box

Save

Creation of 2 G/L Accounts

          AML Books
         ASL Books
a) FI/CO reconciliation A/C 400150 A/C (Expenses A/C with out cost element)

b) ASL A/C 0 200160

a) FI/CO reconciliation Accounts
 ( 400150)


b) AML à A/C No: 200161

Use the transaction code:FS00

Give the G/L account No: 400150

Company code: AML

Select with template button

Give the G/L account: 400100 (salaries account)

Company code: AML

Enter

Change short & long text: FI/CO reconciliation account

Select create/bank/interest tab

Field status group: select ICCF (Co à FI reconciliation posting)

Save

Give the G/L Account NO: 400150

Company code: ASL

Select with template button

Give the G/L account No: 400150

Company code: AML

Enter & save

G/L Account No: 200160

Company code: AML

Select with template button

Give the G/L account No: 200120 (Inventory raw material)

Company code: AML

Enter

Change short & long text to: Aravind steels limited

Select create/bank/interest tab

Field status group: G067

Save

G/L Account No: 200161

Company code: ASL

Select with template button

Give the G/L Account No: 200160

Company code: AML

Enter

Change the short text & long text to: Aravind mills limited

Save

Prepare cross company code transactions

SPRO à financial accounting à general ledger accounting àbusiness transaction à prepare cross company code transactions
FI Customization    (T. Code OBYA)

Give the company code 1: AML
               Company code 2: ASL

Enter

Posted in AML

Cleared against ASL

Debit posting key: 40

Account debit: 200160

Credit posting key: 50

Account credit: 200160
Company code:2

Posted in: ASL

Cleared against: AML

Debit posting key: 40

Account debit: 200161

Credit posting key: 50

Account credit: 200161

Save (or) (ctrl + s)

Save in your request

Co. Customization:

Assign company code ASL to controlling area AML:

Use the transaction code: OKKP

Select controlling area: AML

Select details button

Company code to controlling area à select cross company code cost accounting

Document type: SA

Save

Save in your request

Double click on assignment of company codes folder:

Select company code: AML

Select copy as button

Change the company code to: ASL

Enter & save

Define adjustment accounts for reconciliation posting:

Path: SPRO àcontrolling àcost element accounting à reconciliation ledger à define adjustment accounts for reconciliation postings

Double click define accounts for automatic postings

From the menu select extras à select controlling area

Give your controlling area: AML

Enter

Select change account determination button

Save

Give the account No: 400150 (FI/CO reconciliation account)

Save & save in your request

Specify document no. range for reconciliation posting:

Same path: (T. code: OK13)

Give the controlling area: AML

Select change intervals button

Select interval button

Give the No. range: 01

From No: 1 to 100000

Enter & save

Creation of cost centre (path: KS01)

Give the cost centre: Dept X

Valid from: 01.04.2006 to31.12.9999

Reference cost centre: dept A

Controlling area: AML

Enter

Change the name to dept X

Description, cost centre dept X

Person responsible: X

Company code: change to ASL

Save (or) (ctrl + s)

Ignore the message, press enter

Posting of salaries in company code AML (F -02)

Document date: 01.11.2006

Type: SA         Company code: AML

Posting key: 40           Account No: 400100 (Salaries)

Enter

Amount: 100000

Cost centre: Dept A

Text: salary payment

Posting key: 50

Account No: 200105 (SBI current account)

Enter

Amount: ‘*’

Business area: AMH

Text: ‘+’

Document à Simulate & save


Go and see the G/L account: (FS10N)

Give the G/L account No: 400100 (Salaries)

Company code: AML

Fiscal year: 2006

Execute

Select back arrow

Give the company code: ASL

Execute

Go and see the cost centre report (KSB1)

Cost centre: Dept A to Dept C

Execute

Select back arrow

Give the cost centre: Dept x

Execute

Reposts costs: (KB11N)

Give the cost centre old: (Dept A)

Cost element: 400100 (Salaries)

Amount: 20000

Cost center new (Dept x)

Save

Go and see the G/L Account: (FS10N)

Give the G/L account No: 400100 (salaries)

Company code: AML

Fiscal year: 2006

Execute

Select back arrow

Give the company code: ASL

Execute

Go and see the cost centre report (KSB 1)

Cost centre: Dept A to Dept C

Execute

Select back arrow

Give the cost centre: Dept x

Execute
           
Reconciliation ledger run:

Path:accounting àControlling àCost element accounting à Actual postings à Reconciliation with FI (T. code: KALC)

Select controlling area radio button

Give the controlling area: AML

Period: 8

Fiscal year: 2006

Deselect test run check box

Execute

Select reference document No: 1

Select back arrow

Select reference document No: 2

No comments:

Post a Comment