Sunday, 23 August 2015

PROJECT in sap CO


PROJECT



BIL group (to go for ERP)
Packages available Cost / Feature/Time

ERP Packages
SAP
Oracle Financials
JD Edwards
People soft

Decided to go for SAP –Consulting firms Cost/Support /Experience

1)      WIPRO
2)      Infosys
3)      Satyam
4)      Intell
1)      Zensar

Buy SAP package from SAP-India –Bangalore with the support of WIPRO –Hyderabad vendors.

Implement all the modules at all locations (BIG Bang project) or in a phased manner

BIL
WIPRO
A) Project Manager
A) Project Manager
B) Accounts Manager
B) FI Consultant
C)Cost Accountant
C)Co Consultant
D) Purchase Manager
D)MM Consultant
E) Sales Manager
E)SD Consultant
F)IT Staff
F) BASIS Consultant

G) ABAP Programmers

Kick of Date means Start date

Form a staring committee

BIL Senior people
WIPRO Senior people
Project Mangers BIL and WIPRO

BIL core team members –As is process existing process and requirements from SAP

WIPRO- Study the process and prepare to be process

GAP reports –Write to SAP the requirement /through programmer/work around /user exits.

WIPRO-Customization based clients requirement .
BIL core team –Testing
WIPRO –Customization document

Before going live
Training to the BIL company users will be given

Fix ago live date:
Customization will be transported from development client to production client.

Up load masters in production client

Upload balances in production client

Give the number  ranges in production client.

On go live date :Enter transactions in production client.

Support: For the issues raised by BIL end users.

Rollouts : Implementing  SAP in different locations afterwards


ASAP  Methodology  (ASAP –Accelerated SAP)
  1. Project Preparation
  2. Business blue print
  3. Realization
  4. Final preparation
  5. Go and live and support

OSS mean Online Support  Service

Land Scape
1.      Development à Quality testing à Production
Send box –All scenarios à configuration selected scenarioà Testing

2.      Development à Production

R/ 3 Structure

Presentation application data base                  SAP Package data stored in data base server

Asset Accounting Report in sap CO

ASSET ACCOUNTING REPORTS:


1.Depreciation forecast

Path :Accounting –Financial accounting –Fixed assets –Information system –Reports on asset accounting –Depreciation for cost –Depreciation on capitalized assets (Depreciation simulation) (Tr code is S_ALR_87012936)

Give the company code                      :BIL
Report date                                         :31.03.2011
Execute

2. Fixed asset schedule as per schedule VI of companies Act



Gross block in the beginning year
Additions during the year
Sales /Transfers during the year
Gross block in the year end
Dep.for the year end
Acc.Dep.in the beginning of year
Dep.for the year
Dep on sales /Transfer
Acc.Dep in the year
Net block in the year end
Net block in the beginning

