Pilkington Automotive India Pvt. Ltd.India Processes

# Particulars

2 Purchase

2.1

2.2

2.3

2.4

2.5

3 Sales

3.1

3.2

3.3

3.4

4 Others

4.1

4.2

4.3

Import Purchases- Bonded Plant

DTA Purchases- Bonded Plant

Import Purchases- Non-Bonded Plant

Domestic Purchases for Non-Bonded Plant

Domestic Purchase Capital Equipment for Non-Bonded Plant

Export Sales- Bonded Plant

DTA Sales- Bonded Plant

Export Sales- Non Bonded Plant

Domestic Sales -Non-Bonded Plant

Periodic Processes

Tax Procedure

GL Accounts

Pilkington Automotive India Pvt. Ltd.Data Sheet

# Data Description

2 Company Code 9999

3 Purchasing Organization 9999

4 Purchasing Group 9999

5 Sales Area 9900-10-01

6 Plant 9999 9910

7 Vendor Account Group KRED

8 Vendor 100010 100015 100016 100018

9 Cost Centers 1001,1002,1003,2001, 3001,3002

15 Customer Cust01

16 Customer Account Group KUNA

17 Material (Purchasing) 2 12 14

18 Material (Sales) 6

19 Bank GL Account 131185

Import Purchase- Bonded Plant

Foreign Vendor 100020

Clearing Agent Vendor

Material 24

Tax Code V0

Domestic Purchases for Non-Bonded Plant

Domestic Vendor 100022

Material 25

Tax Code V1

Plant 9910

4500000108

Capital Procurement Scenario

20 Group Asset 203500 AS21

21 Asset 203501 AS01

22 Material for Asset 31

4500000112

Chapter ID 6540.3.13

Plant 9999

Pilkington Automotive India Pvt. Ltd.Process Description for Imported Procurement- Bonded Plant

# Process/Sub-Process

1 Create Vendor

1.1 Create Vendor (Import)

1.2 Create Customs Clearing Vendor

2 Create Material

2.1

3 Excise Rate Maintenance

3.1 Maintain Chapter ID

3.2 Material- Chapter ID

3.3 Vendor Excise Details

3.4 Vendor Excise Details

3.5 Plant Excise Indicator

3.6 Excise Tax Rate

4 Maintain Tax Conditions

4.1

1 Purchase Order

1.1 Create Purchase Order

1.2 Release Purchase Order

2 Capture Bill of Entry

2.1 Capture Bill of Entry

3 Create Goods Receipt

3.1 Create Goods Receipt

3.2 Create Excise Invoice

4 Capture Vendor Excise Invoice

4.1 Vendor Excise Invoice

5 Invoice Verification

5.1 Invoice Verification

6

6.1 Update Registers

7 Excise Register Extraction

7.1 Post Payment

8 Print Excise Registers

8.1 Print Excise Registers

Update of Registers RG1 and RG23 (Part1)

Pilkington Automotive India Pvt. Ltd.Process Description for Imported Procurement- Bonded Plant

Description

Enter Company Code and Purchasing Organization

In Purchasing Data maintain Schema group 4 for Foreign Vendors, Order Currency GBP

Enter Company Code and Purchasing Organization

In Purchasing Data maintain Schema group 3 for Domestic Vendors, Order Currency INR

Material Type ROH, Material Type 02,

Maintain Chapter ID Details

Assign Material to Chapter ID, Material Type Raw Material, Multiple Goods Receipts- Multiple Credits

Maintain '-' for ECC No, ECC reg no etc. for the Foreign Vendors. Maintain Excise Indicator 1

Maintain ECC No, ECC reg no etc. for the Customs Clearing Vendors. Maintain Excise Indicator 1

Plant Excise Indicator

Maintain Excise Tax Rate for Chapter ID

Tax Rates to be maintained for V0. Worksheet TAXINN

Enter Material, Plant, Purchasing Organization, Purchasing Group, Quantity and Amount

Click on Line Item Detail- The Commitment Item and the Fund are derived automatically. Enter the fund center

Click on Save to create the Purchase Order

Enter the Purchase Order and click on Release Strategy Tab, Click on icon release for both Buyer and Manager

Enter the value and Quantity and Post

Note the invoicing doc

Enter Purchase Order

Select Items Ok. The excise tab will appear

Enter Excise invoice date and number

Enter the Purchase Order, Select Delivery Costs. The line items for Freight and other charges appear. There will also be line items for CVD and other duties. Delete these since these are statistical.

Warning message that CENVAT Determination has not been maintained for the material

Post

Check the excise invoice tab. Click on Post. Accounting document created -DR Stock Cr GR/IR. Entry in Part 1 of Register 23A is created

Enter the PO number. The excise invoice is displayed

Select Check

Post the document. System creates Part II Entry in Register RG23A and an accounting document Dr MODVAT Cr GR/IR

Enter the document and posting date. In the field just above line items enter the PO number

The amount is displayed. Enter the amount in the header

Post the document

Click on followon documents to display the accounting documents. An accounting and a funds management document are posted

We update Part 1 entries into the Register. Enter Company Code, Plant and Excise Group. Select Radio Button RG23A Part 1. Execute

Select relevant documents and click create. The indicator should turn green for items successfully executed.

Part of Periodic Processes

Enter Start and End Date

Execute once for RG23A Part 1 and RG23A Part 2

