66165223 SAP SD IMG Configuration Notes 1

(1)

TABLE OF CONTENTS

1. INTRODUCTION --- 2

2. FINANCE --- 5

3. ASSET ACCOUNTING --- 46

4. CONTROLLING --- 62

5. SALES & DISTRIBUTION --- 76

6. MATERIALS MANAGEMENT --- 87

7. INDIA LOCALIZATION SETTINGS (CIN) --- 99

8. PRODUCTION PLANNING --- 107

9. QUALITY MANAGEMENT --- 113

10. ENHANCEMENTS --- 115

(2)

INTRODUCTION

Sunshine Cosmetics Limited (SCL), Crystal Cosmetics Limited (CCSL), Lumena Home Products Limited (LHPL) and Sterling Home Products Limited (SHPL) had initiated the implementation of SAP R/3 by Integgra Solutions (ISL). The project implementation was completed and live as per schedule. The following is the SAP R/3 Organization:

ELEMENT SCL CCL LHPL SHPL

Company Code IN41 IN42 IN43 IN44

Chart of Accounts IN41 IN42 IN43 IN44

Chart of Depreciation 1IN 1IN 1IN 1IN

Plant IN41 IN42 IN43 IN44

Sales Organization IN41 IN42 IN43 IN44

Distribution Channel 41 42 43 44

Division 41 42 43 44

Purchase Organization IN41 IN42 IN43 IN44

Storage Locations SL01 – SL10 SL01 – SL10 SL01 – SL10 SL01 – SL10 Fiscal Year V3 V3 V3 V3 Valuation Class Raw Material Packing Materials Finished Goods 0100 / 0101 0400 0900 0100 / 0101 0400 0900 0100 / 0101 0400 0900 0100 / 0101 0400 0900

(3)

Work in Process Engineering Spares 0800 0300 0800 0300 0800 0300 0800 0300

ISL completed the configuration and customization of the SAP R/3. This documents specifies the settings made by ISL team and the modifications carried out to the standard system as per the requirements upto 15th December 2000.

(4)

FINANCE

Configuration Transaction code / Menu Path What was Created /changed Define Countries OY01

IMG Menu Path:

General Settings → Set Countries→ Define Countries

Maintained Country IN (India) with System delivered settings.

Tax Procedure Maintained as 2TAINJ.

Enter exchange rates OB08

IMG Menu Path:

General Settings → Currencies → Enter exchange rates

Required Currency exchange rates are defined for currency INR

Maintain Calendar SCAL

IMG Menu Path:

General Settings → Maintain Calendar

Applicable public holidays are created. The following Holiday calendar and Factory calendar are maintained.

41 - Sunshine Factory Calendar

42 – Crystal factory Calendar 43 – Lumina Factory Calendar 44 – Sterling Factory Calendar

Copy Company code EC01

IMG Menu Path:

Enterprise Structure → Definition → Financial Accounting → Define, Copy, delete, check Company code

The following Company codes are copied from Company code IN01.

IN41 – SUNSHINE COSMETICS LIMTED IN42 – CRYSTAL COSMETICS LIMITED IN43 – LUMENA HOME PRODUCTS LIMITED

IN44 – STERLING HOME PRODUCTS LIMITED

(5)

Edit Company code SPRO

IMG Menu Path:

Enterprise Structure → Definition → Financial Accounting → Define, Copy, delete, check Company code

Company Name, City and Currency are maintained in this transaction for each Company code.

Maintain Controlling area OX06

IMG Menu Path:

Enterprise Structure → Definition → Controlling → Maintain

Controlling area→Maintain Controlling area

Maintained currency as Company code currency and Fiscal year variant V3 for each controlling area.

Assign Company code to controlling area

OX19

IMG Menu Path:

Enterprise Structure → Assignment → Controlling → Assign Company code to Controlling area

The Controlling areas are assigned to each Company code.

Enter Global Parameters OBY6

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Enter Global Parameters

Details under the ‘Additional details’ screen are maintained for each Company code.

Activate Extended Withholding Tax

SPRO

IMG Menu Path:

The check box for Extended Withholding tax is marked for each Company code.

(6)

Financial Accounting → Financial Accounting Global settings → Activate Extended Withholding Tax

(7)

Assign Company code to a Fiscal year variant

OB37

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Fiscal year → Assign Company code to a Fiscal year variant

All the Company codes are assigned to Fiscal year variant V3.

Define variants for Open Posting Periods

OBBO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Posting periods → Define variants for Open Posting periods

Posting period variants are created by each Company code’s name.

Open and Close Posting Periods

OB52

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Posting periods → Open and Close Posting periods

Time intervals for Open periods are specified for each Posting period variant.

Assign variants to Company code

OBBP

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Posting periods → Assign Variants to Company code

The respective Posting period variants are assigned to each Company code.

(8)

Document Number ranges Overview

FBN1

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Document Number Ranges → Overview

The document number ranges are maintained for each Company code for each Fiscal year.

Document Header Overview

OBA7

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Document Header → Overview

Document types are maintained and number ranges are assigned to each document type.

Annexure – ‘ A ‘

Validation in Accounting Documents

OB28

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Document Header → Validation in Accounting

Documents

Validation (DOC_TYP) is defined for Bank Accounts restricting users to use only the document types defined for them.

Maintain field status variants

SPRO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Line item → Controls → Maintain Field status Variants

Field status Variants are defined with field status groups with Company code names. Annexure – ‘ B ‘

(9)

Assign Company code to Field status variants

OBC5

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Line item → Controls → Assign Company code to Field status variants

The respective field status variant is assigned to each Company code.

Screen variants for Document entry

OB71

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Line item → Controls → Screen Variants for Document entry

Screen Variant ‘2’ is assigned to each Company code

Enable Fiscal Year default OB63

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Default values for document processing → Enable fiscal year default

The check box for ‘Propose fiscal year’ has been enabled for each Company code.

Default value date OB68

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Document → Default values for document processing → Default

The check box for ‘Propose Value date’ has been enabled for each Company code.

(10)

value date Check Calculation

Procedure

OBQ3

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Tax on Sales/Purchases → Basic settings → Check Calculation Procedure → Define Procedures

Tax Procedure ‘2TAINJ’ has been maintained.

Annexure – ‘C ‘

Assign Country to Calculation Procedure

SPRO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Tax on Sales/Purchases → Basic settings → Assign Country to Calculation Procedure

Tax Procedure ‘2TAINJ’ has been assigned to Country ‘IN’.

Check and Change settings for Tax processing

OBCN

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Tax on Sales/Purchases → Basic settings → Check and Change settings for Tax Processing

Internal Processing keys required for the Tax procedure have been defined. Annexure – ‘D‘

Specify Structure for Tax jurisdiction code

OBCO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Tax

The structure has been defined for Tax Procedure.

Procedure: 2TAINJ

(11)

on Sales/Purchases → Basic settings → Specify Structure for Tax jurisdiction code

for India

Length: 2 Length: 2 Tax line by line: Yes Define Tax Jurisdictions OBCP

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Tax on Sales/Purchases → Basic settings → Define Tax jurisdictions

Defined the Tax jurisdictions for the Tax Procedure.

Jurisdiction code Name IN00 Federal tax Jurisdiction

IN01 Andhra Pradesh IN09 Others

Define Tax codes for Sales / Purchases

FTXP

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Tax on Sales/Purchases → Calculation → Define Tax codes for Sales / Purchases

