il ordermanagement receivables trading

7/22/2019 IL OrderManagement Receivables Trading

1/241

Oracle India Local Order Management, India LocalReceivables and India Trading Functionality

Users Reference Manual

Release 11i

July 2006


2/241

India Local Order Management ........................................................................................................................5

Sales Order India Localized Overview............................................................................................................ 6Basic Business Needs__________________________________________________________________ 6Major Features _______________________________________________________________________ 7

Ship Confirm India Localized ..........................................................................................................................9Overview ____________________________________________________________________________ 9Basic Business Needs__________________________________________________________________ 9Major Features ______________________________________________________________________ 10Reports ____________________________________________________________________________10

Sales Order Returns India Localized Overview ...........................................................................................11Basic Business Needs_________________________________________________________________ 11Major Features ______________________________________________________________________ 12

AR 3A Form Receipt Tracking - Overview....................................................................................................13Basic Business Needs_________________________________________________________________ 13Reports ____________________________________________________________________________13

Concurrents ....................................................................................................................................................14

Service Tax Processing ................................................................................................................................. 16

India - VAT Invoice Generation...................................................................................................................... 18Setting Up India Localization Order Management ........... .......... ........... .......... ........... .......... ........... .......... 22

Defining Allow Negative Balance in PLA Organization Additional Information _____________________ 23Excise Invoice Generation Organization Additional Information________________________________ 25Defining Sub Inventory Locations ________________________________________________________ 28Defining Customer Additional Information __________________________________________________ 30Defining Bond Register ________________________________________________________________ 33

Defining Tax Code Localization .................................................................................................................. 37Defining new Service Tax Regime________________________________________________________ 38Define VAT Document Sequencing_______________________________________________________ 46

Managing Order Management Transactions................................................................................................48Transactions Sales Order (Localized) _____________________________________________________ 49Tax Details India Localization - Sales Order ________________________________________________ 55

Returns (Localized) ___________________________________________________________________ 57RMA Return/Receipt (Localized) _________________________________________________________ 59RMA Return/Receipt - Trading Item ______________________________________________________62Customer Returns Under 173(H)_________________________________________________________ 63Use of LC Functionality ________________________________________________________________ 65Shipment Confirmation (Localized) _______________________________________________________ 71Bond Register _______________________________________________________________________ 75Excise Exempted Sales Orders__________________________________________________________ 79AR3 A Form Receipts _________________________________________________________________ 79

Reports............................................................................................................................................................ 82Commercial Invoice___________________________________________________________________ 83India - Excise/VAT Invoice Template______________________________________________________ 86

India Local Receivable .................................................................................................................................... 89

Transactions (Localized) Overview.......... .......... ........... .......... ........... .......... ........... .......... ........... ........... ...... 90Basic Business Needs_________________________________________________________________ 90Major Features ______________________________________________________________________ 91Reports ____________________________________________________________________________93

Tracking of ST Forms Receipts..................................................................................................................... 94Basic Business Needs_________________________________________________________________ 94Reports ____________________________________________________________________________94

AR 3A Form Receipt Tracking - Overview....................................................................................................95Basic Business Needs_________________________________________________________________ 95Reports ____________________________________________________________________________95


3/241

Oracle India Localization

Oracle India Localization Users Reference Manual 3

RG Consolidation - Overview ........................................................................................................................96Basic Business Needs_________________________________________________________________ 96Major Features ______________________________________________________________________ 96

Supplementary Transactions - Overview ..................................................................................................... 97Basic Business Needs_________________________________________________________________ 97Major Features ______________________________________________________________________ 97Reports ____________________________________________________________________________98

Duty Drawback Processing ...........................................................................................................................99Basic Business Needs_________________________________________________________________ 99Major Features ______________________________________________________________________ 99

TDS Certificates Received - Overview ........................................................................................................ 101Basic Business Needs________________________________________________________________ 101Major Features _____________________________________________________________________101Reports ___________________________________________________________________________101

Setting Up India Localization - Receivables............... ........... .......... ........... .......... ........... .......... ........... ...... 102Defining Bond Register _______________________________________________________________ 103Defining Tax Code Localization ________________________________________________________ 107Negative Balance in PLA Organization Additional Information________________________________ 108Excise Invoice Generation Organization Additional Information_______________________________ 109Customer Additional Information ________________________________________________________ 112

Setting Up Transaction Sources ________________________________________________________ 118

Setting Up Concurrent Programs................................................................................................................ 124Setting Up India Local concurrent for processing order lines to AR Program ____________________ 124India Importing Excise/VAT Invoice Numbers in AR ______________________________________ 126Setting Up India ST Forms Receipt Processing Program: __________________________________128

Managing Receivables Transactions..........................................................................................................130Transactions (Localized) ______________________________________________________________ 131Reprocessing Errored OM Tax Records __________________________________________________ 139

Using Sales Tax Declaration Forms Receipt Tracking........................................................................... 141Prerequisites _______________________________________________________________________ 141Recording details of Sales Tax Declaration Forms:__________________________________________ 142Viewing Received Forms______________________________________________________________ 147

AR3 A Form Receipts Tracking................................................................................................................... 150RG Consolidation .........................................................................................................................................153

Back Dated RG Consolidation Functionality:_______________________________________________ 154

Supplementary transactions ....................................................................................................................... 159Run Concurrent Request______________________________________________________________ 167

TDS Certificates Received...........................................................................................................................175Inquiry ____________________________________________________________________________ 177Transaction Summary ________________________________________________________________ 177

Reports.......................................................................................................................................................... 178Commercial Invoice__________________________________________________________________ 179ST Form Customer Report ____________________________________________________________181India Total Sales Report ______________________________________________________________185India -Debtors Ledger Report __________________________________________________________ 188Debtors Trial Balance Report __________________________________________________________ 191Supplementary Transaction Details Report(AR) ____________________________________________ 193Supplementary Invoice Consolidation Report(AR) __________________________________________195Status of AR3 A form Report ___________________________________________________________ 197Duty Draw Back Report_______________________________________________________________ 200Journal Voucher Report_______________________________________________________________ 203India -Cash/Bank Book Report _________________________________________________________ 205India - Service Tax Pending Liability Report _______________________________________________ 207India - Service Tax Pending Recovery Report______________________________________________ 209India-Service Tax ST3 Report __________________________________________________________ 211


4/241



India ER1 Report____________________________________________________________________ 213

Trading Functionality.................................................................................................................................... 215

Trading Functionality Overview .......... ........... .......... ........... .......... ........... .......... ........... .......... ........... ...... 216

Major Features.............................................................................................................................................. 216

Match Receipts Localized Overview...........................................................................................................218

Basic Business Needs________________________________________________________________ 218Major Features _____________________________________________________________________219Trading Inventory Organization Set Up ___________________________________________________ 220Trading Sub inventory Location Set up ___________________________________________________ 222Trading Item Set Up _________________________________________________________________ 224Shipment Register Set Up _____________________________________________________________ 225

Transactions ................................................................................................................................................. 226Matching Receipts For Trading Item _____________________________________________________ 227Unmatching Receipts - For Trading Item__________________________________________________ 233Manual RG 23 D Entry _______________________________________________________________235

Trading Accounting...................................................................................................................................... 238Receipt of Material___________________________________________________________________ 238On Return to Vendor _________________________________________________________________ 239Receivables Invoice__________________________________________________________________ 239

Reports.......................................................................................................................................................... 240RG23D Register Report ______________________________________________________________240


5/241



India Local Order Management

This chapter explains how to use the Oracle Order Management functionality developed for India. Itdiscusses the following concepts:

Overview of Sales Order Entry, Shipping, Match receipts, Return MaterialAuthorization.

