3 · web viewconfiguration document for sd module this is a configuration document for sd module...

83
1 2 3 PROJECT RCIL 4 5 Configuration Document for SD Module 6 1)This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration settings in the system. 2)This Document starts with the Organizational Structure relevant for SD Module. 3)Only those functionalities are taken for configuration which are relevant to the project and mentioned in the BBP for SD. 4)Special requirements of the Client are also customised which are mentioned with the relevant reason. 5)Certain default settings are used which are mentioned with the respective functionality. 6) Sequence of the various functionalities of this document matches with that of SPRO. Page 1 of 83

Upload: vankhue

Post on 27-May-2018

231 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

12

3 PROJECT RCIL 4

5 Configuration Document for SD Module 61)This is a Configuration Document for SD Module for the RCIL

Project. Based on this document the Consultant will do the configuration settings in the system.

2)This Document starts with the Organizational Structure relevant for SD Module.

3) Only those functionalities are taken for configuration which are relevant to the project and mentioned in the BBP for SD.

4) Special requirements of the Client are also customised which are mentioned with the relevant reason.

5) Certain default settings are used which are mentioned with the respective functionality.

6) Sequence of the various functionalities of this document matches with that of SPRO.

Page 1 of 69

Page 2: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

7 8 ORGANIZATIONAL STURCTURE

9

9.1.1.19.1.1.29.1.1.39.1.1.4 SALES ORGANIZATION: 9.1.1.5 RCIL has two divisions responsible for manufacturing and selling Auto part and Cycle Parts where in Auto parts are excisable while selling. So there is a legal requirement that the business of the two divisions should be kept separate. This is reason RCIL will have two sales organization RASO for Auto division and RCSO for Cycle division.

DISTRIBUTION CHANNEL: RCIL sells the products through various ways which have been located and divided into said Distribution Channel. Two kinds of customers namely Accessory Dealers and Other Dealers will be sold

goods via CR ( Replacement Market ) Distribution Channel. For these Customers Page 2 of 69

3 RCILCompany

Code

2 RCSOSales Org. 1

1 RASO Sales Org. 2

DISTRIBUTION CHANNEL DISTRIBUTION CHANNEL

CG : Grp Com & OEM CE : Direct ExportCI : Indirect ExportCR : Replacement Mkt.CS : Product ScrapOM : Other Material

AO : OEM AR : Replacement Mkt.AS : Auto Scrap

DIVISION DIVISION

CC : Cycle ChainCH : Cycle HubCS : Cycle ScrapCD : Common DivOM : Other MaterialSP : Service Product

AC : Auto ChainAH : Auto HubAS : Auto ScrapCD : Common Div

Page 3: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

different account groups are maintained so that they can be categorised differently form the Replacement Market Dealer.

Distribution Channel CS ( Product Scrap ) is for the Scrap which comes from Manufacturing. So it is also called Manufacturing Scrap.

Distribution Channel OM ( Other Material) consists of Non Manufacturing Scrap, Trading Goods or any other such material. The Non Manufacturing Scrap generated from Auto Plant is being sold through this Distribution Channel only. Infact it is taken care by Cycle Plant. This is the reason that Auto Sales Organization does not have Distribution Channel for Other Scrap.

DIVISION:RCIL sells its items under two product line ( Chain and Hub ) each in both the sales organization . besides this both the sales org. sell scrap as well. Scrap is a different product that is why a separate Scrap division ( CS ) has been

created. A different division is created for Other Material namely OM for Non Manufacturing

Scrap, Trading Goods etc. For repairs in Cycle Sales Organization a separate division called SP ( Service

Product ) is created. A service material master will be created with this division. The customers in both the sales org. can buy items from there respective

Divisions (Product line) that is why a Common Division CD has been created to reduce the Customer data redundancy.

9.1.1.69.1.1.7

Page 3 of 69

5 C000Cycle Plant

7 C300Finished Goods storage location

9 C600Cycle Scrap

storage location

4 A0004.1 Auto Plant

8 A300Finished Goods storage location

6 A600Auto Scrap

storage location

9.1.1 Shipping Point

10CYSPCycle

Shippinng

Page 4: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Insert RegionIn General Settings following Regions will be defined for India as per RCIL requirement.

CODE NAME01 ANDHRA PRADESH02 ARUNACHAL PRADESH03 ASSAM04 BIHAR05 GUJRAT06 GOA07 HARYANA08 HIMACHAL PRADESH09 JAMMU & KASHMIR10 KARNATAKA11 KERALA12 MAHARASHTRA13 MADHYA PRADESH14 MANIPUR15 MIZORAM16 NAGALAND17 ORISSA18 PUNJAB19 RAJASTHAN20 SIKKIM21 TAMILNADU22 TRIPURA23 UTTAR PARDESH24 WEST BENGAL25 MEGHALAYA31 ANDEMAN NIKOBAR32 CHANDIGARH33 DELHI34 DEU DEMAN35 DADRA & NAGAR HAVELI

Page 4 of 69

11C700Finished Goods Hero location

12AUSPAuto

Shipping

Page 5: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

36 LAKSHDWEEP37 PONDICHERY38 CHHATISGARH39 JHARKHAND90 NEPAL91 EXPORT

Maintain Sales OfficeRCIL has got following sales offices.

Sales Office Description

ZC06 UP WEST PART-IIZC07 UP EAST PART-IIZE14 NORTH BIHAR & NEPALZE15 S.BIHAR,MP,1 STN-WBZE16 WEST BENGAL-NORTHZE17 WEST BENGAL-SOUTHZE18 ORISSAZE19 NORTH EAST FULLZE29 KOLKATTA & SUBURBSZE30 KOLKATTA LOCALZN01 PUNJAB(N/E),J&KZN02 PUNJAB(S/W),HPZN03 HAR/CHD/PBZN04 DELHI/HAR/RAJZN05 RAJASTHANZN32 PUNJABZN34 PUNJAB/HAR/RAJZN99 LUDHIANA DEALERSZ100 SCRAP & OTHER SALEZN34 RAJASTHANZS20 KARNATAKAZS21 A.P (COASTAL)ZS22 A.P (TELANGANA)ZS23 TN(S),KERALA 1 STNZS24 TN (N), KERALAZS28 CHENNAI LOCALZS35 TAMILNADUZW10 MADHYA PRADESHZW11 MAH,GOA,UTZW12 MAHARASHTRA-MPZW27 GUJARAT,RAJASTHANZW31 GUJARAT

Page 5 of 69

Page 6: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

AUTO AUTO DIVISIONRCIL EXPORT

Define Sales GroupAll the sales representative of the RCIL are defined as Sales Group and the relevant codes will be assigned to the Customers following under their territory.

Sales Group

Description

01 Mr. V.K. Chopra02 Mr. A.K.Gupta03 Mr. Rishi Raj Gulati05 Mr. Praveen Sharma06 Mr. Mahesh Sharma08 Mr.Vishal Bararia09 Mr. A.K.Dey10 Mr. Mahesh Kumar12 Mr. Naresh Rohila13 Mr. Sanjeev Mehta14 Mr. Parmaeshwar Mahai15 Mr. Rajnesh Sehgal16 Mr. P.K.Sharma17 Mr. P. Chatterjee18 Mr. A.K.Sethi20 Mr. Rajesh Bhardwaj21 Mr. Rupesh Gupta27 Mr. G.Ajith Kumar28 Mr. A.R.Barman29 Mr. K.N. Aravindan30 Mr. Rajiv Mehta31 Mr. Lalit Verma32 Mr. V.K.Verma34 Mr. Aashu Kishnani35 Mr. Brajesh Sinha36 Ludhiana Dealers37 Mr. R.S. Jamwal98 Scrap & Other Sale

Shipping Point DetailsThere will be two shipping points for RCIL one for each plant ( C000 , A000 )

Page 6 of 69

Page 7: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Shipping Point Details

For Cycle For AutoShipping Point CYSP AUSPCountry IN INDeparture ZoneFactory Calender RK RKDetermine Load Time C CLoading Time with DaysDetermine Pick/ Pack Time

C C

Pick Pack Time with Days Rounding Working Days 0.2 0.2

Assign Sales Organization to Company CodeAssign RCSO and RASO to Company Code RCIL

Assign Distribution Channel to Sales OrganizationAssign Distribution Channel to Sales Organization as follows.

RCSO RASOCR AOCG ARCE ASCICSOM

Assign Division to Sales OrganizationAssign Division to Sales Organization as follows

RCSO RASOCC ACCH AHCD CDCS ASOMSP

Set Up Sales Area:

Page 7 of 69

Page 8: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Sales area is a combination of Sales org. , DC, and DIV. RCIL will have following Sales Area.9.1.1.89.1.1.9 SALES AREA

SALES AREA RASO

SALES AREA RCSO

SALES ORG DC DIV SALES ORG DC DIVRASO AO AC RCSO CE CCRASO AO AH RCSO CE CDRASO AO CD RCSO CE CHRASO AR AC RCSO CG CCRASO AR AH RCSO CG CDRASO AR CD RCSO CG CHRASO AS AS RCSO CG OM

RCSO CG SPRCSO CI CCRCSO CI CDRCSO CI CHRCSO CR CCRCSO CR CDRCSO CR CHRCSO CR SPRCSO CR OMRCSO CS CSRCSO OM OM

Assign Sales Office to Sales Area AUTO Sales Office will be assigned to following sales area

AUTO RASO AO ACAUTO RASO AO AHAUTO RASO AO CDAUTO RASO AR ACAUTO RASO AR AHAUTO RASO AR CDAUTO RASO AS AS

RCIL EXPORT Sales Office will be assigned to the following sales area

RCIL RCSO CE CCRCIL RCSO CE CDRCIL RCSO CE CHRCIL RCSO CI CC

Page 8 of 69

Page 9: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

RCIL RCSO CI CDRCIL RCSO CI CH

Rest all the sales offices will be assigned to following sales area

RCSO CR CCRCSO CR CDRCSO CR CH

Assign Sales Group to Sales Office

Sales Off Sales Group

Description

