Thursday, 30 August 2012

India Localization for SCM - Presentation Transcript
1. India Localizations for SCM Ravi Sagaram, PMP Motorola
2. Agenda
o Introduction to India Localization
o India Taxes
o Localization Setups
o Localization in Purchasing
o Localization in Order Management
o Question and Answers
3. Introduction
o India Localization is complying with the India Specific Tax Requirements.
o India Localization Patch set has to be applied for India Localization over and above the standard R12 implementation.
o India Localization Provides some seeded responsibilities like India Local Purchasing, India Local Inventory, India Local Order Management, India Local Payables, India Local Receivables etc. Also it provides India related menus, functions, reports etc.
o Localization provides provision for defining of taxes, defaulting of taxes, recording of taxes, calculation of taxes, and reporting of taxes.
4. Taxes
o Central Excise
o Sales Tax
o Income Tax
o Customs Duty
o Service Tax
5. Central Excise
o Applied to both manufacturing and trading Orgs when the organization is excise registered.
o It is a federal tax controlled by the central excise department.
o A CE registration called ECC# is required for each physical location. If there are two inventory orgs at the same location, they will share a common ECC#
6. Sales Tax
o Sales Tax is administered by States
o The Tax is applied at the time the product is sold to the end customer
o There are 2 components for Sales tax– Central Sales Tax and Local Sales Tax. Different tax registration is required for both of them
o The head office would be responsible for tax settlement and accounting for all the tax registered orgs.
o Each state will have a separate LST and CST registration numbers. These are defined at each inventory Org.
o If multiple Inventory orgs fall under one state, they all will use the same CST and LST registrations.
7. Income Tax
o Head office is normally registered with the Income Tax at the LE level. PAN (Permanent account number) will be allocated for the head office, defined at the LE.
o TAN (Tax Deduction Account Number) is allocated by the local Income Tax jurisdiction office for the income tax under local jurisdiction at the OU level.
o A separate TAN Number is required for each OU that fall under different states
o A common TAN can be used for multiple OUs if they are all under the same State
8. VAT
o Value Added Tax (VAT) is a tax levied on the value added to a product at different stages.
o VAT is a tax levied at each of the stages in a multi point entry in the supply chain with the facility of set-off of input tax. It is levied by States in the place of Sales Tax.
o A manufacturer may pay VAT on input raw materials and recovers that tax when he sells the finished goods to a dealer. The difference of tax collected from the dealer and the tax paid for the raw materials is paid to the tax authority.
o Similarly, a dealer may pay VAT on the finished Goods and recovers that tax when he sells it to a retailer. The tax after recovery is paid to the tax authority.
o Finally the end customer pays the VAT to the retailer. The retailer recovers his portion of the tax he paid and pays the balance to the tax authorities.
o CENVAT is a Central VAT. You have the provision to claim this tax at the time of receipt. The RG registers are updated with the CENVAT entries at the time of receipt.
9. Customs Duty
o Customs Duty is paid on goods when goods are imported into India
o It is paid in INR as a % of the duty over the value of goods received in foreign Currency.
o In Oracle, provision is made to pay this duty as a prepayment before receiving the materials and it is adjusted against BOE given by Customs.
o When goods are received into the inventory org, they should be associated with the BOE Tax amount paid on them at the time of import.
o These Entries are registered in a Tax Register called RG23D
o While Shipping the goods on a sales order, the deliveries are associated with these registry entries.
10. Service Tax
o Service tax is paid for the services rendered. Examples are telecom service, tax services, consulting services Etc.
o You can define Tax regime for Service tax and have service tax registration.
12. Setups
o Localization Setups
Inventory Orgs
Sub Inventories
Tax Regimes
Service Tax
Bond Register
13. Define Addl. Info for Inv Orgs
o The information that you provide in the organization additional information using India Localization would become the basis for the recording, reporting and accounting for the tax
o Setup Inventory Orgs in the regular way
o Setup records for each inventory Org and inventory location in the Organization additional information
o Each organization should have a record with Null location first. The other records for each location should be defined there after
o Each organization has tabs for providing Tax Info, Accounting Info and Trading Info.
o In the Tax info, Provide the Excise Registration Information, Sales Tax registration Information.
o In the Accounting Info tab, provide all the accounting related information.
o In the Trading Info, provide the trading excise registration information related to the trading orgs.
14. Define Addl. Info for Inv Orgs (Contd..)
o Each organization should have a record with Null location first.
o Each organization has tabs for providing Tax Info, Acct Info and Trading Info
o Provide the Excise Information, Sales Tax information, Income tax information,and VAT registration info under this tab
o Once you enter the excise info, the org will be treated as Manufacturing Org
o Create separate records for each location
o You can set up one of those records as Master and the other as Child Orgs for Excise. Then Excise will be consolidated at the Master org level
o Most of the excise info that you specify here will print on the excise related documents.
o Most of the Sales Tax info that you provide here would print on the sales tax documents.
o If you enter excise info in the Tax Info tab, then you will not be able to enter the excise info under the trading tab. An Organization is either a manufacturing org or a trading org but not both.
15. Define Addl. Info for Inv Orgs (Contd..)
16. Define Addl. Info for Inv Orgs (Contd..)
o Provide the Excise information under trading info tab for the trading organization
o Checking Excise in RG23D option will create entries in the RG23D register. If this is not selected, then the excise amount will be added to the inventory cost on receipt
o Order Price Inclusive Option includes the Excise tax in the order price. If the option is checked, then excise duty is not added to the receivables account. If it is unchecked, then the excise tax is added to the receivables account
17. Associate Sub Inventories with India Localization
o Associate sub inventories for India Localization
o Check the Bonded flag for the Excise related Sub Inventories. Then only Excise related transactions will be recorded.
o Check the trading flag for trading Organizations.
18. Setup item templates for India Localization and apply the templates to Items
o Apply these Item templates to Items for each Inventory Org
o You can override the attribute values derived from the template
You can define Item Templates for Excise and VAT and apply the template attributes to the items. Template Attributes
19. Template attributes for items under VAT and Excise Yes RECOVERABLE     Finished Goods ITEM CLASS     Yes APPLICABLE Value Added Tax           No RECOVERABLE     Finished Goods ITEM CLASS     Yes APPLICABLE Vat Not Recoverable VAT Attribute Value Attributes Template Name Type Yes EXCISABLE     No MODVATABLE     Finished Goods India ITEM CLASS     Yes TRADABLE Excise Tradable EXCISE
20. Setup Tax Calendar
o Tax Year in India is from 1 st April to 31 st March
o This task needs to be done every tax year.
o Do not open the tax year for the next year by mistake as it will become current and cannot be changed.
o If Excise invoice has to be generated with a specific prefix, then complete the setups under Excise Generation
21. Define Tax Authorities as Vendors
o Define Customs, Excise, VAT and Service Tax authorities as Vendors in the Payables.
o Appropriate Vendor Type has to be selected while defining these vendors. For example while defining the Customs Authority, select the vendor type India Customs Authority
o Some of the types are India Custom Authority, India Excise Authority, India VAT authority etc.
o You will cut Payables Invoices to these authorities for the taxes to be paid.
22. Regimes Registration
o Setup VAT and Service Tax Regime Registrations
o You specify the registration numbers, Tax Types and the inventory Orgs for which it is applicable
o Also you specify the tax account details like Liability Account, Recovery Account etc.
o The Regime would be used to define the rules that are applicable to all the taxes assigned to it. Taxes defined under the regime would default only for those organizations assigned to it. You can over ride them at the org level.
23. Define Bond Register
o Setups in Bond Register are required to generate Excise Invoice numbers and Updation of excise registers.
o You specify the Order type from OM in bond register to associate the related excise transactions
o The excise transactions related to manufacturing and trading need to be associated with the bond register.
o By associating the order types to the excise transactions for an inventory org and location, excise records will be passed based on the nature of goods cleared.
o Some of the register types are Trading Domestic with Excise; Trading Export with Excise; Export with Excise etc.
24. Defaulting of Taxes
o The item category will list items and associated tax category
o When POs are created, taxes are defaulted from Item category specified on the supplier and supplier sites in the additional supplier information.
o In PO Receipts, taxes are defaulted from the PO Lines.
o When Sales orders are created, taxes are defaulted on the sales orders from Item Category Specified on the customers and customer site in the additional customer information.
o When lines are shipped, the lines will have taxes defaulted from sales orders
25. Define Additional Info for Supplier and Customers
o VAT, Excise and Service tax registrations can be defined for each supplier, supplier site, customer and customer site.
o The information that you setup here would be the basis for tax defaults on PO and SO.
o These can be setup in the additional Supplier or customer information
o VAT info on customer is mandatory for VAT Invoice Generation
o Assessable Price List is used where excise or VAT has to be calculated based on assessed amount rather than line price.
o Localization in PO
o for a trading org
27. Flow of Customs Duty on a PO in a trading Org Create a Tax Category Create PO and Apply Tax Category to PO and submit PO for approval Enter BOE Invoice Interface BOE with AP And generate AP Invoice Create a Receipt Apply the BOE amount to the receipt Verify the Registry Entry And accounting
28. Setup Taxes and Tax Categories for India
o Define Taxes separately and group them together into tax categories
o Taxes are OU specific.
o When you define tax category, you can define tax over tax, or tax over basic amount etc.
o When You create Purchase orders and sales orders, it is easy to apply these tax categories on each PO and SO line than several individual taxes
Credit % indicates the credit that can be claimed Tax % Tax Category Taxes Tax
29. Setup of Precedence in Tax Category
o Tax Precedence indicates whether the tax is on base amount or tax on tax
o CVD is Counter Vailing Duty (Excise Duty) imposed on value of goods + customs duty.
30. Application of Taxes on PO lines
o Create PO the regular way
o Before the PO is submitted for approval, query the PO using the India Localization Menu.
o For each PO line, specify a Tax category. All the taxes under the tax category will apply to the PO line
o If tax category is not specified, then specify all the taxes for each PO line
o Save the records.
o Open the PO through the regular PO screens and submit it for approval.
You can specify the default tax category and it will default to all the PO lines
31. Enter a BOE Invoice
o Enter a BOE Invoice for the customs duty to be paid.
o Go to BOE Details to enter the Tax details
o The total tax amount will reflect on the BOE Invoice header.
o The BOE Invoice will interface with Payables and will create an AP Invoice.
1 2 3 4
32. PO Receipts
o PO Receipts should be created using India Localization Menus.
o Create the receipt.
o Enter the Excise Invoice #
o Apply the BOE. The Apply BOE button is enabled only for those receipts which have customs duty tax component.
o Look at the Registers and verify whether they are populated with the registry entries.
o Also the accounting should be populated.
o If the receipt routing is Standard and claim CENVAT on receipts is set to Y, Excise Quantity and the Duty registers are updated and accounting entries are passed.
o Registers RG23A is updated for CENVAT on input, RG23C is updated by CENVAT on capital goods, RG23d is updated by dealers register. These are decided by the values for items defined in the Item Class
o If CENVAT is not claimed, then the tax amount should be added to the item cost for inventory valuation
PO Receipt RG23D Register Entries
o Localization in SO
o for a trading org
34. Flow of transactions on a SO in a trading Org Create a Tax Category for SO Enter SO and Apply Tax Category to a SO and Book Pick Release Match the delivery with Receipt Ship Confirm Generate Excise Invoice
35. Application of Taxes on SO lines
o Create SO the regular way
o Before the SO is booked, query the SO using the India Localization Menu.
o For each SO line, specify a Tax category. All the taxes under the tax category will apply to the SO line
o If tax category is not specified, then specify all the taxes for each SO line
o Save the records.
o Open the SO through the regular OM screens and book the SO.
Specify the default tax category which will default to all the SO lines
36. Application of Taxes on SO lines
o Tax is calculated based on the tax category and the line amount.
o If the tax is based on a different price than the line price, a separate assessable price list can be created and attached at the customer or customer site level. System will use the price on the assessable price list instead of the line price.
o You can choose excise exemptions and vat exemptions on the header on a sales order.
o Changes made to the base order line quantities, cancellations and splitting of the lines are automatically reflected on the localization lines.
o Taxes are automatically copied when new sales orders are created using the copy functionality
o RMAs can be created and taxes will be copied from the original sales order that is referred.
37. Match the delivery with the receipt and Ship Confirm
o Pick Release the Sales order
o Match the delivery with the receipt
o The Match Receipts functionality allows to pass on excise credit to your customers.
o The excise duty is tracked while receiving the goods in a trading organization and it can be allowed as CENVAT credit to customers.
o Before confirming the shipment, the organization needs to allocate the excise duty involved during receipt of the excisable goods.
o While shipping from the trading org, you are required to track the exact amount of the duty paid by the original manufacturer for passing down the credit under CENVAT procedures
o You can see the tax details from the ship confirm screen
o Ship Confirm the sales order
o RG23D will be updated with the quantity matched
1 2 3
38. Generate Excise / VAT Invoice
o Generate Excise Invoice using the concurrent Program ‘India – Excise Invoice Generation’
o This can be generated by running Excise Invoice Concurrent Program. The program will generate Invoice number for each delivery ID and hits the excise registers and accounting.
o This needs to be run every day a few times atleast to take care of the deliveries created in a day
o This needs to be run after the inventory interface.
o This needs to be run before the auto invoice if the excise invoice information is required in AR
o The program will not generate any report.
o Generate VAT invoice using the concurrent program ‘India – VAT Invoice Generation / Accounting’. This can be run from Order Management.
o The Program captures the VAT localization taxes in shipments and inserts VAT invoice number in India localization shipment table.
o This Program needs to be scheduled and needs to be run as a mandatory program.
39. Reports
o RG23D report register will give the complete details of the register as per central excise act.
o This can run as a concurrent report.
o India Excise/VAT Invoice Template report gives invoice template giving the required data for excise / VAT invoicing. We need to customize this report for the actual reporting


  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.