Skip Headers

Oracle Financials for India User Guide
Release 12.1
Part Number E13658-03
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

India Local Order Management

This chapter covers the following topics:

Sales Order India Localized

You can create a Sales Order by navigating through the India Local Sales Order window. This enables defaulting and calculation of Localization Taxes. The defaulting is based on the three-way defaulting logic followed for India Localization i.e., based on Customer, Customer Site or Item Class. Alternatively, you can create a Sales Order from Internal Requisitions, using Import Orders feature. The localization taxes will flow to Fulfilled Orders India Localization. For the Deliveries created from India Local Sales Orders, taxes will flow to the same.

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

The Sales Order India Localized functionality caters to your tax calculation needs required for a Sales Order Transaction. You can:

Major Features of Sales Order India Localized

Defaulting Taxes to India Local Sales Orders

You can 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 Defaulting is 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 to calculate Tax Base Amount on which the Tax Rate is applied. The Tax Base Amount can either be the line amount or line amount including other taxes calculated for the transaction.

Important: No precedence logic and tax rates are available for adhoc taxes.

Defaulting Assessable Value to India Local Sales Orders

You can use an Assessable Value that is different from the Sales Price while creating a Sales Order in the Order Management. This Assessable Price can be defaulted based on the Tax Defaulting Rules. The automatic defaulting is based on Price List assigned to the Customer, Customer Site or null Site.

Important: The Assessable Value is a display only field and cannot be edited by user on Sales Order. It is only controlled through Price List setups and Price List attachments.

Manual Changes to Defaulted Taxes to India Local Sales Orders

The Taxes defaulted can be changed manually, if required.

Record Excise Exemptions

You can choose the Exemption Type applicable to the Sales Order by selecting the Excise Exempted check box provided at the line level. This changes 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 to select VAT Exemption Type, Date and Ref No at Header. This gets defaulted on all lines and changes the VAT value of all lines to zero.

If you require partial VAT Exemption viz., on some lines only, you need to deselect the VAT Exemption flag. You can also have a different type of VAT Exemption at line level.

CENVAT Recovery against Excise Exemptions

You can set up CENVAT Recovery % in the Organization Additional Information Screen in CENVAT Recovery % 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 the base Sales Order also split lines in India Local Sales Order. The Tax lines are then recalculated based on the revised line quantity.

Changes in Sales Order Lines

Changes made to Quantity in Base Sales Orders are automatically reflected in the Sales Order India Localization. Lines deleted from base order also get deleted from India Local Sales Order.

Cancellation in Sales Order Lines

A line cancelled in the base Sales Order changes the Quantity in Localization screen to zero.

Copying of Sales Orders

A Sales Order created by navigating through India Local Sales Order screen can be copied using the Copy Order feature. This will result in taxes flowing to Localization for the copied Order. While coping Order, if there is any change in the Assessable Price with respect to source Order line, then it results in recalculation of the taxes.

Important: Copy Sales Order feature can be used to create a RMA Order. An RMA Order taxes is based on shipping taxes and hence to avoid data inconsistency issues in localization tables, Copying of Sales Order is not possible unless such Order is already shipped & data is available in Localization shipping tables.

Localization does not currently allow copy of RMA Order to standard Order or existing RMA Order to new RMA Order.

Assessable Price Recalculation

Excise duties attached to the Order lines can be recalculated whenever there are changes in assessable price of items. This is helpful at the time of Budget/changes in Excise statutes. For further details refer Assessable price recalculation provided under reports.

Line Level Query in India Local Sales Order

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

Auto Query of India Local Sales Order

Clicking the Open Button on the India Local Sales Order displays the Base Sales Order Form to create an Order.

When you fill the base Sales Order form and save it, the details of the transaction are auto queried and displayed in the India Local Sales Order form. To view the details, navigate to the India Local Sales Order form. You can also query an existing Order in the Localized Sales Order form.

If you navigated away to multiple forms, Auto query does not work and you must click refresh to view the localization screen with requisite details.

Note: For details on generating VAT invoices for non-shippable items, refer to Generating VAT Invoices in the Oracle Financials for India Implementation Manual.

Fulfilled Orders India Localized

Overview

You can make changes to localized freight in the Order Management Module. You will also have a facility to add Localization Freight manually at this stage.

This information flows into Shipping Localized screen on completion of the Picking, Shipping and Inventory and Order Management Interface. Taxes entered in Sales Order cannot be changed at this stage. However, you can change or add freight details at this stage. The same information flows to AR Transactions after running the Auto Invoice program.

The Fulfilled Orders India Localized functionality lets you satisfy all your needs related to Freight addition required for a Shipment Transaction. You can:

Major Features of Fulfilled Orders India Localized

Facility to Add Freight in Fulfilled Orders India localized

You have an option to change or add new freight lines using the Fulfilled Orders Localized screen.

Important: All the features mentioned here involving changes to transaction has to be completed before Auto Invoice happens, else the same will not flow to the AR Transaction.

Record AR3A Form Number and Date

You can record AR3A form Number and Date against individual shipment line for Excise-Exempted transactions for the purpose for tracking.

Reports

Receivables generates these reports for India:

India - Debtors Ledger Report - Lists all the transactions with the Customer to arrive at the net liability 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 with Excise 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.

Sales Order Returns India Localized

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 Tax calculation required for a RMA Transaction. Users can create an RMA Order by giving:

Major Features of Sales Order Returns India Localized

Defaulting Taxes to India Local RMA Orders

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 be attached manually. The automatic tax defaulting would be based Item Category assigned to the Customer, Customer Site or based on the Item Class assigned to the Tax Category. This is only applicable for the RMA Order created without reference and the reference is filled as ‘Legacy’. For a RMA Order created with reference taxes are defaulted based on the original delivery and cannot be changed.