ZC06 02 Mr. A.K.GuptaZC07 03 Mr. Rishi Raj GulatiZE14 05 Mr. Praveen SharmaZE15 05 Mr. Praveen SharmaZE16 17 Mr. P. ChatterjeeZE17 09 Mr. A.K.DeyZE18 12 Mr. Naresh RohilaZE19 21 Mr. Rupesh GuptaZE29 35 Mr. Brajesh SinhaZE30 28 Mr. A.R.BarmanZN01 14 Mr. Parmaeshwar MahaiZN02 18 Mr. A.K.SethiZN03 30 Mr. Rajiv MehtaZN04 08 Mr.Vishal BarariaZN05 08 Mr.Vishal BarariaZN32 32 Mr. V.K.VermaZN34 10 Mr. Mahesh KumarZN99 36 Ludhiana DealersZ100 98 Scrap & Other SaleZS20 01 Mr. V.K. ChopraZS21 16 Mr. P.K.SharmaZS22 20 Mr. Rajesh BhardwajZS23 27 Mr. G.Ajith KumarZS24 29 Mr. K.N. AravindanZS28 15 Mr. Rajnesh SehgalZW10 31 Mr. Lalit VermaZW11 06 Mr. Mahesh SharmaZW12 13 Mr. Sanjeev Mehta

Page 9 of 69

Page 10: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

ZW27 34 Mr. Aashu KishnaniZW31 37 Mr. R.S. JamwalAUTO 95 Auto DivisionRCIL 94 Direct ExportRCIL 96 Indirect Export

Assign Sales Org. and Distribution Channel to Plant

Sales Org. DC Plant

RASO AO A000RASO AR A000RASO AS A000

RCSO CG C000RCSO CE C000RCSO CI C000RCSO CR C000RCSO CS C000RCSO OM C000

Assign Sales Area to Credit Control AreaThe Credit Management is active only for Cycle Replacement market customers. So the credit control area RCIL will be assigned to following sales area. Sales Org. DC DIV CCRA

RCSO CR CC RCILRCSO CR CH RCILRCSO CR CD RCIL

Define Business Area There will be two business areas for RCIL for internal reporting

Business Area Description

AUTO Auto Business Area

CYCL Cycle Business

Page 10 of 69

Page 11: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Area

Assign Business Area RCIL will do internal reporting on combination of Plant and Div level so rule 1 ( Plant / Div ) will be used.A relevant rule is assigned with sales area and then the relevant business area is assigned to the plant and division combination.

SALES ORG DC DIV RULEPlant / Div

RASO AO AC 1RASO AO AH 1RASO AO CD 1RASO AR AC 1RASO AR AH 1RASO AR CD 1RASO AS AS 1

RCSO CE CC 1RCSO CE CD 1RCSO CE CH 1RCSO CG CC 1RCSO CG CD 1RCSO CG CH 1RCSO CG SP 1RCSO CG OM 1RCSO CI CC 1RCSO CI CD 1RCSO CI CH 1RCSO OM OM 1RCSO CR CC 1RCSO CR CD 1RCSO CR CH 1RCSO CR OM 1RCSO CR SP 1RCSO CS CS 1

The plant and Div combianation will be assigned to relevant business area

PLANT DIV BUSINESS AREA

A000 AC AUTOA000 AH AUTO

Page 11 of 69

Page 12: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

A000 AS AUTOA000 CD AUTOC000 CC CYCLC000 CH CYCLC000 CD CYCLC000 CS CYCLC000 SP CYCLC000 OM CYCL

Account Group

1) RCIL will need to maintain following account groupa) Sold to Party ( as the customer is playing the role of all the partner functions

that is why we only need to make SP account group b) One Time Customer

RCIL wants to have the same customer code for there common RM customers with Hero Cycle. For this they have further segregated the no range according to the region. If new costomer is added in hero cycle then an information is given to rockman and they also add that customer with same Customer Number. If new customer comes to rockman then they have to take the permission form Hero cycle and then both the companies add the customer with same no. This is why External No. range is assigned to RCSO Replacement Market customers. The direct customer of rockman ( Accessories Customer and Other Dealers) are added directly to rockman customer list and has got different no range ( but there sale would be conisdered in Replacement market ). This is an internal no range.

For All the account groups make following fields mandatory1) Name2) Region3) Country4) Tax jurisdiction code5) Customer Pricing Procedure6) Shipping conditions7) Account Assignment Group8) Incoterms 19) Incoterms 210) Terms of Payment

For customers in Cycle Replacement Market make these additional fields as mandatory1) Price List Type2) Sales office3) Sales Group

Page 12 of 69

Page 13: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

4) Sales District

For Export Customer mark these fields as NON MANDATORY1) Tax Jurisdiction code2) Region

The Product Scrap dealers for both the Sales Organization can be common so they will be maintained under one Account Group ( ZSRP ) and will be extended for both the Sales Area namely RASO/AS/AS and RCSO/CS/CS.

ACCOUNT GROUPNumber Ranges

S No.

RCSO Rockman Cycle CODE From To

1. CYCLE REPLACEMENT MARKET ZCRM 0000001001 0000600000 12. CYCLE OEM CUSTOMERS ZCOE 0000801001 0000899999 23. PRODUCT SCRAP DEALERS ZSRP 0000601001 0000699999 34. CYCLE OTHER DEALER ZCOT 0000701001 0000799999 45. DIRECT EXPORTS ZCDE 0000901001 0000901999 56. INDIRECT EXPORTS ZCIE 0000902001 0000902999 67. CYCLE ACCESSORY CUSTOMER

ZCAC 0000903001 0000909999 7

8. CYCLE OTHER MATERIAL ZCOM 0000910001 0000910999 8

RASO Rockman Auto CODE From To1. AUTO REPLACEMENT MARKET ZARM 0000920000 0000929999 92. AUTO OEM CUSTOMERS ZAOE 0000930000 0000939999 10One time customer ZOTC 0000000001 0000000009 11

Common DivisionCommon division will only be created for maintaining Customer Master and not for Condition Master because there is a need of having different pricing for different divisions.

Sales Org.

Div Div Cond. Div Cust.

RASO AC AC CDRASO AH AH CDRASO AS AS ASRASO CD CD CD

RCSO CC CC CDRCSO CD CD CD

Page 13 of 69

Page 14: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

RCSO CH CH CDRCSO OM OM OMRCSO CS CS CSRCSO SP SP CD

Create Customer Group

Customer Group

Name

1 Retail2 Industr

y

Create Sales DistrictRCIL has Seven head offices led by respective District Head. These have been defined as following Sales District in the system.

Sales District District Name

Z001 Mr. Rupam Gupta Ludhiana head officeZ002 Mr. Y.S. Upadhyay Mumbai head officeZ003 Mr. N.K.Bhardwaj Delhi head officeZ004 Mr. Rahul Sahrama Chennai head officeZ005 Mr. Biman Banerjee Kolkota head officeZ006 Mr. Praveen Sharma Patna Head OfficeZ015 RCIL RCIL

10 Create Delivery Priorities

DELIVERY PRIRORITY

DESCRIPTION

1 HIGH2 NORMAL3 LOW

11 Create Terms of Payment RCIL will use following terms of payment which may be changed at the order level. For export there are different payment terms which will be handled manually as text.

Page 14 of 69

Page 15: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

So the payment term field in the incompletion porcedure will be deleted for export order ZXOR.

RC01 RC02 RC03 RC04

Sales Text Rockman P1 Rockman P2 Rockman P3

Own Explanation

Advance / POD

Advance / POD

Day LimitFixed Day Additional Months

According to transit time

Default for Baseline Date

Document date

Document date Posting date

Terms 1 1 1, 2 , 3% 2% , NIL 3% , NIL 1.5% , 1%

NILNo. of days 0 , 45 0 , 45 15 , 30 , 301213 Create Incoterms

INCOTERMS DESCRIPTION DESTINATION MANDATORY

CNF COST INSURANCE AND FREIGHT

ATT ADVANCE TTFOB FREE ON BOARDCFR COST AND FREIGHTCIF COST, INSURANCE , FREIGHTFOC FREE OF COSTEXW FROM PLANT

14 PRICING

Maintain Condition TypesFollowing condition types will be made other than standard

Condition Types for Pricing

CR00 Price Prices QuantityADVP Advance Price Fixed

Page 15 of 69

Page 16: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

amountADED Advance to be

DeductedPrice Fixed

amountADVD Advance Discount Discount or

surchargePercentage

AR00 Price Prices QuantityDISC Scheme Discount Discount or

surchargeQuantity

CREB Customer Rebate Expense reimbursement

Percentage

MGRB Material Group Rebate

Expense reimbursement

Quantity

MREB Material Rebate Expense reimbursement

Quantity

PBAL Previous Balance Price Fixed amount

ZCES Cess On Scrap Discount or surcharge

Percentage

ZTCS Tax Collected source Taxes PercentageZSTC Surch.on tax collect Taxes PercentageFPAY Freight TO PAY Freight Fixed

amountFPAD Freight PAID Freight Fixed

amount

15 Maintain Access Sequence Following Access sequence will be made for the corrosponding Condition Types.

Access Seq

Tables Description Condition Type

Exclusive

CR00 305 Customer/Material

CR00 Yes

CR00 4 Material CR00

AR00 305 Customer/Material

AR00

AR00 4 Material AR00

UTXJ 2 Domestic Taxes

UTXJ

JCED 350 Sales JCEDPage 16 of 69

Page 17: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

OrganizationJECX 350 Sales

OrganizationJECX

Page 17 of 69

Page 18: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Maintain Pricing Procedures

AOEM01

NEW Auto OEM and RM Pricing Procedure

STEP CNTR C TYPE

DESCRIPTION FRO TO MAN

MDT

STAT

PRI

SUB

REQT

ALT CTYP

E

ALT CBV

ACT KEY

ACCRL

100 0 AR00 Price yes X 1 ERL200 0 JMAN IN Manual excise 100 19

0yes

300 0 UTXJ Tax Jurisdict.Code 100 190

yes 352 351

350 0 JMOD IN A/R BED 100 yes yes S D 355375 0 Base prices 100 19

0yes

400 0 JEX2 IN A/R BED 350 2 353 EXD475 0 Base prices + BED 375 40

0yes

550 0 JCES IN A/R CESS 350 yes yes S H575 0 Base + BED 475 54

0yes

600 0 JCED IN A/R CESS 550 6 353 EXD625 0 Base + BED+cess 575 60

0yes