Information systems –Accounting –Financial accounting –Fixed assets –Asset History sheet (Tr code is AR02

Give your company code                    :BIL
Report date                                         :31.03.2009
Select group totals only radio button
Execute

(Note :Retirement mean sale of asset)

Select asset button

Double click on asset retirement 

Financial Statement Version in sap CO


FINANCIAL STATEMENT VERSION



Balance Sheet and Profit & Loss account format creation

In India –Companies Act –Schedule VI format

Summary                               Schedules                               Amount

Share capital               
                                    Equity share capital                             100000
                                    Preference share capital                      100001
Reserves & Surplus    
                                    General Reserves                                100101
                                    Capital Reserve                                   100102
Secured loans
Unsecured loans

By using 0-9 levels –we can get all 3 versions consultant creates 2 versions –Summary -Schedules 

In 000 Client SAP has given for India Bain.

Path :SPRO-Financial Accounting –General ledger Accounting-Business transactions-Closing –Document-Define financial statement versions.

Select new entries button 
Financial statement version                 :BIL1
Name                                                   Balance Sheet and Profit & Loss account
Maintain Language                             :EN
Select item keys automatic check box
Chart of Accounts                              :BIL
Save
Press enter to save in your request
Select financial statement item button
Keep the cursor on AML1
Select create items button
Give the items             :Balance Sheet
                                    :Profit & Loss account
                                    :Net profit /Loss transfer to Balance Sheet
Enter
Kept the cursor on profit and loss account
Double click on No text exists against Liability +Equity
Give  item                   :Liabilities
Enter
Double click no text exists against Assets
Give the item Assets
Enter
Keep the cursor on Assets
Press select button (beside  reassign button)
Keep the cursor on Balance sheet
Select resign (Shift+F6) button
Select subordinate radio button
Enter
Keep the on liabilities
Press select button (F9)
Keep the cursor on Balance Sheet
Select resign button (Shift+F6)
Select subordinate radio button
Enter
Keep the cursor on Profit & Loss account
Select create item button
Give the items             :Income
Give the items             :Expenditure
Enter
Save
Press enter to save in your request
Keep the cursor on Liabilities
Select create items button
Give the          Share capital
                        Reserves & Surplus 
                        Secured loans
                        Unsecured loans
Enter
Keep the cursor on Assets
Select create items button
Give the items             :Net Fixed Assets
                                    :Net Current Assets
:Misc. expenditure to the extent not written off   Eg: Preliminary exp.
Enter
Keep the cursor on Income
Select create items button
Give the heads            :Sales
                                    :Other Income
                                    :Inc/Dec in Stocks
Enter
Keep the cursor on expenditure
Select create item button

Expenditure :
                        Raw material consumption
                        Personnel expenses
                        Manufacturing expenses
                        Administration Expenses
                        Interest
                        Depreciation
Enter and Save
Double click no text existent  against net result :Profit
Give the item :Net profit transferred from P & L Account
Enter
Keep the cursor on Net profit transfer from P & L Account
Press select button (F9)
Keep the cursor on reserves  & Surplus
Select reassign button (shift +F6)
Select subordinate radio button
Enter
Double click on no text exists against net result loss
Item                 :Net loss transferred from  P & L Account
Enter
Keep the cursor on net loss transferred from P & L Account
Press select button (F9)
Keep the cursor on Misc. Expense to extend not written off
Select reassign button
Select subordinate radio button
Enter
Save

Assignment of accounts are to be assigned to the last note

Keep the cursor on Share Capital
Select assign accounts button
Enter
From Account                         :100000
To Account                             :100099
Select debit check box
Select credit check box
From Account                         :100101
To                                            :199999
Select debit check box
Select credit check box
Note :Expect 100000 all are same
Enter
Keep the cursor on net fixed assets
Select assign accounts button
From Account                         :200000
To Account                             :299999
Select debit check box
Select credit check box
Enter
Keep the cursor on sales
Select assign accounts button
From account                          :300000
To account                              :399999
Select debit and Credit check box
Enter
Keep the cursor on Raw material consumption
Select assign account button
From account                          :400000
To account                              :499999
Select Debit and Credit  check box
Enter
Keep the cursor net profit/loss transferred to Balance Sheet
Select Assign account button
From account                          :100100
Select Debit & Credit Check box
Enter & Save
To check whether all accounts assigned or not
Select check button
Select non assigned account check box
Enter & Save

Liabilities                                                                    Amount
Sources of Funds:
                                    100000
                                    100001
                                    100002
Share capital                100003
                                    -------                                       X
                                    100100
                                    100101
Reserves & Surplus     100102
Secured loans                                                              X
Unsecured loans                                                          X
                                                                                    ------
Total Liabilities                                                           X
                                                                                    =====
Double click on liabilities
Start of group Liabilities
End of group total liabilities

Select display total check box
Enter
Double click on share capital
Start of group              :Source of funds        
End of group               :Share capital
Select display totals check box
Enter
Double click on Reserves & Surplus
End group :Reserves & Surplus
Select display total check box
Enter
Note :Same way secured and unsecured loans
Double click on assets
Start of group :Assets
End of group   :Total Assets
Select display total check box
Enter
Double click on Net fixed Assets
Start of group :Application of funds
End of group   :Net fixed Assets
Select display total check box
Enter
Double click on Misc. expenditure to  extend not written off
End group Misc. expenditure to the expend not written off
Select display totals
Enter
Double click on Profit & Loss Account
End of Group              :Net Profit /Loss for the year
Select display total check box
Enter
Double click on Income
Start of group :Income
End of Group                          :Total Income
Select display total check box
Enter
Double click on sales
End of Group :Sales
Select display total check box
Enter
Double click on Expenditure
Start of group :Total expenditure
Select display total check box
Enter
Double click on Raw material consumption
End of group   :Raw material consumption
Select display total check box
Enter
Double click on net profit /Loss transferred  to Balance sheet
Start of group :Net Profit /Loss transferred to balance Sheet
Select display total check box
Enter
Double click on No text exist against P  & L result
Item     :Net profit/Loss transferred to Balance Sheet
End of Group:  Net profit/Loss transferred to Balance Sheet
Select display total check box
Enter & Save

Open one more session :

Path :Accounting-Financial Accounting –General Ledger-Information system—General Ledger reports-Balance Sheet/Profit loss Statement /Cash flow-General –Actual/Actual comparisons- Balance sheet/Profit Loss Statement (S_ALR_87012284)  

Company code                        :BIL
Business area                           :BILH
Financial Statement version    :BIL1
Reporting year                        :2008
Reporting period                     :1 to 16
Comparison year                     :2007
Comparison periods                :1 to 16
Select classical list radio button
Select special evaluations tab
Balance sheet type                  :1 (Standard Financial Statement )
Select output control tab
Company code summarization :Select 1 (Balance sheet per company code)
Business area summarization :select 1(Balance Sheet per business area)
Summary report                      :3
Comparison type                     :1

Note :2 types of comparison in SAP
                                                            2008                2007
                        Sales                            100                  75
1) Percentage of Increase        Current year –Previous year *100
                                                ----------------------------------
                                                            Previous year
                                    100-75/75*100=33.3




2) Percentage of growth           :Current year *100
                                                    --------------------
                                                    Previous year
                                                100/75=133

Scaling            :5/2

Scaling note :
A) Only Rupees without paise                        0/0
B) Rupees with paise                                      0/2
C)Rupees in lakhs –without decimals             5/0
D)Rupees in mission without decimals           6/0
E)Rupees in crores without decimals              7/0
F)Rupees in laksh –Thousands in decimals    5/2


Sales                                                                987654321.55
Rupees in lakhs (100000)        5 Decimals

            2 decimals                   2 decimals       9876.54

Select execute button
Select back arrow
Select special evaluations tab

Give the display currency dollar execute

central excise and sales tax in sap CO