Auto picking of Delivery Detail ID in India Local RMA Orders

Whenever a RMA Sales Order is created with reference, Localization taxes would be based on the shipment taxes and hence required entry of Delivery Detail ID. There is no need to search this delivery detail id, which would make the process tedious. On navigating to Localization Screen, the same 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 prevented from 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 Memo that is raised for such return be raised for the base amount without passing on the benefit of Excise Duty. For such kind of transactions, the days within which if return is made, the Excise to be allowed has to be mentioned in the Organization Additional Information in Excise Return Days field. This ensures that when any RMA is made beyond such stipulated period, the Credit Memo raised will be net of Excise.

RMA without Sales Tax

Whenever a return takes place beyond the stipulated period by Sales Tax Authorities, you are prevented from claiming the same in your Sales Tax Returns. Under such circumstances, many a times, it is necessary that the Credit Memo that is raised for such return be raised for the base amount without 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 Additional Information Sales Tax Return Days field. This ensures that when any RMA is made beyond such stipulated period, the Credit Memo raised will be net of Sales Tax.

AR3A Form Receipt Tracking

Material Clearance without payment of duty under AR3A needs to be tracked for receipt of Re-warehousing Certificate. AR3A Receipt Tracking feature of Oracle Financials for India can be used to meet this requirement. All clearances under Excise Exemptions is recorded and on receipt of the authenticated document; the Receipt Date can be recorded. The data thus collected can be used to monitor the Rewarehousing Certificates that need to be received from Customers at any point of time.

The AR3A Receipt Tracking functionality allows user AR3A forms due from Customers. Users can:

Reports

India - AR3A Status Report lists all exempted sales transactions, while an Acknowledged AR3A form is pending from Customer.

Concurrents

India Local 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 generates Excise invoice Number against delivery and also hits Excise registers based on the Delivery ID (optional). You must schedule it to run after Inventory Interface and Order Management Interface and prior to AutoInvoice. This report does not generate any printable output.

India - Excise Duty Recalculation

This is an optional concurrent program that enables you to recalculate Excise Duty attached to Unshipped Orders, if there is a change in the assessable value of items. Excise Duty recalculation is done for those Unshipped Orders that satisfy the input criteria. This report does not generate any printable output. You can use this program to recalculate 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 the transaction. Using this feature, you can eliminate manual effort required to update all Open Sales Orders to reflect changes in Assessable Prices.

This concurrent can be invoked through India Local Order Management > Reports, Request > Single Request > India > Excise Duty Recalculation

Field Description Type Action Description
Start Order Required PICK Enter the Sales Order from which you would like to effect Tax Changes
End Order Required PICK Enter the Sales Order which you would like to take as the last document on which the change has to be effected.
Order Type Required PICK Choose one of the Order Types from the list
Organization Id Required PICK Choose one of the Organizations from the list.

Important: On completion of the request the selected Sales Orders, provided they are open and have an Assessable Price applicable, are updated with the revised Tax Amounts

India - Service Tax Processing

All Accounting events will be accounted when the Base transaction line is being accounted. The ‘India Service Tax Processing’ Concurrent program processes the recovery Accounting events. This program must be scheduled at regular intervals. At each run, the program would create Accounting and Service Tax Repository entries for all eligible transactions.

This concurrent can be invoked through India Local Receivables > Reports, Request > Single Request > India > Service Tax Processing.

Field Description Type Action Description
Regime (Required) PICK
HELP
EDIT
Select the Regime you have defined for Service Tax.
Tax Registration Number (Required) PICK
HELP
EDIT
Select the Registration Number here.
Organizations are logically grouped by Tax Registration Number. On selecting a Registration Number, all eligible transactions created in the related group of Organizations would be processed.
Transaction From Date (Required) PICK
HELP
EDIT
Specify Transaction From Date here.
Organization Name (Required) PICK
HELP
EDIT
Specify Inventory Organization here.

India - VAT Invoice Generation

The India - VAT Invoice Generation / Accounting concurrent program handles generation of VAT Invoice and passes requisite VAT Accounting entries for VAT type of taxes from Order Management. This program captures Value Added Tax localization taxes in Shipments and inserts VAT Invoice Number in India Local Shipment Table and Entries in GL interface. You have to schedule the concurrent to submit the request at suitable intervals.

Note: VAT Invoice Number is now supported for non shippable items in both Standalone AR Invoice and Sales Orders, if the Item is classified as VAT Item in Oracle Financials for India and defined as Non Shippable Item in the base inventory. For detailed information, please refer to Generating VAT Invoices in the Oracle financials for India Implementation Manual.

This concurrent can be invoked through India Local Order Management > Reports, Request > Single Request > Select ‘India - VAT Invoice Generation / Accounting > Schedule

Important: Please make it mandatory to Schedule this concurrent program.

The field wise detail description of the screen and its feature are described below for ready reference.