720 0 JIN1 IN A/R CST 625 yes yes S740 0 JIN2 IN A/R LST 625 yes yes S760 0 JIN4 IN A/R Surcharge 720 yes yes S770 0 JIN5 IN A/R LST Surchrg 740 yes yes S775 0 Price + taxes 625 77 yes S

Page 18 of 69

Page 19: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

0780 0 DIFF Rounding Off

yes S 13 16 4 ROF

790 0 Total price 775 780

yes S

ASCRAP NEW Auto Scrap Procedure

STEP CNTR C TYPE

DESCRIPTION FRO TO MAN

MDT

STAT

PRI

SUB

REQT

ALT CTYP

E

ALT CBV

ACT KEY

ACCRL

100 0 AR00 Price Yes X 1 2 ERL200 0 JMAN IN Manual excise 100 19

0Yes

300 0 UTXJ Tax Jurisdict.Code 100 190

Yes S 352 351

350 0 JMOD IN A/R BED 100 Yes Yes S D 355375 0 Base prices 100 19

0Yes

400 0 JEX2 IN A/R BED 350 2 353 EXD475 0 Base prices + BED 375 40

0Yes

550 0 JCES IN A/R CESS 350 Yes Yes S H575 0 Base + BED 475 54

0Yes

600 0 JCED IN A/R CESS 550 6 353 EXD625 0 Base + BED+cess 575 60

0Yes

720 0 JIN1 IN A/R CST 625 Yes Yes S740 0 JIN2 IN A/R LST 625 Yes Yes S760 0 JIN4 IN A/R Surcharge 720 Yes Yes S770 0 JIN5 IN A/R LST Surchrg 740 Yes Yes S

Page 19 of 69

Page 20: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

625 770

Yes S

780 0 ZTCS Tax Collected source 775 S TCS785 0 ZSTC Surch.on tax collect 780 S STC790 0 775 78

5795 0 ZCES IN A/R CESS 780 78

5S CES

800 0 790 795

810 0 DIFF Rounding Off Yes S 13 16 4 ROF820 0 Total Payable 800 81

0

CYRM01

NEW Cycle RM Pricing Procedure

STEP CNTR C TYPE

DESCRIPTION FRO TO MAN

MDT

STAT

PRI

SUB

REQT

ALT CTYP

E

ALT CBV

ACT KEY

ACCRL

11 0 CR00 Price Yes X 2 ERL15 0 UTXJ Tax Jurisdict.Code 11 Yes 352 35120 0 ADVP Advance Payment Yes Yes S25 0 Base Value 1130 0 ADVD Advance Discount 20 Yes S DOA35 0 DISC Scheme Discount40 0 Net value for tax 25 35 S45 0 rebate basis 40 750 0 MGRB Mat/Group Rebate 45 24 ERB ERU55 0 MREB Material Rebate 45 24 ERB ERU60 0 CREB Customer Rebate 45 24 ERB ERU

Page 20 of 69

Page 21: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

70 0 Net value for tax 40100 0 JIN1 IN A/R CST 70 Yes Yes S110 0 JIN2 IN A/R LST 70 Yes Yes S120 0 JIN4 IN A/R Surcharge 100 Yes Yes S130 0 JIN5 IN A/R LST Surchrg 110 Yes Yes S131 0 Net Value 70 13

0135 0 DIFF Rounding Off Yes S 13 16 4 ROG160 0 FPAY Freight TO PAY Yes S ERF170 0 ADED Adv to be deducted Yes S180 0 This Bill Amount 131 17

0Yes S

185 0 PBAL Previous Balance Yes Yes200 0 Total Payable Amount 180 18

5S

210 0 SKTO Cash Discount Yes 9 11220 0 FPAD Freight PAID Yes Yes ERF

COEM01

NEW Cycle OEM Pricing Procedure

STEP CNTR C TYPE

DESCRIPTION FRO TO MAN

MDT

STAT

PRI

SUB

REQT

ALT CTYP

E

ALT CBV

ACT KEY

ACCRL

11 0 CR00 Price Yes X 2 ERL15 0 UTXJ Tax Jurisdict.Code 11 Yes 352 35120 0 Net value for tax 11

Page 21 of 69

Page 22: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

100 0 JIN1 IN A/R CST 19 Yes Yes S110 0 JIN2 IN A/R LST 19 Yes Yes S120 0 JIN4 IN A/R Surcharge 100 Yes Yes S130 0 JIN5 IN A/R LST Surchrg 110 Yes Yes S131 0 Net Value 20 13

0135 0 DIFF Rounding Off Yes S 13 16 4 ERS

CSCRAP NEW Cycle Scrap Pricing Procedure

STEP CNTR C TYPE

DESCRIPTION FRO TO MAN

MDT

STAT

PRI

SUB

REQT

ALT CTYP

E

ALT CBV

ACT KEY

ACCRL

11 0 CR00 Price Yes X 2 ERL15 0 UTXJ Tax Jurisdict.Code 11 Yes 352 35120 0 11

100 0 JIN1 IN A/R CST 11 Yes Yes S110 0 JIN2 IN A/R LST 11 Yes Yes S120 0 JIN4 IN A/R Surcharge 100 Yes Yes S130 0 JIN5 IN A/R LST Surchrg 110 Yes Yes S131 0 Net Value 20 13

0135 0 ZTCS Tax Collected source 131 S TCS140 0 ZSTC Surch.on tax collect 135 S STC150 0 131 14

0160 0 ZCES IN A/R CESS 135 14

0S CES

165 0 DIFF Rounding Off Yes 13 16 4 ROF

Page 22 of 69

Page 23: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

170 0 Total Payable Amount 150 160

S

COTHER

NEW Cycle Other Pricing Procedure

STEP CNTR C TYPE

DESCRIPTION FRO TO MAN

MDT

STAT

PRI

SUB

REQT

ALT CTYP

E

ALT CBV

ACT KEY

ACCRL

11 0 CR00 Price Yes X 2 ERL15 0 UTXJ Tax Jurisdict.Code 11 352 35120 0 Net Value for Tax 11

100 0 JIN1 IN A/R CST 20 Yes Yes S110 0 JIN2 IN A/R LST 20 Yes Yes S120 0 JIN4 IN A/R Surcharge 100 Yes Yes S130 0 JIN5 IN A/R LST Surchrg 110 Yes Yes S131 0 Net Value 20 13

0165 0 DIFF Rounding Off Yes 13 16 4 ROF170 0 Total Payable Amount 131 16

5S

CEXP01 NEW Cycle Dir/InDir Export Pric Proc

STEP CNTR C TYPE

DESCRIPTION FRO TO MAN

MDT

STAT

PRI

SUB

REQT

ALT CTYP

E

ALT CBV

ACT KEY

ACCRL

Page 23 of 69

Page 24: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

11 0 CR00 Price X 2 ERL15 0 UTXJ 11 Yes 352 35120 Gross Price 11

Page 24 of 69

Page 25: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Assign Pricing Procedure

Assign Pricing Procedure

Sales Org

DC DIV Do PR

Cu PP

Pri Pro C Type

RASO AO AC A 1 AOEM01 AR00RASO AO AH A 1 AOEM01 AR00RASO AO CD A 1 AOEM01 AR00RASO AR AC A 1 AOEM01 AR00RASO AR AH A 1 AOEM01 AR00RASO AR CD A 1 AOEM01 AR00RASO AS AS A 1 ASCRAP AR00

RCSO CI CC A 1 CEXP01 CR00RCSO CI CD A 1 CEXP01 CR00RCSO CI CH A 1 CEXP01 CR00RCSO CE CC A 1 CEXP01 CR00RCSO CE CD A 1 CEXP01 CR00RCSO CE CH A 1 CEXP01 CR00RCSO CG CC A 1 COEM01 CR00RCSO CG CD A 1 COEM01 CR00RCSO CG CH A 1 COEM01 CR00RCSO OM OM A 1 COTHER CR00RCSO CR CC A 1 CYRM01 CR00RCSO CR CD A 1 CYRM01 CR00RCSO CR CH A 1 CYRM01 CR00RCSO CS CS A 1 CSCRAP CR00

Maintain Price Relevant Master Data field

16 Maintain Price List type Price list type groups are to be maintained for Replacement market because at the time of rebate settlement this field is in the incompletion procedure for rebate credit memo request.

Page 25 of 69

Page 26: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Price List Type

Description

1 Wholesale2 Retail

17 Maintain Material Price Group This data has to maintained for Cycle Plant only because the sales deal can be given on the material groups.

Mat. Price Group

Description

CC Cycle chain

CH Cycle hub

18 Maintain Promotion and Sales Deal

1) RCSO normally comes up with Promotion / Sales Deal for there customers. No provision of sales deal in RASO.

2) This deal is valid for certain time period.3) Scales are also maintained in this deal.4) Normally they use discount and keep the price same. So we will keep only

discount condition type in the sales deal and will not maintain any other condition type.

5) The deal can be same for all the products in the both the divisions namely CC and CH or it can vary with the product.

6) If the deal is same for all the products in one division then we will create material price group and put that in MMR. The relevant condition table is 029. We will assign this table to access sequence DISC ( K004 ) and then make the valid records in VK11.

7) If the deal is different for the all the products ( material specific ) then we will maintain material specific discount. Condition table 004.

8) We have to make provision for both types of discount. We have to assign condition tables 004 and 029 in access sequence DISC ( K004 ).

9) In IMG we have to assign condition tables sales deal type RCSP ( Rockaman Cycle Sales Promotion ) to DISC ( K004 ) and condition tables 004, 029.

10) To maintain material price group in IMG we have to go to Pricng contol and then Maintain Price Relevant Master Data. There we will make two groups 01 for cycle chain and 02 for cycle hub.

Page 26 of 69

Page 27: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

11) Customise the Promotion type RCSP Rockman Cycle Sales Promotion RCSD Rockman Sycle Sales Deal. With No. ranges for both Sales deal and promotion. Give internal no. range.

19 Maintain No range for Promotion and Sales Deal No. ranges for Promotions, Sales Deal and Rebates will be different in order to track the respective document.

Descrip.

From To

RCSP 100001 199999RCSD 200001 299999

Maintain Condition Type Group ROCK and assign the sales deal type RCSD to this group. Assign condition types CR00 and K004 with this group. 202122 Maintain Taxes

RCIL will maintain one tax type UTXJ which will trigger the appropriate tax calculation according to the key Maintained in Customer Master and Material Master records.