Tax codes for Sales and Purchases have been maintained for the Country IN.

Define Tax Accounts OB40

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Tax on Sales/Purchases → Posting → Define Tax Accounts

Accounts have been assigned for each Company code for different procedures for Automatic posting. Trans Description G/L Account 200 *MODVAT ED ON PURCHA 104405023 510 * BASIC ED ON SALES 200003000 520 *CST ON SALES 113712009 530 * LST ON SALES

(12)

113700000

Assign Tax codes for Non-Taxable transactions

OBCL

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Tax on Sales/Purchases → Posting → Assign Tax codes for Non-Taxable Transactions

Input and Output tax codes V0 and E1 are assigned respectively to each Company code.

Define Official Withholding Tax Codes

SPRO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Withholding tax → Extended

Withholding Tax→ Basic Settings→ Define Official Withholding tax codes

Applicable TDS section codes have defined for the Country IN.

Off. W/tax Key Description

194A TDS-Int. other then int. on Securities

194C TDS on Contractors 194I TDS on Rent

194J TDS on Fees for Prof. Services

Check Recipient types SPRO

IMG Menu Path:

Withholding Tax→ Basic Settings→ Check Recipient types

Recipient types CO (Corporate), HU (HUF), OT (Others) have been defined for each Withholding tax type.

(13)

Check Income Types SPRO

IMG Menu Path:

Withholding Tax→ Basic Settings→ Check Income types

Income types have been defined for the Country ‘IN’.

Income Type Text CO Contracts IN Interest PR Professional services

RE Rentals Define Withholding tax

type for Invoice posting

SPRO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Withholding tax → Extended Withholding Tax→ Calculation → Withholding tax type → Define Withholding tax type for Invoice posting

Withholding tax type ‘I1’ has been defined for Country ‘IN’ for Invoice posting.

Define Withholding tax type for Payment posting

SPRO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Withholding tax → Extended Withholding Tax→ Calculation → Withholding tax type → Define Withholding tax type for Payment posting

Withholding tax type ‘P1’ has been defined for Country ‘IN’ as the Withholding tax type for Posting

Define Rounding rule for Withholding tax type

SPRO

IMG Menu Path:

Rounding rule has been assigned as ‘100’ per Withholding tax type for each

(14)

Financial Accounting → Financial Accounting Global settings → Withholding tax → Extended Withholding Tax→ Calculation → Withholding tax type → Define Rounding rule for Withholding tax type

Define Withholding tax codes

SPRO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Withholding tax → Extended Withholding Tax→ Calculation → Withholding Tax codes→ Define Withholding Tax codes

Tax codes have been created for each Withholding tax type

Annexure – ‘ E ‘

Assign Withholding tax types to Company code

SPRO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Withholding tax → Extended Withholding Tax→ Company code → Assign Withholding tax types to Company code

Withholding tax types ‘I1’ and ‘P1’ are assigned to each Company code.

Activate Extended Withholding Tax

SPRO

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Withholding tax → Extended

The check box for Extended Withholding tax has been enabled for each Company code.

(15)

Withholding Tax→ Company code → Activate Extended Withholding tax

Define Accounts for Withholding tax to be paid over

OBWW

IMG Menu Path:

Financial Accounting → Financial Accounting Global settings → Withholding tax → Extended Withholding Tax→ Postings →Accounts for Withholding tax → Define Accounts for Withholding tax to be paid over

General Ledger Accounts have been assigned for each Withholding tax code per Withholding tax type for each Company code.

Annexure – ‘ F ‘

Edit Chart of Accounts List OB13

IMG Menu Path:

Financial Accounting → General Ledger Accounting→G/L

Accounts→ Master Records → Preparations→ Edit Chat of Accounts List

Charts of Accounts have been defined with the name of the Company code for each Company code.

(16)

Assign Company code to chart of Accounts List

OB62

IMG Menu Path:

Accounts→ Master Records → Preparations→ Assign Company code to Chart of Accounts list

Respective Chart of Accounts is assigned to each Company code.

Define Account Group OBD4

IMG Menu Path:

Accounts→ Master Records → Preparations→ Define Account group

Account groups are defined for each Chart of Account.

Annexure – ‘G‘

Define Retained Earnings Account

OB53

IMG Menu Path:

Accounts→ Master Records → Preparations→ Define Retained Earnings Account

Retained earnings account (117200000) is defined for each Chart of Account.

Define Accounts for

Exchange rate Differences

OB09

IMG Menu Path:

Financial Accounting → General Ledger Accounting→ Business transactions → Open item clearing

The control Accounts of Customers and Vendors are assigned under G/l Account column.

(17)

→ Define Accounts for Exchange rate differences

Define Adjustment accounts for GR/IR clearing

OBYP

IMG Menu Path:

Financial Accounting → General Ledger Accounting→ Business transactions → Closing →

Regrouping → Define Adjustment accounts for GR/IR clearing

Adjustment Accounts for GR/IR clearing are assigned here.

Annexure – ‘ H ‘

Define Financial Statement Versions

OB58

IMG Menu Path:

Financial Accounting → General Ledger Accounting→ Business transactions → Closing →

Documenting → Define Financial statement versions

Financial Statement Versions for each company are defined in this transaction.

Define Accounts for Material Management

OBYC

IMG Menu Path:

Financial Accounting → General Ledger Accounting→ Business transactions → Integration → Materials Management → Define Accounts for Material Management

FI Configuration for Automatic postings for Materials Management is done here. Annexure – ‘ I ‘

Prepare Revenue Account Determination

VKOA

IMG Menu Path:

FI Configuration for automatic postings for Sales & Distribution is done here.

(18)

Financial Accounting → General Ledger Accounting→ Business transactions → Integration → Sales & Distribution → Prepare Revenue Account determination

Annexure – ‘ J ‘

Define Account Groups with Screen layout (Vendors)

OBD3

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Vendor Accounts → Master records → Preparations for creating Vendor master records → Define Account groups with Screen Layout

Account groups for Vendor master records are created here.

Annexure – ‘K ‘

Maintain Terms of payment OBB8

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Incoming invoices /Credit memos → Maintain terms of Payment

The required Terms of Payment for Incoming Invoices are maintained here. Payment Terms ID Text

PT01 Payable Immediately PT02 Payable within 7 days PT03 Payable within 15 days PT04 Payable within 30 days PT05 Payable within 60 days PT06 Partial Payment (Installments) PT07 Advance Payment PT08 Letter of Credit PT09 Payable within 45 days

(19)

PT10 Payable within 27 days

Define Accounts for Cash Discount Taken

OBXU

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Outgoing Payment global settings → Define Accounts for Cash Discount taken

G/L Account ‘400458000’ has been assigned for Cash discounts received.

Define Accounts for Lost Cash Discount

OBXV

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Outgoing Payment global settings → Define Accounts for Lost Cash Discount

G/L Account ‘400458000’ has been assigned for Cash discounts lost.

(20)

Define Accounts for Overpayments / Underpayments

OBXL

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Outgoing Payment global settings → Define Accounts for Overpayments / Underpayments

G/L Account ‘ 400889002’ has been assigned for Payment differences by reasons.

(21)

Define Accounts for Rounding Differences

OB00

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Outgoing Payment global settings → Define Accounts for Rounding differences

G/L Account ‘ 400889002’ has been assigned for Internal currencies rounding differences.

Define Accounts for Bank Charges