CENTRAL EXCISE AND SALES TAX


CIN: Country India Version

MM Consultant
SD consultant
FI consultant –Creation of accounts and assignment of accounts

Central excise is an Indirect Tax

This will be charged at the time of sales,  sales men (Removal of goods)

Central excise registration       :15 digits code

(10 digits will be income tax PAN + 5 digits central excise)

Central excise registration will be plant wise
Central excise rates are given in central excise tariff chapter  IDs :8 digits code
Under chapter id we have material description and rate
Basic Excise Duty (BED)       14% maximum (now changed to 10%)
Additional excise duty (AED) –Products like textiles

                                                15% of basic amount –Now no AED
Special Excise Duty (SED)- Tobacco related products
                                                8% on invoice original value
Education cess                        2% (on 8% excise duty)
Higher and secondary education cess  1% (on 2% ED)

CEN VAT (Central Excise Value Added Tax) –Earlier MODVAT

Where we pay excise duty at the time of purchase, the excise amount can be adjusted when we pay excise duty on sales to excise dept.
(Though  collected from customer)

RG23A           Part 1 Quantity updation  -     Excise duty on consumable
                        Part 2 value updation -            100% CENVAT same year

RG23C            Part 1 Quantity updation –     Excise duty on Capita Goods
                        Part 2 value updation -            50% current year 50% next year

PLA                Personal Ledger Account
                        Bank excise credits and debits

ER1                 (Excise return 1) (Earlier it was RT12 monthly return)
                        To pay excise before 5th of next month
                        To file the return before 10th next month

RG1                Finished goods register

Purchase scenario:

                        Consumable purchase                         capita goods purchase (stores)   

Basic price                   100                                          200
Excise 8%                   8                      10%                 20
                                    ----                                           ----
108                                                                                    220
VAT 4%                      4.32                                         8.8
                                    -----                                          ----
112.32                                                                          228.8

Goods receipt for consumables

A)    Goods receipt entry

Inventory RM local     DR                  100
            To GR/IR clearing RM LCL  100
                       

B)    Excise entry

RG 23 A BED                        DR                  8
            To CENVAT clearing             8

Invoice verification for consumables

GR/IR clearing RM LCL        DR                  100
CENVAT clearing A/c           DR                  8
VAT Receivable                     DR                  4.32
            To party                                               112.32

Goods receipt for capital goods

A)    Goods receipt entry
Inventory stores local DR                              200
                        To GR/IR clearing stores Local          200
B)    Excise entry

RG 23C BED                         DR                              10
CENVAT on hold      DR                              10
            To CENVAT clearing a/c                   20

Invoice verification for capital goods

GR/IR clearing stores LCL     DR                              200
CENVAT clearing a/c             DR                              20
VAT Receivable                     DR                                8 .08
            To party                                                                       228.08
                       
Sales scenario
Basic price                               1000
Excise rate       14%                 140
                                                -----
                                                1140
VAT 12.50%                           142.5
                                                -------
                                                1283

Sales billing :
Customer A/c              Dr        1283
            To Sales                       1000
            To CENVAT suspense 140
            To VAT payable         142.50

Excise invoice creation
CENVAT suspense a/c Dr      140
            To Excise duty payable 140

Excise Balances:

                                                                                    RG23A           RG23C            PLA
Purchase                                                                                  8                      10
Payable on sale            140
            To pay                                                                         5                      6          129


PLA Deposit 
PLA A/c          Dr        150
            To Bank          150

Excise utilization
Excise duty payable  DR        140
            To RG23A BED         5
            To RG23C BED         6
            To PLA                       129



10) Sales tax Payment to Dept

            VAT Payable              143
            VAT Receivable         13
                        To Bank          130

            VAT Payable Dr                    143
                        To VAT Receivable    13.10
                        To Bank                      129

11) Final balances in excise registers

                                                RG23A                       RG23C                        PLA
Purchase /Deposit                   8                                  10                                150
Utilized at the time of sale      5                                  6                                  129
                                                -----------------------------------------------------------------
Closing balance                       3                                  4                                  21
                                                ======================================
SAP:

Tax procedures TAXINJ: Formula based
                          TAXINN condition based

In new implementations –TAXINN
Client 000-SAP has given TAXINN and TAXINJ
Excise conditions /Service tax conditions / Education cess conditions /Sales tax conditions.


CENTRAL EXCISE CUSTOMIZATION

Activate Country Version India for specific fiscal year

Path :SPRO-Financial accounting –Financial accounting global settings –Tax on sales /purchases –Basic settings- India-Activate country version India for specific fiscal years

Select position button
Component                 :select IND
Enter
For component IND select active check box
Save
Press enter to save in your request



Check and change settings for tax processing

Path :Up to tax on sales / purchases the path is same –Basic settings-Check and change settings for tax processing

Select new entries button
Process                        :B1
Description                  :A/P Basic Excise duty (A/P BED)
Tax type                      :select 2 (input tax)
Posting indicator         :select 2 (separate line item)
Save
Press enter to save in your request
Select back arrow
Select process              :B1
Select copy as button
Change the process to B2
Change the description :A/P CST
Posting indicator         :select 3 (Distribute to relevant expense /revenue items)
Enter & Save
Select              :B1,B2
Select copy as button
Change the process to B3
Change description to APVAT
Enter
Change the description to AR VAT
Other things are common
Press enter and Save
Change process to B5
Change description to AR CST
Change tax type to      :1
Posting indicator         :2 separate line item
Enter and Save
Select B5
Select copy as button
Change the process to B6
Change the description  to AR VAT
Other things are common
Press enter & Save