Define Tax Determination Rule

Tax Country Tax Category

IN UTXJ

Assing Delivering Plants to Tax Determination

Plant A000 C000

Name 1 Rockman Cycle Industries Limit

Rockman Cycle Industries Limit

Name 2 Auto Component Plant Cycle Components PlantLanguage EN EN

House no/street A-7 Focal Point A-7 Focal PointPO Box

Post.Code 141010 141010City Ludhiana Ludhiana

country IN IN

Page 27 of 69

Page 28: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

NameRegion 19 19

Company CodeCity code

Juridiction code IN00 IN00Factory

CalendarRockman Calendar Rockman Calendar

Define Tax Relevancy Of Master Record

23 CUSTOMERFor customer we will maintain the following Tax Class so as to determine different tax codes in VK11 for UTXJ

Tax Category Tax Class for UTXJUTXJ Tax

Jurisdict.CodeA Reg Auto in PB

UTXJ Tax Jurisdict.Code

B Reg Auto out PB

UTXJ Tax Jurisdict.Code

C Reg Auto Scrap in PB

UTXJ Tax Jurisdict.Code

D Reg Auto Scrp out PB

UTXJ Tax Jurisdict.Code

E UnRg Auto Scrp in PB

UTXJ Tax Jurisdict.Code

F UnRg Auto Scrp out P

UTXJ Tax Jurisdict.Code

G Reg Cycle In PB

UTXJ Tax Jurisdict.Code

H Reg Cycle out PB

UTXJ Tax Jurisdict.Code

I UnReg Cycle In PB

UTXJ Tax Jurisdict.Code

J UnReg Cycle out PB

UTXJ Tax Jurisdict.Code

K Reg Cycle Scrap In P

UTXJ Tax Jurisdict.Code

L Reg Cycle Scrp out P

UTXJ Tax Jurisdict.Code

M UnReg Cyle Scrp In P

UTXJ Tax Jurisdict.Code

N UnRg Cyle Scrp out P

UTXJ Tax O Reg Other In PB

Page 28 of 69

Page 29: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Jurisdict.CodeUTXJ Tax

Jurisdict.CodeP Reg Other out PB

UTXJ Tax Jurisdict.Code

Q UnReg Other in PB

UTXJ Tax Jurisdict.Code

R UnReg Other out PB

UTXJ Tax Jurisdict.Code

S Export Sale

UTXJ Tax Jurisdict.Code

T Nepal Sale

24 MATERIALAll the materials in RCIL are liable for tax

Tax Category Tax Class

Description

UTXJ 1 Full Tax

Info record for UTXJ for Tax Code determinationThis will be done in VK11

Tax Clas Of Cust Tax Clas Of Mat

Amount Tax Code

A Reg Auto in PB 1 Full Tax

100 51

B Reg Auto out PB 1 Full Tax

100 52

C Reg Auto Scrap in PB 1 Full Tax

100 51

D Reg Auto Scrap out PB

1 Full Tax

100 51

E UnReg Auto Scrap in PB

1 Full Tax

100 51

F UnReg Auto Scrap out PB

1 Full Tax

100 51

G Reg Cycle In PB 1 Full Tax

100 51

H Reg Cycle out PB 1 Full Tax

100 53

Page 29 of 69

Page 30: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

I UnReg Cycle In PB Full 54

J UnReg Cycle out PB 1 Full Tax

100 55

K Reg Cycle Scrap In PB 1 Full Tax

100 51

L Reg Cycle Scrap out PB

1 Full Tax

100 53

M UnReg Cycle Scrap In PB

1 Full Tax

100 56

N UnReg Cycle Scrap out PB

1 Full Tax

100 55

O Reg Other Scrap In PB 1 Full Tax

100 51

P Reg Other Scrap out PB

1 Full Tax

100 53

Q UnReg Scrap Other in PB

1 Full Tax

100 51

R UnReg Scrap Other out PB

1 Full Tax

100 51

S Export Sale 1 Full Tax

100 51

T Nepal Sale 1 Full Tax

100 51

There are no customers for red colour customer classification at the moment. But a provision has been kept for the future.

Maintain Revenue Account DeterminationAs per requirement of the RCIL the sale has to be grouped according to certain category. The sale value has to go to different G/L accounts assigned to relevant Category.

Account Assignment Group of Material

Account Assignment

Group

Description

CC Cycle ChainCH Cycle HubAC Auto ChainAH Auto HubS1 Auto Chain ScrapS2 Auto Hub ScrapS3 Cycle Chain Scrap

Page 30 of 69

Page 31: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

S4OM Other MaterialLC Labour Charges

Account Assingment Group of Customer

Account Assignment

Group

Description

A1 Reg Auto in PBA2 Reg Auto out PBA3 Reg Auto Scrap in PBA4 Reg Auto Scrap out PBA5 UnReg Auto Scrap in PBA6 UnReg Auto Scrap out PBC1 Reg Cycle In PBC2 Reg Cycle out PBC3 UnReg Cycle In PBC4 UnReg Cycle out PBC5 Reg Cycle Scrap In PBC6 Reg Cycle Scrap out PBC7 UnReg Cycle Scrap In PBC8 UnReg Cycle Scrap out

PBO1 Reg Other In PBO2 Reg Other out PBO3 UnReg Other in PBO4 UnReg Other out PBES Export SaleNS Nepal Sale