Part of Periodic Processes

Select Radio button RG23A Part 1. The Green tick should indicate successful execution

Select Radio button RG23A Part 1. The Green tick should indicate successful execution

T-Code

XK01 100020

XK01 100021

MM01 24

J1ID 6540.3.13

J1ID

J1ID 100020

J1ID 100021

J1ID 9999

J1ID

FV11

ME21N 4500000100

ME29N 4500000100

MIRO 5105600223

MIGO

Transaction Ref

5000000141

ME29N

J1IEX

MIRO

J1I5

J2I5

J2I6

Pilkington Automotive India Pvt. Ltd.Process Description for Domestic Procurement- Non-Bonded Plant

# Process/Sub-Process

1 Create Vendor

1.1 Create Vendor (Import)

2 Create Material

2.1

3 Excise Rate Maintenance

3.1 Maintain Chapter ID

3.2 Material- Chapter ID

3.3 Vendor Excise Details

3.4 Vendor Excise Details

3.5 Plant Excise Indicator

3.6 Excise Tax Rate

4 Maintain Tax Conditions

4.1

1 Purchase Order

1.1 Create Purchase Order

1.2 Release Purchase Order

2 Create Goods Receipt

2.1 Create Goods Receipt

2.3 Create Excise Invoice

3 Capture Vendor Excise Invoice

3.1 Vendor Excise Invoice

4 Invoice Verification

4.1 Invoice Verification

5 Excise Register Extraction

5.1 Post Payment

6 Print Excise Registers

6.1 Print Excise Registers

Pilkington Automotive India Pvt. Ltd.Process Description for Domestic Procurement- Non-Bonded Plant

Description

Enter Company Code and Purchasing Organization

In Purchasing Data maintain Schema group 3 for Domestic Vendors, Order Currency INR

Material Type ROH, Material Type 02,

Maintain Chapter ID Details

Assign Material to Chapter ID, Material Type Raw Material, Multiple Goods Receipts- Multiple Credits

Maintain ECC No, ECC reg no etc. for the Local Vendors. Maintain Excise Indicator 1

Maintain ECC No, ECC reg no etc. for the Customs Clearing Vendors. Maintain Excise Indicator 1

Plant Excise Indicator

Maintain Excise Tax Rate for Chapter ID

Tax Rates to be maintained for V1. Worksheet TAXINN

Enter Material, Plant, Purchasing Organization, Purchasing Group, Quantity and Amount

Click on Line Item Detail- The Commitment Item and the Fund are derived automatically. Enter the fund center

Click on Save to create the Purchase Order

Enter the Purchase Order and click on Release Strategy Tab, Click on icon release for both Buyer and Manager

Enter Purchase Order

Select Items Ok. The excise tab will appear

Enter Excise invoice date and number

Check the excise invoice tab. Click on Post. Accounting document created -DR Stock Cr GR/IR. Entry in Part 1 of Register 23A is created

Enter the PO number. The excise invoice is displayed

Select Check

Post the document. System creates Part II Entry in Register RG23A and an accounting document Dr MODVAT Cr GR/IR

Enter the document and posting date. In the field just above line items enter the PO number

The amount is displayed. Enter the amount in the header

Post the document

Click on followon documents to display the accounting documents. An accounting and a funds management document are posted

Part of Periodic Processes

Enter Start and End Date

Execute once for RG23A Part 1 and RG23A Part 2

Part of Periodic Processes

Select Radio button RG23A Part 1. The Green tick should indicate successful execution

Select Radio button RG23A Part 1. The Green tick should indicate successful execution

T-Code

XK01 100020

MM01 24

J1ID 6540.3.13

J1ID

J1ID 100020

J1ID 100021

J1ID 9999

J1ID

FV11

ME21N

ME29N

MIGO

ME29N

J1IEX

MIRO

J2I5 Check if J1I5 required

Transaction Ref

J2I6

Pilkington Automotive India Pvt. Ltd.Process Description for Imports- Non-Bonded Plant

# Process/Sub-Process

1 Create Vendor

1.1 Create Vendor (Import)

2 Create Material

2.1

3 Excise Rate Maintenance

3.1 Maintain Chapter ID

3.2 Material- Chapter ID

3.3 Vendor Excise Details

3.4 Vendor Excise Details

3.5 Plant Excise Indicator

3.6 Excise Tax Rate

3.7 Cess Rate

4 Maintain Tax Conditions

4.1

1 Purchase Order

1.1 Create Purchase Order

1.2 Release Purchase Order

2 Post Customs Duty & Planned Delivery Costs

2.1

2 Create Goods Receipt

2.1 Create Goods Receipt

2.3 Create Excise Invoice

3 Capture Vendor Excise Invoice

3.1 Vendor Excise Invoice

4 Invoice Verification

4.1 Invoice Verification

5 Update of Registers

5.1 Update Registers

6 Excise Register Extraction

6.1 Post Payment

7 Print Excise Registers

7.1 Print Excise Registers

Pilkington Automotive India Pvt. Ltd.Process Description for Imports- Non-Bonded Plant

Description

Enter Company Code and Purchasing Organization

In Purchasing Data maintain Schema group 3 for Domestic Vendors, Order Currency INR

Material Type ROH, Material Type 02,

Maintain Chapter ID Details

Assign Material to Chapter ID, Material Type Raw Material, Multiple Goods Receipts- Multiple Credits