Define condition types:

Path :Up to tax on sales /purchases the path is same  -Basic settings-Check calculation procedure –Double click on define condition types

Select new entries button
Condition type                                    :BIL1
Description                              :AP Excise BED
Access sequence                     :select JTAX (IN: Excise Access)
Condition class                       :select D (Taxes)
Calculation type                      :select A (percentage)
Condition category                 :select D (Tax)
Select item condition check box
Save
Press enter to save in your request
Select back arrow
Select                                      :BIL1
Select copy as button
Change the condition type change  to :BIL2
Change the description to       :APCST
Access sequence                     :Change to JST1 (India Sales tax access)
Enter & Save
Select                                      :BIL2
Select copy as button
Change condition type to       :BIL3
Change description                 :A/P VAT
Other things are common
Enter & Save

Define procedures

Path :Up to tax on sales /purchases the path is same –Basic settings –Check calculation procedure

Double click on define procedures
Select new entries button
Procedure                                :TAXINN
Description                              :Sales tax India
Save
Press enter to save in your request

Select                                      :TAXINN
Double click on control data folder


Select new entries button

Step
Condition type
Description
From
To
Statistics
Print
Base type
Account key
100
Select BASB
Base amount




Select 362

110

Calculated cell
100
100
Select static’s check box



120
BIL1
AP Excise BED
100
100

Select X

B1
150

Basic +Excise
110
140
Select static check box




160
BIL2
A/P CST
150
150

Select X

B2
170
BIL3
A/P VAT
150
150

Select X

B3

Save




Assign country to calculation procedure

Path :Up to tax on Sales /Purchases the path is same –Basic settings –Assign country to calculation procedure

Select position button
Country                                   :IN for India
Enter
For country IN assign procedure TAXINN
Save
Press enter to save in your request

Define tax codes for sales and purchases

Path :Up to tax on sales / purchases the path is same –Calculation –Define tax codes for sales and purchases (Tr code is FTXP)  

Give the country                     :IN
Enter
Tax code                                 :V0
Enter
Give the description                :0% Input tax
Tax type                                  :V (input tax)
Enter
Save
Tax code                                 :V1
Enter
Description                              :V1 Dummy tax code for purchases
Tax type                                  :V for input tax
Tax percentage rate                 :0
Enter & Save
Tax code                                 :A0
Enter
Description                              :0% output tax
Tax type                                  :A ( out put tax)
Enter & Save
One more tax code
Tax code                                 :A1
Enter
Description                              :Dummy tax code for sales
Tax type                                  :A (Out put tax)
Enter & Save



Creation of GL masters (FS00)
                                                                                                                        To Copy

200156            RG23A BED A/c Current assets, Loans & Advances to copy 200155 VAT
receivable

200157            RG23C BED A/c Current Assets, Loans and Advances to copy 200155 VAT
receivable

200158            CENVAT on hold Current Assets, Loans and Advances to copy 200155
VAT receivable

200159            PLA Account Current Assets, Loans & Advances to copy 200155 VAT
Receivable

200155            VAT receivable already created

100506            CENVAT A/c clearing current liability provision copy 100505 VAT payable

100507            CENVAT A/c suspense current liability & provisions copy 100505 VAT payable

100508            Excise duty payable A/c current liability & provision copy 100505 VAT payable

100509            CST payable  A/c current liabilities & provision X copy 100505

100505            VAT payable already created

Save

Note :In all accounts tax category * posting without check box



Define tax accounts

Path :Up to tax on sales /purchase the path is same posting –Define Tax accounts (Tr code is OB40) 

Double click transaction B1 A/P Excise BED
Give the chat of accounts       :BIL
Enter
Save
Select posting key button
Debit               40
Credit              50
Save
Press enter to save in your request
Select accounts button
Give the account no.100506 CENVAT clearing A/c
Save
Press enter to save in your request
Select back arrow
Double click on transaction B3 APVAT
Save
Select posting key button
Debit   40
Credit 50
Save
Press enter to save in your request
Select accounts button
Give the A/c no.200155 VAT receivable
Save
Press enter to save in your request




Maintain excise registration 

Path :SPRO-Logistic general –Tax on goods movements –India –Basic settings –maintain excise registrations

Select new entries button
Excise registration       :2
(ECC number means excise control code)
ECC no.                      1234
Excise Registration no.(15 digits code)
(10 digits PAN other 5 Excise no.)     :123456
Excise range                            :Kukatpally range
Excise division                        :Kukatpally division
Commissionerate                     :Hyderaba commissionerate
Excise invoice items(EI)         :999
Select partial credit check box
Save
Press enter to save in your request

Maintain company code settings
Same path

Select new entries button
Select company code              :BIL
Select details button
CENVAT document type       :SA
Utilization FI document type :SA
Select debit account override check box
Select auto adjustment indicator check box
Select immediate credit on capital goods check box
First month                              “select April
Excise selection days              :30 days
No.of excise invoice selection :999
Excise invoice selection procedure     :FIFO
Save
Press enter to save in your request

Maintain plant settings:
Same path