Setting Up India Order Management

Managing Transactions

Using Localized Sales Order Entry

Using Match Receipt Functionality

Using Localized Ship confirm screen.

Using Localized Returns

Reports


6/241

Sales Order India Localized OverviewYou can create a Sales Order by navigating through Sales Order India Localization window. Thiswould enable defaulting and calculation of Localization Taxes. The defaulting would be based on theThree-way defaulting logic followed for India Localization i.e., based on Customer, Customer Site orItem Class. You can alternatively create a Sales Order from Internal Requisitions, using ImportOrders feature. The localization taxes would flow to Ship Confirm India Localization. For theDeliveries created from Sales Orders India Localization, taxes would flow to the same.

The Localization Tax information flows into Shipping Localized screen on completion of the picking,shipping and Inventory and Order Management Interface. This information flows to AR Transactionscreated based on such deliveries. The same information flows to Transactions after running the autoinvoice program.

Basic Business Needs

The Sales Order India Localized functionality lets you satisfy all your needs related to Tax calculation

required for a Sales order Transaction. You can:

Define Item category lists and attach the same to Customer and Customer sites..Alternatively, an Item Class can be attached to a Tax Category. This would enable third levelof Tax defaultation, which would apply only when the Tax information does not default fromCustomer and Customer Site. This would be the basis for taxes defaulting to Transactions

Assign assessable prices to items. This price would be the basis for excise duty calculation.The Assessable Price lists can be attached selectively to Customer Sites.

Create Sales Orders by navigating through Sales Orders India Localization window. Thiswould automate tax defaultation and calculation.

Modify defaulted tax lines and add to the existing list.

Get overview information for Sales Order lines, without localization taxes.

Create Sales Order for excise exempted sales e.g., CT2, CT3. Relevant certificate

information can be recorded. Create Sales Order for VAT exempted Sales order like Vat Exemption item, Export, Inter

State Sale, Sale to Specified parties, Transfer.

Automate calculation, recording and accounting of CENVAT Recovery (as specified underRule 6 of The CENVAT Credit Rules 2002) for excise-exempted sale.

The Sales Order displays Assessable Value which forms the base for calculation of ExciseDuty.

The Sales Order also displays the VAT Assessable Value which forms the base forcalculation of VAT taxes.


7/241

Major Features

Defaulting Taxes to Sales Orders India Localization

You have an option to use Localization taxes while creating a sales order in the Order Management.These taxes can be defaulted based on the Tax Defaulting Rules. The automatic Tax Defaultationwould be based on Item Category assigned to the Customer, Customer Site or based on the Item

Class assigned to the Tax Category.

Tax Base Amount

You can define precedence logic for calculation of Tax Base Amount on which the Tax Rate would beapplied. The Tax Base Amount can either be the line amount or line amount including other taxescalculated for the transaction.

Note:No precedence logic and tax rates will be available for an adhoc type of taxes.

Defaulting Assessable Value to Sales Orders India Localization

You have an option to use an Assessable value that is different from the sales price while creating asales order in the Order Management. This Assessable price can be defaulted based on the TaxDefaulting Rules. The automatic Defaultation would be based on Price list assigned to the Customer,Customer Site or null site.

Note:The Assessable value is a display only field & cannot be edited by user on sales order & is onlycontrolled through price list setups & price list attachments.

Manual Changes to Defaulted Taxes to Sales Orders India Localization

The Taxes defaulted can be changed manually if the need arises.

Note: 1) Tax line can be deleted only when there no other tax line is dependant on it.2) User needs to click on Apply and Save post deletion of defaulted taxes prior to attaching

new Taxes.

Record Excise Exemptions

You can choose the Exemption Type applicable to the Sales Order. To do this, you need to click on

Excise Exempted check box provided at the line level to indicate that the specific line is exciseexempted. This results in changing the excise value of that line to zero.

Record VAT Exemptions

You can choose the VAT Exemption Type applicable to the Sales Order. To do this, you need toselect VAT Exemption Type, date and Ref No at header. This gets defaulted on all lines. This resultsin changing the VAT value of that all lines to zero.In case you require to do a partial VAT exemption viz., on some lines only, you need to uncheck theVAT Exemption flag. You also have the flexibility of having a different type of VAT exemption at linelevel.

CENVAT recovery against Excise Exemptions

You can set up CENVAT recovery % in the Organization additional information screen in CENVATrecovery % field using India Local Inventory responsibility which will ensure CENVAT recovery under

Rule 6 of The CENVAT Credit Rules 2002 for the above excise exempted transactions.

Splitting of Sales Order Lines

Any Splitting lines in base Sales order will result in splitting of lines in Sales Order India localization.The Tax lines would be recalculated based on the revised line quantity.


8/241



Changes in Sales Order Lines

Changes made to Quantity in Base Sales orders are automatically reflected in the Sales order IndiaLocalization. As a result, lines deleted from base order also gets deleted from Sales order IndiaLocalization.

Cancellation in Sales Order Lines

A line cancelled in the Base sales order results in changing the Quantity in Localization screen toZero.

Copying of Sales Orders

A Sales Order created by navigating through sales order India localization screen can be copiedusing the Copy Order feature provided. This will result in taxes flowing to Localization for the copiedorder. During copy order, if there is any change in the assessable price with respect to source orderline, then it results in recalculation of the taxes.Note:1) Copy Sales Order feature can be used to create a RMA Order. An RMA Order taxes isbased on shipping taxes and hence to avoid data inconsistency issues in localization tables, Copyingof Sales order is not possible unless such order is already shipped & data is available in Localizationshipping tables.2) Localization does not currently allow copy of RMA order to standard Order or existing RMA Orderto new RMA Order.

Assessable Price Recalculation

Excise duties attached to the order lines can be recalculated whenever there are changes inassessable price of items. This would be very helpful at the time of Budget/changes in Excisestatutes. For further details refer Assessable price recalculation provided under reports.

Line Level Query in Sales Order India Localization

You can now query for lines in Sales Orders India Localization screen once the Sales order isqueried. This feature would be helpful to find the lines in case where the item name is above 25characters long or sales order has large number of lines.

Auto Query of Sales Order India Localization

Clicking the Open button on the Sales Order India Localization displays the Base Sales order Form tocreate an Order.

When the user enters the requisite details in Base Sales order Form and saves the form, the detailsof the transaction are auto queried and displayed in the Sales Order India Localization form. To viewthe details, the user needs to navigate to the Sales Order India Localization form. Similarly user canquery an existing Order in the Localized Sales Order form & clicking on open results in auto query ofthe base order.If user has navigated to multiple forms, Autoquery does not work and in such cases the Refreshbutton provided needs to be clicked to refresh the localization screen with requisite details.

Direct entry of Tax Category in Sales Order India Localization

User has a option of direct entry of Tax category at the line level. As a result if feature of Taxdefaultation is not used, user need not attach individual tax lines for each order line, but can directlyattach tax category to the Order line.

Calculation of VAT ReversalDefaultation of VAT Reversal price would be based on Sales Price with option to Override the sameon Sales order localized form at line level. VAT Reversal is supposed to take place when a item onwhich VAT is claimed is sold / transferred to a different state. The VAT Reversal needs to becalculated on Purchase price and not on the selling price. Hence the option of overidding the VATReversal price is provided.


9/241

Ship Confirm India Localized

OverviewYou can make changes to localized freight in the Order Management module. You will also have afacility to add localization freight manually at this stage.

This information flows into Shipping Localized screen on completion of the picking, shipping andInventory and Order Management Interface. Taxes entered in Sales Order cannot be changed at thisstage. However, you can change or add freight details at this stage. The same information flows toAR Transactions after running the auto invoice program.