Maintain '-' for ECC No, ECC reg no etc. for the Foreign Vendors. Maintain Excise Indicator 1

Maintain ECC No, ECC reg no etc. for the Customs Clearing Vendors. Maintain Excise Indicator 1

Plant Excise Indicator

Maintain Excise Tax Rate for Chapter ID

Maintain Cess Rate

Tax Rates to be maintained for V1. Worksheet TAXINN

Enter Material, Plant, Purchasing Organization, Purchasing Group, Quantity and Amount

Click on Line Item Detail- The Commitment Item and the Fund are derived automatically. Enter the fund center

Click on Save to create the Purchase Order

Enter the Purchase Order and click on Release Strategy Tab, Click on icon release for both Buyer and Manager

Post Customs Duty & Planned Delivery Costs

Enter the Purchase Order, Select Delivery Costs

Enter Purchase Order

Select Items Ok. The excise tab will appear

Enter Excise invoice date and number

Check the excise invoice tab. Click on Post. Accounting document created -DR Stock Cr GR/IR. Entry in Part 1 of Register 23A is created

Enter the PO number. The excise invoice is displayed

Select Check

Post the document. System creates Part II Entry in Register RG23A and an accounting document Dr MODVAT Cr GR/IR

Enter the document and posting date. In the field just above line items enter the PO number

The amount is displayed. Enter the amount in the header

Post the document

Click on followon documents to display the accounting documents. An accounting and a funds management document are posted

We update Part 1 entries into the Register. Enter Company Code, Plant and Excise Group. Select Radio Button RG23A Part 1. Execute

Select relevant documents and click create. The indicator should turn green for items successfully executed.

Part of Periodic Processes

Enter Start and End Date

Execute once for RG23A Part 1 and RG23A Part 2

Part of Periodic Processes

Select Radio button RG23A Part 1. The Green tick should indicate successful execution

Select Radio button RG23A Part 1. The Green tick should indicate successful execution

T-Code

XK01 100020

MM01 24

J1ID 6540.3.13

J1ID

J1ID 100020

J1ID 100021

J1ID 9999

J1ID

J1ID 4500000100

FV11

ME21N

ME29N

MIRO

MIGO

ME29N

J1IEX

Transaction Ref

MIRO

J1I5

J2I5 Check if J1I5 required

J2I6

Pilkington Automotive India Pvt. Ltd.Process Description for Domestic Procurement- Non-Bonded Plant

# Process/Sub-Process

1 Create Vendor

1.1 Create Vendor (Import)

2 Create Material

2.1

3 Excise Rate Maintenance

3.1 Maintain Chapter ID

3.2 Material- Chapter ID

3.3 Vendor Excise Details

3.4 Vendor Excise Details

3.5 Plant Excise Indicator

3.6 Excise Tax Rate

3.7 Cess Rate

4 Maintain Tax Conditions

4.1

1 Create Vendor

1.1 Create Vendor (Import)

2 Create Material

2.1

3 Excise Rate Maintenance

3.1 Maintain Chapter ID

3.2 Material- Chapter ID

3.3 Vendor Excise Details

3.5 Plant Excise Indicator

3.6 Excise Tax Rate

3.7 Cess Rate

4 Maintain Tax Conditions

4.1 Maintain Tax Conditions

1 Purchase Order

1.1 Create Purchase Order

1.2 Release Purchase Order

2 Create Goods Receipt

2.1 Create Goods Receipt

3 Capture Vendor Excise Invoice

3.1 Display Vendor Excise Invoice

4 Invoice Verification

4.1 Invoice Verification

Pilkington Automotive India Pvt. Ltd.Process Description for Domestic Procurement- Non-Bonded Plant

Description

Enter Company Code and Purchasing Organization

In Purchasing Data maintain Schema group 4 for Foreign Vendors, Order Currency GBP

Material Type ROH, Material Type 02,

Maintain Chapter ID Details

Assign Material to Chapter ID, Material Type Raw Material, Multiple Goods Receipts- Multiple Credits

Maintain ECC No, ECC reg no etc. for the Domestic Vendors. Maintain Excise Indicator 1

Maintain ECC No, ECC reg no etc. for the Customs Clearing Vendors. Maintain Excise Indicator 1

Plant Excise Indicator

Maintain Excise Tax Rate for Chapter ID

Maintain Cess Rate

Tax Rates to be maintained for V1. Worksheet TAXINN

Enter Company Code and Purchasing Organization

In Purchasing Data maintain Schema group 5 for Domestic Vendors, Order Currency INR

Material Type ROH, Material Type 02,

Maintain Chapter ID Details

Assign Material to Chapter ID, Material Type Raw Material, Multiple Goods Receipts- Multiple Credits

Maintain '-' for ECC No, ECC reg no etc. for the Foreign Vendors. Maintain Excise Indicator 1

Plant Excise Indicator

Maintain Excise Tax Rate for Chapter ID

Maintain Cess Rate

BED Setoff% (JMOP) 12%, AED (JAOP) 2% and Conditions JMX1, JMX2, JAX1, JMX2 at 100%, JCEP at 2% and JSEP at 1%

Enter Material, Plant, Purchasing Organization, Purchasing Group, Quantity and Amount

Click on Line Item Detail- The Commitment Item and the Fund are derived automatically. Enter the fund center