Field Description Type Action Description
Regime (Required) PICK
EDIT
You will have to pick the Regime here. Currently only ‘VAT’ (Value Added Tax) is available here.
Tax Registration No. (Required) PICK
EDIT
You will have to pick the Tax Registration Number that has been defined for VAT Regime here. This LOV will display all Registration Numbers defined by you for VAT Regime.
Organization (Optional) PICK
EDIT
You can choose the Organization here if you want to run the program for a specific Organization.
Location (Optional) PICK
EDIT
This will be enabled only if you select an Organization and you can choose the Location here if you want to run the program for a specific Location.
Delivery From (Optional) PICK
EDIT
This will be enabled only if you select an Organization and Location and you can choose the from Delivery id here if you want to run the program for a specific range of delivery ids.
Delivery To (Optional) PICK
EDIT
This will be enabled only if you select an Organization and Location and you can choose the end Delivery id here if you want to run the program for a specific range of delivery id’s.
Transactions from Date (Required) EDIT Enter Transaction Date Range here. All transactions having transaction date between this range will be picked up for processing.
Transactions to Date (Required) EDIT Enter Transaction Date range here. All transactions having transaction date between this range will be picked up for processing
Action (Required) PICK
EDIT
This is the type of action, which is expected. The program has three options
1) “GENERATE INVOICE NO” which will only generate VAT invoices for the selected Regime,
2) “PROCESS ACCOUNTING” which will make repository entries and pass GL entries for the selected Regime.
3) “PROCESS ALL” which will result in both generation of VAT Invoice and pass GL entries.
Generate Single Invoice (Optional) PICK
EDIT
You have an option of running the concurrent with “Yes” for this parameter which will then group delivery ids for each Customer and create a single VAT Invoice for each Customer instead of one VAT Invoice per delivery.
Default Invoice Date (Optional) EDIT Using this option you can enter a Date for which you want the VAT Invoice Date and Accounting to happen. This is useful mainly for cases where shipment happens as say 11:45 pm on Month end & you are running the concurrent during the next month but want the accounting to happen on a date different from current date. This will however not impact the number series & hence care should be taken to process all pending invoices prior to running the concurrent for the next period.
Debug Switch (Required) PICK
EDIT
Default value of this parameter is “No” but the same can be changed to “Yes” to see the debug messages when required.

Advanced Pricing Support

For detailed information, refer to India Local Advanced Pricing chapter in the Oracle Financials for India User manual.

Managing Order Management Transactions

This Section elaborates on the transactions for which you can default and calculate the Localization taxes. This would be possible only when you create the transactions navigating through the localization windows.

Transactions Sales Order (Localized)

In Oracle Financials for India, the Sales Orders are designed handle tax impacts on Sales Orders and Sales Returns.

In order to use India Local taxes, you need to navigate to the open standard application Sales Order screen by navigating through Sales Order (Localized) screen. You need to complete Standard Applications Order form. On saving the Sales Order in the standard applications, data required for the localized Sales Order will get created. Based on the tax defaulting set ups, the localization taxes will get calculated automatically. For defaulting the taxes are depended on the tax defaulting set up hierarchy mapped for localization taxes. Taxes can get defaulted based on the association of Item Category to the Customer Sites or based on the Tax Category set up. You have an option to Delete or Add localization taxes if you need to modify the defaulted taxes. Deletion of taxes will be restricted if the taxes intended for deletion has an impact on the tax precedence calculation.

The India Local Sales Order is a view form, shows the Item, UOM, Quantity Ordered, Item Category List, Unit Price, Order Line amount, which are defaulted from Standard Apps Sales Order form. However, you can change the defaulted Service Type before closing or shipment of the order.

Tax Amount, Line Amount and Assessable Value will be defaulted and are also displayed but you can modify that in the India Local Tax Details form through Taxes.

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 a Letter 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 Financials for India, navigate to the India Local Sales Order window from India Local Order Management > Orders , Returns > Orders/returns (Localized)

Field Description Type Action Description
Header level      
Customer Name/Number (Displayed)   The Customer Name and the Number will be displayed here from Standard Apps Sales Order Form.
Order Type (Displayed)   The Order Type selected in the Standard Apps Sales Order Form will be displayed here.
Order Number (Displayed)   The Order Number allotted in the Standard Apps Sales Order Form will be displayed here.
Order Date (Displayed)   The Order Date of the Standard Apps Sales Order Form will be displayed here.
Ship To Location (Displayed)   Ship To Location Id of the Customer will be displayed here from Standard Apps Sales Order Form.
Order Line total (Displayed)   The Order Line Amount appearing in the Standard Apps Sales Order Form in will be displayed here.
Tax total (Displayed)   This field shows the total of the Localization taxes worked out for the Sales Order/Sales Returns Order.
Excise Exempt Type (Optional)   If you need to carry out an exempted transaction, the Exemption Type needs to be picked up in this field. For transactions on payment of duty, this field need to be left as null. Whenever you pick for an Excise-Exempted Transaction you need to enable the Excise-Exempted Flag in the line level. The excise exemption options are:
CT2 IND
This option needs to be mapped to the requirements under Rule 20 of the Central Excise Rules. This Amount will not be accounted in the Receivable.
CT2 OTH IND
In case the Customer needs to be Debited for the Excise Duty under of the Central Excise Rules, this option need to be used. As per the provisions of the above rule, Duty debited should not be debited to the Customer.
CT3 IND.
This option needs to be picked up for clearance of goods to 100% Export Oriented Units without payment of Duty against CT 3 Certificate.
Excise Exempted Certificate IND / Excise Exempted Certificate - Others - IND
This option may be used for transactions without payment of duty
LC Flag (Optional) CHECK BOX This field should be ticked for marking the Order as a LC enabled Order.
Field Description Type Action Description
Exemption Ref. No. (Required/Optional)   You can use this field to input the details of the Document/Transaction on which Exemption is claimed from payment of Duty.
Excise Exempt date (Required/Optional)   You need to enter date CT2 Form, CT3 Form, Excise Exemption Certificate respectively.
VAT Exemption Type (Optional)   If you need to carry out an VAT Exempted Transaction, the Exemption Type needs to be picked up in this field. For Transactions where VAT is payable, this field need to be left as null. Whenever you pick for an VAT Exempted transaction, all the lines get the VAT exempted flag and the VAT Exemption type defaulted. If for any line, VAT Exemption is not applicable, then you can uncheck the VAT Exemption for such line. The VAT Exemption types are:
  • VAT Exemption Item

  • Export

  • Inter State Sale

  • Sale to Specified parties, Transfer