The Ship Confirm India Localized functionality lets you satisfy all your needs related to Freightaddition required for a Shipment Transaction. You can:

Query a ship confirmed Transaction using Delivery name, Order number, Customer etc tofind localization related details.

Add or change Freight type of Tax at this stage.

Enter Pre printed Excise Invoice Numbers.

View Tax lines attached to each line of delivery.

On Completion of the India Excise Invoice Generation you can also view the exciseInvoice number that has been generated against this delivery.

Query based on the Excise invoice number generated.

Query based on items. Option to view all items in the delivery or only items whose name hasbeen entered in the query.

View details of the Duty paying Register that has been hit by the delivery transaction.

Enter AR3A Form Number and Date for Excise Exempted transactions.


10/241

Major Features

Facility to Add Freight in Ship confirm (Localized)

You have an option to change or add new freight lines using the ship confirm localized screen.

Note:All the features mentioned here involving changes to transaction has to be completed beforeauto invoice happens, else the same will not flow to the AR Transaction.

Pre Printed Excise Invoice Numbers

You can enter your pre printed excise invoice numbers against each delivery. Such numbers can bealpha numeric in nature. It is also possible that a delivery may be printed on more than one preprinted invoice. For such cases, option has been provided to enter from and to numbers so that thesame is recorded in the system for future reference.

Record AR3A Form Number and Date

You can record AR3A form Number and date against individual shipment line for excise-exemptedtransactions for the purpose for tracking.

ReportsReceivables generates these reports for India:

India - Debtors Ledger Report Lists all the transactions with the Customer to arrive at the netliability for the Customer. You can use this report to get Debtors Sub-Ledger.

India - Commercial Invoice for OM Report This Report gives you the commercial Invoice withExcise Invoice Number, Excise Details for a Sales order against each delivery.

India Forecast Excise Amount in RG Registers Gives the Forecast for CENVAT and PLA

Payments for a given Organization, Location Combination from as of date to entered date.


11/241



Sales Order Returns India Localized Overview

Users can create RMA Orders with localized taxes in the Order Management. The taxes would be

calculated for the RMA lines, based on the Original sales order.


The RMA Order India Localized functionality allows the user to satisfy all requirements related to Taxcalculation required for a RMA Transaction. Users can create an RMA Order by giving:

Reference to the original Sales orderReference to the InvoiceWithout giving any reference.Return orders without Excise Component.Reference to the delivery line shipped


12/241



Major Features

Defaulting Taxes to RMA Orders India Localization

You have an option to use Localization taxes while creating a return sale order in the Order

Management. These taxes can either be defaulted based on the Tax Defaulting Rules or can beattached manually. The automatic tax defaultation would be based Item Category assigned to theCustomer, Customer Site or based on the Item Class assigned to the Tax Category. This is onlyapplicable for the RMA order created without reference and the reference is filled as Legacy. For aRMA order created with reference taxes are defaulted based on the original delivery and cannot bechanged.

Auto picking of Delivery Detail id in RMA Orders India Localization

Whenever a RMA sales order is created with reference, Localization taxes would be based on theshipment taxes and hence required entry of Delivery Detail id. There is no need to search thisdelivery detail id, which would make the process tedious. On navigating to Localization screen, thesame gets automatically populated if the sales order reference is given.

Returns without Excise

Whenever a return takes place beyond the stipulated period by Excise Authorities, you are preventedfrom claiming CENVAT benefit on the returned goods viz., when returns are made beyond 180 days.Under such circumstances, many a times, it is necessary that the Credit note that is raised for suchreturn be raised for the base amount without passing on the benefit of Excise duty. For such kind oftransactions, the days within which if return is made, the excise to be allowed has to be mentioned inthe Organization additional information in Excise Return Days field. This ensures that when any RMAis made beyond such stipulated period, the credit note raised will be net of Excise.

RMA without Sales Tax

Whenever a return takes place beyond the stipulated period by Sales Tax Authorities, you areprevented from claiming the same in your sales tax returns. Under such circumstances, many atimes, it is necessary that the Credit note that is raised for such return be raised for the base amountwithout passing on the benefit of Sales Tax. For such kind of transactions, the days within which if

RMA is made, the Sales Tax to be allowed has to be mentioned in the Organization additionalinformation Sales Tax Return Days field. This ensures that when any RMA is made beyond suchstipulated period, the credit note raised will be net of Sales Tax.


13/241



AR 3A Form Receipt Tracking - Overview

Material Clearance without payment of duty under AR-3A needs to be tracked for receipt of re-

warehousing certificate. AR-3A Receipt Tracking feature of India Localization can be used to meetthis requirement. All clearances under excise exemptions will be recorded in this screen and onreceipt of the authenticated document; the receipt date can be recorded. By viewing the contents ofthis screen, you can monitor the re-warehousing certificates that need to be received from thecustomers at any point of time.


The AR-3A Receipt Tracking functionality allows user AR-3A forms due from Customers. Users can:

Track AR-3A forms to be received from the Customers. You can enter the Date on which the Form isreceived.Generate a Report to view the AR-3A forms pending from each Customer.

ReportsReceivables generates these reports for India:

India - AR3A Status Report Lists all the exempted sales transactions against while anAcknowledged AR-3A form is pending from customer.


14/241



ConcurrentsIndia Localization Order Management requires the following concurrent programs to be run:

India Excise Invoice Generation This is a mandatory concurrent program (if you are using

excise type of localization taxes), which based on the Delivery id (optional) results in generationof Excise Invoice number against the delivery and also hits the excise registers. This has to bescheduled to run after Inventory interface and Order Management Interface and prior to Autoinvoice. This report does not generate any printable output.

Note : 1) This concurrent needs to be setup as incompatiable to itself. If the same is not done andmultiple users run it with blank Delivery_id, it would result in skipping Excise invoice numbers oralrenatively hitting the Excise register multiple times for the same delivery.2) This concurrent is expected to be scheduled with blank Delivery id which would pick andprocess all available deliveries. This is to be run with Delivery_id for specific cases where debuglog is required for any problem reporting.3) In case the users run it with delivery_id as a part of the process, then the concurrent needs tobe scheduled to run atleast once a day without Delivery_id to ensure that any records skipped getExcise Invoice numbers for the same day. Not doing this will result in sequencing issues whencompared to excise invoice dates.4) The concurrent will process only those deliveries which are OM interfaced and InventoryInterfaced.5) This concurrent is for generating excise invoice number and accounting thereof. There is no rdfattached to the same and hence this is not supposed to generate any output.6) This concurrent needs to be run prior to Autoinvoice import if the Excise invoice number isrequired to be seen in Localization AR tables.


15/241



India Excise Duty Recalculation This is an optional concurrent program that enables you torecalculate Excise Duty attached to unshipped orders, if there is a change in the assessablevalue of items. Excise duty recalculation is done for those unshipped orders that satisfy the inputcriteria. This report does not generate any printable output. You can use this program torecalculate the Excise duty and all dependent taxes on Open Sales Orders. The excise duty is

recalculated to reflect the latest Assessable Prices applicable to the items included in thetransaction. Using this feature, you can eliminate manual effort required to update all Open SalesOrders to reflect changes in Assessable Prices.

India Local Order Management Reports, RequestSingle REQUESTIndia ExciseDuty Recalculation

Field Description Type Action Description

Start Order Required PICK Enter the Sales Order from whichyou would like to effect TaxChanges

End Order Required PICK Enter the Sales Order which youwould like to take as the lastdocument on which the changehas to be effected.

Order Type Required PICK Choose one of the Order Typesfrom the list

Organization Id Required PICK Choose one of the Organizationsfrom the list.