Click on Save to create the Purchase Order

Enter the Purchase Order and click on Release Strategy Tab, Click on icon release for both Buyer and Manager

Enter Purchase Order

Select Items Ok. The excise tab will appear

Enter Excise invoice date and number

Enter the PO number. The excise invoice is displayed

Select Check

Post the document. System creates Part II Entry in Register RG23A and an accounting document Dr MODVAT Cr GR/IR

Enter the document and posting date. In the field just above line items enter the PO number

The amount is displayed. Enter the amount in the header

Post the document

Click on followon documents to display the accounting documents. An accounting and a funds management document are posted

T-Code

XK01 100022

MM01 25

J1ID 6540.3.13

J1ID

J1ID 100020

J1ID 100021

J1ID 9999

J1ID

J1ID 4500000100

FV11

XK01 100022

MM01 25

J1ID 6540.3.13

J1ID

J1ID 100022

J1ID 9910

J1ID

J1ID

FV11

ME21N 4500000109

ME29N 4500000109

MIGO 5000000150

Transaction Ref

J1IEX

MIRO

Pilkington Automotive India Pvt. Ltd.Process Description Domestic Procurement- Capital Equipment Non Bonded

# Process/Sub-Process

1 Create Vendor

1.1 Create Vendor (Local)

2 Create Material

2.1 Create Material

3 Create Fixed Asset

3.1 Create Fixed Asset

4 Excise Rate Maintenance

4.1 Maintain Chapter ID

4.2 Material- Chapter ID

4.3 Vendor Excise Details

4.4 Plant Excise Indicator

4.5 Excise Tax Rate

5 Maintain Tax Conditions

5.1

1 Purchase Order

1.1

1.2 Release Purchase Order

2 Create Goods Receipt

2.1 Create Goods Receipt

2.3 Create Excise Invoice

3 Capture Vendor Excise Invoice

3.1 Vendor Excise Invoice

4 Invoice Verification

4.1 Invoice Verification

Create Account Assigned Purchase Order

5 Capital Goods Transfer of Credit

5.1 Capital Goods Transfer of Credit

6 Check Account Balances

6.1 Check Account Balances

Pilkington Automotive India Pvt. Ltd.Process Description Domestic Procurement- Capital Equipment Non Bonded

Description

Enter Company Code and Purchasing Organization

In Purchasing Data maintain Schema group 4 for Foreign Vendors, Order Currency GBP

Material Type ROH, Material Type 01,

Create Asset, Enter Cost Center and Business Area

Maintain Chapter ID Details

Assign Material to Chapter ID, Material Type Raw Material, Multiple Goods Receipts- Multiple Credits

Maintain ECC No, ECC reg no etc. for the Customs Clearing Vendors. Maintain Excise Indicator 1

Plant Excise Indicator

Maintain Excise Tax Rate for Chapter ID

Tax Rates to be maintained for V0. Worksheet TAXINN

Enter Material, Plant, Purchasing Organization, Purchasing Group, Quantity and Amount

Click on Line Item Detail- Enter the Fixed Asset

Click on Save to create the Purchase Order

Enter the Purchase Order and click on Release Strategy Tab, Click on icon release for both Buyer and Manager

Enter Purchase Order

Select Items Ok. The excise tab will appear

Enter Excise invoice date and number

Check the excise invoice tab. Click on Post. Accounting document created -DR Stock Cr GR/IR. Entry in Part 1 of Register 23C is created

Enter the PO number. The excise invoice is displayed

Select Check

Post the document. System creates Part II Entry in Register RG23C and an accounting document

Enter the document and posting date. In the field just above line items enter the PO number. In header also select tax code and click on 'calculate tax'

The amount is displayed. Enter the amount in the header

Post the document

Click on followon documents to display the accounting documents. An accounting and a funds management document are posted

Enter Company Code, Plant and the Excise Group

Select/ Check items and click on Transfer of Credit. A message with the update of Registers appears

This will be done next year. Check Account Balances for the Excise Accounts

The account balances will be updated with the Capital goods transfer of credit values

T-Code

XK01 100022

MM01 32

AS01 203502

J1ID 6540.3.13

J1ID

J1ID 100022

J1ID 9999

J1ID

FV11

ME21N

ME29N

MIGO

ME29N

J1IEX

MIRO

Transaction Ref

J2I8

FBL3N

Sales Process Page 34

Pilkington Automotive India Pvt. Ltd.Process Description for Domestic Sales- Non-Bonded Plant

# Process / Sub-Process

1 Customer

1.1 Create Customer

1.2 Create Material in Sales Area

1.3 Create Initial Stock for Delivery

2 Create Material

2.1 Create Material

3 Excise Rate Maintenance

3.1 Maintain Chapter ID

3.2 Material- Chapter ID

4.3 Customer Excise Details

4 Tax Rate Maintenance

4.1 Maintain Excise Tax Conditions

4.2 Maintain CST & LST Tax Conditions

Sales Process Page 35

1 Sales Order

1.1 Create Sales Order

2 Delivery

2.1 Picking (PGI)

2.2 Post Goods Issue

3 Billing

3.1 Generate Customer Invoice

3.2 Display Billing Document

Sales Process Page 36

Pilkington Automotive India Pvt. Ltd.Process Description for Domestic Sales- Non-Bonded Plant

Description T-Code

XD01