Select new entries button
Plant                                        :BILP
Excise registration                   :002 (This is plant level)
No.GRS per Excise invoice    :select Multiple goods receipt multiple credits
Save

Maintain excise groups:
Same path

Select new entries button
Excise group                           :2
Description                              :Excise group for BILP
Plant                                        :BILP
Excise registration                   :2
No.GRS per excise invoice multiple goods receipts, multiple credits
Select default challan quality in GR check box 
Select EI capture check box under MIGO settings
Select post excise Invoice MIGO check box
Select duty different at GR check box
Select update RGI at MIGO check box
Save
Press enter to save in your request
Note :MRO –Invoice verification

Maintain series groups
Same path
Select new entries button
Series group                            :2
Series description                    :BILP series group
Excise registration                   :2
Save
Press enter to save in your request

Maintain excise duty indicators:
Same path
Select new entries button
Excise indicator 1       :100%  Tax
Excise indicator 2       :50%  Tax
Excise indicator 3       :Nil Tax
Save
Press enter to save in your request

Maintain excise defaults:

path :Up to India the path is same –Basic settings –Determination of excise duty –maintain excise defaults

select new entries button
Tax procedure                         :TAXINN
CVD condition                       JCV1:
A/P BED condition type        :BIL1
A/R BED condition type        :BILA
BED percentage                      :BIL 4
Save
Press enter to save in your request

Maintain chapter ID’s:(8Digists excise code)

Path :Up to India the path is same –Master data –Maintain chapter Id’s

Select new entries button
Chapter ID      :50000001
Unit of measurement for excise kg
Description as per law  :Chemicals
Save
Create request  in your  Work Bench Request for BIL
save
Select next entry (F8) button
Chapter ID                  :55000001
Unit of measurement for excise kg
Description as per law Steel
Save




Specify G/L Accounts per excise transaction

Path :Up to India the path is same –Account determination –specify GL accounts per excise transaction

Select new entries button
Excise group                           :select 2
Excise transaction type           :GRPO (Excise Invoice for goods receipt against PO)
Company code                        :BIL
Chart of Accounts                  :BIL
RG23A BED                          :200156
RG23C BED                          :200157
MODVAT clearing                 :100506 (CENVAT clearing )
G/L account per PLA BED    :200159
CENVAT on hold                  :200158
CENVAT suspense account   :100507
PLA on hold                           :200159
Save
Press enter to save in your request
The same way the you send the accounts for all excise transaction types.
For excise transaction type DLFC  same as above
Save
Note :              PLA on Hold                          Dr
                                    To Bank


                        PLA A/c                                  Dr
                                    To PLA on Hold A/c
                        (This is used for next year carry  forward)


Specify SAP Script forms

Path :Up to India the path is same –Business transactions –Excise registers –Specify SAP script forms

Select all the registers of company Code                    :IN01
Select copy as button
Change the company code to BIL for Registers and returns
Save press enter to save in your request

Maintain number ranges
Path :Up to India the path is same –Tools-Number ranges

Object                         :Select J_1IINTNUM (Internally document number to be generated )
Select number rages button
Select change intervals button
Select interval button
Number rage   :01
Year                :2008
From no.          :1
To no.              :100000
Save
Ignore the message press enter
Select back arrow two times
Object                         :Select J_1IRG23A1 (RG23A part 1 no. range object)
Select number rages button
Excise group   :select 2
Select change intervals button
Select interval button
No. range        :01
Year                :2008
From number   :100001
To number       :200000
Enter & save
Ignore the warning message press enter
Select back arrow two times
Object                         :J_1IRG23A2 This is (RG23A part II Number rage object)
Select number rage button
Excise group   :2
Select change intervals button
Select interval button
No.range         :01
Year                :2008
From no.          :200001
To no.              :300000
Enter & save
Ignore the warning message press enter
Select back arrow two times
Select object J_1IEXCLOC (Local excise invoice number rage for sales)
Select number ranges button
Series group    :2
Select change intervals button
Select interval button
No.range         :01
Year                :2008
From number   :300001
To number       :400000
Enter & Save
Ignore the warning message press enter
Select back arrow two times
Select object    :J_1IINTPR2 despatch series number
Select number ranges button
Excise group   :2
Select change intervals button
Select interval button
No.range         :01
Year                :2008
From no.          :500001
To no.              :600000
Enter & save
Ignore the warning message press enter

Excise rates maintenance  

Use the Tr code is J1ILN (India local menu) (This have no path)

Path :Indirect taxes -Master  data -Excise rate maintenance (Tr code is J1ID)

Select material & chapter ID combination radio button
Select maintain button(F5)
Select new entries button
Material                       :BILRM1
Plant                            :BILP
Chapter ID                  :5000001 Chemicals
Material type               :Raw materials
GR with reference      :select multiple goods receipt , multiple credits
Declared                      :1
Declaration date          :29.02.2008

One more
Material                       :BILFG
Plant                            :BILP
Chapter ID                  :5500001 Steel
Material type               :RG1
GR with reference      :Multiple goods receipts, Multiple credits
Declared                      :1
Declaration date          :29.02.2008
Save
Select back arrow
Select CENVAT determination radio button
Select maintain button
Select new entries button