Note: On completion of the request the selected Sales Orders, provided they are open and have anAssessable Price applicable, would be updated with the revised Tax Amounts.


16/241



Service Tax ProcessingAll Accounting events would be accounted when the Base transaction line is being accounted.The India Service Tax Processing Concurrent program would process the recovery Accounting

events.This program has to be scheduled at regular intervals. At each run, the program would createaccounting and Service Tax repository entries for all eligible transactions.

India Local Order ManagementReports, RequestSingle REQUESTIndia ServiceTax Processing

The Parameter details are described below.

Field Description Type Action DescriptionRegime (Required) PICK

HELPEDIT

Select the regime you havedefined for Service Tax.

Tax Registration number (Required) PICKHELPEDIT

Select the Registration numberhere.

Organizations are logically

grouped by Tax Registrationnumber. On selecting aregistration number, all eligibletransactions created in therelated group of organizationswould be processed.

Transaction From Date (Required) PICKHELPEDIT

Specify Transaction From Datehere.

Organization Name (Required) PICK Specify Transaction To Date


17/241



HELP

EDIT

here.


18/241



India - VAT Invoice GenerationA New concurrent program India - VAT Invoice Generation / Accounting has been added toOracle Order Management India Localization. This has been introduced to handle generation ofVAT Invoice and pass requisite VAT Accounting entries for VAT type of taxes from Order

Management. This program captures Value added Tax localization taxes in Shipments andinserts VAT Invoice number in India Localization shipment table and Entries in GL interface. Youhave to schedule the concurrent to submit the request at suitable intervals. Please make itmandatory to Schedule this concurrent program.

India Local Order Management Reports, Request Single REQUESTSelect India -VAT Invoice Generation / AccountingSchedule

The screen layout and its feature are described below for ready reference.

FieldDescription

Type Action Description

Regime (Required) PICKEDIT

You will have to pick the Regime here. Currentlyonly VAT (Value Added Tax) is available here.

TaxRegistrationNo.

(Required) PICKEDIT

You will have to pick the Tax registration Numberthat has been defined for VAT Regime here. ThisLOV will display all registration numbers defined byyou for VAT Regime.

Organization (Optional) PICKEDIT

You can choose the organization here if you want torun the program for a specific organization.


19/241



Location (Optional) PICKEDIT

This will be enabled only if you select anorganization and you can choose the Location hereif you want to run the program for a specificLocation.

Delivery From (Optional) PICK

EDIT

This will be enabled only if you select an

organization and Location and you can choose thefrom Delivery id here if you want to run the programfor a specific range of delivery ids

Delivery To (Optional) PICKEDIT

This will be enabled only if you select anorganization and Location and you can choose theend Delivery id here if you want to run the programfor a specific range of delivery ids

Transactionsfrom Date

(Required) EDIT Enter transaction date range here. All transactionshaving transaction date between this range will be

picked up for processing

Transactionsto Date

(Required) EDIT Enter transaction date range here. All transactionshaving transaction date between this range will bepicked up for processing

Action (Required) PICKEDIT

This is the type of action which is expected. Theprogram has three options 1) GENERATE INVOICENO which will only generate VAT invoices for theselected regime,

2) PROCESS ACCOUNTING which will make

repository entries and pass GL entries for theselected regime.3) PROCESS ALL which will result in bothgeneration of VAT invoice and pass GL entries.


20/241



GenerateSingleInvoice

(Optional) PICKEDIT

You have an option of running the concurrent with Yesfor this parameter which will then group delivery ids foreach customer and create a single VAT invoice for eachcustomer instead of one VAT invoice per delivery.

DefaultInvoiceDate

(Optional) EDIT Using this option you can enter a Date for which you wantthe VAT invoice date and accounting to happen. This isuseful mainly for cases where shipment happens as say11:45 pm on Month end & you are running the concurrentduring the next month but want the accounting to happenon a date different from current date. This will however notimpact the number series & hence care should be taken toprocess all pending invoices prior to running theconcurrent for the next period.

DebugSwitch

(Required) PICKEDIT

Default value of this parameter is No but the same canbe changed to Yes to see the debug messages whenrequired.


21/241

Important Note:

1) This program is a mandatory program to be run for generating VAT Invoice Number andgeneration of accounting entries.

2) This concurrent will show the following error Excise invoice generation program has notbeen run for various reasons or Excise Invoice Generation is not generated yet for thisDelivery. Please run the excise invoice number generation number for delivery : when youhave setup Same Invoice No for Excise and VAT Regimes as Y for this registration numberand try to run this program prior to running Excise Invoice generation or if the Excise invoicegeneration has errored out for this delivery.

3) This concurrent will show the following error Document sequencing setup not done atRegistration number level if you try to run the same without defining the Documentsequencing for the given registration number

4) This concurrent will show the following error Document Numbers are exhausted. Please setthe End number to a larger value when the last number as setup in document sequencinghas been reached & hence cannot generate a VAT invoice number.

5) When VAT invoice number generation happens after the AR invoice is created, localizationAR table does not have VAT Invoice number imported from localized shipping tables. Hence

care should be taken to run the VAT invoice generation program prior to creation of ARInvoice.

6) When this concurrent is run with parameter of GENERATE INVOICE NO accounting entriesare not passed.


22/241

Setting Up India Localization Order Management

This section describes the setup procedures for India Localization Order Management. You mustcomplete setups detailed in this section before you start using Sales Orders (Localized) and the other

features in Order Management India Localization.


23/241

Defining Allow Negative Balance in PLA Organization AdditionalInformation

The latest Excise Rules allowed settlement of Excise liability on a fortnightly basis. With this system,you will not have to hold shipments for non-availability of funds. The Allow Negative Balance in PLA

Flag setup for the Organization/Location, allows you to over draw from the PLA balance available withyou.

Prerequisites

Before you enter the Allow Negative Balance in PLA - Organization Additional Information, you must:

Define OrganizationsDefine LocationsOrganization Additional Information

See also: Define Organizations, Oracle Inventory User Guide

Creating Allow Negative Balance in PLA - Organization Additional Information

Details

To enter Allow Negative Balance in PLA - Organization Additional Information Details:

In Oracle India Localization, navigate to the Organization Tax information India Localization windowas follows:

India Local InventoryOrganizationAdditional Information


24/241



Query for the Organization Location fro which you wish to make the setup. Switch toAccounts Info Tab.

Check the -Ve Balance in PLA field.

Note

The Organization Defined should be either a Master Organization or attached to aMaster Organization for Generation of Excise Invoice Numbers.The Organization and its Master Organization can have only one EC Code.


25/241

Excise Invoice Generation Organization Additional InformationYou might prefer to use a different excise invoice for a Transaction source or a combination oftransaction sources. On completing this Setup Step, you can generate Excise Invoice numbers in asequence and with the alphanumeric prefix that you prefer.

You can skip this setup. On doing this, the system will generate only two series of excise invoices,one for domestic clearances. These would be numeric values, incremented by one and would bewithout any prefixes.

Prerequisites

Before you enter the Organization Additional Information Details, you must:

Define OrganizationsDefine LocationsOrganization Additional InformationTax Calendar

The following information can be entered by user to generate multiple Excise Invoice Serial numbersbased Order /Invoice Type/Excise Register codes.The screen layout and its feature are described below for ready reference.


Transaction Type (Required) PICKHELP

Choose one of the options from theLOV. The options would be

Order:

On selecting this option incombination with the Order Type,the Excise Invoice numbergenerated on shipping the deliverycreated with this Order Typewould be based on the definitionspecified for this record.

Return To Vendor:


26/241