Create Material in Sales Area. Select all the Sales views in the Material Master and the Accounting view MM01

Use Movement Type 561 MB1C

Material Type FERT, Material Type 01, MM01

Maintain Material for Basic, Sales, Plant, Accounting & Costing Views

Maintain Chapter ID Details J1ID

Assign Material to Chapter ID, Material Type Raw Material, Multiple Goods Receipts- Multiple Credits J1ID

Maintain ECC No, ECC reg no etc. for the Customers. Maintain Excise Indicator 1 J1ID

Maintain tax rates for BED, AED, SED, Cess and Surcharge on Cess conditions VK11

Maintain tax rates for CST & LST Conditions VK11

Customers are created using Account Group KUNA

Sales Process Page 37

VA01

VL01N

VL02N

Vf01

View the billing document and the accounting document VF03

Enter the Sales Order Type, Material,Sales Area, Delivery Plant, Storage locationEnter the Quantity, Price and Delivery Date

Click on Go to > Item > Account Assignment. Select the Icon FM Account Assignment. The Commitment item and the Fund are derived. Enter the Fund Center

Enter storage location, enter pick quantity and Post Goods IssueAn Accounting Entry is generated

View Billing Due List. Enter the details. Select the item from the billing due list and select 'Individual billing document' from the Menu. The billing document is displayed. Post the document to generate the billing and the accounting documentRelease to Accounting

Sales Process Page 38

Pilkington Automotive India Pvt. Ltd.Process Description for Export Sales- Non-Bonded Plant

# Process / Sub-Process

1 Customer

1.1 Create Customer

1.2 Create Material in Sales Area

1.3 Create Initial Stock for Delivery

2 Create Material

2.1 Create Material

3 Excise Rate Maintenance

3.1 Maintain Chapter ID

3.2 Material- Chapter ID

4 Tax Rate Maintenance

4.1 Maintain Excise Tax Conditions

4.2 Maintain CST & LST Tax Conditions

1 Create Sales Order

1.1 Create Sales Order

Sales Process Page 39

2 Create Delivery

2.1 Picking (PGI)

2.2 Post Goods Issue

3 Billing

3.1 Generate Customer Invoice

3.2 Display Billing Document

Sales Process Page 40

Pilkington Automotive India Pvt. Ltd.Process Description for Export Sales- Non-Bonded Plant

Description T-Code

XD01

Create Material in Sales Area. Select all the Sales views in the Material Master and the Accounting view MM01

Use Movement Type 561 MB1C

Material Type FERT, Material Type 01, MM01

Maintain Material for Basic, Sales, Plant, Accounting & Costing Views

Maintain Chapter ID Details J1ID

Assign Material to Chapter ID, Material Type Raw Material, Multiple Goods Receipts- Multiple Credits J1ID

Maintain tax rates for BED, AED, SED, Cess and Surcharge on Cess conditions VK11

Maintain tax rates for CST & LST Conditions VK11

VA01

Customers are created using Account Group KUNA

Enter the Sales Order Type, Material,Sales Area, Delivery Plant, Storage locationEnter the Quantity, Price and Delivery DateClick on Go to > Item > Account Assignment. Select the Icon FM Account Assignment. The Commitment item and the Fund are derived. Enter the Fund Center

Sales Process Page 41

VL01N

VL02N

Vf01

View the billing document and the accounting document VF03

Enter storage location, enter pick quantity and Post Goods IssueAn Accounting Entry is generated

View Billing Due List. Enter the details. Select the item from the billing due list and select 'Individual billing document' from the Menu. The billing document is displayed. Post the document to generate the billing and the accounting documentRelease to Accounting

Sales Process Page 42

Pilkington Automotive India Pvt. Ltd.Process Description for Export Sales- Bonded Plant

# Process / Sub-Process

1 Customer

1.1 Create Customer

2 Create Material

1.2 Create Material in Sales Area

1.3 Create Initial Stock for Delivery

3 Excise Rate Maintenance

3.1 Maintain Chapter ID

3.2 Material- Chapter ID

3.3 Customer Excise Details

3.4 Excise Tax Rate

4 Condition Maintenance

4.1 Maintain Excise Conditions- Basic Excise

4.2 Maintain Excise Conditions- Additional Excise

5 Create Bond

Sales Process Page 43

5.1 Create Bond

1 Sales Order

1.1 Create Sales Order

2 Delivery

2.1 Picking (PGI)

2.2 Post Goods Issue

3 Billing

3.1 Generate Customer Invoice

3.2 Display Billing Document

Sales Process Page 44

Pilkington Automotive India Pvt. Ltd.

Description T-Code

XD01

MM01

Use Movement Type 561 MB1C

Maintain Chapter ID Details J1ID

Assign Material to Chapter ID, Material Type RG1, Multiple Goods Receipts- Multiple Credits J1ID

Select Excise Indicator 1 (Fully Excisable) J1ID

Maintain Excise Tax Rate J1ID

Condition JEXP, Access Sequence: Country-Plant-Control Code Access Sequence. Maintain 6% for Material VK11

Condition JEAP, Access Sequence: Country-Plant-Control Code Access Sequence. Maintain 12% for Material VK11

Customers are created using Account Group KUNA. Select Cust Pricing Procedure 6 (Export Sales under bond). Tax Category '1' Liable for Taxes