VAT Exemption Date (Required/Optional)   This field becomes required when VAT Exemption Type is selected.
VAT Exemption Refno (Required/Optional)   This field becomes required when VAT Exemption Type is selected.
Order Total (Displayed)   The Total Order Amount including Order Line Amount and the Tax Amount for all the Items in an Order will be displayed here.
Line level      
Line Number (Displayed)   The Line Number appearing in the Standard Apps Sales Order Form will be displayed here.
Shipment Line Number (Displayed)   The Shipment Line Number appearing in the Standard Apps Sales Order Form in will be displayed here.
Item (Displayed)   The Item selected in the Standard Apps Sales Order Form for a line will be displayed here.
Item Description (Displayed)   The description of the item Standard Apps Sales Order Form for a line will be displayed here.
UOM (Displayed)   The UOM for the above Item appearing in the Standard Apps Sales Order Form in will be displayed here.
Quantity (Displayed)   The Quantity entered in the Standard Apps Sales Order Form for a line in will be displayed here.
Tax Category (Displayed)   The Tax Category associated to the above item in the Item Category List will be displayed here.
Unit Price (Displayed)   The Unit Price of the Item will be displayed here.
Assessable Value (Displayed)   The Assessable Price as defined in the system for this Item will be displayed here.
Extended Price (Displayed)   Extended Amount is the multiplication of Quantity and Unit price for a item appearing in a line.
Tax Amount (Displayed)   Tax Amount for a item in a line is displayed here. If you modify the tax lines, then the modified Tax Amount for a item from the India Local Tax details form will be displayed here.
Line Amount (Displayed)   The Line Amount is the total of Extended Amount and the Tax Amount for a line.
Excise Exempted   CHECK BOX If a Line Item is exempted from Excise Duty, then you need to enable this Flag. This is enabled only if you select an Excise Exempted Transaction.
VAT Exemption Flag   CHECK BOX Once at header level a Order is marked as VAT Exempt, this check box will get checked. If any particular line is not supposed to be VAT Exempt, the box should be unchecked.
VAT Exemption Type (Optional)   If you need to carry out an VAT Exempted Transaction, the Exemption Type needs to be picked up in this field. For Transactions where VAT is payable, this field need to be left as null. Whenever you pick for an VAT exempted transaction, all the lines get the VAT Exempted flag and the VAT Exemption type defaulted. If for any line, VAT Exemption is not applicable, then you can uncheck the VAT exemption for such line. The VAT Exemption types are:
  • Vat Exemption Item

  • Export

  • Inter State Sale

  • Sale to Specified parties

  • Transfer

VAT Exemption Date (Required/Optional)   This field becomes required when VAT Exemption Type is selected.
VAT Exemption Refno (Required/Optional)   This field becomes required when VAT Exemption Type is selected.
Refno (Displayed)   The reference number of the item on the sales order
[ ] (Optional) EDIT Enter line-specific additional detail and Save.

Important: The Sales Order will display following message when for any line the Tax Setup is not made and as a result does not have taxes. This is useful mainly to ensure that all the items entered in the Sales Order have appropriate tax setup.

India Local Tax Details - Sales Order

India Local Tax Details screen displays Taxes for the current line in the Sales Order- Localized screen. All the Taxes related to that Sales Order line could be viewed by clicking the Taxes Button. You can view the Taxes defaulted for the Item and have an option to Update/Add/Delete the taxes defaulted. If you make some changes in the defaulted taxes, you need to click the apply button to make the tax modifications effective. After applying the Tax modifications, you need to save the record.

You can check the Tax Name, Tax Type, Tax Rates, Unit of Measurement, Precedence logic for calculation of taxes and the taxes calculated for each line item. No precedence logic and tax rates will be available for an adhoc type of tax.

Specifying Tax Details

In Oracle Financials for India, navigate to the India Local Tax Details window from India Local Order Management > Orders > Returns > Sales Order (Localized) > Taxes

All the above fields are displayed as per the taxes defined in the window for an item associated with a respective customer.

Important: System will show the following message & open the tax window in display mode based on status of the Sales Order line.

Similarly Taxes will be shown in a display mode when a Sales Order line status is reflected as ‘SHIPPED’. Please refer the Alert.

Returns (Localized)

In Oracle Financials for India, the localized information of the Sales Return Order can be viewed from the India Local Sales Order screen and the fields are discussed in earlier. You need to click the return tab region to view the tax related information/localized item information pertaining to a Sales Return Order.

Taxes on Sales Return Order appears as default and displayed in read only mode when the Return corresponds to a delivery detail id. The Tax details are opened in editable mode only when such Return is made without reference and taxes are based on the setup definitions.

The Screen can be invoked through India Local Order Management > Orders, Returns > Sales Order (Localized) > Return Tab

Line Level Details :

Field Description Type Action Description
Line Number (Displayed)   The Line Number appearing in the Standard Apps Sales Order Form will be displayed here.
Delivery Detail id (Required)   The Delivery Detail id against which this RMA Line is being entered. Taxes from Shipment are supposed to be based on the delivery Detail id entered here.
Item (Displayed)   The Item selected in the Standard Apps Sales Order Form for a line will be displayed here.
Item Description (Displayed)   description of the item in the Standard Apps Sales Order Form for a line will be displayed here.
UOM (Displayed)   The UOM for the above Item appearing in the Standard Apps Sales Order Form in will be displayed here.
Quantity (Displayed)   The Quantity entered in the Standard Apps Sales Order Form for a line in will be displayed here.
Unit Price (Displayed)   The Unit Price of the Item will be displayed here.
Assessable Value (Displayed)   The Assessable Price as defined in the system for this Item will be displayed here.
Line Amount (Displayed)   Line Amount is the multiplication of Quantity and Unit Price for a Item appearing in a line.
Service Type (Displayed)   The Service Type entered in the Standard Apps Sales Order Form for a line in will be displayed here.
Allow Excise Tax   CHECK BOX Unchecking this would mean that the Credit Note generated against such RMA Order should be without Excise Duty
Allow Sales Tax   CHECK BOX Unchecking this would mean that the Credit Note generated against such RMA Order should be without Sales Tax
[ ] (Optional) EDIT Enter line-specific additional detail and Save.