OBXK

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Outgoing Payment global settings → Define Accounts for Bank charges

G/L Account ‘40024000’ has been assigned for Bank Charges.

Configure Payment program

FBZP

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Automatic Outgoing payments → Payment Method /Bank selection → Configure Payment Program

All the company codes are added as Paying companies. And Payment methods have been selected for each company. Payment method ‘ C ‘ is for Check Payment.

Configure Bank selection for Payment Program

SPRO

IMG Menu Path:

Financial Accounting → Accounts

Housing banks are assigned for the payment methods for each Company code

(22)

Receivable and Accounts payable → Business Transactions → Outgoing payments → Automatic Outgoing payments → Payment Method/ Bank selection → Configure Bank selection for Payment Program

(23)

Enter Available amounts for Payment program

OB75

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Automatic Outgoing payments → Payment Method / Bank Selection → Enter Available amounts for Payment Program

For each Company code and House Bank Amount available for both Outgoing / Incoming payments are specified.

Assign Payment forms for Payment Methods in Company code

SPRO

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Automatic Outgoing payments → Payment media → Assign Payment forms for Payment Methods in Company code

Sap script forms designed for cheque printing has been assigned for Payment method ‘C’ for each company code

Define Sender details for Payment forms

SPRO

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Automatic Outgoing payments → Payment media → Define Sender details for Payment forms

Sender details for payment forms are specified for each Company code

(24)

Define Number ranges for Checks

FCHI

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Outgoing payments → Automatic Outgoing payments → Payment media → Check management → Define Number ranges for Checks

Check lots have been defined for each combination of House bank and Account ID for each Company code

Define Alternative

Reconciliation Account for Down Payment

OBYR

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Down Payment made → Define

Alternative Account for Down payment

Reconciliation Accounts have been

assigned for various special G/L indicators for each company code.

Annexure - ‘L‘

Reconciliation Account for Vendors

OBXT

IMG Menu Path:

Financial Accounting → Accounts Receivable and Accounts payable → Business Transactions → Postings with Alternative

Reconciliation Accounts → Other Special G/L Transactions → Define Alternative Reconciliation Account for Vendors

Reconciliation Accounts are specified for Special G/L indicators for Vendors for each company code.

(25)

Define House Banks FI12

IMG Menu Path:

Financial Accounting → Bank Accounting → Bank Accounts → Define House Banks

House Banks and related Bank Accounts are defined here for each Company code.

Reconciliation Account for Bill of Exchange postings

OBYM

IMG Menu Path:

Financial Accounting → Bank Accounting → Business

Transactions → Bill of exchange Payable → Create Bill of Exchange Payable → Define Alternative Reconciliation Account for Bill of Exchange postings

Alternative reconciliation Accounts for Bill s of Exchange Payable are defined here.

Special G/l Ind.: W – Bill of Exchange Payable

Reconciliation A/c Special G/L A/c 111000000 111000015 111000003 111000015 111000008 111000015 111000009 111000015 111000010 111000015

Create G/L Account for Cash Journal

FS00

IMG Menu Path:

Transactions → Cash Journal → Create G/L Account for Cash Journal

Cash on Hand Account ‘10150001’ is created for each Company code.

(26)

Define document types for Cash Journal documents

OBA7

IMG Menu Path:

Transactions → Cash Journal → Define document types for Cash Journal documents

Document types ‘C1’ and ‘C2’ are defined for Cash Receipts and Cash Payments respectively.

Define Number range intervals for Cash journal documents

FBCJC1

IMG Menu Path:

Transactions → Cash Journal → Define Number range intervals for Cash Journal documents

Number Range is specified for each Company code for each Cash Journal.

Set Up Cash Journal FBCJC0

IMG Menu Path:

Transactions → Cash Journal → Set Up Cash Journal

Cash Journal is Set Up for each Company code by assigning the Cash Account (101500001), document types (C1 for Receipts and C2 for Payments) and currency (INR) to each Cash journal.

Create, Change, Delete Business transactions

FBCJC2

IMG Menu Path:

Transactions → Cash Journal → Create, Change, Delete Business Transactions

Required Business transactions have been created for each company code.

(27)

Annexure – FI – 001

Details of Document types and Number ranges Maintained: Document

type

Description Account types Allowed Reverse document type Number range From To A1 Receipt-ANZ--Hyderabad ADKMS A2 A1 100000 199999 A2 Payment-ANZ--Hyderabad ADKMS A1 A2 200000 299999 A3 Receipt-ANZ--Mumbai ADKMS A4 A3 300000 399999 A4 Payment-ANZ--Mumbai ADKMS A3 A4 400000 499999 A5 Receipt-SBH-Hyderabad ADKMS A5 A5 500000 599999 A6 Payment-SBH-Hyderabad ADKMS A5 A6 600000 699999 A7 Receipt- AB--Balanagar ADKMS A8 A7 700000 799999 A8 Payment- AB--Balanagar ADKMS A7 A8 800000 899999

AA Asset Posting ADKMS AA AA 900000 999999

AB Accounting Document

ADKMS AB AB 1000000 1099999

AF Dep. Postings AS AF AF 1100000 1199999

AN Net Asset Posting AKMS AN AN 1200000 1299999

B1 Receipt BOA -Mumbai ADKMS B2 B1 1300000 1399999 B2 Payment- BOA - Mumbai ADKMS B1 B2 1400000 1499999 B3 Receipt- Central Bank ADKMS B4 A7 700000 799999

(28)

B4 Payment-Central Bank

ADKMS B3 A8 800000 899999

C1 Cash Receipts ADKMS C1 C1 1500000 1599999

C2 Cash Payments ADKMS C1 C2 1600000 1699999

DA Customer Document DS AB DA 3100000 3199999

DG Customer Credit Memo

DS DA DG 3200000 3299999

DR Customer Invoice ADMS DR DR 3300000 3399999

DZ Customer Payment DS DA DZ 3400000 3499999

ED Excise Transactions ADKMS AB ED 3500000 3599999

EU Euro Rounding Diff. ADKMS EU 3600000 3699999

EX External Number DKS AB EX A ZZZZZZZ

ZZZ

KA Vendor Document AKMS KA KA 4000000 4099999

KG Vendor Credit Memo AKMS KA KG 4100000 4199999

KN Net Vendors AKS KN 4200000 4299999

KP Account Maintenance AMS KP KP 4300000 4399999

KR Vendor Invoice AKMS KA KR 4400000 4499999

KZ Vendor Payment KS KA KZ 4500000 4599999 ML ML Settlement MS ML 4600000 4699999 PR Price Change MS PR 4700000 4799999 RA Sub.Cred.Memo Stlmt AKMS RA RA 4800000 4899999

RE Invoice Receipt AKMS RE RE 5000000 5099999

RN Net Invoice Receipt AKMS RN RN 4900000 4999999

RV Billing Doc. Transfer ADS AB RV 1 99999

SA G/L Account Document

ADKMS SA SA 5100000 5199999

SB G/L Account Posting S AB SB 5200000 5299999

SK Cash Transactions ADKMS AB ZZ 9200000 9299999

SU Adjustment Document

S SU ZZ 9200000 9299999

TD TDS Posting ADKMS TD TD 6000000 6099999

UE Data Transfer ADKMS UE UE 6100000 6199999

WA Goods Issue AMS WA 7000000 7099999

(29)

WI Inventory Document AMS WI 7200000 7299999