Create Material in Sales Area. Material Type FERT. Select all the Sales views in the Material Master and the Accounting view. Standard Price '1000'

Sales Process Page 45

Enter the type of Bond 'Fixed Bond' . Enter the bond amount and surety if any. Save

VA01

VL01N

VL02N

Vf01

View the billing document and the accounting document VF03

Enter the Sales Order Type, Material,Sales Area, Delivery Plant, Storage locationEnter the Quantity, Price and Delivery Date

Click on Go to > Item > Account Assignment. Select the Icon FM Account Assignment. The Commitment item and the Fund are derived. Enter the Fund Center

Enter storage location, enter pick quantity and Post Goods IssueAn Accounting Entry is generated

View Billing Due List. Enter the details. Select the item from the billing due list and select 'Individual billing document' from the Menu. The billing document is displayed. Post the document to generate the billing and the accounting documentRelease to Accounting

Sales Process Page 46

Pilkington Automotive India Pvt. Ltd.Process Description for Domestic Sales- Bonded Plant

# Process / Sub-Process

1 Customer

1.1 Create Customer

2 Create Material

1.2 Create Material in Sales Area

1.3 Create Initial Stock for Delivery

3 Excise Rate Maintenance

3.1 Maintain Chapter ID

3.2 Material- Chapter ID

3.3 Customer Excise Details

3.4 Excise Tax Rate

4 Condition Maintenance

4.1 Maintain Excise Conditions- Basic Excise

4.2 Maintain Excise Conditions- Additional Excise

1 Sales Order

Sales Process Page 47

1.1 Create Sales Order

2 Delivery

2.1 Picking (PGI)

2.2 Post Goods Issue

3 Billing

3.1 Generate Customer Invoice

3.2 Display Billing Document

Sales Process Page 48

Pilkington Automotive India Pvt. Ltd.Process Description for Domestic Sales- Bonded Plant

Description T-Code

XD01

MM01

Use Movement Type 561 MB1C

Maintain Chapter ID Details J1ID

Assign Material to Chapter ID, Material Type RG1, Multiple Goods Receipts- Multiple Credits J1ID

Select Excise Indicator 1 (Fully Excisable) J1ID

Maintain Excise Tax Rate J1ID

Condition JEXP, Access Sequence: Country-Plant-Control Code Access Sequence. Maintain 5% for Material VK11

Condition JEAP, Access Sequence: Country-Plant-Control Code Access Sequence. Maintain 12.6% for Material VK11

Customers are created using Account Group KUNA. Select Cust Pricing Procedure 6 (Export Sales under bond). Tax Category '1' Liable for Taxes

Create Material in Sales Area. Material Type FERT. Select all the Sales views in the Material Master and the Accounting view. Standard Price '1000'

Sales Process Page 49

VA01

VL01N

VL02N

Vf01

View the billing document and the accounting document VF03

Enter the Sales Order Type, Material,Sales Area, Delivery Plant, Storage locationEnter the Quantity, Price and Delivery DateClick on Go to > Item > Account Assignment. Select the Icon FM Account Assignment. The Commitment item and the Fund are derived. Enter the Fund Center

Enter storage location, enter pick quantity and Post Goods IssueAn Accounting Entry is generated

View Billing Due List. Enter the details. Select the item from the billing due list and select 'Individual billing document' from the Menu. The billing document is displayed. Post the document to generate the billing and the accounting documentRelease to Accounting

Pilkington Automotive India Pvt. Ltd.PLA & Other Periodic Processes

# Process/Sub-Process

1 Create JV

1.1 Create Journal Voucher for PLA

2 Create JV for TR6 Challan

2.1 Create JV for TR6 Challan

3 Display Excise Invoice

3.1 Display Excise Invoice

4 Utilization of CENVAT

4.1

Pilkington Automotive India Pvt. Ltd.

Description

Enter the Primary ledger account and bank account

Dr PLA on Hold

Cr Bank

Select 'TR6' Challan, enter Doc Number 'PLA100001', Company Code 9999, Plant 9999, Excise Group E3

Dr PLA AED 1000

Dr PLA AT1 1000

Dr PLA BED 8000

DR PLA CESS 1000

DR PLA SED 1000

Cr PLA on Hold 12000

Enter Excise Invoice number from last step

Display accounting document number

View Part1/Part2 (Only Part 2 entries will be displayed)

Enter the Company Code, Plant, Excise Group and Series

Select Radio "Pay CENVAT from Service Tax Credit"

Select the Duties. Enter the utilized amount (normally from PLA-BED). If amount is matching the Fig on top becomes green

Only when the 2 traffic signals are green- the posting indicator becomes active

Click on Post. An accounting document is generated.

T-Code

FB50 100000033

J1IH

J1IH

J2IUN

Transaction Ref

Excise JV: 1000040, Accounting Doc:

100000034

Pilkington Automotive India Pvt. Ltd.

Tax Procedure

Procedure Condition Condition DescriptioType Account Key Posting

ZAXINN JMOP BED Setoff% Deductible VS1

ZAXINN JMOQ BED Quantity Deductible VS1

ZAXINN JAOP AED Setoff% Deductible VS2

ZAXINN JAOQ AED Quantity Deductible VS2

ZAXINN JSOP SED Setoff% Deductible VS3

ZAXINN JSOQ SED setoff Qty Deductible VS3