RMA Return/Receipt (Localized)

RMA Receipts should be created using the new screen (common for PO Receipts and RMA Receipts). You should navigate from this screen to the base receiving screen and complete the RMA receipt transaction. You should capture additional details related to the receipt, such as RMA Type, Excise Invoice details etc. in the India Localization screen.

The user has the facility to use the “Populate Defaults” feature. This feature allows the users to populate same Excise Invoice number and date for multiple lines.

Localization will create entries depending on Return Type.

Return Type Effect in RG Registers and accounting
Production Input Update Register for Quantity depending on Item Class. Update RG 23 A part II information CENVAT Flag Is Checked and corresponding accounting are passed
This Type need to be used by units who will be using the Sales Returns as their Raw Materials. For e.g., Foundry Units, where a casting is returned as defective due to air crack, the defect cannot be cured, but the defective casting can be recycled. For this type of transactions, the Organization needs to file declarations and get the consent/acknowledgment from the Local Excise Authorities.
Return Under 173L This Option is no Longer valid due to changes in Excise Laws.
Scrapped No RG Register update will be made.
Excise Expenses account will be debited for Excise Amount.
FG Return No RG Register update will be made.
Excise Expenses account will be debited for Excise Amount.

Following are the Accounting entries passed based on the Return type.

RMA Receipts considered as ‘Production Input’

CENVAT Credit For Excise and CVD Taxes

Account Debit Credit
CENVAT A/c Tax Amount  
Excise Paid Payable Account   Tax Amount

RMA Receipts considered as ‘Finished Goods Return’

Localization accounting entry for Excise Tax treatment

Account Debit Credit
Excise Expense a/c Excise Amount  
Excise Paid Payable Account   Excise Amount

Excise duty paid will be written off as Excise expense Account.

RMA Receipts considered as ‘Scrap’

Account Debit Credit
Scrap Cost a/c Item cost  
Sub Inventory a/c   Item cost

Localization accounting entry for Excise Tax treatment

Account Debit Credit
Excise Expense a/c Excise Amount  
Excise Paid Payable Account   Excise Amount

(Excise Duty Paid will be written off as an expense account)

RMA Return/Receipt - Trading Item

The following are the possible scenario in the case of Customer Return for a Trading Item in a Trading Organization

Transaction/Description

RMA Receipts - The goods are totally damaged and the Customer is not looking for any replacement. RG23D- Receipts entry will be passed for the Rejected Qty. Ref. Document: The Customer Invoice for returning the goods.

RMA Receipts - Customer is looking for Replacement. No RG23D Entry RMA Receipts as well return to Customer will be handed through separate D.C or valid documents.

RMA Return - For the above RMA Receipts No RG23D Entry RMA return to Customer will be handed through separate D.C or valid documents.

Important: The Dealers need to inform to the Range Superintendent regarding the Goods Returns.

Use of LC Functionality

Oracle Financials for India also provides the LC functionality. The following are the details how the user can use the LC Functionality.

Create LC Master

LC Master holds the Master Information. You can record the details of the Letter of Credits received by the Organization. He should be able to make amendments, view the transactions against each LC and the Balance available at any point of time.

Navigation: India Local Order management > Letters of Credit > Letters of Credit > Master

Field Description Type Action Description
LC Number (Displayed)   The LC Number is system generated, once the details are entered and saved to create an LC.
Reference Number (Required / Protected) EDIT Reference Number is required to be entered while creating a new LC.
LC Type (Required / Protected) PICK The LC Type has to be chosen from available LOVs. This enables you to record the type of LC as one of ‘Revolving’, ‘Revocable’, ‘Irrevocable’ and ‘Confirmed Revocable’. There is no change in behavior based on LC Type.
Customer Name/Number (Required) EDIT You can pickup a valid Customer for whom Localization setup exists and his Number.
Description (Required) EDIT Description of the LC is entered. This is not protected from updation and can be edited latter on.
[ ] (Optional) EDIT Enter line-specific additional detail and Save.
Original Amount (Required) EDIT LC is opened with an Initial Amount.
Balance Amount (Displayed)   This Balance Amount is defaulted after each matching against the LC.
Start Date (Required / Protected) EDIT Start Date From which the entered LC is effective.
End Date (Required / Protected) EDIT End Date till which the entered LC is effective
Negotiation Days (Required / Protected) EDIT Negotiation Days as per the LC
Last Negotiation Date (Required / Protected) EDIT Last Negotiation Date of the LC
Credit Period (Required / Protected) EDIT Credit Period for the LC
Last Ship Date (Required / Protected) EDIT Last Date until which Shipment can be carried out against this LC
Issue Bank Name / Issue branch Name / Issue Bank Address (Required / Protected) EDIT Issue Bank Details of the LC
Negotiation Bank Name / Negotiation branch Name / Negotiation Bank Address (Required / Protected) EDIT Negotiation Bank Details of the LC
Remarks (Optional) EDIT Remarks of the LC can be entered. Not Protected from updation.
Qty. Amendment Button   This screen has been provided to amend Quantity matched, for any possible user mistake.
Amendments Button   This screen has been provided to amend LC Values and details, for any possible user mistake.
View Transactions Button   This screen has been provided to view all transaction done against the specific LC.

Quantity Amendment