Give the plant                         :BILP
Input material              :BILRM
Output material           :BILFG
Intimation date           :01.04.2008
Save
Select back arrow
Select vendor excise details radio button
Select maintain button
Select new entries button
Vendor                        :2001
Excise indicator for vendor :1 ( 100% Tax)
Type of vendor           :select manufacturer
Save
Select back arrow
Select customer excise details radio button
Select maintain button (F5)
Select new entries button
Give the customer no. :200101
Excise indicator for customer             :select 1 (100% Tax)
Save
Select back arrow
Select excise indicator for plant radio button
Select maintain button
Select new entries button
Company code                        :BIL
Plant                                        :BILP
First month                              :select April
Excise indicator for company :select 1 (100% Tax)
Save
Select back arrow
Select excise indicator for pant and vendor radio button
Select maintain button 
Select new entries button
First column excise indicator :select 1
Second column excise tax indicator for vendor         :select 1 (100% Tax)
Third column excise tax indicator for vendor             :Select 1 (100% tax)
Save
Select back arrow
Select excise indicator for plant & customer radio button
Select maintain button
Select new entries button
First column excise tax indictor for company             :select  1 (100% tax )

Second column Excise indicator for vendor  :Select 1 (100% tax)
Third column excise tax indicator vendor :select 1 (100% tax)
Save

Creation of condition records
(FV11) (No path this one)

Condition type                        :select BIL1 AP Excise basic
Select key combination  button
Select plant /vendor /material radio button
Enter
Plant                            :BILP
Vendor                        :2001
Material                       :BILRM1
Amount                       :8 (Excise rate & Tax rupees)
Valid from                  :01.04.2008
Valid to                       :31.03.2009
Tax code                     :V0
Save
Select back arrow
Condition type            :BIL3 A/P VAT
Select key combination button
Select plant /vendor /Material  radio button
Plant                            :BILP
Vendor                        :2001
Material                       :BILRM1
Amount                       :4
Valid from                  :01.04.2008
Valid to                       :31.03.2009
Tax code                     :V0
Save

SD Excise customization

SD consultant job

Define condition types

Path :SPRO-Sales & Distribution –basic functions –Pricing –Pricing control –Define condition types

Double click on maintain condition types
Select new entries button
Condition type                        :BIL4
Description                              :A/R Basic excise duty (AR BED)
Access sequence                     :JEXC (India Excise Access)
Plus/ Minus                             :Select A Positive
Condition class                       :select A discount or Surcharge
Calculation type                      :select A (Percentage )
Select Item condition check box
Select amount /percentage check box
Save
Press enter to save in your request
Select back arrow
Select                          :BIL4
Select copy as button
Change the condition type to BILA
Description A/R Excise  BED (100% copy)
Access sequence         :select JDUM (India 100 copy of other fields are values)
Enter & Save
Select BIL4 & BILA
Select copy as button
Change condition type to BIL5
Description                  :A/R CST
Access sequence         :select JCST (India Central Sales Tax :Access)
Plus / Minus                : Blank
Calculation type          :A (Percentage)
Condition class           :change to D (Taxes)
Condition category     :select D (Tax)
Enter
Change the condition type to BIL6
Description                  :AR VAT
Access sequence         :change to JLST (India Local sales tax access)
Plus or Minus              :Blank
Calculate type                         : A (Percentage)
Condition class           :select D taxes
Condition category     :select D tax
Enter & save

Define account keys:

Path :SPRO-Sales & Distribution –Basic functions –Account assignment/costing –Revenue account  determination –Define and assign account keys –Double click define account key

Select new entries button
Account key                :B4
Name                           :A/R Excise BED

Account key                :B5
Name                           :AR CST

Account key                :B6
Name                           :AR VAT
Save
Press enter to save in your request

Check and change settings for tax processing

Path :SPRO-Financial accounting –Financial accounting global settings –Tax on sales /Purchases –Basic settings –Check and change settings for tax processing

Select B2 and B3
Select copy as button
Change the process to B5
Change the description to A/R CST
Tax type                      :select 1 (Output tax)
Posting indicator         :select 2 (separate line item)
Enter
Change process to       :B6
Change the description to A/R VAT
Tax type                      :change to 1 Output tax
Enter & save
Save in your request

Define tax accounts:

Path :up to Tax on sales /Purchases the path is same –Posting –Define tax accounts (Tr code is OB40)

Double click on truncation      :B5 AR CST
Give your Chart of Accounts             :BIL
Enter
Save
Select posting key button
Debit               :40
Credit              :50
Select save button
Press enter to save in your request

Select accounts button
Give the account no.100509 CST (payable)
Save

Press enter to save in your request
Select back arrow
Double click on transaction    :B6 ARVAT
Save

Select posting key button
Debit   :40
Credit :50
Save
Press enter to save in your request
Select accounts button
Give the account no.100505 VAT payable
Save
Press enter to save in your request

Maintain pricing procedures

Path :SPRO-Sales & Distribution –Basic functions –Pricing –pricing control –Define and assign pricing procedures

Double click on maintain pricing procedures
Select new entries button
Procedure                    :BIL
Description                  :BIL domestic Pricing procedure
Save
Press enter to save in your request

Select                          :BIL
double click on control data folder
Select new entries button







Step
Condition type
Description
From
To
Require
Statistics
Print
Account key
100
PR00
Price


Select Check box (√)

X
ERL


Subtotal
100
100
Select Check box (√)
Select Check box (√)


200
BIL 4
A/R Basic excise duty 