The document sequence definedhere would be applicable to exciseinvoice numbers generated for aReturn to Vendor Transaction.

Domestic:

The document sequence definedhere would be applicable to exciseinvoice numbers generated for aDomestic Transaction.This would be applicable to all theOrder/Invoice Types that areDefine Bond Register: Chosen forthe Organization/ Location with theRegister Type as Domestic withExcise ANDThis Order Type is not chosen inthe Excise creation IndiaLocalization screen for theOrganization, Location.

Invoice:On selecting this option incombination with the Invoice Type,the Excise Invoice numbergenerated on saving an ARInvoice would be based on thedefinition specified for this record.

Export:The document sequence definedhere would be applicable to exciseinvoice numbers generated for a

Export Transaction.This would be applicable to all theOrder/Invoice Types that areDefine Bond Register: Chosen forthe Organization/ Location with theRegister Type as Export withExcise and this Order Type is notchosen in the Excise creationIndia Localization screen for theOrganization, Location.

Order/Invoice Type (Required) PICKHELP

The relevant Order Type/Invoicetype related for a inventory

organization Location have to beselected here from the LOV.Register Code (Required) PICK

HELPThe appropriate Register Code fora Order/Invoice Type have to beselected here from the LOV.

Prefix (Optional) Any alpha-numeric code thatwould be prefixed to the ExciseInvoice number.

Start No (Required) You can specify the Start Numberfor a specific Excise Invoice


27/241



Serials which are to be generatedfrom a particular InventoryOrganization Location for aspecific Order/Invoice Type

Jump by (Required) You can decide chronologicalseries for Excise Invoice Numbers

by specifying Jump by Number.End No The User can specify the EndNumber for a specific ExciseInvoice Serials, which are to begenerated from a particularInventory Organization Locationfor a specific Order/Invoice Type &Register Code.

Note:

Before defining user prefixes and excise invoice numbers, appropriate setups need to bedone in define Bond register to associate an Order type for all Transactions OrderManagement module. In addition, Transaction source for all transactions from Accounts

Receivable module needs to be defined. The Order type and transaction source will beassociated with different type of excise removals (l ike domestic with excise, Bond, Export withexcise etc.). Only after associating an Order type/Transaction source with an excise relatedtransaction type, user should define the user definable prefixes and excise invoice numbersin this region.

It is not mandatory for the user to define Excise Invoice Generation Serial Number. If the Userdoes not define the Excise Invoice Generation Screen, then auto generated system numberswill be allotted to the Excise Invoice as stipulated under Rule 52 A of the Central ExciseRules (one sequence for domestic transactions and another for exports).


28/241



Defining Sub Inventory Locations

Before you start using India Localization Order Management, the sub-inventories have to beassociated with Organization/Location combination. Excise related transactions and records would beupdated only for those sub inventories, which are identified as bonded for manufacturing

organizations and as Trading for trading organizations. By considering the transactions of a subinventory, the check box for bonded/traded needs to be enabled. Sub-inventories that are not definedhere are considered as non-bonded.

PrerequisitesBefore you enter the Sub inventory Locations, you must:

Define OrganizationsDefine LocationsOrganization Additional InformationDefine Sub inventories

In Oracle India Localization, navigate to the Assign Subinventories to Location India Localizationwindow as follows:

India Local Order ManagementSetupOrganizationSubInventory Locations

The screen layout and its feature are given here for your ready reference.


Header Level

Organization Name/Location (Required) PICKHELP

inventory organizations nameand location to be selected bythe user from the LOV.

Line LevelSub-Inventory (Required) PICK You can select the Sub-


29/241



HELP inventory name from the LOV

Description (Displayed) The Description for the selectedSub-Inventory will be displayedhere.

Bonded (Flag) (Optional) CHECKBOX

You need to specify whether aSub inventory belonging to the

specified organization andlocation is Excise Bonded orDuty Paid. When this Flag isenabled the Sub inventory isconsidered as Bonded.

Trading (Flag) (Optional ) CHECKBOX

This Flag is enabled for all theSub-inventory attached to aTrading Organization. If theOrganization location has aManufacturing setup, this field isdisabled.

Note

1) The above Sub Inventory setup is mandatory in nature & missing the same will result in shippinggetting stopped with the following message:

ORA-20406 - Mandatory India Localization Sub-inventory Setup not done for this Location fromwhere shipment is made

2) The Subinventory can be either Bonded or Non-Bonded in Manufacturing Organization. Non-Bonded subinventory is where the Bonded flag is unchecked and does not result in Excise Registerupdates for any shipments made.

3) For Trading Organization the Trading flag would be autochecked and the same is not updatable forunchecking.


30/241

Defining Customer Additional InformationYou will have to complete this setup step before using the Receivables Localization functionality. Theinformation setup in customer Additional Information would be the basis for Tax defaultation. You canalso record the Registration details of the customer with Excise, Sales Tax and Income Taxauthorities. This information at site level would be used in the Localization Reports and hence is

mandatory if Localization reports are to be used.

Prerequisites

Before you enter the Organization Additional Information Details, you must:

Define OrganizationsDefine LocationsOrganization Additional InformationDefine TaxesDefine Tax CategoriesDefine Item CategoriesDefine Assessable Price Lists

Define Customer, Customer Sites

Defining Customer Additional Information

In Oracle India Localization, navigate to the Enter Transaction India Localization window as follows:

India Local Order ManagementCustomersAdditional Information

Navigate to India Local Receivables, Customer Additional Information.

Follow the table in completing the setup.



31/241




Customer Name/Site (Required) HELPEDIT PICK

You can select the Customername from LOV for whom theAdditional Information regardingtax are to be defined. TheCustomer number will default.

The Customer site will beselected from LOV for which theinformation will relate. TheCustomer additional informationcan be defined for no specificlocation also and this will betreated as location NULL.

Note: It may be noted thatAdditional customer informationcan be recorded in the systemonly on saving the customerinformation in the customerMaster of the standard

application.Exempt CHECK

BOXIf the Customer is exempted fromExcise, then you need to enablethis check Box.

Excise Block (Optional) ENTER You can enter all these fieldswhich are relevant to identify theExcise Duty information for aCustomer for a Location.

Sales tax Block (Optional) ENTER Additional information regardingSales Tax like CST No and LSTNo which are relevant to identifythe Sales Tax information for acustomer for a location.

VAT BlockReg No (Optional) EDIT Specify the VAT Registration

Number applicable to theCusomer, Customer Site

Assessable Value (Optional) PICKEDIT

You can select from the list ofPrice Lists. The price specified inthe list here would replace theLine Amount while calculatingVAT Taxes

Service Tax blockService Tax Reg No (Required) PICK

HELPEDIT

Customer Service TaxRegsitration number will becaptured in this field.

Income tax Block (Optional) ENTER Additional information regardingIncome tax like PAN No and TANNo which are relevant to identifythe Income Tax information for acustomer for a location.

Item Category List (Optional) EDITHELPPICK

You can select from the LOV theitem category list. The selectionof the Item category list will affectthe default status of the taxes


32/241



defined within the tax categoriesassociated to the items within thisItem category list. This is anoptional field.

Assessable Value/Transactionvalue

(Optional) EDITHELP

PICK

There will be cases where theprice charged for the transaction

is not the sole consideration andthe customer relationships willhave an impact on the saleconsideration. Section 4 of theCentral Excise Act, specifies thatif there is any other considerationbuilt up in the price, excise dutyneeds to be worked out on thenormal transaction value of thegoods.

There are cases, where excise duty or VAT Tax needs to be calculated on some other price. Thisrequirement is addressed through the functionality of assessable value. You can create a simple