Define Account KeysFollowing account keys has to be maintained `Account

KeyDescription

ERL Sales RevenueERS Sales Deduction ( Sales

Deal )ERF FreightERB Rebate

Page 31 of 69

Page 32: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

ERUEXD ExciseTCS Tax Collected At SourceSTC Surcharge on TCSCES Cess on TCS+STCDOA Discount on AdvanceROF Rounding Off

Assign G/L AccountsThe G/L account assignment will be done on the following two levels.

Customer acc ass grp / Material acc ass grp / Account KeyHere the Sales Revenue G/L Accounts will be assigned ( ERL )

NEED TO GET 4 MORE G/L ACCOUNTS FROM SHYAM FOR OTHER DEALER SALE

Application

Condition Type

Chat Of Accounts

Sales Org

AAC

AAM

Account Key

G/L Accounts

G/L Accounts

G/L Description

Nepal SaleV KOFI RCIL RCSO NS CC ERL 1 Nepal CC saleV KOFI RCIL RCSO NS CH ERL 2 Nepal CH sale

Export Sale

V KOFI RCIL RCSO ES CC ERL 7 Export CC SaleV KOFI RCIL RCSO ES CH ERL 8 Export CH sale

Cycle Standard Sale

V KOFI RCIL RCSO C1 CC ERL 15 Reg CC in PBV KOFI RCIL RCSO C1 CH ERL 16 Reg CH in PBV KOFI RCIL RCSO C2 CC ERL 17 Reg CC Out PBV KOFI RCIL RCSO C2 CH ERL 18 Reg CH Out PBV KOFI RCIL RCSO C3 CC ERL 19 UnReg CC in PBV KOFI RCIL RCSO C3 CH ERL 20 UnReg CH in PBV KOFI RCIL RCSO C4 CC ERL 21 UnReg CC Out PBV KOFI RCIL RCSO C4 CH ERL 22 UnReg CH Out PB

Page 32 of 69

Page 33: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Cycle Scrap ( Hub / Chain )

V KOFI RCIL RCSO C5 S3 ERL 35 Reg CC Scrap in PBV KOFI RCIL RCSO C5 S4 ERL 36 Reg CH Scrap in PBV KOFI RCIL RCSO C6 S3 ERL 37 Reg CC Scrap outPBV KOFI RCIL RCSO C6 S4 ERL 38 Reg CH Scrap

outPBV KOFI RCIL RCSO C7 S3 ERL 39 UnReg CC Scrap in

PBV KOFI RCIL RCSO C7 S4 ERL 40 UnReg CH Scrap in

PBV KOFI RCIL RCSO C8 S3 ERL 41 UnReg CC Scrap

outPBV KOFI RCIL RCSO C8 S4 ERL 42 UnReg CH Scrap

outPB

Other Sale Auto / Cycle

V KOFI RCIL RCSO O1 OT ERL 45 Reg Other in PBV KOFI RCIL RCSO O2 OT ERL 46 Reg Other out PBV KOFI RCIL RCSO O3 OT ERL 47 UnReg Other in PBV KOFI RCIL RCSO O4 OT ERL 48 UnReg Other out PB

Auto Standard Sale

V KOFI RCIL RASO A1 AC ERL 51 Reg AC in PBV KOFI RCIL RASO A1 AH ERL 52 Reg AH in PBV KOFI RCIL RASO A2 AC ERL 53 Reg AC Out PBV KOFI RCIL RASO A2 AH ERL 54 Reg AH Out PB

Auto Scrap ( Hub / Chain )

V KOFI RCIL RASO A3 S1 ERL 57 Reg AC Scrap in PBV KOFI RCIL RASO A3 S2 ERL 58 Reg AH Scrap in PBV KOFI RCIL RASO A4 S1 ERL 59 Reg AC Scrap out

PBV KOFI RCIL RASO A4 S2 ERL 60 Reg AH Scrap out

PBV KOFI RCIL RASO A5 S1 ERL 61 UnReg AC Scrap in

PBV KOFI RCIL RASO A5 S2 ERL 62 UnReg AH Scrap in

PBV KOFI RCIL RASO A6 S1 ERL 63 UnReg AC Scrap out

PBV KOFI RCIL RASO A6 S2 ERL 64 UnReg AH Scrap

out PB

Page 33 of 69

Page 34: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Service V KOFI RCIL RCSO SP LC ERL 67 Service Labour

charges

Account KeyHere following G/L Accounts will be assignedERS, ERF, ERB, ERU, EXD, TCS, STC, CES, ROF

Application

Condition Type

Chat Of Accounts

Sales Org

Account Key

G/L Accounts

G/L Accounts

G/L Description

V KOFI RCIL RASO DOA 1106

Discount on Advance

V KOFI RCIL RASO EXD 14058

Basic Exise Duty

V KOFI RCIL RASO TCS 14068

Tax Collected at Source

V KOFI RCIL RASO STC 14069

Surcharge on TCS

V KOFI RCIL RASO CES 14070

E Cess on TCS + STC

V KOFI RCIL RASO ROF 1117

Rounding Off

V KOFI RCIL RCSO ERS 1113

Sales Deduction Sales Deal

V KOFI RCIL RCSO ERB 1100

Rebate

V KOFI RCIL RCSO ERU 1098

1099

Rebate Accrual

V KOFI RCIL RCSO ERF 1111

Freight

V KOFI RCIL RCSO TCS 14071

Tax Collected at Source

V KOFI RCIL RCSO STC 14072

Surcharge on TCS

V KOFI RCIL RCSO CES 14073

E Cess on TCS + STC

V KOFI RCIL RCSO ROF 1117

Rounding Off

Page 34 of 69

Page 35: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Maintain Availability Check and Transfer of RequirementDefault values are used

Maintain Delivery Scheduling and Transportation PlanningDefault values are used

Maintain Output Control

Output type RD03 for Cash sale has to be maintained and the Output Procedure has to be assigned to ZCCS ( Cycle Cash Sale ) document.

Delivery Output LD00 ( as Gate Pass ) for Cycle Plant Commercial Invoice RD00 for Cycle Plant Commercial Invoice RD10 for Auto Plant Gate Pass and Van Loading Slip for Auto has been developed. Packing List FJEP for Export. Proforma Invoice FUPI for Export Commercial Invoice FUCI for Export.

Output Type Output Dter. Proc

Assign Doc. Type

AF00 Inquiry V05000AN00 Quotation

V06000

BA00 Order V10000KO00 Contract V08000LP00 Sche. Agree

V10001

RD03 Cash Sale

V07000

LD00PL00

Delivery output

RD00 Invoice V10000

Following steps has to be performed for output determination 1) Maintain the required output type 2) Assign them to the relevant output procedure3) Assign procedure to the relevant document type4) Define print parameters for the sales, billing and shipping ( shipping will be

done in logistic general ) and assign ouput device LP01Page 35 of 69

Page 36: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Handling unit has to be maintained for packaging material for export

Maintain Partner DeterminationDefault values are usedThe partner functions SH, SP, BP, PY are to be assigned to all the defined account groups

Partner Function

Name Account Group

Name

SH Ship-to party ZARM SP Replacement Market

BP Bill-to party ZARM SP Replacement Market

PY Payer ZARM SP Replacement Market

SP Sold-to party ZARM SP Replacement Market

SH Ship-to party ZAOE SP OEMBP Bill-to party ZAOE SP OEMPY Payer ZAOE SP OEMSP Sold-to party ZAOE SP OEMSH Ship-to party ZCOM SP Other MaterialBP Bill-to party ZCOM SP Other MaterialPY Payer ZCOM SP Other MaterialSP Sold-to party ZCOM SP Other MaterialSH Ship-to party ZOTC One-time cust.BP Bill-to party ZOTC One-time cust.PY Payer ZOTC One-time cust.SP Sold-to party ZOTC One-time cust.SH Ship-to party ZCAC SP Accesssory

customerBP Bill-to party ZCAC SP Accesssory

customerPY Payer ZCAC SP Accesssory

customerSP Sold-to party ZCAC SP Accesssory

customerSH Ship-to party ZCDE SP Direct ExportBP Bill-to party ZCDE SP Direct Export

Page 36 of 69

Page 37: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

PY PayerSP Sold-to party ZCDE SP Direct ExportSH Ship-to party ZCIE SP Indirect ExportBP Bill-to party ZCIE SP Indirect ExportPY Payer ZCIE SP Indirect ExportSP Sold-to party ZCIE SP Indirect ExportSH Ship-to party ZCOE SP OEMBP Bill-to party ZCOE SP OEMPY Payer ZCOE SP OEMSP Sold-to party ZCOE SP OEMSH Ship-to party ZCOT SP Other DealerBP Bill-to party ZCOT SP Other DealerPY Payer ZCOT SP Other DealerSP Sold-to party ZCOT SP Other DealerSH Ship-to party ZCRM SP Replacement

MarketBP Bill-to party ZCRM SP Replacement

MarketPY Payer ZCRM SP Replacement

MarketSP Sold-to party ZCRM SP Replacement

MarketSH Ship-to party ZSRP SP Scrap DealerBP Bill-to party ZSRP SP Scrap DealerPY Payer ZSRP SP Scrap DealerSP Sold-to party ZSRP SP Scrap Dealer

Maintain Text ProcedureDefault values are used

Maintain Log of Incomplete ItemsDefault values are used check what fields they do not require for incompletion log. this will be done when the format for data uploading will be given Payment Terms field has to be removed from the incompletion log

for export sale

Maintain Credit Management 24.124.2 Simple credit limit check

A credit limit check can be carried out when sales documents are created or changed. The check is carried out within one credit control area. When

Page 37 of 69

Page 38: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

changing a document, the check is repeated if changes regarding quantity or value are made. A credit control area consists of one or more company codes. A sales document belongs to one credit control area depending on the allocation of the sales organization to a company code. The SAP System checks the credit limit, which was granted to the customer in this credit control area. The credit control areas and the credit limit of a customer are defined in financial accounting and entered in the customer master record. During the check, the SAP System totals the receivables, the open items from special G/L transactions and the net value of the sales order for every item of sales document. The open items take into account obligations bound by contract which are not recorded for accounting purposes but which involve expenses through diverse business transactions. The total is compared with the credit limit. If the limit is exceeded, the system responds in the way defined by you in the configuration menu.

No credit limit checkA Run simple credit limit check and warning messageB Run simple credit limit check and error messageC Run simple credit limit check and delivery blockD Credit management:Automatic credit control

1) In FD32 manage the customer credit limit and other details.2) For releasing a blocked document against credit go to VKM4.

Foreign Trade Data

Define Comodity codes

Country Comodity Code

Description

IN 111.11 Export codeIN 1617.1 Export code

Define Business Transaction types and default values

Business Transaction types

Country Business Transaction Type

Description

IN 1 Import Auto

Page 38 of 69

Page 39: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Default Business Type

Country

Sales Org

DC Description Item Cat Description

Transaction type

IN RCSO CE Cycle D Export

TAN Standard Item

99

Define Procedure and Default Value

Country Procedure Description Export Import

IN STDEXP Export Procedue RCIL

Warning

Warning

Transportation Data

Define Custome Office

Country Custom office

Description

IN SE1000 Custom Office Gujrat

Modes of transport

Country Mode of Trans

Description

IN 1 SeaIN 2 RailIN 3 RoadIN 4 Air

Maintain Sales Document Types

25 Only internal no range is required The serial no has to be filled in for internal no assignment for relevant sales doc type.The current no for Auto Plant has to be matched with RCIL legacy No. on the GO LIVE date this is because of Excise rules.

Page 39 of 69

Page 40: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Sales Document

TypeNumber

S No.

From ToAuto

ZAIN AUTO Inquiry 0000310001 0000320000

01

ZAQT AUTO Quotation 0000320001 0000330000

02

ZAOR AUTO Standard Order 0000330001 0000340000

03

ZARE AUTO Sales Returns 0000340001 0000350000

04

ZALZ AUTO Sch. Agreement 0000350001 0000360000

05

ZACR Credit Memo Request 0000360001 0000370000

06

ZADR Debit Memo Request 0000370001 0000380000

07

ZALA Ret.Packaging Pickup 0000380001 0000385000

08

ZAQC AUTO Scrap Contract 0000390001 0000399999

09

ZAFD AUTO Del Free of Charge

0000400001 0000499999

10

Cycle

ZCIN Cycle Inquiry 0007000101 0007001000

11

ZCQT Cycle Quotation 0007001001 0007005000

12

ZCOR CYCLE Standard Order 0000020001 0000040000

13

ZCSS Cycle Scrap Sale 0000040001 0000050000

14

ZCRE CYCLE Sales Returns 0000050001 0000055000

15

ZCCS CYCLE Cash Sale 0000055001 0000060000

16

ZCCR CYCLE Return to Customer

0000060001 0000065000

17

ZCQC CYCLE Qty. Contract 0000065001 0000070000

18

ZCFD CYCLE Del Free of Charge

0000070001 0000075000

19

Page 40 of 69

Page 41: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

ZCSA CYCLE Sch Aggreement

0000080000

20

ZCCM CYCLE CR. Memo Req 0000080001 0000085000

21

ZCDM CYCLE Debit Memo Req

0000085001 0000090000

22

ZCB1 CYCLE Reb.Cr Mem Req.

0000090001 0000095000

23

ZCB2 CYCLE Reb Correctn Rq

0000095001 0000099999

24

Export

ZXIN EXPORT Inquiry 0000200001 0000220000

25

ZXQT EXPORT Quotation 0000220001 0000240000

26

ZXOR EXPORT Sales Order 0000240001 0000250000

27

ZXQC Export Quantity Contract

0080010001 0080020000

28

ZXSA EXPORT Sch Aggreement

0080020001 0080030000

29

Define Order Reason Default values are used

Assign Sales Area to Sales Document TpyeNot all Documents can be used in all the sales areas. Documents relevant to there respective sales area are assigned here.

Reference Sales Organization

S Org Ref. S Org

RASO Auto Sales Organisat

RASO Auto Sales Organisat

RCSO Cycle Sales Organisa

RCSO Cycle Sales Organisa

Page 41 of 69

Page 42: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Reference Distribution Channel

S Org DC Ref DC

RASO AO Auto OEM AO Auto OEMRASO AR Auto RM AO Auto OEMRASO AS Auto Scrap AS Auto ScrapRCSO CE Cycle D Export CE Cycle D ExportRCSO CI Cycle I Export CE Cycle D ExportRCSO CG Cycle OEM CG Cycle OEMRCSO CR Cycle RM CG Cycle OEMRCSO OM Cycle Other

MatOM Cycle Other Mat

RCSO CS Cycle Scrap CS Cycle Scrap

Reference Division

S Org DIV Ref DIV

RASO AC Auto Chain AC Common DivisionRASO AH Auto Hub AH Auto HubRASO AS Auto Scrap AS Auto ScrapRASO CD Common Division CD Common DivisionRCSO CC Cycle Chain CC Cycle ChainRCSO CD Common Division CD Common DivisionRCSO CH Cycle Hub CH Cycle HubRCSO OM Cycle Other Mat OM Cycle Other MatRCSO CS Cycle Scrap CS Cycle ScrapRCSO SP Service Product SP Service Product

Assign Sales Document

Ref Sorg

Ref DC Div S Doc TP

RASO AO CD ZAINRASO AO CD ZAQTRASO AO CD ZAORRASO AO CD ZARERASO AO CD ZALZRASO AO CD ZADRRASO AO CD ZACR

Page 42 of 69

Page 43: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

RASO AO CD ZALARASO AO CD ZAFDRASO AO CD ZALNRASO AS AS ZAORRASO AS AS ZADRRASO AS AS ZACRRASO AS AS ZARERASO AS AS ZAQCRCSO CE CD ZXINRCSO CE CD ZXQTRCSO CE CD ZXORRCSO CE CD ZXQCRCSO CE CD ZXSARCSO CG CD ZCINRCSO CG CD ZCQTRCSO CG CD ZCORRCSO CG CD ZCRERCSO CG CD ZCCSRCSO CG CD ZCRCRCSO CG CD ZCQCRCSO CG CD ZCFDRCSO CG CD ZCSARCSO CG CD ZCCRRCSO CG CD ZCDRRCSO CG CD ZCB1RCSO CG CD ZCB2RCSO OM OM ZCORRCSO OM OM ZCQCRCSO OM OM ZCRERCSO OM OM ZCCSRCSO OM OM ZCCRRCSO OM OM ZCDRRCSO CS CS ZCQCRCSO CS CS ZCRERCSO CS CS ZCCRRCSO CS CS ZCDRRCSO CS CS ZCOR

Maintain Item Categories and relevant functionsDefault values are used

In case of cycle return sale a delivery free of charge ( sales document type ) will be created in which repair cost will also be added as service product along with the standard product which

Page 43 of 69

Page 44: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

was returned for repair. This service product will have a cost and will be billed. For this we have to make a item category assignment with this sales docment and make that item category relevant for billing ( without delivery ).

There will be two line items in the order type ( Return to customer) subsequent free of charge delivery. One would be the standard item which had come for repair and the other is the service item. The standard item will be relevant for delivery but not for pricing and billing. The service item will be relevant for pricing, billing and will go to delivery as value item. Copy item category KLX to ZLX make it price, billing relevant.

Assign ZCCR – DEIN – XXXX – XXX – ZLX

This is how system will be able to deliver the service material

Make the Delivery Item Category HUPM as not relevant for Pricing and Billing. You can also make two documents. One for delivery of the return product ( for repair ) which is not relevant for billing. And then make a new standard order with the service product which is not relevant for delivery but relevant for billing. In this way they will invoice the customer for the cost incurred in repair.

Maintain Reason For RejectionDefine following reason for rejection other than standard

Packing Problem Poor Quality Other

Maintain Schdule line Categories and relevant func tions Default values are used

For retrun delivery schedule line category DN is being used with movement type 651 which post the stock to blocked stock. But it should go to Unrestricted stock. So copy DN to ZN and change the movement type 651 to 653 which will post the stock to unrestricted use stock. This change is done because this return case for repair happens in Cycle sale for OEM’s which is rare. In 651 we

Page 44 of 69

Page 45: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

have to manually transfer the goods to unrestricted use from blocked stock for PGI this extra step will be avoided if we use 653.

Maintain Contract

1) Create a new quantity contract types in IMG. ( ZCQC / ZAQC )2) Maintain copy control.3) Maintain the incompletion procedure. Create new Procedure by coying the

standard and delete the fields Net Value and Target Quantity for the procedure of item. This is done because in RCIL a contract for scrap is made with the customer before it is sold. At this time the quantity of the scrap generated is not known. So the value field has to be delete from the incompletion procedure assigned to the item category KMN. The other way for this is that don’t do any changes in the incompletion procedure rather save the document in incomplete mode and then fill the quantity at the time of selling the scrap.

4) Maintain the required fields in the incompletion procedure.5) Set the no. range for contract.

Maintain Scheduling Agreement

The scheduling criteria has been set for splitting the quantity in the agreement for 6 working days in a week ( Mon to Sat ). It has been configured that a planning delivery schedule will be created acutomatically at the time of saving the forcast delivery schedule.Maintain Planing Delivery schedule instruction

Instruction

D B T VAL P A Description

AUTO X 2 3 5 X Auto Scheduling Plan

Mainatin Delivery Schedule Split Rules

Split Rule

Mon

Tue Wed

Thur Fri Sat Sun H R Description

ROK 1 1 1 1 1 1 1 1 Rockman Spltting Rule

Assign Delivery Schedule Splitting Rules

D Range Split Rule

Description

Page 45 of 69

Page 46: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

3 7 ROK Rockman Splitting Rule

Maintain Copy Control for Sales Document

Copying Control Sales doc to Sales Doc

Target SourceZAQT ZAINZAOR ZAINZAOR ZAQTZARE ZAORZADR ZAORZACR ZAORZAOR ZAQC

ZCQT ZCINZCOR ZCINZCOR ZCQTZCRC ZCREZCRE ZCORZCOR ZCCQZCCR ZCORZCDR ZCORZCSS ZCCQ

ZXQT ZXINZXOR ZXIN ZXOR ZXQTZXOR ZXQC

Maintain Billing Types

Billing Type

Description Number Ranges

S No.

From To

Page 46 of 69

Page 47: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

AUTOZAF2 Invoice (AUTO) 0000000001 0000020000 30ZJEX Excise invoice (AUTO ) 0070025001 0070050000 31ZAG2 Credit Memo (AUTO) 0070050001 0070051000 32ZAL2 Debit Memo (AUTO) 0070051001 0070052000 33ZARE CR for Returns (Auto) 0070050001 0070051000 32ZAS2 Cancel of Cr

Mem(AUTO)0070052001 0070053000 34

CYCLEZCF2 Invoice (CYCL) 0090010001 0090040000 35ZSF2 Scrap Invoice 0090040001 0090050000 36ZCS1 Cancel. Inv (CYCL) 0090050001 0090051000 37ZCBV Cash Sale (CYCL) 0090051001 0090052000 38ZCSV Cancel Cash Sale

(CYCL)0090052001 0090053000 39

ZCB2 Rb Correction (CYCL) 0090053001 0090058000 40ZCB4 Rb Manul Acrls(CYCL) 0090058001 0090059000 41ZCG2 Credit Memo (CYCL) 0090059001 0090060000 42ZCL2 Debit Memo (CYCL) 0090060001 0090061000 43ZCB1 Rb Credit Mem (CYCL) 0090061001 0090080000 44ZCRE CR for Returns (CYCL) 0090081001 0090085000 45ZCS2 Cancel of Cr Mem(CY) 0090085001 0090090000 46ZCF5 Proforma Invoice

(CYCL)0090090001 0090099999 47

EXPORT

ZXF2 Invoice Export 0080010001 0080020000 48ZXF5 Pro Forma for Export 0000250001 0000260000 49ZXS1 Cancel Invoice 0000260001 0000270000 50

Maintain Copy Control

Copying control for Billing to Billing doc

Target SourceZAG2 ZAF2ZAL2 ZAF2

ZCG2 ZCF2

Page 47 of 69

Page 48: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

ZCL2

Copying control for Delivery to Billing doc

ZAF2 ZALFZCF2 ZCLFZXF2 ZXLFZCF8 ZCLF

Copying Control for sales doc to bill doc

ZAL2 ZADRZAG2 ZACRZARE ZARE

ZCB1 ZCB1ZCG2 ZCREZCL2 ZCDRZCRE ZCCR

Maintain Rebate Processing

Define Rebate Type For rebates the indicator should be set in CMR

Rebate Type Description

MREB Maerial RebateMGRB Material Grp/ RebateCREB Customer RebateCMRB Customer/Material

Rebate2627 No. Range

Number

From To

1 30001 39999

1) RCIL does give rebates to its customers. 2) This functionality is only in Cycle Division Replacement Market.

Page 48 of 69

Page 49: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

3) Rebate is given on the achievment of targets within specific period of time. 4) Scales are also maintianed so that the customer can get better rebate.5) It is based on the Distribution Channel.6) If the customer lifts the target qty. then he is issued a credit memo. 7) They give the money against the Credit memo and also have the practise of

adjusting that amount in the future invoices of that customer.8) They also give the retroactive rebate.9) Rebate can be on material group for which we have to create material group

and assign it to material master.10) Rebate process U have to Maintain Pricing Group in CMR

a) The rebate agreement is created first b) Fill in the sales org / distribution channel / division c) Fill in the rebate recipient and validity period.d) For each customer a different rebate agreement has to be created.e) Go to conditions and fill in the rate of rebate f) If required then maintain scales. It will be decsending scale because

discount descends if the rate value increases. – 4 % is smaller than – 3 %.g) If the total sales volume at the settlement period lies in the higher scale

then the system will calculate the rate accordingly. h) If system shows an error that the sales volume is not current then go to

VBOF and update the billing documents.i) After the validity end date the status of each agreement has to be

changed to released for settlement.j) Go to each agreement check the sales volume and the target volume and

if the customer has achieved the target then there will be no change in the rebate amount. If the target has not been achieved then the rebate amount has to be changed to zero.

k) Run VB(7 for settlement of rebate agreements. The credit memo request will be automatically generated which can be processes further.

There are several combinations of these rebates schemes which are to be mapped the detail of all these scemes has to be entered here.

Shipping

Basic Shipping FunctionsShipping point determination2829 Maintain Shipping Conditions

Ship Cond

Description

01 Rockman02 Hero

Page 49 of 69

Page 50: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

30 Define Loading Group Loading Group

Description

R001 MannualR002 Fork Lift

31 Shipping Point Determination Ship.

ConditionsLoading Group

Plant Proposed Ship. Pnt.

01 R001 A000 AUSP01 R002 A000 AUSP01 R001 C000 CYSP01 R002 C000 CYSP02 R001 C000 CYSP02 R002 C000 CYSP

This is decided not to be configures because this functionality is not being used.Route Determination

Define Routes and Stages

32 Define Routes

Route Description Transit Time Transportation Ld Time

000001 Northern route000002 southern route000003 western route000004 eastern route

33 Define Transportation Zone

Cty TranspZone Description

Page 50 of 69

Page 51: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

IN TR00000001IN TR00000002 WEST ZONEIN TR00000003 SOUTH ZONEIN TR00000004 EAST ZONE

34 Define Departure Coutnry to shipping point

ShPt Ctry DepartZone

Description Descript. Name

AUSP IN TR00000001 Auto Shipping Point NORTH ZONE IndiaCYSP IN TR00000001 Cycle Div Shipping

PointNORTH ZONE India

35 Maintain Route Determination

Incompletion ProcedureDefault values are used

Partner Determination ProcedureDefault values are used

Output Determination ProcedureDefault values are used

Text Determination ProcedureDefault values are used

Define Delivery Types

Delivery Type

Description Number Ranges

S No.

From ToAUTOZALF Outbound

Delivery0040010001 0040050000 51

ZALR Return Delivery 0040050001 0040060000 52

CYCLEZCLF Outbound

Delivery0050010001 0050050000 53

ZCLR return Delivery 0050050001 0050060000 54ZCBV Cash Sale Del. 0050060001 0050070000 55

Page 51 of 69

Page 52: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

EXPORTZXLF Export Delivery 0060010001 0060050000 56

Maintain Item Categories for Deliveries36 Use default settingsFor Returnable packaging and Standard Packaging in Auto Plant following Delivery Item Category Determination has to be done

ZALF – LEIH – PACK – TAL ZALF – VERP – PACK – HUMP

Maintain Copy Control

Copying control for Sales doc to del doc

Target Source

ZALF ZAORZALF ZALZZALR ZARE

ZCLF ZCORZCLF ZCSAZCLR ZCREZCBV ZCCSZCLR ZCRCZCLF ZCFDZCLF ZCSS

ZXLF ZXOR

Define Picking Location

Define Storage Conditions

Storage Conditions

Description

HS Hero StoreRC Rockman

Cycle

Page 52 of 69

Page 53: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

RA Rockman Auto

RS Rockman Scrap

Assign Picking Location This assignment is done because we need to have automatic storage location while processing the delivery. For scrap sales we have different customers and different storage location, for auto customers we will take the goods from finsished goods storage location, for cycle OEM and Export customers will need finished goods storage location at Rockman, for cycle RM customers goods can be sent from two storage locations finished storage location at Rockman and Hero Store storage location, for sale of cycle scrap we will use Rockman Cycle Scrap storage location. For this reason we have made four storage conditions. Cycle RM customers can be send goods form both Rockman storage location and Hero Store storage location, so if this is the case then at the time of delivery a relevant storage location has to be picked from the allowed storage locations

Storage condition is maintained in material master data in plant / storage location data 1. The automatic storage location determination is done in SPRO Logistic General. But if that is done then the system will automatically pick the storage location while making delivery ( according to the storage condition stored in Material Master ) in delivery the storage condition can not be changed so at one time a customer can be delivered goods from only one stroage location which can not be changed at the time of delivery. So storage conditions will not be maintained in the Material Master of Cycle Plant products however it will be maintained for Auto products and scrap.

Ship. Point Plant Stor. Conditions

Stor. Location

AUSP A000 RA A300AUSP A000 RS A600CYSP C000 RC C300CYSP C000 RS C600CYSP C000 HS C700

Packing The packing function is used in for Export products.

Define Packaging MaterialPage 53 of 69

Page 54: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

The Packaging Material Type combines Packaging Material into groups and contains essential control features which apply to the corresponding shipping materials.

Packaging Material Type

Description

0001 Pallets0002 Container0003 ShipTruk TruckPoly PolytheneBOX Box

Define Material Group for PKG MATDefine Material Group Packaging Material, with which materials that are to be packed intosimilar Packaging Material are grouped together. The material grouping for packaging materials is entered in the material master record of the shipping material.

Material Group for PKG MAT

Description

CHAI cycle chainROCK auto chain

packing

Define Allowed Packaging MaterialBy assigning Packaging Material Type to the Material group for packaging material, you define which packaging materials are allowed for packing.

Mat Grp PKG MAT

Description PKG MAT Type

Description

CHAI cycle chain 2 ContainerROCK auto chain

packingTRUK Truck

CINEXCISE CONFIGURATION

Page 54 of 69

Page 55: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

SPRO – LOGISTIC GENERAL – TAX ON GOODS MOVEMENTS – INDIA

BASIC SETTINGS

Maintain Excise RegistrationAn entity in India that is entitled by law to produce any goods liable to excise.Each entity is assigned its own excise registration number.Every factory that manufactures excisable goods is required to register separately, so that a business with seven factories requires seven registrations.

Exc. Reg. 2ECC No. AAACR7866EXM001Excise Reg. No. AAACR7866EXM001Excise Range V, 1536/2, NEW PREM NAGAR , LUDHIANAExcise Division CENTRAL REVENUE BUILDING , CIVIL LINES ,

LUDHIANAExcise Commissionerate

PUNJAB COMMISSIONARATE

AED NoSED NoCess YesEI Items 6Reg. Set ROCK MAN EXCISE REGISTRATIONPartial cr Yes

Maintain Company Code Settings

CoCd RCILCenvat Doc Type ZCFI Utilisation Doc Type ZCDebit Acc Overwrite XAut Adj ind XImm Credit On Capital Goods

X

First Mnth AprilExc Sel Days 30No.Exc Sel 20Exc Selection Procedure FIFORounding duty on Procurement

No

Rounding duty on Removal NoPage 55 of 69

Page 56: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Exchange rate type for CVDExchange rate type for Export

M

CVD Account 18012

Maintain Plant Settings

Plnt Depot

Exc.Reg.

GRs per EI

C000 002 Multiple goods recipt single credit

A000 002 Multiple goods recipt single credit

Maintain Exicise GroupsA unit within an excise registration, in India, which keeps its own set of excise records.Whereas the excise registration reports to the excise authorities, the excise group is a purely internal organizational unit. Each excise group keeps records of all transactions that have to be reported to the excise authorities. When the time comes to present these records to the authorities, the excise registration compiles the information from all of its excise groups.

Excise Gp R1Plnt A000Excise Group Description ROCK MAN OUTGOING EXCISE GROUPExc. Reg. 1GRs per EI Multiple goods recipt single creditDefault Challan Qty in GR

X

Create EI in Billing XCreate and post EI single step

X

Part1 Ind XDepot Eis NoFolio Nos. NoEI Capture XPost EI XEI/RG23D XAddress 2Update RG1 at MIGO XDuty Diff X

Page 56 of 69

Page 57: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Maintain Series GroupDefine excise series groups based on type of outgoing documentAssign series group to excise registration IDIf no financial postings are required for an Excise invoice in this seris group then you tick the 'No utilization' indicator.If the CENVAT has to be paid immediately and you need not wait for the Fort nightly payment then mark the 'Immediate Utilization' indicator.

Series Grp R1Series Description OUT GOING INVOICE SERIES 1Exc. Reg. 2No utilizImm. util. YesExp. Prd. NoReb. Prd. NoFast Cr. N0Address No

Maintain Excise Duty Indicator

Excise Indicator Description

1 100% TAX2 50% TAX3 NIL TAX

Select Tax Calculation ProcedureSpecify which tax procedure you want to use for determining excise duties and sales taxes on input materials in India.If you use Condition Based Excise Determination use a copy of the tax procedure TAXINN.If you use Formula Based Excise Determination use a copy of the tax procedure TAXINJ.

Country Name Procedure

IN INDIA ROCKINJMaintain Excise DefaultsDefine which tax procedure and pricing condition types are used in calculating excise taxes using formula-based excise determination.If you use condition-based excise determination, fill out the CVD cond. field and leave all the others blank.

Page 57 of 69

Page 58: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

If you use formula-based excise determination, fill out all of the fields as follows:Enter the tax procedure and the pricing conditions that are relevant for excise tax processing.Specify the purchasing and sales conditions types used for Basic Excise Duty, Additional Excise Duty, Special Excise Duty and Cess.Specify the conditions in the sales order that are used for excise rates.Specify the Countervailing duty condition type used for import purchase orders.

Tax Proc ROCKINJCVD Cond JCV1Export Tax CodeTax Jur Code IN00A/P BED JMO1A/P SED JSO1A/P AED JAO1A/R BED JEX2A/R SED JEXSA/R AED JEXAA/R CESS JCESBED Perc JMODAED Perc JAEDSED Perc JSEDCESS Perc JCEDECS AP JEC1ECS AR JECSECS Perc JECS

MASTER DATA

Maintain Chapter IDThe number given to a material in the schedules of materials published by the government of India.The schedule lists all materials involved in manufacturing, input materials and output materials alike. It shows how much excise duty is levied on each material.Each material in the schedule is assigned its own identification code, called "chapter ID."

Page 58 of 69

Page 59: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Chapter ID Description by Law

Define Form TypesDefine which form types you want to record in the system. You can only use form tracking for the form types that you enter here

Form Form Text Form Req. Tax Clas Of Customer

C Form CH Form H

ACCOUNT DETERMINATION

Determine G/L accounts for TaxesSpecify which G/L accounts you will use to record which taxes.Set up G/L accounts for each of the processing keys listed below.

Assign an account to each of the following posting keys. The accounts for VS1, VS2, and VS3 are used as clearing accounts duringExcise Invoice Verification.

VS1 (basic excise duty) VS2 (additional excise duty) VS3 (special excise duty) VS5 (sales tax setoff) MWS (central sales tax) MW3 (local sales tax) ESA (service tax) ESE (service tax expense)

Specify Excise Accounts per Excise TransactionsSpecify which excise accounts (for excise duty and CENVAT) are to be posted to for the various transaction types. Enter all the accounts that are affected by each transaction type.If you use subtransaction types, enter the accounts for each subtransaction type as well.

Transaction type UTLZ is used for determining accounts only while posting excise JVs and also if the payment of excise duty has to be done fortnightly.

Page 59 of 69

Page 60: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

The fortnightly CENVAT payment utility picks up the credit side accounts from the transaction types of GRPO, EWPO, and TR6C for determining the CENVAT and PLA accounts. There is no separate transaction type for fortnightly payment.

These are the Excise Transaction types for which the relevant Excise accounts will be assigned57CM 57F CHALLAN COMPLETION57FC 57F CHALLAN CAPTURE/CHANGE57NR 57F NON RECEIPTARE1 EXPORT PROCESSING UNDER ARE1ARE3 DEEMED EXPORTS UNDER ARE3CAGI CAPITAL GOODS ISSUESCAPE CAPITAL GOODSCEIV CANCELLATION OF EXCISE INVOICEDIEX DIFFERENTIAL EXCISE THROUGH JVDLFC GOODS REMOVAL THROUGH SALESEWPO EXCISE INVOICE WITHOUT POGRPO EXCISE INVOICE FOR GOODS RECEIPT/POMRDY REVERSAL WITHOUT REFERENCEMRRD REVERSAL INCASE OF COMSUMPTION OTHER

THAN PRODUCTIMRWO CENVAT REVERSALS FOR WRITE OFFOTHR EXCISE INVOICE FOR OTHER MOVEMENTSTR6C PLA ACCOUNT ADJUSTMENT THROUGHUTLZ FORTNIGHTLY PAYMENTS

Assignment of accounts to Excise Transaction Type

Excise Tra

Type

Sub T Type

DC Indicator

Account Name

57FC Credit PLA BED account57FC Credit RG 23 BED account57FC Debit CENVAT clearing

accountCAPE Credit CENVAT on hold

accountCAPE Debit CENVAT on hold

accountCAPE Debit RG 23 BED account

Page 60 of 69

Page 61: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

CEIVCredit

CENVAT suspense account

CEIV Debit PLA BED accountCEIV Debit RG 23 BED accountDIEX Credit CENVAT clearing

accountDIEX Debit RG 23 BED accountDLFC Credit PLA BED accountDLFC Credit PLA cess accountDLFC Credit RG 23 BED accountDLFC Debit CENVAT suspense

accountEWPO Credit CENVAT clearing

accountEWPO Debit RG 23 BED accountGRPO Credit CENVAT clearing

accountGRPO Debit CENVAT on hold

accountGRPO Debit RG 23 BED accountMRDY Credit PLA BED accountMRDY Credit PLA cess accountMRDY Credit RG 23 BED accountMRDY Debit CENVAT clearing

accountMRRD Credit PLA BED accountMRRD Credit PLA cess accountMRRD Credit RG 23 BED accountMRRD Debit CENVAT clearing

accountMRWO Credit PLA BED accountMRWO Credit PLA cess accountMRWO Credit RG 23 BED accountMRWO Debit CENVAT clearing

accountOTHR Credit PLA BED accountOTHR Credit PLA cess accountOTHR Credit RG 23 BED accountOTHR Debit CENVAT suspense

accountTR6C Credit PLA on hold accountTR6C Debit PLA BED accountTR6C Debit PLA cess account

Page 61 of 69

Page 62: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

UTLZCredit

UTLZ Credit PLA cess accountUTLZ Credit RG 23 BED accountUTLZ Debit CENVAT clearing

account

Specify G/L Accounts per Excise TransactionAssign the excise and CENVAT accounts to G/L accounts.When you come to execute the various transactions, the system determines which G/L accounts to post to by looking at the:

Excise group Company code Chart of accounts

Furthermore, if you want separate account determination settings within an excise group, you can also use sub transaction types.37 ActivitiesFor each excise group, assign the excise and CENVAT accounts to G/L accounts. For most businesses, one set of accounts will suffice for all transactions.NoteYou need not remit the CENVAT to the excise department immediately, so maintain the credit account for transaction type DLFC as an excise duty interim account. This will be set off when you remit the duty.

Excise

ETT CoCode

Sub Ttyper

Chart of Acc

RG23A BED

RG23A AED

RG23A SED

RG23C BED

RG23C AED

RG23C SED

R1 57CM RCIL RCIL 8093 8093 8093 8089 8089 8089R1 57CM RCIL 1 RCIL 8093 8093 8093 8089 8089 8089R1 57FC RCIL RCIL 8093 8093 8093 8089 8089 8089R1 57FC RCIL 1 RCIL 8093 8093 8093 8089 8089 8089R1 57NR RCIL RCIL 8093 8093 8093 8089 8089 8089R1 57NR RCIL 1 RCIL 8093 8093 8093 8089 8089 8089R1 ARE1 RCIL RCIL 8093 8089R1 ARE3 RCIL RCIL 8093 8089R1 CAPE RCIL RCIL 8093 8089R1 CEIV RCIL RCIL 8093 8089R1 DIEX RCIL RCIL 8093 8089R1 DLFC RCIL RCIL 8093 8089R1 EWPO RCIL RCIL 8093 8089R1 GRPO RCIL RCIL 8093 8089R1 MRDY RCIL RCIL 8093 8089

Page 62 of 69

Page 63: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

R1 MRRD RCIL8089

R1 MRWO RCIL RCIL 8093 8089R1 OTHR RCIL RCIL 8093 8089R1 TR6C RCIL RCIL 8093 8089R1 UTLZ RCIL RCIL 8093 8089

Continued …….

Offsetting

Modvat Clearing

PLA BED

PLA AED

PLA SED

PLA CESS

CENVAT on Hold

Cenvat Suspense

PLA on Hold

Reversal

18020 8097 8096 8096 8096 8089 18021 18022 18020 1802318020 8097 8096 8096 8096 8089 18021 18022 18020 1802318020 8097 8096 8096 8096 8089 18021 18022 18020 1802318020 8097 8096 8096 8096 8089 18021 18022 18020 1802318020 8097 8096 8096 8096 8089 18021 18022 18020 1802318020 8097 8096 8096 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 1802318020 8097 8096 8089 18021 18022 18020 18023

BUSINESS TRANSACTIONS

Outgoing Excise Invoice

Assign Billing Types to Delivery TypesEnter outgoing Excise Invoices by referring to either of the following documents:

Page 63 of 69

Page 64: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Customer invoices Pro forma excise invoices

These options are represented in the system by different document types and document flows.In this IMG activitySpecify which billing document types you use as a reference for CENVAT utilization

Assign them to the appropriate delivery document types

Del Type Bill Type

ZALF ZAF2

Maintain Default Excise Group and Series GroupSpecify which Excise Group and series group you want to appear in these fields by default. You can make separate settings for different combinations of sales organization, distribution channel, division, and shipping point.ActivitiesThis activity is optional, unless you want the system to automatically create outgoing excise invoices when you create a customer invoice.

Sales Org

DC DIV Shipping Point

Plant Excise Group

Series Group

RASO AO AC AUSP A000 R1 R1RASO AO AH AUSP A000 R1 R1RASO AO CD AUSP A000 R1 R1RASO AR AC AUSP A000 R1 R1RASO AR AH AUSP A000 R1 R1RASO AR CD AUSP A000 R1 R1RASO AS AS AUSP A000 R1 R1

TOOLS

Number RangeMaintain the number ranges for all CIN Number range objects using this transactionActivitiesMaintain the number ranges for the folllowing objects The no nr has to be '01' for all

Page 64 of 69

Page 65: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

38 Internal No Range Object ( this is automatically done by the system )1. j_1iintnum

39 At an Excise group1. j_1irg23a12. j_1irg23a23. j_1iRG14. j_1irg23c15. j_1irg23c26. j_1ipla27. j_1iintpr28. j_1irg23d9. j_1irg1_t ( material level)10. j_1iconpla ( if Consolidated PLA is used )

40 At Series group1. j_1iexcloc 2. j_1i57Fc ( 57F Challans )

The Number Range is Year DependentFor Excise Group

Excise Group

Object From To

R1 j_1irg23a1 0020000001 0020099999R1 j_1irg23a2 0020100001 0020199999R1 j_1iRG1 0020200001 0020299999R1 j_1irg23c1 0020300001 0020399999R1 j_1irg23c2 0020400001 0020499999R1 j_1ipla2 0020500001 0020599999R1 j_1iintpr2 0020600001 0020699999R1 j_1irg1_t 0020700001 0020799999R1 j_1iconpla 0020800001 0020899999

For Series Group

Series Group

Object From To

R1 j_1irxcloc 0030100001 0030199999R2 j_1i57Fc 0030200001 0030299999

Page 65 of 69

Page 66: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

40.1.1.1 EXCISE RATE MAINTENANCE ( J1ID )

MASTER DATA

Chapter ID

Chapter ID Description by Law

Page 66 of 69

Page 67: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Material and Chapter ID Combination

Material Code

Plant Chapter ID Subcontracting

Material Type

GR Reference

71010002

A000 87.14 No RG1 Multiple Goods Receipts, Single Credit

71010003

A000 87.14 No RG1 Single Goods Receipt

72210001

A000 87.14 No RG1 Single Goods Receipt

73510215

C000 87.14 No RG1 Single Goods Receipt

Customer Excise Details

Customer

Exc. Code Excise Regi No.

Exc. Range

Exc. Div.

Exc. Collectrate

930000 410040098 410040098 3930001 AAACH0812J

XM001AAACH0812JXM001

3

Continued …..

CST No. LST No. PAN No.

Excise Indicator

RWR-2304 DT.1.4.87

TIN NO.06572702304 1

RWR/1895 DT 3.2.84

TIN-06522701895 1

Excise Indicator for Plant

Co Code

Plant

Month

No ECC No. Excise Reg No.

Excise Range

RCIL A000 April 1 AAACR7866E AAACR7866E V,1536/2 NEW PREM Page 67 of 69

Page 68: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

XM001 XM001 NAGAR, LUDHIANA

RCIL C000 April 1 AAACR7866EXM001

AAACR7866EXM001

V,1536/2 NEW PREM NAGAR, LUDHIANA

Continued …..

Excise Div Excise Coll

CST No. LST No.

PAN Excise Ind

CENTRAL REVENUE BUILDING, CIVIL LINES, LUDHIANA.

LUDHIANA CST/HGST/GRG/19098/18.9.95

1233 1234 1

CENTRAL REVENUE BUILDING, CIVIL LINES, LUDHIANA.

LUDHIANA CST/HGST/GRG/19098/18.9.95

1233 1234 1

Excise indicator for Plant and Customer

Exc. Ind for Plant

Exc. Ind for Cust

Form Type Exc Ind

1 1 1

Excise Rate

Chapter ID

Exc. Ind

Valid From

Valid To Excise Rate

Cess Rate

Plant Material

Valid From

Valid To Cess

Page 68 of 69

Page 69: 3 · Web viewConfiguration Document for SD Module This is a Configuration Document for SD Module for the RCIL Project. Based on this document the Consultant will do the configuration

Page 69 of 69