ZAXINN JMIP BED Inventory% Non-Deductible NVV

ZAXINN JMIQ BED Inven Qty Non-Deductible NVV

ZAXINN JAIP AED Inventory% Non-Deductible NVV

ZAXINN JAIQ AED Quantity Non-Deductible NVV

ZAXINN JSIP SED Inventory% Non-Deductible NVV

ZAXINN JSIQ SED Inventory Qty Non-Deductible NVV

ZAXINN JMX1 BED Setoff Total Statistical

ZAXINN JAX1 AED Setoff Total Statistical

ZAXINN JMX2 BED Inventory Total Statistical

ZAXINN JAX2 AED Inventory Total Statistical

ZAXINN JSX2 SED Inventory Total Statistical

Total Excise

ZAXINN JECP A/P Cess setoff Deductible JI1

ZAXINN JECI A/P ECess inven Non-Deductible NVV

ZAXINN JSEP A/P SECess setoff Deductible JI6

ZAXINN JSEI A/P SECess inven Non-Deductible NVV

ZAXINN JHX1 A/P SECess SOTot Total Statistical

ZAXINN JHX2 A/P SECess invT Total Statistical

Excise after Cess

ZAXINN JVCS Inp CST under VAT JP4

ZAXINN JVRD Inp VAT Cr Non-CG JP5

ZAXINN JVRN Inp VAT w/o Cr NonCG JP6

ZAXINN JVCD Inp VAT Cr CG JP7

ZAXINN JVCN Inp VAT w/o Cr CG JP8

ZAXINN JSER IN: Service tax-Outp ESA

ZAXINN JSVD IN:Service tax debit ESE

Formula Values Nature of Tax VB

10 A/P Excise 0% -

10 A/P Excise - -

10 A/P Excise 0% -

10 A/P Excise - -

10 A/P Excise 0% -

10 A/P Excise - -

10 A/P Excise - -

10 A/P Excise - -

10 A/P Excise - -

10 A/P Excise - -

10 A/P Excise - -

10 A/P Excise - -

20 A/P Excise 100% -

20 A/P Excise 100% -

20 A/P Excise 100% -

20 A/P Excise - -

20 A/P Excise - -

100

2 A/P Excise - -

2 A/P Excise - -

2 A/P Excise - -

2 A/P Excise 0%

2 100% 100%

2 100% 100%

108 A/P Excise

Input Tax

V0 (0 Excise & Sales Tax)

Input Tax

Input Tax

Input Tax

Input Tax

Service Tax

Service Tax

12% 12%

2% 2%

100% 100%

100% 100%

100% 100%

100% 100%

100% 100%

2% 2%

- -

1% 1%

- -

100% 100%

100% 100%

4% 4%

V1 (With Excise and Sales Tax)

V2 (Assets-With Excise and Sales

Tax)

Pilkington Automotive India Pvt. Ltd.GL Accounts

GL Account Description

Excise GL Accounts

212434 CENVAT Clearing

212435 RG23A AED

212436 RG23A BED

212437 RG23A SED

212438 RG23C AED

212439 CENVAT INPUT CLAIM - RG23CBED

212440 RG23C SED

212441 PLA ON HOLD

212442 PLA AED

212443 PLA BED

212444 PLA CESS

212445 PLA SED

212446 SERVICE TAX -OUTPUT SERVICE TAX

212447 VAT- CG

212466 SESS

212467 PLA AT1

212468 RG23A AT1

212469 Reversal Clg Acct

212470 CENVAT Suspense Account

Pilkington Automotive India Pvt. Ltd.Issues

Issues J1IIN

No defaults could be proposed for Excise utilizati In Excise Invoice

Message no. 8I633

J1IA101

Parameters not maintained for output type

Message no. 8I621

Not Enough Balance for utilisation

Message no. 8I578

Duty payable cannot be less than 3,780.00

Message no. 4F264

Message no. 8I312

Issue during utilization J1IIN

System failure 212443

Error updating Condition Table 372 This is because JMAN does not have an access sequence

Message no. 8I308

BED : Debit = 35,000.00 Credit = 0.00 Diff = 35,000.00

This is because JMAN does not have an access sequence

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 62

Pilkington Automotive India Pvt. Ltd.Localization- Accounting Entries

# Source Transaction D/C GL Code

Extended Withholiding Tax

1 Accounting Down Payment Dr Supplier

Cr Bank-wise

Cr TDS Payable

2 Accounting Invoice Verification Dr GR/IR

Cr Vendor

Cr TDS

3 Accounting TDS Remittance Chalan Dr TDS Payable Account

Cr TDS Clearing

4 Accounting Payment of TDS Dr TDS Clearing A/C

Cr Bank

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 63

Pilkington Automotive India Pvt. Ltd.Localization- Accounting Entries

# Source Transaction D/C GL Code

Local Body Tax

1 Accounting With PO Dr Inventory A/C

Cr GR/IR

Cr LBT Payable

2 Accounting Without PO Dr Consumable/Expense A/c

Cr Vendor

Cr LBT Payable

Entry Tax

1 Accounting Entry Tax with PO Dr Inventory A/C

Cr GR/IR

Dr Entry Tax Payable

Cr Bank

2 Accounting Entry Tax without PO Dr Consumable/Expense Acc

Cr Vendor

Cr Entry/Tax payable

3 Accounting Entry Tax Payment Dr Entry Tax Payable