WL Goods Issue/Delivery AMS WL 7300000 7399999

WN Net Goods Receipt AMS WN 7400000 7499999

ZP Payment Posting ADKMS ZP ZP 8000000 8099999

ZR Bank Reconciliation DKS ZR ZR 8100000 8199999

ZS Payment By Check DKS ZS 8200000 8299999

(30)

Annexure – FI – 002 Details of Field Status Groups Maintained:

Field Status Group Text

101A CASH & BANK (VALUE DATE MANDATORY) 101B CASH & BANK (VAL.DATE OPTIONAL)

102A ACCOUNTS RECEIVABLES

102B *ACCOUNTS RECEIVABLES FOR PO

102C *ACCOUNTS RECEIVABLES

103A INVENTORY ACCOUNTS

104A PREPAID EXPENSES

104B PREPAID EXPENSES / DOWN PAYMENTS 104D PREPAID EXPENSES FOR I / O s

105A INTERCOMPANY

105B INTERCOMPANY FOR POS

107A PROPERTY & EQUIPMENT

107B PROPERTY & EQUIPMENT W/O COST CENTER

108A INTANGIBLE ASSETS

109A MISCELLANEOUS INVESTMENTS / ASSETS

111A ACCOUNTS PAYABLE

111B *ACCOUNTS PAYABLE PHASE - 1 111C *ACCOUNTS PAYABLE FOR PO 112A SHORT TERM DEBT

113A ACCRUED EXPENSES

113B *ACCRUED EXPENSES W/O CC

113C *ACCRUED EXPENSES FOR PO ONLY

114A ACCRUED TAXES

115A DEFERRED LIABILITIES

115B DEFERRED LIABILITIES FOR PO 116A DEFERRED LIABILITIES FOR PO 117A EQUITY & RESERVES

200A SALES

(31)

200C *GROSS TO NET PA ADJUSTMENTS 200D *GROSS TO NET TRADE ALLOWANCES

220A FACTORY OVER HEADS

300A VARIABLE COST OF SALES (MAT.CONSUMPTION) 300B INTERCOMPAMY SALES / COST OF SALES

300C VARIABLE COST OF SALES - NO CC

300D VARIABLE COST OF SALES - CC REQUIRED

400A NON VARIABLE OVERHEADS

400B *NON VARIABLE OVERHEADS NON CC

400C *NON VARIABLE OVERHEADS - OTH.POSTINGS 400D *NON VARIABLE OVERHEADS - CC REQUIRED 500A ADVERTISING

500B ADVERTISING WORK ORDERS

600A O E / I & TAXES

650A INTEREST EXPENSES - MISCELLANEOUS

700A CASH DISCOUNTS

Annexure – FI – 003 Tax Calculation Procedure 2TAINJ:

Step Description CTyp From To Man. Reqt SubTo Stat AltCTy AltC

BV ActKy

100 Base Amount BASB

110 Calculated call 100 X 352

120 Sub Total X

200 A/P Eduty for Setoff JMO1 100 354 200

205 A/P AED for Setoff JAO1 100 364

207 A/P SED for Setoff JSO1 100 368 0

210 A/P Eduty for Inven JMO2 100 362 0

212 A/P AED for Inventry JAO2 100 365 0

214 A/P SED for inventory JSO2 100 369 0

215 Sub total X

217 A/P Sales Tax setoff JIP3 215 370 VS1

(32)

230 A/P L Sales Tax Inv JIP2 215 371 NVV 250

SERVICE TAX

CREDIT JSER 100 ESA

260 SERVICE TAX DEBIT JSVD 250 ESE

510 A/R Excise Duty JMOD 120 X 363 510

512 A/R Add. Excise Duty JAED 120 366

513 A/R Sp. Excise Duty JSED 120 360

514 A/R Cess JCES 120 367

515 Sub total X

520 A/R Centr. Sales Tax JIN1 515 520

530 A/R Local Sales Tax JIN2 515 530

540 CST surcharge JIN4 520 520 540

550 LST surcharge JIN5 530 530 550

Annexure – FI – 004 Internal Processing Keys for Tax Procedure:

Process Description Tax type Not Deductible Posting

indicator 000 *NON-DED.INPUT TAXES 2 X 3 200 *MODVAT ED ON PURCHA 2 2 510 * BASIC ED ON SALES 1 2 512 * ADD. ED ON SALES 1 2 513 * SED. ED ON SALES 1 2 514 * CESS. ED ON SALES 1 2 520 *CST ON SALES 1 2 530 *LST ON SALES 1 2 540 *SUR ON CST-SALES 1 2 550 *SUR ON LST -SALES 1 2

(33)

Annexure – FI – 005 Details of Withholding tax codes defined:

Wth.t.type WTx Off.

key Description % rate

W/tax rate ITyp Post. ind. I1 1 194C TDS - @ 2.20% - CONTRACTORS - INVOICE 100 2.2 CO 1 I1 2 194C TDS -@ 1.10% - SUB-CONTRACTORS - INVOICE 100 1.1 CO 1 I1 3 194A TDS -@ 22% - INTEREST-COMPANIES-INVOICE 100 22 CO 1

I1 4 194A TDS -@ 11% - INTEREST-OTHERS- INVOICE 100 11 CO 1

I1 5 194I

TDS -@ 22% - RENTALS

-COMPANIES-INVOICE 100 22 CO 1

I1 6 194I TDS -@ 16.5% - RENTALS-OTHERS- INVOICE 100 16.5 CO 1

I1 7 194J TDS -@ 5.5% - PROF.CHRGS-INVOICE-COMPANI 100 5.5 CO 1 I1 8 194J TDS -@ 5.5% - PROF.CHRGS-INVOICE-OTHERS 100 5.5 CO 1 I1 9 194C TDS - @ 2.20% - P.M.SUPPLIERS - INVOICE 100 2.2 CO 1 I1 10 194C TDS - @ 2.20% - TRANSPORTERS - INVOICE 100 2.2 CO 1 I1 11 194C TDS - @ 0.25% - TRANSPORTERS - INVOICE 100 0.25 CO 1 P1 21 194C TDS - @ 2.20% - CONTRACTORS - PAYMENT 100 2.2 CO 1 P1 22 194C TDS -@ 1.10% - SUB-CONTRACTORS - PAYMENT 100 1.1 CO 1 P1 23 194A TDS -@ 22% - INTEREST-COMPANIES-PAYMENT 100 22 CO 1

P1 24 194A TDS -@ 11% - INTEREST-OTHERS- PAYMENT 100 11 CO 1

P1 25 194I TDS -@ 22% - RENTALS -COMPANIES-PAYMENT 100 22 CO 1 P1 26 194I TDS -@ 16.5% - RENTALS-OTHERS- PAYMENT 100 16.5 CO 1 P1 27 194J TDS -@ 5.5% - PROF.CHRGS-PAYMENT-COMPANI 100 5.5 CO 1 P1 28 194J TDS -@ 5.5% - PROF.CHRGS-PAYMENT- 100 5.5 CO 1

(34)

OTHERS

P1 29 194C TDS - @ 2.20% - P.M.SUPPLIERS - PAYMENT 100 2.2 CO 1 P1 30 194C TDS - @ 2.20% - TRANSPORTERS - PAYMENT 100 2.2 CO 1 P1 31 194C TDS - @ 0.25% - TRANSPORTERS - PAYMENT 100 0.25 CO 1