100
100



B4
210

Basic +Excise
100
200

Select Check box (√)


400

Base value
100
--

Select Check box (√)


410
BILA
A/R BED (100% copy) Basic +Excise
200
200

Select Check box (√)
X

420


400
410

Select Check box (√)


450
BIL5
AR CST
420



X
B5
460
BIL6
AR VAT
420



X
B6
500

Basic +Excise+ Sales tax
420
460

Select Check box (√)


Save



Define pricing procedure determination

Path :Up to pricing control the path is same –Define and assign pricing procedures ( Tr code is OVKK)

Double click on define pricing procedure determination
Select position button
Sales organization       :BILS
enter
For BILS change the pricing procedure to BIL
Save
Press enter to save in your request

Define tax determination rules

Path :SPRO-Sales and Distribution –Basic functions –Taxes –Define tax determination rules

Select new entries button
Tax country                 :IN
Sequence                     :1
Tax category               :BIL5

Tax country                 :IN for India
Sequence                     :2
Tax category               :BIL6 Name:A/R VAT
Save
Press enter to save in your request

Define tax relevancy of mater records:
Same path
Double click on customer taxes
Select new entries button

Tax category
Name
Tax classification
Description
BIL5
A/R CST
0
Nil Tax
BIL5
A/R CST
1
Taxable
BIL6
A/R VAT
0
Nil Tax
BIL6
A/R VAT
1
Taxable
Save
Press enter to save in your request

Select back arrow
Double click on material taxes
Select new entries button

Tax category
Name
Tax classification
Description
BIL5
A/R CST
0
Nil Tax
BIL5
A/R CST
1
Taxable
BIL6
A/R VAT
0
Nil Tax
BIL6
A/R VAT
1
Taxable

Save
Press enter to save in your request

Assign delivering plants for tax determination (OX10)
Same path

Select position button
Plant                            :BILP
Enter
Select plant                 :BILP
Select details button
Select address button(Shift +F5)
Region                         :select AP (Andhra Pradesh)
Enter & Save
Press enter to save in your request

Assignment of accounts for automatic postings
Tr code is VKOA

Double click on Table 1
Select new entries button
Application area                      :V
Condition type                        :KOFI
Chart of Accounts                  :BIL
Sales organization                   :BILS
Account assignment group for customer :01 domestic revenues
Account assignment group for customer :03 finished goods

Account assign group for account key :B4 AR Excise duty
GL Account 100507 (Send VAT suspense account)
Save
Press enter to save in your request

SD END USER AREA

Assign  tax classification material master (Tr code is MM02)

Give the material no.BILFG
Press select view button
Select sales :sales organization  data 1
Select organization levels button
Plant                            :BILP
Sales organization       :BILS
Distribution channel    :BD
Enter
For tax classification  tax category BIL5 0 taxable
For tax classification tax category  BIL6 1 taxable
Save

Enter tax classification in customer master (Tr code is XD02)

Select the customer                 :200101
Company code                        :BIL
Division                                   :BS
Select customer sales area button
Double click on sales organization      :BILS
Enter
Select sales area data button
Select billing documents tab
For tax category                      :BIL6
Tax classification                    :1 (taxable)
Save


Creation of condition records (Tr code is VK11)

Condition type            :select BIL4 A/R basic excise duty
Select key combination button
Select material radio button
Enter
Sales organization       :BILS
distribution channel    :BD
Material                       :BILFG
Amount                       :10
Valid from to              :01.04.2008
Valid to                       :31.03.2009
Save
Select back arrow
Select condition type BILA (A/R BED 100% copy)
Select key combination button
Select sales organization radio button
Enter
Sales organization       :BILS
Amount                       :100
Valid from                  :01.04.2008
Valid to                       :31.03.2009
Save
Select back arrow
Condition type            :select BIL6 AR VAT
Select key combination button
Select country /Plant/Region /Material radio button
Enter
Country                       :IN
Plant                            :BILP
Region                         :AP
Material                       :BILFG
Amount                       :4 (Percentage)
Valid from                  :01.04.2008
Valid to                       :31.03.2009
Tax code                     :select A1 (Dummy tax code for sales)
Save

To check whether 0% input tax code and 0% output tax code assigned to company code to BIL

Path :SPRO-Financial accounting –Financial accounting global settings –Tax on sales /Purchases -posting  -Assign tax codes for non taxable transactions(OBCL)

Select position button
Company code                        :BIL
enter
For company code                  :BIL
Input tax code                                     :V0
Output tax code                      :A0
Company code                        :BIL
enter
For company code                  :BIL
Input tax code                                     :V1
Output tax code                      :A1
Save
Press enter to save in your request

Creation of Purchase order (ME21N)

Purchase org                                        :BILR
Company code                                    :BIL
Vendor                                                :2001
Enter
Give the purchasing group                  :BIL
Item                                                     :10
Material                                               :BILRM1
PO Quantity                                        :100 Kgs
Net price                                             :75
Currency                                             :INR
Plant                                                    :BILP
Enter
Select invoice tab
Tax code                                             :select V1 dummy tax code for purchases
Enter
Select Taxes button
Select back arrow
Save
Not the purchase order no.4500017094

To open material periods for January (MMPV)

From company code                           ;BIL
period                                                  :10
Fiscal year                                           :2008
Select check and close period radio button
Execute
Ignore the warning message press enter