To refer the Screen Navigate through : India Local Order Management - Letters of Credit - Letters of Credit - Master - Qty Amendment Button.

Field Description Type Action Description
Order Header (Optional) EDIT Order Number
Order Line (Optional) EDIT Order Line id
Qty Released (Optional) EDIT Quantity Received against the Order.
Qty Matched (Optional) EDIT Quantity Matched against the LC
LC Type (Optional) EDIT The LC Type against which matching is done
LC Number (Optional) EDIT The LC Number for which the record is being displayed
Amount (Optional) EDIT The Amount matched against the particular LC

Amendments

To refer the Screen Navigate through : India Local Order Management - Letters of Credit - Letters of Credit - Master - Amendment Button.

Field Description Type Action Description
SL / No (Required) EDIT SL No of the Amendment
LC Number (Optional) EDIT LC Number against which Amendment is to be entered
Amd Date (Optional) EDIT Date of Amendment
Amd Amount (Optional) EDIT Revised / New LC Amount
Negotiation Date (Optional) EDIT New Negotiation Date as per Amendment.
Shipment Date (Optional) EDIT Revised Last Shipment Date as per Amendment
Description (Optional) EDIT Description for the Amendment.

View Transactions

To refer the Screen Navigate through : India Local Order Management - Letters of Credit - Letters of Credit - Master - View Transactions Button.

Field Description Type Action Description
SL / No (Display)   SL No of the Transaction
Customer Id (Display)   Customer Number against which LC pertains
Order Header (Display)   Order Number
Order Line Num (Display)   Line Number of the Order
Qty Released (Display)   Quantity Released against the Order
Qty Matched (Display)   Quantity Matched against this LC
LC Type (Display)   LC Type for the given LC
LC Number (Display)   LC Number to which the Order line is matched
Amount (Display)   Amount of the Order Line for this LC

LC Matching

Navigation: India Local Order management - Letters of Credit - Letters of Credit - Matching

This will be displayed as entered in the Base Apps Sales Order Screen. LOV's are available.

At Line Level

Field Description Type Action Description
Customer Name Required   Name of the Customer will be entered for the LC transactions to be matched.
Customer Number     Number of the Customer will be entered for the LC transactions to be matched.
SL / No (Display)   SL No of the Transaction
Order Number (Required) LOV Order Number which needs to be Matched
Order Line Number (Required) LOV Order Line Number which needs to be Matched
Delivery Detail ID (Required) LOV Delivery Detail ID which needs to be Matched
Item Name (Display)   Item Name
Qty Released (Display)   Quantity Released against the Order
Qty Matched (Required)   Quantity to be Matched against this LC
LC Type (Display)   LC Type for the given LC
LC Number (Display)   LC Number to which the Order line is matched

Important: If an Order is LC enabled, the Delivery needs to be matched fully with a LC for the Customer prior to fulfilling orders, else system will prevent the Shipment from taking place, till such Matching is completed.

If the Matched Quantity is not equal to the quantity being shipped, the base shipment will be stopped with the following message:

‘ ORA-20401 LC Matched Quantity - X should be equal to Shipped Quantity - Y for LC enabled Orders’

In the given case match the balance quantity & then try shipping.

If the Order is Attached to Bond Register / LUT (Letter of Undertaking) Excise Duty and Excise Cess will not be considered for LC Matching.

LC Matching can be carried out provided the LC Balance is equal or more than the Order Amount.

Fulfilled Orders (Localized)

The Fulfilled Orders India Localization form is used to search and display the shipment information for both the shippable and non-shippable items. It also supports GL drilldown of journal lines, viewing and update of tax information for non-shippable items, generating VAT accounting and VAT invoice number and import Order and tax information for non-shippable items

You can enter any one of the following fields, such as Departure Name, Customer, Order Number, Batch Name, Ship date, Delivery Name, Warehouse, Order type, Waybill to help in specific query of records in the Fulfilled Orders Screen.

Before dispatching the goods, the Sales Order needs to be released and the shipping need to be Confirmed through the standard application. You need to take enough care to ensure that the correct taxes are defaulted in the Sales Order before Releasing/Confirming the shipment of the Order.

Warning: The localization taxes cannot be modified once the Order is Released/Shipped

Immediately on order fulfilment, Excise related records get updated. You can view the Excise and Other Tax Information related to the Shipment using Fulfilled Orders - Localized screen. You can query for an existing Shipment based on the Order Number/Delivery Number.

You have an option to add any taxes of tax type Freight in the tax region of the Fulfilled Orders localized screen. The freight added in this screen will be considered while running the Auto Invoice program and the same will get accounted in the Receivables Module.

Confirming Shipment

In Oracle Financials for India, navigate to the Shipment Confirmation India Localization window as follows:

Shipping > Confirm Shipments > Fulfilled Orders (Localized) > Find

Field Description Type Action Description
Operating Unit (Required) (Pick) The Operating Unit for which the Shipment needs to be queried.
Header level (Display only)   Relevant Shipping Information like Delivery Name, Order Number, Customer Name, Order Type, Ship To, Excise Exemption Type, Way Bill Number, Line Total, Excise Exemption Reference Number, Excise Exemption Date, Tax Total, Order Total Amount, Currency, Item Name, Excise Invoice No and VAT Invoice No are displayed.
Checking the Matching Items Only flag returns only those items that match the shipment details entered.

Fields discussed below pertains to the localized information.