(35)

Accounts for Automatic Posting of Withholding Tax:

Withholding Tax type Withholding Tax code Account 01 I1 I1 I1 I1 I1 I1 I1 I1 I1 I1 I1 P1 P1 P1 P1 P1 P1 P1 P1 P1 P1 P1 01 01 02 03 04 05 06 07 08 09 10 11 21 22 23 24 25 26 27 28 29 30 31 113713008 113713007 113713008 113713009 113713009 113713011 113713012 113713016 113713017 113713005 113713006 113713006 113713007 113713008 113713009 113713009 113713011 113713012 113713016 113713017 113713005 113713006 113713006

(36)

Annexure – FI – 007 Details of Account Groups Created for each Chart of Account:

Account Group Name From Account To Account

101A CASH, BANK AND MARKETABLE SECURITIES 101000000 101999999

102A ACCOUNTS RECEIVABLES 102000000 102999999

103A INVENTORY ACCOUNTS. 103000000 103999999

104A PREPAID EXPENSES 104000000 104999999

105A INTERCOMPANY 105000000 105999999

106A INTERCOMPANY 106000000 106999999

107A PROPERTY, PLANT & EQPT. 107000000 107999999

108A INTANGIBLE ASSETS 108000000 108999999

109A OTHER ASSETS 109000000 109999999

111A ACCOUNTS PAYABLE 111000000 111999999

112A SHORT TERM DEBTS 112000000 112999999

113A ACCRUALS 113000000 113999999

114A ACCRUED TAXES 114000000 114999999

115A DIFFERED LIABILITIES 115000000 115399999

116A LONG TERM DEBTS 116000000 116999999

117A EQUITY AND SHARE HOLDERS 117000000 117999999

200A SALES TO CUSTOMERS 200000000 200099999

200B REDUCTION TO GROSS SALES 200100000 200199999

200C SALES ALLOWANCES 200200000 200299999

200D CASH DISCOUNTS ALLOWED 200300000 200399999

220A FACTORY OVERHEAD 220000000 220699999

220B VARIABLE COST OF SALES (RM CON) 220700000 220999999

240A VARIABLE WARE HOUSING 240000000 240999999

250A VARIABLE FREIGHT 250000000 250999999

260A VARIABLE COMMISSIONS 260000000 260999999

270A DOUBTFUL A/Cs AND BAD DEBTS 270000000 270999999

300A INTERCOMPANY SALES 300000000 300999999

310A INTERCOMPANY C.O.S. 310000000 310999999

400A NON-VARIABLE OVERHEADS 400000000 400899999

(37)

500A MEDIA 500000000 500499999

500B PROMOTION 500500000 500899999

500C FUTURE ADVERTISING 500900000 500999999

550A DIVISION INVESTMENT FUND 550000000 550999999

600A OTHER INCOME / EXPENSES 600000000 600399999

650A INTEREST 650000000 650999999

700A INCOME TAXES & OTHER APPROPRIATIONS 700000000 700999999

(38)

Adjustment Accounts for GR/IR Clearing:

The following Accounts are assigned from each Chart of Account for each transaction given below.

1. Transaction BNG - Invoiced but not yet delivered

Reconciliation Account Adjustment Account Target Account

111051000 111051001 111100000 111051005 111051006 111100000 111052000 111052001 111100000 111100001 111100002 111100000

2. Transaction GNB - Delivered but not yet invoiced

Reconciliation Account Adjustment Account Target Account

111051000 111051001 111051003 111051005 111051006 111051008 111052000 111052001 111052002 111100001 111100002 111100004

(39)

Annexure – FI – 009 Accounts for Materials Management:

The following Accounts have assigned from each Chart of Account for each Transaction given below.

1. Transaction AUM – Expense/ Revenue from Stock transfer

Valuation modif. Valuation Class Account

1000 0100 220807001 1000 0101 220807001 1000 0300 220842000 1000 0400 220807002 1000 0800 220808000 1000 0900 220841000

2. Transaction BSV – Change in Stock Account Account - 220831001

3. Transaction BSX - Inventory Posting

Valuation modif. Valuation Class Account

1000 0100 103000000 1000 0101 103000000 1000 0104 103000000 1000 0300 103600000 1000 0301 103600000 1000 0400 103200000 1000 0800 103400000 1000 0801 103400000 1000 0900 103500000

(40)

Account - 111100030

5. Transaction DIF - Materials Management Small Differences Account - 400889006

6. Transaction FR1 – Freight Clearing Account - 111052000

7. Transaction FR3 – Customs clearing Account - 111100031

8. Transaction FRL – External Activity Account – 220831001

9. Transaction GBB – Offsetting entry for Inventory Posting

Valuation Modif. General Modification Valuation class Account

1000 AUF 0400 220952000 1000 AUF 0800 220951000 1000 AUF 0900 220950000 1000 BSA 0100 103999000 1000 BSA 0101 103999000 1000 BSA 0300 103999000 1000 BSA 0301 103999000 1000 BSA 0400 103999000 1000 BSA 0800 103999000 1000 BSA 0900 103999000 1000 BSA 3000 103999000 1000 BSA 900 400435000 1000 INV 0100 220807001 1000 INV 0101 220807001 1000 INV 0300 400306021

(41)

1000 INV 0301 400306021 1000 INV 0400 220807002 1000 INV 0800 220808000 1000 INV 0900 220841000 1000 PRA 0900 220811000 1000 VAX 0100 220800009 1000 VAX 0101 220800009 1000 VAX 0300 220800009 1000 VAX 0400 220800009 1000 VAX 0800 220800007 1000 VAX 0900 220800000 1000 VBO 0100 220831005 1000 VBO 0101 220831005 1000 VBO 0400 220831002 1000 VBO 0800 220831004 1000 VBO 0900 220831003 1000 VBR 0100 220900000 1000 VBR 0101 220900000 1000 VBR 0300 400305003 1000 VBR 0301 400305003 1000 VBR 0400 220901000 1000 VBR 0800 220904000 1000 VBR 0900 220905000 1000 VNG 0100 103701001 1000 VNG 0101 103701001 1000 VNG 0300 220907000 1000 VNG 0400 103701003 1000 VNG 0800 103701004 1000 VNG 0900 103701000 1000 VPQ 0100 220829001 1000 VPQ 0101 220829001 1000 VPQ 0300 220842000 1000 VPQ 0301 220842000 1000 VPQ 0400 220829002 1000 VPQ 0800 220829004 1000 VPQ 0900 220829005

(42)

1000 VQP 0100 220820000 1000 VQP 0101 220820000 1000 VQP 0300 220820000 1000 VQP 0301 220820000 1000 VQP 0400 220820000 1000 VQP 0800 220820000 1000 VQP 0900 220820000 1000 VQP 3000 220820000 1000 ZAY 0900 400435000

10. Transaction KDM – Materials management exchange rate differences. Account – 400306027

11. Transaction KDR – MM exchange rate rounding differences. Debit - Account – 400474001

Credit – Account – 400474002

12. Transaction PRD – Cost (price) differences

Valuation Modif. Valuation class Account

1000 0100 220810001 1000 0101 220810001 1000 0400 220810001 1000 0800 220810001 1000 0900 220810001

13. Transaction UMB – Gain/loss from revaluation

Valuation Modif. Valuation class Account

1000 0100 220810001

(43)

1000 0800 220817001

1000 0900 220810004