(Note :  Use the Tr code J1IEXfor creation of Excise Invoice no’s following the other steps same above)
Give the Excise  invoice no. and date

Goods receipt ( Tr code is MIGO)
Select goods receipt
Give the purchase order no.4500017094
Enter
Quantity in delivery note        :100 kgs
Select item ok check box
Select where tab
Storage location                      :HYD
Press enter
Select excise invoice tab
Give the excise invoice no.1
Excise invoice Date                            :Today’s date
Save
Select display button
Enter
Select document information tab
Select FI documents button
Select back arrow
Select excise invoice tab
Select more data button
Select part 2 tab
Select accounting document no.

Invoice verification (MIRO)

Invoice date                :05.01.2009
Posting date                :11.01.2009
Reference                    :51
Select calculate tax check box
Text                             :Invoice verification
Tax code                     :V1 (Dummy tax code)
Purchase order no.      :4500017094
Enter
Give the amount         :8424
Enter
Business area               :BILH
Select payment tab      :Base line date  (Today’s date)
Payment term              :0001
Enter & Save
From the menu select invoice document display
Select follow on documents button
To print excise registers: (Tr Code is J1ILN)

Path :Indirect taxes –Registers –Excise tax –Extract (J2I5)

Excise group                           :2
Start date                                :01.01.2009
End date                                 :31.01.2009
Select any register radio button
Select RG23A part I check box
Select RG23A part II check box
Execute
Enter
Select back arrow
Select print utility program (TR code is J2I6)
Select RG23A part 1 radio button
Execute

Excise group                           :2
Start date                                :01.01.2009
End date                                 :31.01.2009
Execute
Output device                                     :LP01
Select print preview button
Select back arrow two times
Select RG23A part II radio button
Execute
Excise group                           :2
Start date                                :01.01.2009
End date                                 :31.01.2009
Execute
Output devise                                     :LP01
Select print preview button

To view sales tax register (Tr code is J 1 I L N)

Indirect taxes –Registers –Sales tax –sales tax register (J1I2)

Company code                        :BIL
Tax code                                 :V1
LST condition type                 :BIL3
Execute




SD EXCISE

Creation of sales order  (VA01)

Order type                   :OR
Sales organization       :BILS
Distribution channel    :BD
Division                       :BS
Enter
Sold to party               :200101
PO Number                 :2
PO date                       :Today’s date
Required delivery date :Today’s date
Delivery plant                         :BILP
Payment terms                        :0001
Item                             :10
Material                       :BILFG
Order quantity            :10 Kgs
Enter
Ignore the message press enter
Select item                  :10
From the menu select GotoàItem conditions
From the menu select Edit –In complication log (Ctrl +F8)
Select save button
Note the sales order no.11771

Delivery (Tr code is VL01N)

Give the shipping point           :BILH
Order no.                                 :1171
Enter
Actual goods inward received date    :Today’s date
Select item                              :10
Select picking tab
Picked quantity                       :10 Kgs
Select post goods issue button
From menu select out bound delivery –Display
Enter
From the menu select Environment-Document flow
Keep the cursor on  go goods delivery no.
Select display document button
Select accounts document button
Select account document no.

Post :               Inventory FG              700
IN/DE Stock FG         700



 Sales Billing (VF01)

Select the delivery no.
Select execute button
Save
From the menu select billing document –display
Select accounting button
Select accounting document no.

Excise invoice creation (Tr code is J1ILN)

Path :Indirect taxes –Sales /Out bond movements-Excise invoices –For sales order –Out going Excise invoice create /Change /Display  (Tr code is J1IIN)

Select from billing button (F5)
Enter
Excise group to                       :2
Serious group                          :2
Select utilization button  (F6)
Save
Ignore the warning message press enter

CENVAT suspense A/c Dr
            To Excise duty payable

Go and see sales billing display (VF03)

Give the billing document no.90036108
Select accounting button
Select accounting document no.

RG23A BED posting (F-02)

Give the document date         :Today’s date
Type                                        :SA
Company code                        :BIL
Posting key                             :40
Account no.                            :200156 (RG23A BED)
Enter
Amount                                   :50000
Business area                           :BILH
Text                                         :RG23A Debit
Posting key                             :50
Account no.                            :200105 Bank account
Enter
Amount                                   :*
Business area                           :BILH
Text                                         :+
Document –Simulate & Save

PLA Deposit  (F-02)

Give the document date         :Today’s date
Type                                        :SA
Company code                        :BIL
Posting key                             :40
Account no.                            :200159 (RG23A BED)
Enter
Amount                                   :100000
Business area                           :BILH
Text                                         :PLA deposit
Posting key                             :50
Account no.                            :200105 Bank account
Enter
Amount                                   :*
Business area                           :BILH
Text                                         :+
Document –Simulate & Save



Excise duty payment: (Tr code is (J1ILN)

Path :Indirect taxes –Sales /Out bond movements –fortnightly payment (J2IUN)

Company code                        :BIL
Plant                                        :BILP
Excise group                           :2
Period                                      :01.03.2009      to        Today’s date
Business area                           :BILH
Execute
RG23A Utilized                                 :6.60
Select duty  button
Select Simulate button (F7)
Select right mouse button
Select continue button
Save

Go and see the document (FB03)

Document no.                         :38
Company code                        :BIL
Fiscal year                               :2008

Enter