Field Description Type Action Description
Excise Exemption Type (Display only)   Excise Exemption Type will be displayed if an Order is against CT2,CT3 and Exemption Certificate.
Excise Exemption Ref No (Display only)   Excise Exemption Reference Number of CT2,CT3 and Exemption Certificate will displayed if an Order is against CT2,CT3 and Exemption Certificate.
Excise Exemption Date (Display only)   Date of CT2,CT3 and Exemption Certificate will displayed if an Order is against CT2,CT3 and Exemption Certificate.
Tax amount (Display only)   Total Tax for the Shipment will be displayed .
Total amount (Display only)   Total Amount (Total Line Amount + Total Tax Amount) for the Shipment will be displayed.
Item Name (Display only)   You can use this field to query in all Orders with the Item entered here. On executing this query the system would fetch all Shipments that have the specified item in the lines.
Matching Items Only (Display only)   You can use this field in combination with ‘Item Name’ field. On executing a query with this field checked in combination with Item Name, the system would fetch all shipments that contain this Item. The lines would be restricted to the queried Item.
Excise Invoice No (Display only)   You can use this field query on all shipments. On querying on the Excise Invoice No. all shipments with this Excise Invoice Number would be retrieved.
VAT Invoice No (Display only)   You can use this field query on all shipments. On querying on the VAT Invoice No. all shipments with this VAT Invoice Number would be retrieved.
Line Level
Shipped (Display only)   Checking this flag states that the item is shippable.
Line number     Line Number of the Item displayed against the delivery will be displayed
Order Line No     Order Line number of the item displayed against the delivery.
Item Name     Item Code of the Item shipped against the line covered under the delivery will be displayed.
VAT Exemption Date (Display Only)   Displays the VAT Exemption Date.
Reference no. (Display Only)   Reference number of the item shipped against the line will be displayed.
VAT Invoice No (Display only)   VAT Invoice No. of the shipment will be displayed.
[ ] (Optional) EDIT Enter line-specific additional detail and Save.

Important: If tax details do not get populated in the above screen, (even due to invalid / disabled triggers) the same is treated, as Shipment without taxes and taxes will not flow to Accounts Receivable Module. In such cases, User has to raise a Debit Note for Tax Amounts in Receivables & pass Manual Entries in Excise Registers.

Note: You can view the GL Drilldown accounting lines by clicking Show transactions on the Tools menu of the Confirm Shipment India Localization form.

Bond Register

In the Sales Order if you select an Order Type associated with the ‘Bond Register’ Excise Transaction Type, duty will not be debited in any of the duty paying registers. Instead, the duty will be debited to the running bond account balance.

Shipment created based on these Order Types would be considered for the update to Bond Register. A record would be created in the Bond Register on running the ‘Excise Invoice Generation’ program. The Bond Amount would be reduced by the Amount of Transaction.

The system would raise an application error and interface trip stop would complete with an error, whenever, the amount of Bond Credit is lesser than the Excise Duty applicable to the Export Transaction. The same would not be applicable to the Bonds that have been checked as LUT’s.

The system would also raise application error where the Shipment Date is greater than the Bond Expiry Date.

You can view the Transactions under Bond through the View Bond Register screen. The duty amount debited in the Bond Register can be credited on admission of the proof of export by the Excise Authority.

To view the transactions related to the Bond, select the Organization, Location and Bond Number. The lines would reflect the transactions related to the Bond. Bond Amount entered in the Define Bond Register screen would be shown as the Bond Credit. This would be the first transaction. A record would be created for every shipment transaction with the Transaction Name as ‘Bond Sales’. Register Balance would be reduced to the extent of this Excise Duty on the transaction.

India Local Order Management - Setup - Registers - Bond Register Summary

Field Description Type Action Description
Operating Unit (Required) (Pick) The Operating Unit for which the Bond Register is being queried.
Organization Name (Enter)   The Inventory Organization for which you want to check the Bond Register
Location (Enter)   The Inventory Location for which you want to check the Bond Register
Bond Number (Enter)   User can select appropriate Bond Number from the list of LOV’s. User can select a value in this field only after selecting the Organization and Location.
Bond Expiry Date (Displayed)   Value in this field would be displayed on selecting the Bond Number.
Letter of Undertaking. (Displayed) Check box This would be a display field and would indicate whether the Bond is a Letter of Undertaking.
Transaction Name (Displayed)   The Transaction Name will be displayed here for the transaction line.
Transaction Amount (Displayed)   The Transaction Amount will be displayed here for the transaction line.
Register Balance (Displayed)   The Register Balance post the given transaction
Order / Invoice (Displayed)   Wether the transaction has come from an Order or a Manual Invoice from AR Module.
Order Invoice Number (Displayed)   The Order / Invoice Number will be displayed here for the transaction line.
Transaction Type (Displayed)   The Transaction Type will be displayed here for the transaction line.
Excise Invoice Number (Displayed)   The Excise Invoice Number will be displayed here for the transaction line.
Export Approval No (Displayed)   The Export Approval Number will be displayed here for the transaction line under which the proof of export is admitted.

On receipt of proof of export for a particular transaction, you can take credit of the Bond amount in the view Bond Register. This you can do by navigating to Tools, Enter Approval Number. This would display a sub window where you can record the Approval Number. On saving the record, the duty amount will get credited in the running Bond Account.

Tools - Enter Approval Number.

This displays the sub window where the user can record the Approval Number. On saving the record, the duty amount will get credited in the running bond account.

Running Bond Register

In Oracle Financials for India, navigate to the Bond Register Summary India Localization window as follows:

India Local Order Management > Setup > Registers > Bond Register Summary > Tools > Enter approval No

Field Description Type Action Description
Organization/Location (Displayed)   The Inventory Organization and its Location will be displayed here from the transaction line.
Transaction Type (Displayed)   The Transaction Type will be displayed here from the transaction line.
Order Invoice Number (Displayed)   The Invoice Number will be displayed here from the transaction line.
Transaction Amount (Displayed)   The Transaction Amount will be displayed here from the transaction line.
Export Approval No (Required) ENTER You can record the AR4 Number and the document reference under which the proof of export is admitted.