14. Transaction WRX – GR/IR Clearing Account

Valuation Modif. Valuation class Account

1000 111100001 1000 0100 111051000 1000 0101 111051000 1000 0300 111100001 1000 0301 111100001 1000 0400 111051000 1000 0800 111051005 1000 0900 111051005

(44)

Accounts for Sales & Distribution:

The following Accounts are assigned for Account key for each combination of Chart of Account and sales organization.

Application Condition type Account Key G/L Account

V KOFI EL1 200000000 V KOFI EL3 400977000 V KOFI EL4 220800010 V KOFI EL5 200000000 V KOFI EL6 220800010 V KOFI ERF 113510000 V KOFI ERL 200000000 V KOFI EX2 200003000 V KOFI EXD 200000000 Annexure – FI – 011 Account Groups for Vendors:

(45)

CINC * Carriers - Inbound (CCL) CINP * Inventory Vendor-PM (CCL) CINR * Inventory Vendor-RM (CCL) CNIM * Non-Inv. Vendor-Misc.(CCL) CNIV * Non-Inv. Vendor-CG (CCL) COUC * Carriers - Outbound (CCL)

CPD X One-time vend.(int.no.assgnmt) EMP EMPLOYEE ACCOUNT GROUP (EX.No) LINC * Carriers - Inbound (LHPL)

LINP * Inventory Vendor-PM (LHPL) LINR * Inventory Vendor-RM (LHPL) LNIM * Non-Inv. Vendor-Misc.(LHPL) LNIV * Non-Inv. Vendor-CG (LHPL) LOUC * Carriers - Outbound (LHPL)

SINC * Carriers - Inbound (SCL) SINP * Inventory Vendor-PM (SCL) SINR * Inventory Vendor-RM (SCL) SNIM * Non-Inv. Vendor-Misc.(SCL) SNIV * Non-Inv. Vendor-CG (SCL) SOUC * Carriers - Outbound (SCL)

TINC * Carriers - Inbound (SHPL) TINP * Inventory Vendor-PM (SHPL) TINR * Inventory Vendor-RM (SHPL) TNIM * Non-Inv. Vendor-Misc.(SHPL) TNIV * Non-Inv. Vendor-CG (SHPL) TOUC * Carriers - Outbound (SHPL)

(46)

(47)

Annexure – FI – 012 Alternative Account for Down Payments Made: Account Type: K 1. Special G/L indicator: A - Advance Payments Made

Reconciliation A/c Special G/L Account

111000000 102400008 111000003 102400009 111000008 102400010 111000009 102400011 111000010 102400012

2. Special G/L indicator: E - Employee Advance Reconciliation Account - 111000011 Special G/L Account- 102261001

3. Special G/L indicator: F - Request for Advance Payment Reconciliation A/c Special G/L Account

111000000 111000099 111000003 111000099 111000008 111000099 111000009 111000099 111000010 111000099 4. Special G/L indicator: M - Asset Advance Payment

Reconciliation Account - 111000010 Special G/L Account- 102400012

(48)

Reconciliation Account - 111000011 Special G/L Account- 102252000

Annexure – FI – 013 Alternative Reconciliation Accounts for Vendors:

1. Special G/L indicator: H – Deposits made

111000000 102500000 111000003 102500000 111000008 102500000 111000009 102500000 111000010 102500000

2. Special G/L indicator: J – Deposits received

111000000 111105002 111000003 111105002 111000008 111105002 111000009 111105002 111000010 111105002

(49)

ASSET ACCOUNTING

Configuration Transaction code / Menu Path What was Created /changed Copy Chart of Depreciation EC08

IMG Menu Path: Asset Accounting →

Organizational Structures →

Copy reference chart of depreciation → (Again) Copy reference chart of

depreciation →

Copy organizational object

Then

Asset Accounting →

Copy reference chart of depreciation → Specify description of chart of depreciation

Chart of Depreciation is copied from 0GB-Sample chart of Depreciation-Great Britain as 1IN.

1IN – Chart of Depreciation: India

Assign chart of

depreciation to Company code

OAOB

Assign chart of depreciation to company code

Company Code Chart of Depreciation IN41 1IN IN42 1IN IN43 1IN IN44 1IN

(50)

Specify Account Determination

SPRO

Organizational Structures → Specify Account Determination

Account Name of Account Determination Determination 1000000 LAND 3000000 BUILDINGS 3100000 BUILDINGS – TEMPORARY 4000000 PLANT & MACHINERY-EQUPMT 4200000 LAB EQUIPMENT 4300000 ELECTRICAL INSTALLATIONS 4400000 FACTORY EQUIPMENT 5000000 OFFICE EQUIPMENT 5100000 FURNITURE & FIXTURES 6000000 VEHICLES 7000000 COMPUTERS 8000000 LOW VALUE ASSETS 9000000 CAPITAL WORK-IN-PROGRESS

Create Screen layout rules SPRO

Organizational Structures → Create Screen Layout rules

The following rules were defined in addition to the system defined. Screen Layout Name

9100 GROUP ASSET – BUILDINGS 9200 GROUP ASSET – PLANT & MACHINERY 9300 GROUP ASSET – FURNITURE 9400 GROUP ASSET –

(51)

VEHICLES

9500 GROUP ASSET – DP/HARDWARE

Define Number Range Interval

AS08

Organizational Structures → Define Number range interval

Refer to Annexure – ‘A’

Define Asset Classes OAOA

Organizational Structures → Define Asset Classes

Asset classes are defined for the Chart of depreciation.

Refer to Annexure – ‘B’

Assign G/L Accounts AO90

Integration with the General Ledger → Assign G/L Accounts

G/L Accounts are assigned for Acquisitions and Retirements for the respective Chart of Accounts for the book depreciation area.

Refer to Annexure – ‘C’

Specify Financial statement version for Asset reports

OAYN

Integration with the General Ledger → Specify Financial statement version for

The Financial statement versions defined for the respective companies are

assigned here for each depreciation area.

(52)

Asset reports

Specify document type for posting of Depreciation

AO71

Integration with the General Ledger → Post depreciation to the General Ledger → Specify document type for posting of Depreciation→

Specify document type for Depreciation posting

The document type ‘AF’ defined for depreciation posting is assigned to each Company code.

Specify Intervals and Posting rules

OAYR

Integration with the General Ledger → Post depreciation to the General Ledger → Specify Intervals and Posting rules

Monthly posting has been specified as posting rule for each company code.

Specify transfer of Depreciation terms

OABD

Valuation → Depreciation areas → Specify transfer of depreciation terms

Deselect the ‘Identical’ column for the depreciation area specified for Taxes.

(53)

Determine the depreciation areas in the Asset class

OAYZ

Valuation → Determine Depreciation areas in the Asset class

The default values of the depreciation keys and screen layout rules are assigned for each asset class.

Specify Max Amounts for Low Value Assets + Asset classes

OAY2

Valuation → Amount Specifications (Company code / Depreciation Area) → Specify Max Amounts for Low Value Assets + Asset classes → Specify LVA Asset classes

Asset class ‘8000000’ defined for Low Value Assets is specified as Low Value Asset class.

Specify Max Amounts for Low Value Assets + Asset classes

OAYK

Valuation → Amount Specifications (Company code / Depreciation Area) → Specify Max Amounts for Low Value Assets + Asset classes → Specify Amount for Low value Assets

Max Amount for Low Value Assets has been defined for each Company code as Rs.5, 000 for the Book Depreciation area.