price list (Without use of pricing Attributes that are available in advanced pricing module) as theassessable value/transaction value price list and the same can be attached to any customer/customersites.

While performing a transaction for a customer/customer site, first system will check whether anyassessable value list is attached for the customer for the item under transaction. If there is anyassessable value attached to the customer for the item, excise duty will be calculated on theassessable price list and not based on the line price.

If no assessable value is defined for a customer/item, excise duty will be calculated on the line priceamount.

When Customer relationships have been defined, the List of addresses will show LOV of relatedcustomers also. However, the LOV will not show all values based on Profile setup for customer

relationship.

Note: Whenever the price charged is not the sole consideration and a different price needs to beconsidered for calculating excise duty, you must attach the price as assessable value. The pricethat needs to be considered for calculating excise duty / VAT needs to be defined in the price list.


33/241



Defining Bond Register

The calculation of excise duty and updation of excise registers are based on the setups made inthe define bond register. Before making this set up you need to define the Order types and

transaction sources. Excise transactions are classified into the following categories:

Domestic with ExciseDomestic without ExciseExport with ExciseBond Register (Export under Bond)

Excise transactions need to be identified based on the Organization/Location combination andagainst each excise transaction multiple Order types and Transaction sources can be assigned.Order type need to be assigned to excise related transactions from Order Management Moduleand Transaction source need to be assigned for all excise related transactions through the standreceivable module. If the Organization/location is of manufacturing type, excise relatedtransactions for manufacturing set up need to be associated. Like wise, if the

organization/location is trading excise related transactions for trading need to be associated.

By associating the Order Types to the excise transactions for an Inventory Organization andLocation, the related Excise Record entries will be passed based on the nature of goods cleared.

Generating Excise Invoice NumbersFor generating user definable prefixes for excise invoices, the excise transaction type associationneeds to be mapped in the excise generation region of additional organization information screen.

India Localization provides for maintenance of multiple Bond Registers for exports.

Recording Export under bond

Rule 19 of The Central Excise Rules, 2002 provides for Export without payment of duty subject to

the conditions and procedures specified by the notifications by the Central Board of Excise andCustoms. In exercise of the powers conferred under these rules, the Central Board of Excise andCustoms has notified through Central Excise (N.T.) Notification No.42/2001 and NotificationNo.44/2001 the conditions and procedures for export of all excisable goods. These notificationsprovide for taking on a Bond/Letter of Undertaking (LUT) for the export made to all countries otherthan Nepal and Bhutan and another Bond/LUT for the exports made to Nepal and Bhutan. Tocomply with the procedures specified under these notifications, an organization will have tomaintain multiple Bond Registers in order to keep track of exports under bond to all countriesother than Nepal & Bhutan, exports to Nepal and Bhutan and exports under Letter ofUndertaking. Under each of these categories, there would also be a possibility for taking multiplebonds where total of Export made, without proof of exports, is greater than the Bond Amount.

Using Bond Registers in India Localization, you can maintain multiple Bond Registers for acombination of Organization and Location.

On taking a Bond for export you will have to create the required setup before you start creatingexport transactions against the Bond. The only setup step would be to record the Bond details. Todo this, navigate to Define Bond Register window. Select organization, Location for which theBond would be applicable, pick up the Type Bond Register, and enter Bond Number, ExpiryDate and the Bond Amount. On the lines, select the Order Types that would be used for exporttransactions.

In case export is made against the Letter of Undertaking (LUT), there would not be a BondAmount. Hence, you can leave the Bond Amount field blank. However, it would be mandatory for


34/241



you to capture the details of the Bond Number (LUT No.) and the Bond Expiry Date. In addition tothis, check the LUT checkbox to indicate that the Bond Type is LUT.

Details of exports made under bond would be recorded. This information would be used to trackBond utilization.

Prerequisites

Before you enter the Bond Register Details, you must:

Define OrganizationsDefine LocationsDefine Organization Additional InformationDefine Transaction Types

In Oracle India Localization, navigate to the Associate Register Types India Localization asfollows:

India Local Order ManagementSetupRegistersDefine Bond Register

The screen layout and its feature are described below for ready reference. From the look-ups youneed to select the appropriate excise transactions. Options in Manufacturing Organization are:

Domestic with ExciseDomestic without Excise,Export with ExciseBond Register (For Exports)

Options in Trading Organization are:Trading Domestic with exciseTrading Domestic without ExciseTrading Export with ExciseTrading Bond Register (For Exports)


35/241



Note: You need to specify the Bond credit available in his running Bond account maintained forexport purposes.


Organization/Location (Required) EDIT HELPPICK

You can select Organization and itsLocation from LOV for which the

Register setup is to be made.Order/Invoice Information (Required) EDIT HELP

PICKBond Number (Optional /

Required)This would be an enterable field.User can enter Bond Numberhere. This number can bealphanumeric.

Bond Expiry Date (Optional /Required)

The User can enter the BondExpiry Date here. The systemwould raise application error wherethe Shipment date is greater thanthe Bond Expiry Date.

Letter of Undertaking (Optional) Check Box This field would be checked

whenever the Bond Type is aLUT (Letter of Undertaking).

Bond Amount (Optional /Required)

Enter the Bond Amount here.The value in this field can beentered only while creating a newBond. Once the Bond details aresaved, these values cannot beupdated.

Additional Amount (Optional) If the Bond Amount is to beincreased, then, enter theAdditional Amount here. Once,the record is saved, value in thisfield would be erased and the

Bond Amount and Balance wouldbe increased to this extent.

Balance Amount (Display) This field would reflect currentBalance available in the BondRegister.

Additional Bond Button Use this button to captureadditional bond amount. Onclicking this button you will beallowed to enter value in AdditionAmount field. On saving thisvalue will be added to the BondAmount and the Balance Amount

For excise related transactions from the order Management Module, you need to specify theOrder Type intended to be associated with the selected excise related transaction. Any numberof order types can be associated to one single excise related transaction.

For excise related transactions mapped through the transaction - Localized menu of thereceivable module, you need to associate the excise related transaction to the transaction source.Any number of transaction sources can be associated to one single excise related transaction.The transaction batch source is selected against the option of invoice in this field.


36/241



Note:

1) Same order type/transaction source cannot be mapped to different excise relatedtransactions. You need to map your business requirements by considering thelocalization setup that needs to be carried out for mapping the excise related

transactions.2) Attachment of Order type to Domestic without Excise, or Trading without Excise wouldmean that Excise Invoice number for such transaction is not required. This Setup wasmandatory for Tracking ST Forms earlier and is no longer mandatory for form tracking.

3) When Using Master Organization setup for generating Excise invoice numbers at MasterOrg level, It is mandatory to setup the order type at both Child organization and at MasterOrganization for getting the Correct Excise Invoice number.


37/241



Defining Tax Code Localization

It is mandatory to define a Tax code with the name Localization in base applications tax setup.

1. Tax Method and Location flexfield selection has to be done in the System Options as this is amandatory setup requirement.

2. Please ensure that a Base apps Tax Code is defined in your system as below:

a. Tax Code - 'Localization'b. Tax type - 'Sales Tax'c. Tax % - 0 (Zero)d. Taxable Basis - 'Before Discount'e. 'Adhoc' flag checkedf. Leave all the other fields as blank / with default values

There is no need to define any setup in the 'Locations' , 'Authorities' or 'Sales Tax Rates' windowsunder the Base applications Setup > Tax navigation.

Tax defaulting is handled by India Localization based on India Localization setups.

AR Transaction types should be defined with the 'Tax Calculation' flag UNCHECKED.

Not doing the above will result in the concurrent India Local Concurrent for processing Orderlines to AR run into error with the following message:

'Localization' Tax not defined or is end-dated. Please ensure that a valid 'Localization' Tax existsand is not enddated.


38/241



Defining new Service Tax Regime

Defining Service Tax Regime

Regime would be used to define rules that would be applicable to all Taxes assigned to it.

Following figure gives a brief on the Regime structure

DEFINING SERVICE TAX REGIME

Define Regimes

AssignOrgnaizations

AssignOrganization

Accounts

Assign Tax Types

Assign Tax

Accounts

Registrations

On a regime, you would define rules that would be applicable to all transactions created from theorganizations assigned to it. Information defined here would be generic unless you assigndifferent properties at an organization level.

Service Tax Registration

Organizations have to register with the various Service Tax Authorities. The registration would bethe basis for all recovering credit on input Tax, settling tax liability and Tax Reporting.

Assigning Tax Types

Service Tax Type have to be assigned to the Service Tax regime. This is a logical grouping of alltransactions to which these taxes are applicable. If the values assigned for a particular tax aredifferent, these would prevail over those defined for the regime.

Assigning Organizations

Regime has to be assigned to all organizations to which it is applicable. Taxes defined under this

regime would default only for these organizations.

Tax information related to Service Tax Regime will be handled through a new screen calledRegime Registration

Navigation:

India Local ReceivablesService TaxRegime Registration


39/241



The screen layout and its feature are described below.


Header Section In this section regime name,description and effective dates ofthe regime is captured

Regime (Required) PICK The LOV contains Service Taxregime.

Description (Required) HELP EDIT Short description of the regimeRegime Registration DetailsblockRegistrations tab This section captures the

registration details of the regime.These registration details areused in the reports that aregenerated. You should enter theregistration details in theregistration value column bypicking up the appropriateregistration type andregistration name. You cancapture as many registration

details as required.Sequence (Required) PICK

HELP EDITThis is the seqence number ofthe registration types to becaptured. This may not beserially numbered. You cannotuse duplicate sequences.

Registration Type (Required) PICKHELP EDIT

LOV containing:Primary Registration NumberSecondary Registration Number


40/241



OthersPick the appropriateRegistrationType.

Registration Name (Required) PICKHELP EDIT

LOV containing:Service Tax Registration NumberJurisdiction

Ward NoRange NoCirclePick appropriate RegistrationName

Registration Value (Required) PICKHELP EDIT

You should enter the actualregistration value in this filed.

These registration details are applicable at the regime level. These registration details will defaulton all the organizations that are assigned to this regime. The user has the facility to change thedefault values at an organization level.

An illustration on how to enter the registration details is given above.

Tax Types tab of Regime Registration Details

This section of the screen shows the Tax Types associated to the regime and the 4 accountsrelated to this regime.


Field Description Type Action DescriptionRegime Registration Details block

Tax Types tab In this section of the screen Tax


41/241



Types and the accountinginformation related to this regimeare setup.

Sequence (Required) PICKHELP EDIT

This is the seqence number of thetax types to be captured.

Tax Types (Required) PICK

HELP EDIT

You should associate both Service

Tax and Education Cess onService Tax.LOV containing:Service Tax-INDService Cess

Description DISPLAY Displays the description of the TaxType

Parent Tax Type PICKHELP EDIT

Parent Tax Type should be pickedup for a tax type which isdependant on the other. e.g.Education Cess on Service Tax isbased on Service Tax.

% of Parent PICKHELP EDIT

Wherever Parent Tax Type isdefined, % of Parent needs to bedefined. This setup is used asdefault in the other transactionforms.

Tax Accounts Details block Accounts that are going to be usedfor accounting of Service Tax arespecified here.

Sequence (Required) PICKHELP EDIT

This is the seqence number of theAccount to be captured.

Account Name (Required) PICKHELP EDIT

LOV contains:1. Interim Recovery Account2. Recovery Account3. Interim Liability Account4. Liability Account

Please refer Accounting section fordetailed discussion on the accounts

Account Value (Required) PICKHELP EDIT

Pick accounting flex fields for eachof the account.

As Service Tax is accounted on cash basis apart from final Recovery and Liability Accounts 2interim accounts have to be defined that will store the Service Tax which has not been paid /received.

On clicking the Organization button the Regime Organization Registration screen will open.This screen shows the organizations that are assigned to the regime.


42/241





43/241




HeaderRegime DISPLAY This field will default from

Regime Registration form.

Description DISPLAY This field will default fromRegime Registration form.

Organization Details block All the organizations falling underthis regime are associated to theregime here.

Organization Type (Required) PICKHELPEDIT

For Service Tax only OperatingUnit is applicable

Organization Name (Required) PICKHELPEDIT

Name of the organization thathas to be associated to thisregime.

Registrations TabRegistration Details block The registration details that are

given at the regime registrationdetails are defaulted to the

organizations. These registrationdetails will default on all theorganizations that are assignedto this regime. The user has thefacility to change the defaultvalues at an organization level.

Registration Type DISPLAY Will show default value fromRegime Registrations screen.

Registration Name DISPLAY Will show default value fromRegime Registrations screen.

Registration Value (Required) PICKHELPEDIT

Will show default value fromRegime Registrations screen.You can edit the information.

Default CHECKBOX

This checkbox will be checkedwhenever default registrationvalue at the regime level areretained. It gets uncheked whenregistration value is modified.


44/241



Tax Types Tab

This section of the screen shows the Tax Types associated to the regime and organization andthe 4 accounts related to this regime and organization.



Tax Types Tab The tax details that are givenat the regime registrationdetails are defaulted to theorganizations. These taxdetails will default on all theorganizations that are

assigned to this regime. Theuser has the facility to changethe default values at anorganization level. You cannotdelete a registration here.

Tax Details blockTax Type DISPLAY Will show default value from

Regime Registrations screen.

Description DISPLAY Will show default value fromRegime Registrations screen.


45/241



Account Details block

Account Name DISPLAY Will show default value fromRegime Registrations screen.

Account Value (Required) PICKHELPEDIT

Will show default value fromRegime Registrations screen.Pick accounting flex fields for

each of the account specific tothe organization.Default CHECKBOX This checkbox will be checked

whenever default accountvalue at the regime level areretained. It gets unchekedwhen account value ismodified.


46/241



Define VAT Document SequencingYou can define document sequencing using the following form.VAT Invoice sequnce generation depends upon the setup made for the Value Added TaxRegime.

You have to setup whether you want to generate same invoice sequence for VAT and Exciseusing the Same Invoice No for Excise and VAT Regimes attribute. This is a mandatory setupthat you need to perform irrespective of the value of Same Invoice No for Excise and VATRegimes attribute.For e.g.When a shipment for Non-excisable but VATable item is made, and the value of Same InvoiceNo for Excise and VAT Regimes attribute is set to YES, VAT invoice generation program willpick up the document sequence from the VAT document sequncing setup



Regime Block

Regime Code (Required) PICKHELPEDIT

You should select VAT regime here.

Regime Description DISPLAY This field will display regime description

Header Block

Registration Number (Required) PICKHELPEDIT

You should select a registration number

Organization Name You can pick the organization here. LOVcontains Organizations related to theregistration number selected above


47/241



Organization Type DISPLAY Organization Type will be displayedhere.

Location PICKHELPEDIT

You can pick the location related to theorganization selected above

Assignment Block

Document Type (Required) PICKHELPEDIT

You can pick the document type here.LOV contains:1. Order2. Invoice3. RTV4. Default5. Unregistered - Order6. Unregistered - Invoice7. Unregistered - RTV8. Unregistered - DefaultYou can define different documentsequences for different types ofdocuments above. If you select default

the document sequence applies to allthe documents. Unregistered Documenttype verifies if the given customer hasVAT Registration number filled in.