Important: The Number once entered is not allowed to be changed and due care needs to be taken while entering the same to enter the correct value.

The facility provided is to enter the number against each invoice only and group entry features are not possible.

Excise Exempted Sales Orders

By selecting an Excise Exemption Type from the Localized Sales Order, you clear excisable goods without payment of duty under specific conditions. Excisable goods can be cleared from the factory without payment of duty to a 100% Export Oriented Unit against CT 3 Certificates under the cover of AR3. Excise Exemption options available for the users.

See Also: The features of excise exemption are discussed in detail under the topic Sale Order - Localized.

AR3 A Form Receipts

Clearance without payment of Duty under AR-3A needs to be tracked for Receipt of Re-warehousing Certificate. This legal requirement can be mapped through this functionality. All clearances under Excise Exemptions will be recorded in this screen and on Receipt of the Authenticated Document, the receipt date can be recorded. By viewing this screen, you can monitor the Re-warehousing certificates that need to be received from the Customers at any point of time.

Through the find query form you can view the AR3A forms to be received for a particular Customer or all Customers.

Tracking AR3 Form Receipts

In Oracle Financials for India, navigate to the India Local AR3 Form Receipt Tracking window as follows:

India Local Order Management > Customers > AR3 A form Receipts Tracking

Field Description Type Action Description
Customer Block     Details regarding the Customer will be displayed.
Customer Name (Displayed)   Customer Name will be displayed.
Customer Number (Displayed)   Customer Number of the above Customer will be displayed.
Customer Site (Displayed)   Customer Site (Ship to) will be displayed.
Transaction Block (Displayed)   Details regarding the transaction will be displayed.
Type     Type of transaction either Order or Invoice will be displayed.
Source (Displayed)   Source for the above type of transaction will be displayed.
Number (Displayed)   Number of the transaction will be displayed.
Form Block     Details regarding CT2, CT3 and Excise Exemption Certificate will be displayed.
Form (Displayed)   Form Type like CT2,CT3 and Excise Exemption will be displayed.
Number (Displayed)   Number of CT2,CT3 and Excise Exemption Certificate will be displayed.
Date (Displayed)   Date of the CT2, CT3 and Excise Exemption Certificate will be displayed
AR3A details block     Details of AR3A Forms for a transaction will be displayed here and once the AR3A forms is received back from a Customer, the same can be entered in this block in received date column.
Delivery Number (Displayed)   Delivery Number will be displayed.
Delivery Name (Displayed)   Delivery Name will be displayed
Delivery Date (Displayed)   Delivery Date will be displayed
AR3A Form Number (Displayed)   AR3A Form Number will be displayed.
Date (Displayed)   AR3A Form Date will be displayed.
Received Date (Enterable)   The Date on which the AR3A forms were received back from the Customer. After receipt of an AR3A form, it will be removed from the outstanding list of AR-3A form to be received from a Customer.

Important: Delivery Number, Name and Date will be visible only for Order Management transactions and will not show any value for Manually entered Receivable transactions.

In the Find window, Order/Invoice refers to query option of querying for an Order entered through Order Management or Invoice entered through Transactions (Localized) in Receivables. Invoice does not list Imported Invoices against Order Management.

Reports

This section provides overview and detailed descriptions of these reports:

Commercial Invoice

This report gives you the Commercial Invoice that covered “ISSUE OF INVOICE UNDER CENTRAL EXCISE RULE 57G OR 57T”. This section is no longer valid, however the report is not dropped so that the fields appearing in the report can be used as an example or base for client required output to generate and print Invoices.

Report Submission

Use the Submit Requests (India Local AR and OM Modules) form and enter India- Commercial Invoice Report in the Name field to submit the report.

Report Parameters

Parameter Description Required/Optional Action
Organization Enter the organization from which delivery of goods is made. Optional Pick
Location Enter the location of the organization. Optional Pick
Customer Enter the customer name. Optional Pick
Order/Invoice Quick field for this field are Order and Invoice. Optional  
Invoice Commercial Invoices that the user wants to print. Required  

India - Excise/VAT Invoice Template

This report gives you the Invoice Template, provided as an example of the Excise/VAT Invoice that is to be generated. Fields appearing in the report can be used as an example or base for Customer required output to generate and print Invoices. You can use this template to customize your requirement of invoice printing as appropriate.

Note: The format of the actual invoice is left to the manufacturer to decide and hence only a generic template is provided.

This report is primarily based on Shipping data, and will not handle the following:

Report Submission

Use the Run Reports from India Order Management module to be invoked from the order management reports request group and enter India Excise/VAT Invoice Template in the Name field to submit the report.

Report Parameters

Report Parameter Type Action Description
Organization Name Required PICK The Inventory organization for which the report is being generated. This allows all Inventory organizations and does not restrict based on Operating Units attached to the user.
Location Optional PICK The Inventory Location for which the report is being generated. This needs to be left blank if all locations are to be printed. This gets enabled only if the Inventory Organization is selected.
From Date and To Date Required   Start Date and End Date for which the report is being run. This can be used leaving the number blank in case you want to generate the report for a range of transactions. This field is however required to restrict printing of invoices to a specific year when there are same numbers across various years in the given organization location combination.
Delivery Optional PICK LOV shows list of all available Deliveries based on From Date and To Date entered. Selecting a value in this field indicates user wants to print a single document for which he already has the number.

Note: When a Single Delivery has both excisable and non-excisable material to be shipped together, the same would display in a single invoice split into two. This is because the Excise Invoice number is a header level field in the report but stored at line level in the current product architecture, when a invoice which has both excisable and non excisable items being shipped together, the report will show All excisable lines as one invoice with Excise Invoice number in header and will show all non-excisable lines as a separate invoice with Excise Invoice number appearing as blank.