Specify Depreciation areas for Group assets

OAYM

IMG Menu Path:

Asset Accounting → Valuation → Group assets → Specify Depreciation areas for Group assets

The indicator is set for the check box for Group Asset for Tax Depreciation area for each company code.

(54)

Specify Asset classes for group assets

OAAX

IMG Menu Path:

Asset Accounting → Valuation → Group assets → Specify asset classes for Group assets

Set the indicator for the asset classes created to consist only of group assets.

Assign accounts for Ordinary depreciation

AO93

IMG Menu Path:

Asset Accounting → Depreciation → Ordinary Depreciation → Assign accounts

G/L Accounts are assigned for Book depreciation for each Account

determination for each Chart of accounts for the Ordinary depreciation.

Refer Annexure – ‘D’ Define Multilevel methods AFAMS

Depreciation → Valuation methods → Depreciation key → Calculation Methods → Define Multilevel methods

Various Multilevel methods are defined. Refer to Annexure –‘F’

Define Period Control methods

AFAMP

Depreciation → Valuation methods → Depreciation key → Calculation Methods → Define Period Control methods

Required Period Control methods are defined.

Period control Description Acq Add Ret Trf

997 20/20/08/06 – WDV-TAX 20 20 08 06

(55)

998 11/11/01/01 – WDV 11 11 01 01

ZZZ 11/11/01/01 – SLM 11 11 01 01

Defining Depreciation keys AFAMA

Depreciation → Valuation methods → Depreciation key → Maintain Depreciation key

Required Depreciation keys are defined. Refer to Annexure -‘G’

Define Period control OAVS

Depreciation → Valuation methods → Period control → Define Period control

One period control is defined.

Period control Name of the Period control 20 For Tax Purpose Define Calendar assignments OAVH

Depreciation → Valuation methods → Period control → Define Calendar assignments

Calendar assignments for the Period control 20 defined above are done here. FV Period Control Year Month Day Period

V3 20 2000 03 31 6

V3 20 2000 09 30 0

Defining screen layout for Asset Master data

SPRO

IMG Menu Path:

Asset Accounting → Master data→ Screen layout → Define layout for Asset master

The fields ‘Plant’ and ‘Investment

purpose’ were changed from suppressed to optional mode for all the screen layout rules.

(56)

data → (again) Define layout for Asset master data

Define screen layout for Asset depreciation areas

AO21

IMG Menu Path:

Asset Accounting → Master data→ Screen layout → Define screen layout for Asset depreciation areas

Field ‘ Useful life ‘ is changed from required mode to optional mode and field ‘Group asset’ is changed from optional to required mode for both the screen layout rules of 1000 and 2000.

Define Evaluation group 1 .

OAVA

IMG Menu Path:

Asset Accounting → Master data→ User fields → Define 4-Character Evaluation Groups

Values for Evaluation group 1 are created.

Refer Annexure – ‘E’

Define Evaluation group 5 OAV8

IMG Menu Path:

Asset Accounting → Master data→ User fields → Define 8-Character Evaluation Groups

Values for Evaluation group 5 are created.

Eval.group 5 Name FACTORY Insurance grouping – Factory

OFFICE Insurance grouping – Office

WAREHSE Insurance grouping – Warehouse

(57)

Define Reasons for Investment

OAW1

IMG Menu Path:

Asset Accounting → Master data→ User fields → Define Reasons for Investment

The following reasons for Investment are created.

Investment Reason Name

1 Savings 2 New Products 3 Replacement 4 Expansion 5 Improvement 6

Environmental, Health & Safety Define Validation OACV

IMG Menu Path:

Asset Accounting → Master data→ Define Validation

A Validation to accept only Asset classes defined for Group assets is defined for when creating Group Assets is defined here.

Assign Settlement profiles to Company code

OAAZ

IMG Menu Path:

Asset Accounting → Transactions → Capitalization of Assets under construction → Define/Assign Settlement Profiles

Assign Settlement Profile ‘AI ’ to each company code.

Specify Transfer Date / Last Closed Fiscal year

SPRO

IMG Menu Path:

Asset Accounting → Asset Data Transfer → Parameters for data transfer → Date specifications → Specify Transfer date / Last Closed Fiscal year

The transfer dates are specified for each company code. Company code Transfer Date IN41 30.09.2000 IN42 30.09.2000 IN43 31.10.2000

(58)

IN44 31.10.2000

Specify Last Period Posted in Previous system

OAYC

IMG Menu Path:

Asset Accounting → Asset Data Transfer → Parameters for data transfer → Date specifications → Specify Last Period Posted in Previous system

The last posted period is mentioned for each company code for depreciation area ‘ 01’.

Company Code Fiscal Year Period IN41 2000 06 IN42 2000 06 IN43 2000 07 IN44 2000 07 ANNEXURE – AA – 001 Number Range defined for Asset Accounting

(59)

No. From Number To Number 10 000000000001 000000000999 11 000000001000 000000009999 12 000000010000 000000099999 19 000000100000 000000199999 20 000000200000 000000299999 30 000000300000 000000399999 40 000000400000 000000499999 50 000000500000 000000599999 60 000000600000 000000699999 70 000000700000 000000799999 80 000000800000 000000859999 81 000000860000 000000899999 90 000000900000 000000999999 91 000001000000 000001000999 92 000001001000 000001001999 93 000001002000 000001002999 94 000001003000 000001003999

(60)

ANNEXURE – AA – 002 Asset Classes Defined for the Chart of Depreciation 1IN

Class Description Account Determinatio n Screen Layout rule Numb er range Invento ry data Status of AUC History status 1000000 3000000 3100000 4000000 4200000 4300000 4400000 5000000 5100000 6000000 7000000 8000000 9000000 GROUP-BL GROUP-FR GROUP-PM GROUP-VH LAND BUILDINGS BUILDINGS - TEMP P & M - EQUIPMENT LAB EQUIPMENT ELEC. INSTALLATIONS FACTORY EQUIPMENT OFFICE EQUIPMENT FURNITURE & FIXTURES VEHICLES

COMPUTERS

LOW VALUE ASSETS CAPITAL WIP

GROUP ASSET- BLDGS. GROUP

ASSET-FURNITURE

GROUP ASSET - P & M GROUP ASSET - VEHCLE 1000000 3000000 3100000 4000000 4200000 4300000 4400000 5000000 5100000 6000000 7000000 8000000 9000000 3000000 5100000 4000000 6000000 1000 1100 1100 2000 2000 2000 2000 2000 3000 3100 3200 3300 4000 9100 9300 9200 9400 10 11 12 19 20 50 30 40 60 80 70 81 90 92 93 91 94 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No AUC No AUC No AUC No AUC No AUC No AUC No AUC No AUC No AUC No AUC No AUC No AUC Line item Settle Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No

(61)

ment No AUC No AUC No AUC No AUC ANNEXURE – AA – 003 General Ledger Accounts for Acquisitions and Retirements

Account Determin ation Acquisition and Production costs Acquisition- down payments Down-payments clearing Account Clearing acct. revenue from asset sale Gain from Asset Sale Loss from Asset Sale Loss made on Asset retirement w/o revenue

(62)