Document Type Name (Required) PICKHELPEDIT

The document type name depends uponthe document type selected above.

Start Number (Required) PICKHELPEDIT

You should enter the start number here.If you wish to start the documentsequencing from 1, then you shouldenter 0 as the start number.

Current Number DISPLAY This filed will display the current

document sequences that is used.

Prefix You can give a prefix to the invoicenumber that is generate.

End Number You can specify an end number for thedocument sequences. If the documentsequence is exhausted, the VAT invoicegeneration program will end into an error


48/241

Managing Order Management TransactionsThis Section elaborates on the transactions for which you can default and calculate the Localizationtaxes. This would be possible only when you create the transactions navigating through the

localization windows.


49/241

Transactions Sales Order (Localized)

In India Localization, the Sales Orders are designed handle tax impacts on sales orders and salesreturns.

In order to use India Localization taxes, you need to navigate to the open standard application SalesOrder screen by navigating through Sales Order (Localized) screen. You need to complete StandardApplications Order form. On saving the sales order in the standard applications, data required for thelocalized sales order will get created. Based on the tax defaulting set ups, the localization taxes willget calculated automatically. For defaulting the taxes are depended on the tax defaulting set uphierarchy mapped for localization taxes. Taxes can get defaulted based on the association of itemcategory to the customer sites or based on the tax category set up. You have an option to delete/addlocalization taxes if you need to modify the defaulted taxes. Deletion of taxes will be restricted if thetaxes intended for deletion has an impact on the tax precedence calculation. In such case

The Sales Order India Localization is a view form, shows the item, UOM, Quantity ordered, itemcategory list, unit price, Order Line amount which are defaulted from Standard Apps Sales Orderform. Tax amount, Line Amount and Assessable Value will be defaulted are also be displayed but you

can modify that in the Tax Details India Localization form through Taxes button.

You need to use the same screen for creating sales orders and RMA orders.If the Customer has a Letter of Credit and shipment against such order is to be matched against aletter of credit, then the Order must be marked as LC enabled by ticking on the LC Flag.

Creating Sales Order and RMA Orders

In Oracle India Localization, navigate to the Sales Order India Localization window as follows:

India Local Order ManagementOrders , ReturnsOrders/returns (Localized)


50/241


Oracle India Localization Users Reference Guide 50



Header level

Customer Name/Number (Displayed) The Customer name and the

number will be displayed herefrom Standard Apps SalesOrder form.

Order Type (Displayed) The Order type selected in theStandard Apps Sales OrderForm will be displayed here.

Order Number (Displayed) The Order Number allotted inthe Standard Apps SalesOrder Form will be displayedhere.

Order Date (Displayed) The Order Date of theStandard Apps Sales OrderForm will be displayed here.

Ship To Location (Displayed) Ship To Location Id of theCustomer will be displayedhere from Standard AppsSales Order Form.

Order Line total (Displayed) The Order Line Amountappearing in the StandardApps Sales Order Form in willbe displayed here.

Tax total (Displayed) This field shows the total ofthe Localization taxes workedout for the sales order/salesreturns order.

Excise Exempt Type (Optional) If you need to carry out an

exempted transaction, theexemption type needs to bepicked up in this field. Fortransactions on payment ofduty, this field need to be leftas null. Whenever you pickfor an excise-exemptedtransaction you need to enablethe excise-exempted flag inthe line level. The exciseexemption options are:

CT2 IND

This option needs to bemapped to the requirementsunder Rule 20 of the CentralExcise Rules. This amountwill not be accounted in thereceivable.

CT2 OTH IND


51/241



In case the customer needs tobe debited for the excise dutydebited under of the CentralExcise Rules, this option needto be used. As per theprovisions of the above rule,

Duty debited should not bedebited to the customer.

CT3 IND.

This option needs to be pickedup for clearance of goods to100% Export oriented Unitswithout payment of dutyagainst CT 3 Certificate.

Excise exempted certificateIND/ Excise exemptedcertificate - Others IND

This option may be used fortransactions without paymentof duty

LC Flag (Optional) CHECKBOX

This field should be ticked formarking the order as a LCenabled order.


Exemption Ref. No. (Required/Optional) You can use this field to input

the details of thedocument/transaction onwhich exemption is claimedfrom payment of duty.

Excise Exempt date (Required/Optional) You need to enter date CT2form, CT3 form, ExciseExemption Certificaterespectively.

VAT Exemption Type (Optional) If you need to carry out an VATexempted transaction, theexemption type needs to bepicked up in this field. Fortransactions where VAT is

payable, this field need to beleft as null. Whenever youpick for an VAT exemptedtransaction, all the lines get theVAT exempted flag and theVAT Exemption type defaulted.If for any line, VAT exemptionis not applicable, then you canuncheck the VAT exemption forsuch line. The VAT exemption


52/241



types are:

Vat Exemption itemExportInter State SaleSale to Specified parties

TransferVAT Exemption Date (Required/Optional) This field becomes required

when VAT Exemption Type isselected.

VAT Exemption Refno (Required/Optional) This field becomes requiredwhen VAT Exemption Type isselected.

Order total (Displayed) The Total Order Amountincluding Order Line Amountand the Tax amount for all theitems in an Order will bedisplayed here.

Line level

Line Number (Displayed) The Line Number appearing inthe Standard Apps SalesOrder Form will be displayedhere.

Shipment Line Number (Displayed) The Shipment line Numberappearing in the StandardApps Sales Order Form in willbe displayed here.

Item (Displayed) The Item selected in theStandard Apps Sales OrderForm for a line will bedisplayed here.

UOM (Displayed) The UOM for the above itemappearing in the StandardApps Sales Order Form in willbe displayed here.

Quantity (Displayed) The Quantity entered in theStandard Apps Sales OrderForm for a line in will bedisplayed here.

Tax Category (Displayed/Optional) The Tax Category associatedto the above item in the ItemCategory List will be displayedhere and can be changed priorto shipment.

Unit Price (Displayed) The Unit Price of the item willbe displayed here.Excise Assessable Price (Displayed) The Assessable price as

defined in the system for thisitem will be displayed here.

VAT Assessable Price (Displayed) The VAT Assessable price asdefined in the system for thisitem will be displayed here.

VAT Reversal Price Per unit (Optional) The VAT Reversal Price perunit on basis of which VAT


53/241



Reversal needs to take placeis allowed to be entered here.

Extended Amount (Displayed) Extended Amount is themultiplication of Quantity andUnit price for a item appearingin a line.

Tax Amount (Displayed) Tax Amount for a item in a lineis displayed here. If you modifythe tax lines, then the modifiedtax amount for a item from theTax details India Localizationform will be displayed here.

Line Amount (Displayed) The Line Amount is the total ofExtended Amount and the Taxamount for a line.

Excise Exempted CHECKBOX

If a Line item is exempted fromExcise duty, then you need toenable this Flag. This isenabled only if you select anexcise-exempted transaction.

VAT Exemption Flag CHECKBOX

Once at header level a Orderis marked as VAT Exempt, thischeck box will get checked. Ifany particular line is notsupposed to be VAT Exempt,the box should be uncheked.

VAT Exemption Type (Optional) If you need to carry out anVAT exempted transaction, theexemption type needs to bepicked up in this field. Fortransactions where VAT ispayable, this field need to be

left as null. Whenever youpick for an VAT exemptedtransaction, all the lines getthe VAT exempted flag andthe VAT Exemption typedefaulted. If for any line, VATexemption is not applicable,then you can uncheck the VATexemption for such line. TheVAT exemption types are:

Vat Exemption itemExport

Inter State SaleSale to Spe