Cr Bank

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 64

Pilkington Automotive India Pvt. Ltd.Localization- Accounting Entries

# Source Transaction D/C GL Code

Value Added Tax

Purchase when Input Credit is Available

1 Accounting Goods Receipt when Input Credit is Available Dr GR/IR Clearing

Dr Input VAT A/c

Cr Vendor

2 Accounting Reversal of VAT posting for VAT Reversal Dr Vendor A/C

Cr GR/IR

Cr Input VAT A/c

Purchase when Input Credit is Not Available

1 Accounting Goods Receipt when Input Credit is Not Available Dr Raw Material

Cr GR/IR

2 Accounting Invoice Verification Dr GR/IR

Cr Vendor

3 Accounting Reversal in case of Debit Note Dr Vendor

Cr GR/IR

Sales

Accounting Sales Invoice Booking without SO Dr Customer A/C

Cr Sales

Cr VAT Payable

Accounting Dr VAT /CST

Cr VAT Payable

Accounting Sales Return (< 180 Days) Dr Gross Sales A/C

Dr VAT/CST Payable

Cr Customer A/C

Accounting Sales Return (>180 Days) Dr Gross Sales A/c

Free of Cost of Sale (Free Samples)- VAT/CST payable but not recoverable from Customer

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 65

Pilkington Automotive India Pvt. Ltd.Localization- Accounting Entries

# Source Transaction D/C GL Code

Dr VAT Expenses

Cr Customer A/C

CST

Purchase

1 Accounting Goods Receipt Dr Material/ Expense A/C incl CST

Cr GR/IR Clearing

2 Accounting Invoice Verification Dr GR/IR

Cr Vendor

Sales

1 Accounting Dr Customer

Cr Sales

Cr CST Payable

Service Tax

Purchase

1 Accounting Invoice Verification- Service Tax Credit Available Dr Services

Dr Service Tax on Hold

Dr Education Cess on Hold A/C

Dr S & HECess on Hold A/C

Cr Vendor

2 Accounting Invoice Verification- Service Tax Credit Not Availab Dr GR/IR Services /Expenses A/c

Cr Vendor

3 Accounting Dr Service Tax

Dr Education Cess

Dr S & HECess

Cr Service Tax on Hold

Cr Education Cess on Hold

Cr S & HECess on Hold

4 Accounting Utilization of Service Tax against Excise Payable Dr Excise Payable

Cr Service Tax Clearing

Transfer from Serv Tax Receivable Clearing A/C to Service Tax Receivable Account

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 66

Pilkington Automotive India Pvt. Ltd.Localization- Accounting Entries

# Source Transaction D/C GL Code

Cr Education Cess

Cr S & HECess

Goods Transport Agent (GTA)

1 Manual Application Money Dr 76672

Cr 168668

2 Manual Interest on Application Money Dr 202013

Cr 76671

3 TRM Allotment Dr 168668

Cr 65400

4 TRM Monthly Interest Accrual Dr 202012

Reversal of accrual 1st day of next month Cr 164014

5 TRM Interest Pay-out Dr 202012

Cr 76671

6 TRM Maturity / Repayment Dr 65400

Cr 76671

Tier II Debentures

1 Manual Application Money Dr 76672

Cr 168666

2 Manual Interest on Application Money Dr 202013

Cr 76671

3 TRM Allotment Dr 168666

Cr 65420

4 TRM Monthly Interest Accrual Dr 201017

Reversal of accrual 1st day of next month Cr 164018

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 67

Pilkington Automotive India Pvt. Ltd.Localization- Accounting Entries

# Source Transaction D/C GL Code

5 TRM Interest Pay-out Dr 201017

Cr 76671

6 TRM Maturity / Repayment Dr 65420

Cr 76671

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 68

GL Description

Vendor Code

Bank Name

TDS Payable Account

GR/IR Clearing

Vendor Account

TDS Payable

Interest on Loans

TDS Clearing A/C

TDS Clearing A/C

Bank Outgoing

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 69

GL Description

Inventory A/C

GR/IR

LBT Payable

Consumable A/C

Vendor

LBT Payable

Entry Tax Payable

Bank

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 70

GL Description

GR/IR Clearing

Input A/C

Vendor

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 71

GL Description

Material/ Expense A/C incl CST

GR/IR Clearing

GR/IR

Vendor

GR/IR Services /Expenses A/c

Service Tax on Hold

Education Cess on Hold A/C

S & HECess on Hold A/C

Vendor

GR/IR Services /Expenses A/c

Vendor A/C

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 72

GL Description

Bank Incoming

Application Money - Debentures

Interest on Application Money

Bank Outgoing

Application Money - Debentures

LT Debentures

Interest Exp - LT Debentures

Provision for Interest on LT Deb

Interest Exp - LT Debentures

Bank Outgoing

LT Debentures

Bank Outgoing

Bank Incoming

Application Money - Tier II Debentures

Interest on Application Money

Bank Outgoing

Application Money - Tier II Debentures

Tier II Debentures

Interest Exp - Tier II Debentures

Provision on Int on Tier II Debentures

ANNEXURE 3B: ACCOUNTING ENTRIES

Bank Loans, WCDL, CC, ICDs Page 73

GL Description

Interest Exp - Tier II Debentures

Bank Outgoing

Tier II Debentures

Bank Outgoing