1000000 3000000 3100000 4000000 4200000 4300000 4400000 5000000 5100000 6000000 7000000 8000000 9000000 107000001 107070001 107070002 107151001 107151002 107151004 107151003 107200003 107200001 107230001 107201001 107201000 107250000 104314006 104314006 104314006 104314006 104314006 104314006 104314006 104314006 104314006 104314006 104314006 104314006 104314006 104314007 104314007 104314007 104314007 104314007 104314007 104314007 104314007 104314007 104314007 104314007 104314007 104314007 400715999 400715999 400715999 400715999 400715999 400715999 400715999 400715999 400715999 400715999 400715999 400715999 400715999 400700001 400700001 400700001 400700001 400700001 400700001 400700001 400700001 400700001 400700001 400700001 400700001 400700001 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002 400700002

(63)

ANNEXURE – AA – 004 General Ledger Accounts for Ordinary Depreciation

Account Determinati on Accumulated depreciation for Ordinary depreciation Expense Account for Ordinary depreciation Accumulated depreciation for Unplanned depreciation Expense Account for Unplanned depreciation 1000000 3000000 3100000 4000000 4200000 4300000 4400000 5000000 5100000 6000000 7000000 8000000 9000000 - 107340001 107340002 107400001 107400002 107400005 107400004 107400008 107450001 107480001 107451001 107450003 - - 400350000 400350001 400352000 400354000 400352002 400352001 400353000 400354001 400355000 400354002 400353002 - - 107340001 107340002 107400001 107400002 107400005 107400004 107400008 107450001 107480001 107451001 107450003 - - 400350000 400350001 400352000 400354000 400352002 400352001 400353000 400354001 400355000 400354002 400353002 -

(64)

ANNEXURE – AA – 005 Characteristics defined for Evaluation Group 1

No. Evaluation Group Description

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1000 1001 1002 2000 3000 3001 4000 5000 5001 5002 5003 5004 5005 5006 5007 5008 5009 5010 5011 5012 5013 5014

LAND (OWNED) - REVALUATION LAND (LEASED) - REVALUATION LAND (IMPRVEMNT) - REVALUATION LEASEHOLD IMPRVMNT-REVALUATION BUILDING - REVALUATION

BUILDING (LEASED) - REVALUATE M & E - MOULD & DIES

F & F - CABINET STEEL F & F - CABINET WOOD F & F - DESK

F & F - TABLE F & F - ARM CHAIR F & F - VISITOR CHAIR F & F - TELEPHONE F & F - FAX MACHINE F & F - TELEVISION F & F - VIDEO

F & F - SLIDE PROJECTOR F & F - LCD PROJECTOR

F & F - OVERHEAD PROJECTOR F & F - MEDIA BOARD

(65)

1 5015 F & F - PAPER SHREDDER 1 1 1 1 1 1 1 1 1 1 1 1 1 1 5016 5017 5018 5019 5020 5021 5022 6000 6001 7000 7001 7002 7003 7004

F & F - ID CARD CONTROLLER F & F - AIR CONDITIONER F & F - AIR CLEANER F & F - TYPEWRITER F & F - CALCULATOR F & F - HARD FURNISHING F & F - OTHERS

AUTO - VAN AUTO – CAR

COMPUTER - PERSONAL COMPUTER COMPUTER - NETWORKING EQUIPMNT COMPUTER - PRINTER

COMPUTER - SOFTWARE

COMPUTER - OTHER COMP.EQUIP.

(66)

Multilevel methods defined for Chart of depreciation 1IN Metho

d

Description Validity start Acq.Yea r Years Peri od Base value Percent 100 100% on changeover From Changeover

year 9999 999 12 01 100 B01 1.63 % - SLM - Office Buildings From Capitalization date 9999 999 12 01 1.63 B02 3.34 % - SLM – Factory Buildings From Capitalization date 9999 999 12 01 3.34

B03 100 % - Temp. Buildings From Capitalization date

9999 999 12 01 100

F01 6.33 % - SLM - Furniture From Capitalization date

9999 999 12 01 6.33

P01 4.75 % - SLM – P & M From Capitalization date

9999 999 12 01 4.75

P02 5.28 % - SLM – P & M From Capitalization date 9999 999 12 01 5.28 P03 9.50 % - SLM From Capitalization date 9999 999 12 01 9.50 P04 11.31% - SLM From Capitalization date 9999 999 12 01 11.31 P05 16.21% - SLM From Capitalization date 9999 999 12 01 16.21 P06 7.42% - SLM From Capitalization date 9999 999 12 01 7.42 P07 10.34% -SLM From Capitalization date 9999 999 12 01 10.34 W01 13.91% - WDV From Capitalization date 9999 999 12 24 13.91 W02 27.82% - WDV From Capitalization date 9999 999 12 24 27.82 W03 18.10% - WDV From Capitalization date 9999 999 12 24 18.10 W04 25.89% - WDV From Capitalization date 9999 999 12 24 25.89 W05 5% - WDV From Capitalization 9999 999 12 24 5

(67)

date W10 10% - WDV From Capitalization date 9999 999 12 24 10 W20 20% - WDV From Capitalization date 9999 999 12 24 20 W25 25% - WDV From Capitalization date 9999 999 12 24 25 W40 40% - WDV From Capitalization date 9999 999 12 24 40 W60 60% - WDV From Capitalization date 9999 999 12 24 60 ANNEXURE – AA – 007 Depreciation keys defined for the Chart of depreciation 1IN

Dep.K ey

Description Depreciation Phase Base Method Decl.Bal.Met hod Prd. Cntrl. Method Multil evel meth od

S100 Straight Line – 100% Ordinary 1 0014 001 ZZZ B03

S103 Straight Line – 10.34% Ordinary 1 0014 001 ZZZ P07 S113 Straight Line – 11.31% Ordinary 1 0014 001 ZZZ P04 S162 Straight Line – 16.21% Ordinary 1 0014 001 ZZZ P05 S163 Straight Line – 1.63% Ordinary 1 0014 001 ZZZ B01 S334 Straight Line – 3.34% Ordinary 1 0014 001 ZZZ B02 S475 Straight Line – 4.75% Ordinary 1 0014 001 ZZZ P01 S528 Straight Line – 5.28% Ordinary 1 0014 001 ZZZ P02 S633 Straight Line – 6.33% Ordinary 1 0014 001 ZZZ F01 S742 Straight Line – 7.42% Ordinary 1 0014 001 ZZZ P06

(68)

S950 Straight Line – 9.50% Ordinary 1 0014 001 ZZZ P03 W010 WDV – 10% Ordinary 1 0014 001 998 W10 W040 WDV – 40% Ordinary 1 0014 001 998 W40 W139 WDV – 13.91% Ordinary 1 0014 001 998 W01 W181 WDV – 18.10% Ordinary 1 0014 001 998 W02 W258 WDV – 25.89% Ordinary 1 0014 001 998 W03 W278 WDV – 27.82% Ordinary 1 0014 000 998 W04 Z100 WDV – 100% Ordinary 1 0014 001 997 B03

ZW05 WDV – 5%-Tax Purpose Ordinary 1 0014 001 997 W05

ZW10 WDV – 10%-Tax Purpose Ordinary 1 0014 001 997 W10 ZW20 WDV – 20%-Tax Purpose Ordinary 1 0014 001 997 W20 ZW25 WDV – 25%-Tax Purpose Ordinary 1 0014 001 997 W25 ZW40 WDV – 40%-Tax Purpose Ordinary 1 0014 001 997 W40 ZW60 WDV – 60%-Tax Purpose Ordinary 1 0014 001 997 W60