India Local Purchasing

This chapter covers the following topics:

Defining Tax Overview

Businesses in India must pay to the Supplier Taxes related to Central, State, and City Tax Authorities on most of the goods and services that they purchase. Tax Handling helps you to manage taxes for Purchase Orders, Requisitions, Request for Quotations, Quotations, Releases and Receipts.

The Tax Handling functionality lets you satisfy all your Tax requirements related to Purchasing. You can:

Oracle Financials for India now supports GL drilldown which enables finding the original transaction in GL from the drilldown UI. This feature also aids viewing accounting entries from the source transaction. For detailed information, refer to Define Tax Codes in the Oracle Financials for India Implementation Manual.

Quote Analysis at the Landed Cost

The quotations are analyzed based on the non-recoverable localization taxes for the calculation of Per Landed Unit Cost. This will not consider the CENVAT able Taxes and VAT Taxes.

Excise Defaulting for PO

While creating the Purchase Order, Excise information defined will be defaulted. If the Purchase Order is created from a Quotation, then the taxes defined for the Quotation will be considered. Tax defaulting will be proportional to the quantity specified at the PO level.

Taxes at Time of Receipt

When the material is received against a Purchase Order, the taxes defined at the PO level will default. Defaulting will be proportional to the quantity received. Since the taxes specified on the Invoice are actually applicable, user will be able to modify the Taxes as per the Invoice. Localization provides the functionality to Modify the Taxes at the time of Receipt. You can effectively use this functionality, when there are changes in Tax Rates due to change in the statute/budget etc. In case of any change in Taxes from the PO, the user needs to take care to update the Taxes Immediately while performing the Receipt. Tax changes will not be allowed once the user comes out from the Receipt screen.

Receipt of Unordered Material and Applicable Taxes

For Unordered Receipts, users will not be able to attach or specify the Taxes applicable while creating Receipt. As a result the Tax Amount will not be calculated or defaulted (as the item price and currency is not known). Taxes defined at the time of purchasing will be applicable here. Tax can be attached or modified to Unordered Receipt in Receipt (Localized) window after matching to PO, this can be achieved based on “Allow tax change on Receipts flag” set in Additional information. If you set Allow Tax change on Receipts to Y, accounting and RG is updated when Receipt localized form is closed. If Allow Tax change on Receipts is set to N, then RG and accounting will be passed when matched to purchase order.

CENVAT Records and Registers

You have an option to generate consolidated CENVAT Report or to continue with RG 23 Registers. Option has been provided to the user either to avail CENVAT credit immediately on Receipt of the goods or to defer taking credit for a later time. In the case of Capital Goods, provision to avail partial credit at the time of receipt and balance later is being provided.

Payments to Vendors Other Than PO Vendor

Provision to pay to the Vendor other than the PO Vendor is provided. This will be required for paying the services offered by other Vendors related to that PO. An approved Invoice for the Non-PO Vendor will be created on running an India Concurrent for Third Party Invoices program. This functionality of Oracle Financials for India can be effectively used for expenses like freight, insurance etc. where payment in normal case will be done directly to such agencies.

PO/Receipt Matching

You have an option to specify whether the Invoice need to be matched to a Receipt or to a Purchase Order. If the user opts for ‘match to PO’, at the time of matching, the Localization Taxes attached to PO will be taken into consideration and Taxes will be apportioned based on the quantity matched. In this case taxes will be calculated based on the taxes defined in the Purchase Order.

If the user opts for Receipt Matching, system will work out the Taxes based on the Taxes available for the particular Receipt and based on the matched quantity, Taxes will be apportioned.

In India, as the occurrence of variance in the Taxes defined in PO with actual receipt being very frequent, it is suggested to opt for Receipt Matching, so that the taxes in AP will be in sync with the taxes at the time of Receipt.

Automatic Creation of Invoices Based On Receipts

Pay on Receipt functionality in Oracle E-Business Suite will also consider Taxes Payable to the PO Vendor for the payment of Receipts entered. Localization supports Pay on Receipts based on Receipt Number as well as Packing Slip Number. If the user opts for Packing Slip Number, he need to take care to enter the Packing Slip Number at the time of creating a Receipt. Pay on Receipt program takes into account the RTV Transactions against the Receipt.

Purchase Returns

While performing Return to Vendor transaction, system can take care of the reversal of CENVAT Credit that needs to be done before removal of goods. Based on the user-defined parameters, the proportionate amount of CENVAT Credit availed will get reversed in Excise Records *. The user can generate the Excise Invoice Number that needs to be issued for such removals **. Provision for defining user definable prefixes for the Excise document that is generated for RTV transactions is also provided.

System will put a hold to RTV transaction for a CENVAT able Item on which credit was not availed. In such cases, user needs to take credit and process RTV transaction from Return to Vendor India Form. This check has been built for ensuring that payment of duty does not happen if credit is not availed.

* The Excise Register updated on RTV transaction depends on Register preferences. The credit in PLA will be updated when the PLA Preference is set to ‘1’.

** Excise Invoice Number will be generated only when you select process action as “Generate”

CENVAT on Additional Customs Duty (CVD) Paid

Provision to allow users to claim CENVAT for the Additional Customs Duty paid, if applicable. While availing the CENVAT it will be restricted to the percentage specified for availing CENVAT at the tax level. Also, the appropriate Excise registers will be updated.

Non - CENVAT Customs Duty

For the taxes where CENVAT cannot be claimed or the percentage of Customs Duty for which the CENVAT is not available, acquisition cost of the item will be increased to that effect.

CENVAT Accounting on CVD

The process of claiming CENVAT is similar to that of the Excise Duty CENVAT. The accounts set for the BOE Account will be used in this case.

Currency Change for Customs Duty

Since, the Customs Duty is to be paid in the Functional Currency (INR), you are allowed to change the applicable Currency at the transaction level. However, the provision to change Currency will depend upon the parameters set while Defining the Tax in the India Local Tax Definition option.

Customs Duty Payment Before Receiving Material

Since, the Customs Duty is always paid in advance. i.e. the amount is paid before the material is received in stores, there is a facility where the duty could be paid before receiving the material. For this purpose, an on Account (prepayment) payment can be made in the name of Customs Authorities. Bill of Entry (BOE) as given by Customs Authorities is then entered in the system. BOE is settled against the prepayment.

Bill of Entry (BOE) on Receipt

Provision to apply the BOE to the Receipt is required. Only the fully paid Bill of Entries will be considered for application at the time of Receipt. This will identify the BOE used for any particular Receipt. The Bill of Entry can only be applied against the Customs Duty type of Taxes i.e. Basic and Additional Customs Duty.

Applying Bill of Entries (BOE) to PO Receipts

During Receipts, the BOE amount applied to the line will be considered as the applicable Customs Duty Amount, instead of the Amount specified at the Receipt Level.

Reversal of Taxes on Purchase Returns

In the event of Purchase Returns, all the taxes applicable to the item will be reversed and for Average Costing Organization the new Average Cost of the Item will re-calculated.

Mass Tax Updates

Mass Tax Update is a batch program to recalculate taxes applicable on the Open Documents. You can use this program to process Open Documents of the selected Document Type. The program uses the localization 3-way defaulting mechanism to derive the Revised Taxes that are applicable to a document. Optionally, you can map the Tax Categories (through request parameters) to replace the existing tax lines with those defined in the New Tax Category. As you process, a record of all documents considered for processing will be maintained.

Bulk Claim CENVAT After Receipts

You can process the Receipt lines to be claimed in claim CENVAT screen line by Line. This option can be used to process each line independently. Else, you can use the option of Bulk Claim CENVAT on Receipts. You can enter values related to Excise Invoice Number and Date on each of the lines and then check ‘Check All’ and press the ‘Claim’ Button to process all the selected records simultaneously, through one concurrent request.

Receipt of Goods from Third Party Excise Vendor

Where goods are received from a third party Vendor and an Excise Invoice is issued, then you can update the Excise Vendor name in the ‘Claim CENVAT on Receipts’ screen. The Name and Registration details of this Vendor will be considered for updating Excise Registers.

Outside Processing Transactions

The Outside Processing Feature of Oracle Financials for India provides the functionality of tracking the goods sent to a Sub-Contractor for processing. This feature provides you with reports that you can use to review the status of each Challan and track each issue. You need to keep a manual track on overdue issues i.e., those pending for more than 180 days. The duty on overdue issues has to be calculated manually and debited to the duty paying register through RG 23 Manual entry screen.

The Outside Processing functionality lets you satisfy all your needs on Tracking of goods sent for outside processing. You can:

By using the Localization features, goods that need to be sent for Sub-contracting can be tracked through a Challan. Based on the parameters set up in the Additional Organization Information, duty will be debited at the time of removal of goods and the same can be credited on receipt of the goods. Hence there is no need to pay duty on removal of goods for Sub-contracting, user need to take care to set up zero in the OSP percentage field of Additional Organization Information Different reports are being provided by Localization to track the dispatch and receipt of goods sent under OSP transactions. User needs to keep a manual track for the receipt of goods by monitoring OSP reports and if the goods are not received back within 180 days, duty needs to be worked out manually and the amount should be debited in the duty paying register through RG 23 Manual Entry screen.

Prerequisites:

Under Localization following additional steps or processes are involved:

Under Localization following additional setups are required.

Populating 57F4 details on moving material for Outside Processing

In Oracle WIP when material is moved to queue of OSP operation, an approved requisition is created in interface tables. Then we run Requisition Import to populate the Requisition in PO Module. Using this Requisition we auto create PO and approve the PO. When we Receive Material it is directly updated in WIP Operations.

Under Localization following additional steps or processes are involved:

Support for User-defined Limit Days

Users will be able to define applicable validity period in number of days for each type of Excise Transaction. These days will be checked while providing Excise treatment. Out Side Processing Material is required to be received in 180 days. Other wise differential duty, based on actual duty on goods not received, has to be paid.

Approve 57F4 Dispatch

Using this Form the user can find out the 57F4 dispatch Forms for a PO or a Vendor and the same can be Approved.

Form Approved in this Form is the Primary Form for a particular OSP PO. System creates the 57F4 form comprising all the WIP Components required for the specific WIP Operation attached to OSP PO in the Outside Processing Details. If the WIP Operation is the First Operation, only the Components are to be dispatched to the Sub Contractor. If the WIP Operation is the second or higher, the intermediate assembly of earlier operations along with the Components required for the current operation need to be dispatched to the Sub Contractor. Hence an additional item line with the PO OSP Item description is created in the 57F4 forms for such OSP Purchase Orders. The PO OSP Item Description could be provided in such a way to identify with the Intermediate Assembly. This is a specific workaround to meet the India specific OSP Excise requirement.

It is not mandatory to dispatch all the components or their full quantities in the Primary Form itself. If the dispatches are done in a staggered manner, the first batch could be dispatched through the Primary form. Subsequent dispatches could be done through the Manual 57F4 Forms.

Transactions Outside Processing Approve 57F4 dispatch Find. The field wise description of the screen is given in the table below for your ready reference.

Field Description Type Action Description
PO Number (Optional) EDIT HELP PICK Select PO Number from LOV to find and review or approve Dispatch / Receipt
Vendor Name (Optional) EDIT HELP PICK Select Vendor Name from LOV to find and review or approve Dispatches/Receipts for that Vendor.
Form Date (Optional) EDIT HELP PICK Select Form Date from LOV to find and review or approve Dispatch / Receipt.

Transactions Outside Processing Approve 57F4 Dispatch

Field Description Type Action Description
Organization Name, Location (Display only)   These fields will show the Organization and its Location in the selected PO.
Form Number (Generated) HELP This will get generated automatically on approval of Dispatch
Form Date (Display only)   This will be the date on which PO was approved and the relevant data was populated.
Supplier Name (Display only)   This field will display the Supplier Name as per the corresponding PO.
Dispatch Date (Required) EDIT HELP PIC You can enter future date as dispatch date and time. Limit of days will be calculated from this date according to the transaction.
Maximum days permitted (Display only)   This field will have default value from Organization parameters.
Receive upto (Display only)   This field will show the Date by which you need to receive the material back from Vendor.
Dispatch Register (Required) EDIT HELP PICK Select Register in which you want to debit the CENVAT Credit Reversal. PICK is available which will show the Register Name and current balance available.
Entry Number (Display only)   On approval of dispatch entry is made in the selected Register and Entry Number is generated.
Receipt Register (Display only) PICK This will always be RG 23 A Part II, as per the legal requirement.
Entry Number (Display only)   On approval of Receipt entry is made in RG 23 A Part II and Entry Number is generated
In Lines      
Assembly (Display only)   This will show the assembly as per WIP Work Order.
Description (Display only)   Description of Assembly will be defaulted as defined in Item Definition
Job Name (Display only)   Pick the Job Name from LOV
Item, Description (Display only)   These fields will show Item Code and Description
Unit of Measure     Unit of Measure for the Item being dispatched. Primary UOM of the Item shall be defaulted. However other UOM’s could be used if UOM conversion is defined for the Item. The quantity and rate details shall be automatically recalculated based on the UOM conversions defined
Identification (Display only)   Enter Identification Mark if any. There is no validation for this field.
Tariff Code (Display only)   Tariff Code will be defaulted from Item Definition. User can change the same. There is no validation for this field.
Dispatch Quantity     This is the Quantity as per Purchase Order. This could be modified based on the Actual Quantity being dispatched in the current form.
Item Rate (Display only)   Value is defaulted in this field in the following order:
1. List Price from Price list attached combination of Item, Vendor, Vendor Site and UOM Code.
2. List Price from Price List attached for the combination of Item, Vendor (Null Site) and UOM Code.
3. List Price for Item, Organization
combination in Item Definition
4. Item Cost for Organization, Item
This can be updated as per the valuation for excise per unit of OSP item.
Dispatch value (Display only)   Dispatch value = Dispatch Quantity * Item Rate
Excise Rate (Display only)   Excise rate will be defaulted from Organization Parameters. You can change if required as per legal provisions. This is percentage rate on Dispatch value and not a per unit rate.
Dispatch Excise Amount (Display only)   Dispatch Excise Amount = Dispatch value * Excise Rate
Processing Nature (Display only)   This will default from Operation Description of OSP operation from the related job. This can be edited if required.

Note: You can view the GL Drilldown Accounting lines by clicking the Show Transaction button on the Tools menu in Approve 57F4 Dispatch form

Enter Manual 57F4

This form can be used to create a Manual 57F4 for sending material for Outside Processing and view the 57F4 Forms. Manual Forms can be created based on an OSP PO or just on the basis of Supplier Information filled in the Query window.

Note: You can view the GL Drilldown Accounting lines by clicking the Show Transaction button on the Tools menu in Enter Manual 57F4 form

Report Submission

If the Manual 57F4 Form is being created based on a OSP PO, the system checks for the dispatched quantity in the Primary Form. An entry is allowed in the Manual 57F4 Form only if the full quantity is not dispatched through the Primary Form. System does not allow to dispatch any additional material against the PO in excess of the materials required for the WIP Job linked to the OSP PO Item line. Use the Submit Requests (INV & PO Modules) Form and enter OSP Pending Receipts Report in the Name field to submit the report.

If the Manual 57F4 form being is created based on the Supplier, there is no linkage to the WIP Job and hence the update to the Form is entirely Manual. The system shall not default any Job related data while creating the Form entries - neither it updates the 'Return Quantity' value as there is no linkage to any PO in this case. The form updates have to be done manually based on manual controls of issue and receipt.

Transactions Outside Processing - Enter Manual 57F4

Field description Type Action Description
PO Number (Required/optional) EDIT HELP PICK Select PO Number from LOV if a PO has been raised for this OSP transaction, otherwise leave blank.
Vendor Name Optional EDIT HELP PICK Select Vendor Name from LOV for whom the 57F4 is going to be created.
Vendor Site Optional EDIT HELP PICK Select Vendor Site for the above Vendor from LOV relevant for a 57F4 transaction.

Click Open and enter values into the 57F4 - India Local Form based on the details below.

Field Description Type Action Description
Organization (Required/Defaulted) ENTER The user needs to enter the Inventory Organization name here. If the Manual 57F4 referred through a Purchase Order, then the PO Organization will be defaulted here.
Location (Required) ENTER The users need to enter the Location of the above Inventory Organization where this Manual 57F4 is to be raised.
Form Number (Display Only)   System generated Form Number will be displayed after completion and approval of a transaction.
Form Date (Display Only) ENTER By default this will be Current Date.
Supplier Name (Required/Defaulted) ENTER If the Manual 57F4 referred through a Purchase Order, then the PO Supplier Name will be defaulted here otherwise the user need to enter the Supplier Name.
Dispatch Date (Display only)   By default Current Date and Time will be displayed here.
Supplier Name (Required/Defaulted) ENTER If the Manual 57F4 referred through a Purchase Order, then the PO Supplier Name will be defaulted here otherwise the user need to enter the Supplier Name.
Max Days Permitted (Display only)   This field will have default value from Organization Parameters.
Receive upto (Display only)   This will be the cutoff date for Receiving back the OSP materials from the delivery date from the Vendor.
Registers Block      
Dispatch Register (Required) ENTER The users need to select the Excise Register to be used for this OSP transaction from the LOV.
Entry Number (Display only)   On approval of dispatch entry in the selected register and Entry Number is generated and displayed here.
Receipt Register (Display only)   This will always be RG23 A Part II as per the legal requirement.
Entry Number (Display only)   On approval of Receipt Entry is made in RG 23 A Part-II and Entry Number is generated.
Line level (Display / Required)    
Job Name ENTER   Job Name associated in the PO will be defaulted here if the user enter Manual 57F4 with PO reference otherwise the user need to select the respective Job Name from the LOV.
Assembly (Display only)   Assembly for the above Job Name will be displayed here.
Description (Display only)   Description for the above Job Name will be displayed here.
Item (Required) ENTER The user needs to select the Inventory Item from the LOV.
Description (Display only)   Description of the above Inventory will display here.
Unit of Measure (Display only in PO linked Manual Forms)   Unit of Measure for the Item being dispatched. Primary UOM of the Item shall be defaulted. However other UOMs could be used if UOM conversion is defined for the Item.
Identification (Display only)   Enter Identification Mark if any. There is no validation for this field.
Tariff Code (Display only)   Tariff Code will be defaulted from Item Definition. User can change the same. There is no validation for this field.
Dispatch Quantity (Required/Display only)   This is the Quantity as per Purchase Order or the user can enter the Dispatch Quantity.
Item Rate (Display only)   List Price in Item Definition will be defaulted in this field. This can be updated as per the valuation for Excise Per Unit of OSP Item.
Dispatch value (Display only)   Dispatch value = Dispatch Quantity * Item Rate
Excise Rate (Display only)   Excise Rate will be defaulted from Organization Parameters. This is percentage rate on Dispatch value and not a per unit rate.
Dispatch Excise Amount (Display only)   Dispatch Excise Amount = Dispatch value * Excise Rate
This amount of duty will be debited to the Selected Register of approval of Dispatch.
Processing Nature (Display only)   This will default from Operation Description of OSP Operation from the related job and this can be edited if required. The user can enter the relevant processing details here if the Manual 57F4 is created without PO reference.
After entering data press the Approve dispatch button, then the transaction will be saved and approved.

Approval 57F4 Receipts

Through this form the user can find out the 57F4 Receipt and approve them. An automatic update feature is provided for the 'Return Quantity' field on Receipt of the materials against the PO. The 'Return Quantity' field is updated on Receipt in the following sequence:

Such automatic update of the Receipt Quantities is provided only for the Forms linked to Purchase Orders. This is not available for Manual Forms created without any linkage to Purchase Order.

Transactions - Outside Processing - Approve 57F4 Receipts

The field wise description of the form is given below for ready reference.

Field Description Type Action Description
Return Quantity     This will be Quantity Received till date. On Receipt of the Material from OSP Vendor this Quantity will get updated.
Return value (Display only)   Return value = Return Quantity * Item Rate
Return Excise Amount (Display only)   Return Excise Amount = Return value * Excise Rate.

Important: : It is advisable to have single distribution line for return of material under 57F4 in order to update the 57F4 forms in an Inventory Location.

Using India - Control over Printing of OSP Challans

This section gives brief overview of 57F4 Challan Printing and Control

Overview

This feature enables you to control printing of 57F4 Challans. It would restrict repeated prints of a Challans. Control over printing of Duplicates would be controlled and Duplicate Challans would be marked as such.

In cases where the print could not be generated due to Printer errors, authorized users can generate an original print.

Using India - Control over Printing of OSP Challans

Records in ‘Approve 57F4 Dispatch’ window would be populated on Approval of a PO with Line ‘Type’ as Outside Processing. The user would check the accuracy of the Records and Approve the Dispatch and not the Form Number. On approval a record would be populated in ‘Print Control 57F4 window, the ‘Original’ in this Form would be set to ‘Yes’ and the value in the ‘Duplicate’ field would be set to ‘No’.

After approval, the user would navigate to India Local Purchasing Reports Run, to run the ‘India - Outside Processing Challan’ report. The ‘Form Numbers From’ and ‘Form Numbers To’ fields would display only the unprinted Challans i.e., challans with either the ‘Original’ or ‘Duplicate’ status set to ‘Yes’ (in the ‘View 57F4 Challan’ window). On Printing the Challan, the value in the ‘Original’ field would be set to ‘No’. At this stage, both ‘Original’ and ‘Duplicate’ fields can be updated.

The Access to ‘View 57F4 Challans’ window would be restricted to authorized users. These users can query for the Forms, and change either ‘Original’ or ‘Duplicate’. The value in either one of these fields can be set to ‘Yes’. On changing value in one of these fields the other field would be disabled. This change would list the Form for Printing once more. The Challan Report that have ‘Duplicate’ as ‘Yes’ would be marked as ‘Duplicate’.

On printing the Challan the values in both ‘Original’ and ‘Duplicate’ fields would be set to set to ‘No’.

Print Control 57F4

Organization Name

The User can select from the Organizations. The LOV for all other fields would be based on value selected in this field. This would be a mandatory field.

Location

The User can select from the Locations defined for the Organization. The LOV for all other fields would be based on value selected in this field. This would be a mandatory field.

Fin Year

The LOV for this field would list the Fin Year (Localization) defined for the select Organization and Location. This would be a mandatory field.

Vendor Name

The LOV for this parameter would display the Suppliers with OSP transactions.

PO Number

The LOV for this field would display the Purchase Orders with OSP Items created for the selected Organization, Location, and Financial Year. This would be restricted based on the value selected in the Vendor Name field.

Form Number

The LOV for this field would display the Form Numbers created for the selected Organization, Location, and Financial Year. This would be restricted to Unapproved 57F4 Receipts.

This would be restricted based on the value selected in the Vendor Name field.

Print Control 57F4 Form

PO Number

This field would display the Purchase Order Number based on which the Form Number has been generated.

Form Number

This field would display the 57F4 Form Number.

Vendor Name

This field would display the Supplier Name for which the Form has been generated

Original

The Check box would be enabled when the 57F4 is dispatched. Once the Challan is printed the check would be removed. However, the user can check this to Print a ‘Original’ Challan. This field cannot be checked if the ‘Duplicate’ field is checked.

Duplicate

The Check box can be enabled only on user intervention. Once the Challan is printed the check would be removed. However, the user can check this to Print a ‘Duplicate’ Challan. This field cannot be checked if the ‘Original’ field is checked.

Reports

System generates following Reports for Oracle Financials for India Outside Processing Transaction.

Receiving Corrections

Oracle Financials for India product supports Receiving Corrections feature provided by Base Receiving. Oracle Financials for India automates adjustment to Taxes and corresponding Accounting and Register Entries on corrections to Receiving Transactions using Receiving Corrections feature.

Oracle Financials for India supports Corrections to following transactions.

Oracle Financials for India adjusts following entries on correcting any of the transactions, specified above:

The above list varies depending on the stage of transaction at which it is corrected.

Mass Tax Update

Mass Tax Update is a batch program that enables you to recalculate taxes applicable to the Open Documents. You can use this program to process open documents of the selected Document Type. The program uses the localization 3-way defaulting mechanism to derive the revised taxes that are applicable to a Document. Optionally, you can map the Tax Categories (through request parameters) to replace the existing tax lines with those defined in the New Tax Category. As you process, a record of all documents records considered for processing will be maintained.

Mass Tax Changes functionality enables you to address all your needs related to changes in Tax applicability and Tax Rates. Using this functionality, you can:

Recalculating Taxes

Whenever there is change in Tax Rates or Tax applicability that applies to a particular type of documents or documents related to a particular Supplier, you can define the New Taxes, Tax Categories and attach them to a Item Category List. On running the program the system will follow the localization defaulting logic to check the revised tax applicability. The Taxes will be defaulted and recalculated accordingly. Optionally, you can map Tax Categories (in the request parameters) to replace the existing Taxes with the Taxes in the new Category.

The Mass Tax Recalculation feature can be used to apply Additional CVD to existing open transactions.

Maintaining History of Processed Records

After every run of the program, the system administrator can query for the records that are processed and check the old Tax Category and the new Tax Category, error codes for the records that are left unprocessed.

Transactions Handled

Oracle Financials for India is designed to handle tax defaulting and calculation for the transactions entered by the user in Requisitions, RFQ, Quotations, Purchase Orders, PO Releases and Receipts. Apart from the transactions created manually, when a transaction is created based on any other document, Taxes are also copied from the Source Document. This section lists such Documents, Source Documents and the events.

Requisitions

RFQ

Default Localization Taxes on creating RFQ from RFQ (Localized) window.*

* Taxes will defaulted only from item class, 3 level tax defaulting is not supported for RFQ.

Quotations

Quote Analysis

Standard Purchase Order

Planned Purchase Order

Blanket Purchase Agreement

Blanket Release

Receipts

Receipts (RMA/ISO)

Returns

Unordered Receipts

Claim CENVAT on Receipt

Defaulting of Excise Type of Taxes (included in the Receipt) to Claim CENVAT on Receipts screen. This happens only when: -

Encumbrance Accounting

India Local taxes are stored separately in India Local tables; this data is not visible to the Base application processes. Hence base application encumbrance processes were not considering India Local taxes while doing the Funds checking or generating encumbrance accounting. Now India Local taxes will be considered in encumbrance accounting as the India Local tax amounts are interfaced into the base application encumbrance processes in a streamlined fashion without any change in the user process flows.

Encumbrance accounting is available for the following events in the P2P cycle:

Funds Available = Budget amount – Encumbrance (till date) – Actual utilization (till date).

Transaction processing is allowed only on the basis of the Funds check control level set up i.e. Absolute (No overspending allowed), Advisory (Raises warning on overspending) or None (Allows overspending).

Requisition / Purchase Order Funds Checking, Reserve / Approval /Modification

Requisition / Purchase Order Encumbrance actions such as Funds checking, Reserve, Approval, Modifications and Control actions will include the attached IL Non- Recoverable (NR) taxes also.

Currently no tax modification is allowed if the Requisition / Purchase Order is in ‘Approved’ or ‘Approved and Reserved’ status. This restriction will now be extended to the status of ‘Reserved’ also under the Encumbrance support to ensure that the reserved amount is equal to the non-recoverable taxes attached to the Requisition / Purchase Order line.

India Local taxes are currently attached at the Requisition line / Purchase Order Shipment level only. Encumbrance is calculated and accounted based on the Requisition / Purchase Order Distribution level. Hence the non-recoverable taxes will be apportioned to the distributions, if multiple distributions exist for the line, and the encumbrance amount is calculated. Such apportioning is done through:

Receiving /Corrections / Returns for Inventory items

Purchase Order / Internal Requisition encumbrances are reversed on the Inventory items’ Receipt Deliver event. Non-recoverable tax amounts of Purchase Order / Internal Requisition distribution that is being received / corrected / returned will be included in the Encumbrance accounting actions of the respective event.

Note: Deliveries to Process Manufacturing Organizations do not generate Encumbrance reversal entries since Oracle Process Manufacturing Costing and Sub ledger accounting does not support Encumbrance currently. Hence there will be no support for India Local taxes for Inventory item deliveries to Process Manufacturing Organizations.

Receiving /Corrections / Returns for Expense items with ‘At Receipt’ accrual method

Purchase Order / Internal Requisition encumbrances are reversed on the Expense Delivery event. Similar to the Inventory destination deliveries, non-recoverable tax amounts of Purchase Order / Internal Requisition distribution that is being received / corrected / returned will be included in the Encumbrance accounting actions of the respective event.

Receiving /Corrections / Returns for Expense items with ‘Period End’ accrual method

Oracle Financials for India does not support ‘Period End’ accrual method, as it is not compatible with India Tax Regimes. Hence Oracle Financials for India support is not being provided for this feature.

Invoicing Encumbrance actions

In the Procure to Pay cycle, encumbrance accounting impact is only applicable for PO matched invoices for Expense items with ‘Period End’ Accrual method. As Oracle Financials for India does not support this accrual method, Oracle Financials for India support is not extended for encumbrance accounting in such an event.

Invoice level encumbrance accounting on invoice validation / invoice accounting will automatically consider the India Local tax distributions as these are created as Invoice distributions.

Encumbrance Reporting

‘PO Encumbrance Details’ report shall be including the IL non-recoverable tax amounts also with the respective transaction amounts.

Migration / Upgrade Script

If any customer has been using the Encumbrance feature (without the IL support) and then adopts the IL encumbrance support solution, there shall be discrepancies in encumbrance accounting in the following scenarios:

Documents reserved or approved before IL encumbrance solution application will not have India Local tax amounts in the Encumbrance accounting entries. Hence post-migration to the new solution, it will be ensured that the Encumbrance reversal entries generated for the migrated documents do not include the tax amounts so that there is no discrepancy in the resulting encumbrance accounting.

Setting Up India Local Purchasing

This section describes the setup procedures for India Localization Purchasing. You should have completed the Organization, Inventory and Tax Setups before you start setting up Oracle Financials for India Purchasing.

To set up India Local Purchasing, you must:

  1. Define Supplier Additional Information

  2. Set up Profile Options

  3. Run India Receiving Transaction Processor

  4. Run India RG Period Balances Calculation

  5. Round off Excise Amount

  6. Run India RG Rounding Process

Defining Supplier Additional Information

You need to setup Supplier Additional Information before you start using Oracle Financials for India for Purchase Module. This lets you record the Tax Registration Information, Item Category List and Assessable Price List. This information setup for the Supplier and Supplier Sites will be the basis for Tax defaulting and calculation. The Tax Registration Information will be used for Reporting.

As a part of set up, you need to create separate records for each Supplier with Null Location, where in you need to set the IT/TDS related information pertaining to the Supplier as IT/TDS calculations are not based on Supplier Sites.

You can setup the Supplier Additional Information for a Supplier NULL Site. The information defined in this record will default to transactions created for all Sites. However, if you create this setup for Supplier Sites, then the Information defined there will be the basis for Tax defaulting and calculation.

In the Excise block, you record all Excise related information of the Supplier Site like Range, Division, Commissionerate, ECC Number, Supplier Type and Document Type as these values are used for printing different Excise related reports pertaining to the supplier related transactions.

If the Supplier Site is a Sales Tax registered Site located within the Site, he should give only his LST Number and the CST field should be left as null. Like wise if the Supplier is a Sales Tax Registered Site located out side the State LST field should be null and only his CST details should be recorded. If the Supplier is not registered under the Sales Tax Rules, the user should leave the CST and LST Number fields as Null.

Important: Excise zone needs to be filled in order to generate Excise Related reports.

Prerequisites

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

Navigation:

India Local Purchasing > India Localization > Suppliers > Supplier Additional Info

Field Description Description
Operating Unit You have to select Operating Unit from the LOV.
Vendor Name/Site You can select the Vendor Name from LOV for whom the Additional Information Regarding Tax are to be defined, the Vendor Number will be defaulted and relevant Vendor Site will be selected from LOV.
Excise Block  
Excise Range Use this field to enter Excise Range under which this Supplier’s Site falls. This would be printed on all the documents that are required under Excise Act.
Excise Division Use this field to enter Excise Division under which this Supplier’s Site falls. This would be printed on all the documents that are required under Excise Act.
Excise Registration Number Use this field to enter Excise Registration Number of this Supplier’s Site. This would be printed on all the documents that are required under Excise Act.
Excise Zone Use this field to review and enter Excise Zone under which this Supplier’s Site falls. This would be printed on all the documents that are required under Excise Act.
Excise Region Use this field to review and enter Excise Region under which this Supplier’s Site falls. This would be printed on all the documents that are required under Excise Act.
Excise Circle Use this field to review and enter Excise Circle under which this Supplier’s Site falls. This would be printed on all the documents that are required under Excise Act.
Excise Commissionerate Use this field to review and enter Excise Range under which this Supplier’s Site falls. This would be printed on all the documents that are required under Excise Act.
Excise EC Code Use this field to review and enter Excise EC Code of this Supplier’s Site. This would be printed on all the documents that are required under Excise Act.
Document type You need to specify the Document, which will be supplied by the Supplier/Site. User can specify any duty document name like Invoice, Delivery Challan, Excise Invoice, Excise Challan, Dealer Invoice, Bill of Entry etc. in this field. This information is used for printing CENVAT reports that need to be submitted to the Central Excise Authorities.
Vendor type You need to pick the Vendor Type from the pick list. The options available are Manufacturer, Depot, First Stage Dealer, Second Stage Dealer and Importer. This information is used for printing the CENVAT reports that need to be submitted to the Central Excise Authorities.
Sales Tax Block  
Sales Tax - Central ST Reg. No. Use this field to review and enter Central Sales Tax Registration Number of this Supplier’s Site. This field should be null for those Supplier Sites, which are not registered under Sales Tax Act and for those registered Supplier Sites falling within the state.
Sales Tax - State ST Reg. No. Use this field to review and enter State Sales Tax Registration Number of this Supplier’s Site. This field should be null for those Supplier Sites, which are not registered under Sales Tax Act and for those registered Supplier Sites falling outside the state.
Item Category List The user can enter the Item Category list then for all the items appearing in this list. The taxes lines will be defaulted as per the Tax Category attached to this Item. This is an optional field and if the user decides to enter the tax lines for a Vendor manually, it can be left blank.
Assessable Value In case of Excisable products, assessable value on which Excise Duty is calculated is not the basic Sales Price. Then the user need to specify whether Assessable Value for a particular Item have to be considered or not in the price list column of Vendor Information - India Form. Only the Excise Duty will be calculated on Assessable Value and the other Taxes will be actual Invoice Value.
Invoice Approval block  
Create pre-approved TDS Invoice and Credit Memo You have to enable this check box at Supplier Site level if you require the Credit Memo and Invoices generated for TDS transactions to be pre-approved. You would also have an option to enter this value at the Supplier Null Site Level. In such a case, the TDS Invoices & Credit Memos created from any of the Sites would be pre-approved. Unless, the setup for a specific Site does not have this check enabled.
VAT Tax Block  
Reg No Specify the VAT Registration Number applicable to the Supplier Site
Assessable Value You can select from the list of Price Lists. The price specified in the list here would replace the Line Amount while calculating VAT Taxes
Standalone AP Invoice Block  
Tax Category Select this to assign tax categories directly to a supplier site for defaulting of taxes to standalone invoices. This field is enabled only at the supplier site level.
Service Tax Block  
Reg No Specify the Service Tax Registration Number applicable to the Supplier Site

Setting Up Profile Options

To use Oracle Financials for India Purchasing, you need to ensure that the Profile Options mentioned below are set up accordingly in the Personal Profiles of Purchasing. These settings are mandatory for using the features of Oracle Financials for India.

Display the Auto-created Documents in PO : NO

Display the Auto-created Quotation in PO : NO

Processing Mode in RCV : Immediate/Online

India Receiving Transaction Processor

To process pending records, India Receiving Transaction Processor can be submitted manually or can be scheduled. This will handle following transactions:

This concurrent program can process in batches when ‘RCV: Processing Mode ’ profile option is set to ‘BATCH’.

This concurrent program can also be scheduled for a particular Inventory Organization, when P_CALLED_FROM is set to JAINPORE in concurrent program definition.

Navigate to India Local Purchasing > Reports > Run > India Receiving Transaction Processor.

India - Concurrent request for defaulting taxes in PO when linked with Quotation

A Purchase Order can be created based on a Quotation using Sourcing rules. In such cases, taxes assigned to a Quotation should be carried to PO. The program ‘India - Concurrent request for defaulting Taxes in PO when linked with Quotation’ defaults taxes from Quotation to PO.

You can schedule this program so that taxes default on all eligible PO’s.

Navigation: India Local Purchasing - Reports - Run - India - Concurrent request for defaulting taxes in PO when linked with Quotation

India - RG Period Balances Calculation

This program calculates balances for the CENVAT Taxes. These balances are maintained on a monthly basis. These balances are used in the India - RG 23 Register Reports. If the balance for the previous month is not calculated before running India - RG 23 Register Report, then India - RG 23 Register Report ends with an error.

Navigate to India Local Purchasing > Reports > Run > India > RG Period Balances Calculation.

Parameters

Register Type: The register Type can either be ‘A’ for Input register and ‘C’ for Capital Goods.

Consolidate Till: This should be last date of the unprocessed month. Any other date will end this program with an error.

Rounding Excise Amounts

This feature is to comply with the rounding of Total Excise Duty on an Excise Invoice. This feature ensures that the Total of Excise Duty in an Excise Invoice is rounded to the nearest rupee.

Prerequisite Setup

You should specify '2' as the Rounding Precision for the Excise Tax that you are defining. For Complete information on Setting up Taxes refer to 'Setting Up Tax Information' section of Oracle Financials for India Implementation Manual.

Specify the Excise Rounding Account for the Organization through the 'Organization Additional Information' screen. For Complete information on Setting up Organization Tax Information refer to 'Defining Organization Additional Information' section of Oracle Financials for India User Reference Manual.

Tax on the Purchase Order and the Receipt is rounded to '2' decimal places.

On CENVAT Claim, the Accounting Entries and the Register updates are made upto two decimal places.

India - RG Rounding Process

This concurrent program creates Rounding Adjustment Entries for the Excise Invoices falling between specified dates.

You should schedule 'India - RG Rounding Process' by specifying the Organization and the Excise Invoice Date Range.

This program creates accounting entries to:

The CENVAT Account will be debited when the Excise Amount on the Invoice is rounded up. The CENVAT account (RM or CG) picked up will be based on the type of Items purchased.

In cases where the Excise Invoice consists of both Raw Material and Capital Goods Purchased, then the rounding amount will be passed to the Register Type specified in the 'India - RG Rounding Process' concurrent request.

Navigate to India Local Purchasing > Reports > Run > India > RG Rounding Process.

Parameters

Organization: Select an Inventory Organization that has been setup for Oracle Financials for India.

Transaction Type: Select the Transaction Type from the LOV for which you wish to process rounding entries.

Register Type: Select either 'A' or 'C'. 'A' Implies 'Inputs' and 'C' implies 'Capital Goods'. This applies only to Excise Invoices including both Inputs and Capital Goods. In such cases, rounding adjustment amount will be passed to the Register you select here.

From Excise Invoice Date: Specify a Date here. The program will show only those Excise Invoices with dates after this date.

To Excise Invoice Date: Specify a date here. The program will show only those Excise Invoices till this date.

In case of CGIN Items, the CENVAT claimed in any year will be rounded to the nearest rupee. In the year subsequent to the year of purchase (and first claim), rounding entry will be created for the total amount and will be passed as and when the Concurrent request is submitted.

Managing Purchasing Transactions

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

Purchase Requisition is the one from where the business cycle for all Purchases begins and it is always better to consider all Indian business aspect and tax requirement from the Requisition level itself. The tax and incidental expenses information captured here flows to other documents created based on the Requisition.

To default and calculate localization taxes you have to create a Requisition navigating through Requisitions (Localized) window. India Local Requisition is a view form and the data in this window is populated based on the transaction details entered in Base Applications form and the Tax Setups.

Creating Requisitions

In India Local Purchasing Responsibility, navigate to the India Local Requisitions window from Requisitions > Requisitions (Localized).

Field Description Type Action Description.
Header Block Number (Display only)   The Requisition Number is a system-generated number will be displayed after enter and save a Requisition.
Operating Unit   HELP
EDIT
PICK		 You have to select the Operating Unit from the LOV.
Type (Display only)   The Type selected in the Standard Apps form will be defaulted.
Preparer (Display only)   The Preparer’s Name will be displayed here.
Description (Display only)   Description of a Requisition will be displayed here.
Status (Display only)   The status of the Requisition will be displayed here. (Quick field are Incomplete, In-Process and Approved)
Total (Display only)   The Total value of the Requisition including Tax Amount will be displayed here and this field will get updated whenever any change made in the tax calculation.
Line Block      
Line No (Display only)   Line Number of a Requisition will be displayed here.
Item (Displayed)   The Item selected in the Std Apps Requisition form for this line will be displayed here.
Description (Displayed)   The Item Description will be displayed here.
UOM (Displayed)   UOM of the entered Item will be displayed.
Qty (Display only)   Requisition Quantity will be displayed here.
Price (Display only)   Price at which requisition is raised for an Item will be displayed here.
Amount (Display only)   Represents the Material Cost excluding Tax will be displayed here.
Tax Amount (Display only)   Tax Amount for a Item in a line are defaulted from India Local Tax Details form and this field will get updated whenever any change made in the tax calculation.
Total Line Amount (Display only)   Represents the Total Line Amount for a line.
Footer Block     The information relating to Inventory Module like Destination type, Requester, Organization, Location, Sub-inventory are defaulted from Standard Applications Requisition form.

The information regarding Supplier like Source, Supplier Name, Site, Contact, Phone are defaulted from Standard Applications, Requisition Form.

See Also: Oracle Purchasing reference User Manual for details on Requisitions in the Standard Applications.

Click Taxes in the India Local Requisition to open the tax details.

The Tax Lines will default based on the Tax Category attached to the Item Class applicable to the Item or based on the Item Category list attached to the Supplier/Supplier Site. You can add Tax lines manually.

Precedence of taxes will decide the basis for calculating the Tax Amount. You can specify the precedence in the Precedence fields.

Important: It is advised that you verify the tax lines and Approve the Requisition; otherwise you cannot change the tax line after Approval of Requisition.

For Excise/CVD related taxes on which credit can be claimed under CENVAT scheme, you need to ensure that appropriate credit percentage is defined in the Tax Definition and the CENVAT credit is considered for deriving the Item Cost while performing a Receipt.

The Vendor Name for a Tax in the Tax Details window will be the same as specified in the header line of a requisition or the Vendor Name specified in the Tax Definition. But, for the Tax lines with Taxes that have Update Vendor Flag enabled, you can Add/Change the Vendor Name in the Tax Details window.

While creating a requisition you can enable the RFQ Required Flag depending upon the type of requisition being entered.

RFQ (Localized)

You can create a RFQ from India Local RFQ window. This will enable defaulting and calculation of Localization Taxes. The defaulting is based on the Three-way defaulting logic followed for Oracle Financials for India i.e., based on Supplier, Supplier Site or Item Class. You can alternatively create a RFQ from the Requisitions. The localization taxes flow to RFQs, if such Requisition is created from Requisitions (Localized) window. For the Quotations created from India Local RFQ, taxes flow to the same.

Click Open in the India Local RFQ window to create RFQs in the Standard Applications RFQ window. This will take you to the India Local RFQ window; the information entered in the Standard Applications window would be defaulted here along with the India Local Taxes.

Creating RFQs

In India Local Purchasing Responsibility, navigate to the India Local RFQ window from RFQ and Quotation - RFQs (Localized).

Functionality of RFQ’s India Localization is similar to Requisition India Localization. You need to follow the regular functionality of Standard Applications while entering data in the Standard Applications RFQ window.

Click Taxes to open the Tax Form to enter the Tax details in the same manner as mentioned in the Requisition form. In India Local Tax Details window the tax lines are defaulted based on the Tax Category attached to the Item Class applicable to the Item or based on the Item Category list attached to the Supplier/Supplier Site. You would also have an Option to Add Tax Lines Manually.

Quotations (Localized)

You can create a Quotation by navigating through India Local Quotations window. This would enable defaulting and calculation of Localization Taxes. The defaulting would be based on the Three-way defaulting logic followed for Oracle Financials for India i.e., based on Supplier, Supplier Site or Item Class. You can alternatively create a Quotation from an RFQ. The Localization Taxes would flow to Quotation, if such RFQ is created from RFQ (Localized) window. For the Purchase Orders created from India Local Quotations, taxes would flow to the same.

You can navigate to Standard Applications Quotations Entry window by clicking on the Open button of India Local Quotations. On closing this form after entering and saving the details, the same would flow to India Local Quotations. The Tax Amounts in this form would default from the India Local Tax Details window.

India Local Quotations is a view form and the data in this window is defaulted from the Standard Applications Quotations and India Local Tax Details.

Creating Quotations

In India Local Purchasing Responsibility, navigate to RFQ’s and Quotations > Quotations (Localized).

Functionality of the India Local Quotations window is similar to India Local RFQ and you need to follow the regular functionality of Standard Applications while entering data in the Standard Applications Quotations form.

Purchase Orders (Localized)

India Local Purchase Orders is designed to meet the requirements related to Tax defaulting and calculation for a purchase transaction. The Purchase Order can be created manually or automatically, based on an existing Purchase Order or based on a Quotation or a Requisition.

Taxes on a Purchase Order are either created:

In all the cases, you can modify the tax lines.

India Local Purchase Orders is a view form, displays the details entered in the Purchase Orders Standard Applications window, which in turn, is opened navigating through India Local Purchase Orders window. The Tax details in this form are based on the India Local Tax Details.

Creating Purchase Orders

In India Local Purchasing Responsibility, navigate to Purchase Orders > Purchase Orders (Localized).

Field Description Type Action Description
Header Block      
Operating Unit   EDIT
PICK
HELP		 You have to select Operating Unit from the LOV.
PO Rev. (Display only)   The PO Number allotted in the Standard Apps form will be displayed here.
Type (Display only)   The PO Type selected in the Standard Apps Form will be displayed here.
Currency (Display only)   PO Currency will be displayed here.
Supplier/Site (Display only)   Defaulted from Standard Apps PO Forms.
Ship To / Bill To (Display only)   Defaulted Ship To / Bill To Inventory Organization Location from Standard Apps PO Forms will be displayed.
Buyer (Display only)   Buyer Name will be displayed from Standard Apps PO Forms.
Status (Display only)   The Status of the PO will be displayed here.
Description (Display only)   Description of the PO is displayed here from Standard Apps PO Forms.
Amount (Display only)   Defaulted the PO Material Cost from Standard Apps PO Forms.
Tax Amount (Display only)   The Total Tax Amount for the PO will be displayed here.
Total (Display only)   The Total PO Value will be displayed here.
Line Block      
Line No (Display only)   Auto generated Line Number will be displayed here.
Shipment No (Display only)   Auto generated Shipment Number will be displayed here.
Item / Description (Display only)   The Item selected in the Std Apps PO form for this line and its Description will be displayed here.
UOM/Qty (Display only)   UOM and Qty entered for an Item will be displayed.
Price (Display only)   Price for the Item in a line will be displayed here from Std Apps PO Form.
Ship To Organization (Display only)   Displayed from Standard Apps PO Forms.
Bill To Location (Display only)   Displayed from Standard Apps PO Forms respective the Operating Unit.
Need-By date (Display only)   Defaulted from Standard Apps PO Forms.
Line Amount (Display only)   Represents the material cost excluding tax and defaulted from Std Apps PO Form.
Tax Amount (Display only)   Tax Amount for a Item in a line are defaulted here. India Local Tax Details Form and this field will get updated whenever any change made in the Tax Calculation.
Line Total (Display only)   Represents the Total Line Amount for a line.
[ ] (Optional) EDIT Enter line-specific additional detail and Save.

The following is the Tax form for the above Purchase Order India Localization and which shows all the taxes related to that PO and the user can add or delete a tax lines depending upon his requirement. Through Apply Button the user can save the tax lines.

Navigate to Purchase Orders > India Local Purchase Order > Taxes

PO Releases (Localized)

This feature is designed to take care Taxes for a PO Release against Blanket Agreement and Contract Agreement. Standard Applications PO Releases Form will be invoked through Open button and after filling up the inventory details for a Blanket or Contract Agreement save and close the Standard Application Form.

Creating PO Releases

In India Local Purchasing Responsibility, navigate to Purchase Orders > Releases (Localized).

The user can move to the Tax Form and verify whether the tax lines are defaulted as per the tax specified in the Blanket or Contract Agreement.

PLA Manual Entry

PLA Manual Entry is a View / Entry form that can be used to View/Enter the Manual PLA transaction. It displays on query all the transactions that have an entry in the PLA Register. Each Inventory Organization is considered as Excise Unit. Thus, you need to specify the Organization Name and Location both for querying & for making manual entries into the Register. Querying can be done based on certain fields on the Entry Block and also Transaction Details block.

India Local Purchasing > Registers > PLA Manual Entry

Use the details given here to create a manual entry in PLA Register. The screen's field wise description and its feature are described below for ready reference.

Field Description Type Action Description
Operating Unit (Required) EDIT
HELP
PICK		 You have to select Operating Unit from the LOV.
Organization (Required) EDIT HELP PICK You need to specify the Inventory Organization Name to which PLA Register entries are to be updated. Where you would like to use this window to view the existing PLA Entries, specify an Inventory Organization for which you would like to view the PLA Register balance and information.
Location (Required) EDIT HELP PICK You need to specify the Location for the Organization you have chosen. The display of existing entries or creation of a new entry would be for the chosen Organization and Location.
Serial No (Required)   It is system generated Serial Number after entering a transaction.
Transaction Date     The Transaction Date should be entered here. If you would like to view existing PLA Register entries for a particular day then you can specify the Transaction Date.
Transaction Type     The transaction types of either Receipt, Issue should be chosen here.
Item     You need to specify Item for which the Receipts/Issue entry is going to be passed.
Customer/Vendor Name     Enter Customer/Vendor Name should be entered here and the manual entry is being made in PLA Register.
Customer/Vendor Location     Enter Customer / Vendor Location should be entered here.
Transaction Detail Block     This block has Transaction details with respect to Reference Number, Invoice No, and Invoice Date.
Excise Amount     Excise utilization details should be entered here.
Excise Cess     Enter Excise Cess Amount in this column.
CVD Cess     Enter CVD Cess Amount in this column.
Account     You need to enter the Account Code to which the Excise Amount on Receipt transaction has to be credited. This account would be debited with the Excise Amount on Issue transaction.
Remarks     In the Remarks Block you can enter relevant remarks for PLA register for your reference and correspondence.

Note: You can view the GL drilldown accounting entries using the Show transactions button on the Tools menu of the Manual Entry form

Receiving Corrections

Using India - Mass Tax Update

In Oracle Financials for India, the Mass Tax update program is designed to handle impacts of Tax Rate revisions and Tax applicability changes for the following documents:

On running this concurrent, taxes will be recalculated for all selected OPEN documents.

Prerequisite Setups:

You must list changes in Taxes that will. impact the Open transactions. Following Changes/Additions will be made to current Tax Setup:

India - Mass Tax Recalculation

After completing the above setup changes, submit the Mass Tax Changes Concurrent request. To submit the request navigate toIndia Local Purchasing > Submit: Requests > Mass Tax Updates.

Choose the ‘Document Type’ (mandatory), From Date, To Date (Mandatory) and any other parameter fields (optionally). On successful completion of the Request, the Taxes on the Open transactions in the chosen Document Type would be recalculated, where applicable. The Taxes on the Tax Details window will be updated with the Taxes from the revised Tax Categories. The Tax Amount and the Total Amount on the Document header and lines would be recalculated to reflect the latest Tax Amounts. All Tax lines, manually added before the update, will be retained if these lines do not have precedence on any other lines (except the Base Item Line) and neither does any other Tax line have precedence over these lines. All documents with manual tax lines having precedence on other lines, will not be processed and audit tables will be updated accordingly.

Successful completion of the Concurrent Request updates the audit tables with the documents that are affected, the Old Tax Category and the New Tax Category. It will also list the documents that could not be updated and needs manual intervention.

If you do not wish to change the Supplier Additional Information and the Item Category Lists, then the Old Tax Category and the New Tax Category Codes can be chosen in the Parameters window. On running the concurrent request, all lines that have Old Tax Category Codes will be replaced with the new Tax Category Codes.

India- Mass Tax Recalculation - Request

Document Type

The User can select from the List of Document Type. This is a mandatory parameter

From Date

Enter a Date Value in this field. The Transaction lines with the document date created on or after this date would be considered for processing. This is a mandatory parameter.

To Date

Enter a Date Value in this field. The Transaction lines with document date created on or before this date would not be considered for process This is a mandatory parameter.

Supplier

The LOV for this parameter would display the Suppliers with transactions. This field is enabled only if Purchase Type of document is chosen in the Document Type field.

Supplier Site

The User can choose Supplier Site ID from the LOV. The LOV is restricted to the value chosen in the Supplier field.

Customer

The LOV for this parameter displays the Customers with transactions. This field is enabled only if Sales Type of document is chosen in the Document Type field.

Customer Site

The User can choose Customer Site ID from the LOV. The LOV is restricted to the value chosen in the Customer field.

Old Tax Category

The User can choose Tax Category from the LOV. The Transaction lines with this Tax Category is considered for processing. This Tax Category will be replaced with the value chosen in the ‘New Tax Category’ parameter and the Taxes will be recalculated accordingly.

New Tax Category

The User can choose Tax Category from the LOV. The Tax Category on the Transaction lines chosen for processing will be replaced with the value chosen in this field and the Taxes will be recalculated accordingly.

Document No.

Enter a Transaction Number of the document type of the transaction that you would restrict the processing to.

Blanket Release No.

Enter the Release Number to be processed.

Document Line No.

Enter the corresponding Document Line Number to be processed.

Shipment No.

Enter the corresponding Shipment Line Number to be processed.

Override Manual Taxes

On selecting ‘Yes’ in this field you would be restricting the processing to documents that do not have Manual Tax Lines. Else, all selected documents would be processed and any Manual Lines on these document would be deleted and new tax lines that would be defaulted for the transaction would be restricted to the taxes that are included in the Tax Category.

Commit Interval

Enter a Numeric Value here. The program will commit the processed records in groups defined by this Number.

Process Partial

Select ‘Yes’ or ‘No’. All OPEN Documents including those Partially Processed, will be considered for update if you selected ‘Yes’.

Update Tax Category

On completion of Patch application the Tax Category will default on the existing documents. The Tax Categories would be defaulted, based on the existing Localization setup.

Oracle Financials for India is designed to handle tax defaulting and calculation for the transactions entered by the user through Requisitions, RFQ, Quotations, Purchase Orders, PO Releases, Receipts, Sales Orders and RMA. The Defaulting would be based on the Three-way defaulting logic followed for Oracle Financials for India i.e., based on Supplier/Customer, Supplier Site/Customer Site or Item Class. However, following would be exceptions:

Receipts (Localized)

The Localization Taxes defined in the Purchase Order will be defaulted and the procedure for Accounting / treating different Localization taxes can be handled at the time of Receipt. For this, user need to Open Receipt through Receipt Localized window. By activating the “NEW” button, user will be taken to the Standard Receipt screen where he needs to match the receipt with a Purchase Order.

Navigate to India Local Purchasing - Receiving - Receipts (Localized) and use the India Local Receipts India Localization form to view and create receipts.

You can view receipts by querying any field like Receipt Number, Receipt Date, Shipment Number, Shipment Date, Excise Invoice No, Excise Invoice Date, Supplier Name, Inventory Organization.

  1. Click New to create receipts. Enter the Header information for the receipt.

  2. In the Transaction Type field, select either Express or Non Express. Selecting Express ensures that a single India Receiving Transaction processor concurrent request is submitted to Process all Receipt lines. The default value in this field is blank, which is equivalent to Non Express.

After the Receipt is created, Receipt details will be auto-queried to Receipt localized window where details of the Excise Documents need to be captured. Excise Invoice Number and Excise Invoice Date is captured in this screen. If you wish to avail CENVAT credit in Auto mode immediately on Receipt, you must check claim CENVAT on Receipt Flag.

Important: Whenever credit on Capital Goods is availed, you can claim 50% of Credit at the time of Receipt by specifying ‘Yes’ in the ‘Claim CENVAT on Receipts’. The balance Credit can be availed using ‘Claim CENVAT on Receipt’ screen.

If a Receipt has multiple lines and share the same Excise Information, then the use can fill these details at the Header level and click on populate defaults button to default the details to shipment lines. You also have an option to change these details at line level.

If there are Multiple Excise Documents for a Single Receipt, user can incorporate this information in the line level also. The user need to enter the Line information for the shipment line and save the data as per the regular standard Applications functionality.

Through the Tax button the user can view the Tax lines for the Receipt, which is as per the PO terms and the user is empowered to modify the tax lines at the times of Receipts. Only the modified tax lines for which the tax Vendor is other than the PO Vendor in the Receipts will be considered for AP Invoices raised for receipts for the respective tax and Third Party Vendor.

Important: The standard applications 'Receiving Transaction Processor' needs to be completed before the localization screen reflects the taxes.

On Receipt, all modifications are permitted to the tax lines provided the Receipt Modify Flag in Additional Organization Information screen is enabled. The modifications include:

Important: These modification of tax lines can be done only before closing of Receipt (Localized) form, once the Receipts (localized) form is closed, the corresponding accounting entries will be passed and the System won't allow the user to modify the tax lines.

The Total Amount will get updated with the Revised Amounts on saving the screen. However, on change of the Tax Amount the dependent tax amounts would not be re-calculated.

Once the Receipt localization screen is closed, India Receiving transaction processor concurrent program is submitted. This concurrent updates Excise Registers and creates Accounting Entries. In case of a Trading Organization RG 23D Register Entry and corresponding Accounting Entries are created by this Concurrent Request.

In case of a Manufacturing Organization, updates to Excise Registers and creates Accounting Entries would be based on the Receipt Routing Type and the value entered for Claim CENVAT in the Receipt.

You can check for the successful completion of the above concurrent program by navigating through view request.

Auto Accounting using NEW Button

A new Receipt can be created without closing Receipt localized form. This can be done using NEW button on India Local Receipts screen. Following message is populated when the user tries to create a new receipt using this path.

Accounting Entries and Excise Register Entries for the Receipt would be generated on accepting the message. You need to ensure that the taxes are updated before creating a new Receipt.

View Accounting

An option to view the Accounting Entries for Tax Accounting generated during the receipt is being provided. You can use this option to verify accounting entries are generated for the Receipt properly. Navigate to Tools > View accounting.

In the Transaction Type segment, you can select the transaction like Receive, Deliver, RTV etc. and look for the accounting entries generated.

Field Description Type Action Description
Account Type     The user can look for Accounting Entries generated for different account types like CENVAT, Receiving etc.
Account Mode     Accounting can be viewed for logistic transactions like Receipts, Return to Vendor etc. For Receipts Type of transactions, Account mode will be regular and for Return related transactions account mode will be reversal.
UOM     This field displays the Unit of Measurement in which the transaction was recorded.
Line number     This field displays the Accounting Transactions lines for which view Accounting Entries are displayed. By using the down/up arrows, user can view the Accounting Entries for different lines in the Receipt.
Transaction Date     This field displays the date on which Accounting Transaction is recorded.
Quantity     This field displays the Quantity Received against the transaction

View Registers

On completion of the Receipt Accounting process, by navigating through the

Tools - View Register Menu, the user can check the updates in the CENVAT Registers.

In the Receipt Segment, Receipt related information like Transaction Date, Unit of measurement, Quantity Received, Sub Inventory and Lines Numbers are displayed. This functionality facilitates the user to confirm updation of excise registers on completion of a Receipt transaction and the amount flown into the CENVAT Registers.

In the Register segment, by using the TAB key, user can move to part I, part II, RG 23 D and PLA * registers as per the transaction parameters.

* PLA will be updated only for RTV Transactions when preference is set to 1 or when sufficient balances are not available.

Field Description Type Action Description
Register Type     This field displays the Register in which the transactions are recorded. This will be updated based on the values for the Items defined in the Item Class. This can be CENVAT on input (RG 23 A), CENVAT on Capital Goods (RG 23 C) or Dealers CENVAT Register (RG 23 D)
Serial Number     This field displays the Serial Number in the respective Register under which the transaction was recorded.
UOM     This displays the Unit of Measurement in which Excise Registers got updated. Always Excise Registers will get updated only in the primary Unit of Measurements and users need to take enough care while defining the conversion factor from primary Unit of Measurement to secondary Unit of Measurement.
Invoice Number     This field displays the Excise Document Number that was recorded for the transaction
Invoice Date     This field displays the Duty paying Document Date on which credit was availed.
Vendor Name     This field displays the Vendor/Customer Name with whom the transaction was performed.

Apply BOE to Receipts

In all Receipts where tax of type Customs Duty or Additional Customs Duty is defined in the tax lines, the system will not permit saving the record, without applying Bill of Entry (BOE). BOE Button will be enabled only when the receipts tax lines have tax type like Customs Duty, Additional Customs Duty.

Payment towards Customs Duty need to be done through BOE Invoices in AP Module (Invoices- BOE Invoices) At the time of Receipt, Items need to be matched with the payment of Customs Duty paid on the item. This is done by matching the BOE Invoice with the Receipt. Matching is done on Item-to-Item basis. Each Item where Customs type of taxes are attached,

Choose 'Apply BOE' to indicate against which Bill Of Entry the Duty Amount was paid.

The Customs Duty is paid to Customs Authorities on the Bill of Entry Value before the Receipts of Goods. You can record the BOE details using BOE Invoices feature in India Local Payables. This will automate creation of a AP Invoice for the Customs Authority. BOE created through BOE Invoices can be applied against a Receipt by using the ’ Apply BOE’ form.

In the Header Block

Field Description Type Action Description
Customs (Displayed)   The amount of Customs Duty in the Receipt Tax Line will be defaulted here.
CVD (Displayed)   The amount of CVD in the Receipt Tax Line will be defaulted here.
Total Customs Duty (Displayed)   Total of Customs Duty and CVD in the Receipt Tax line will be defaulted here
Total Amount Applied (Displayed)   The Total Amount of Customs Duty will be displayed after entering the line data.

In the Line Level

Field Description Type Action Description
BOE No (Displayed)   All the BOE No’s raised in AP but not yet applied will de displayed here.
Import Dept. Sl. No. (Displayed)   Value entered in the corresponding field of the BOE Payment Screen would appear in this field.
Customs Authority (Displayed)   You can view the Customs Authority Name in this field.
BOE Amount (Displayed)   BOE Amount will de displayed here.
Amount written off (Displayed)   If part of the BOE Amount is already written off through the Written off functionality in Accounts Payable, then the same amount will de displayed here
Amount already applied (Displayed)   If part of the BOE Amount has been applied, then the same will appear here.
Amount to be applied (Enterable)   The user can enter the amount to be applied, which can not exceed the Total Customs Amount.
The User need to save this screen after entering the above information. Once a BOE is fully applied it won't be appearing in this form for application.

Unordered Receipt

At the time of Receipt of Items it may not be possible to ascertain the Purchase Order against which an Item is being received. In such case you enter an Unordered Receipt.

In respect of Unordered Receipt, no taxes are defaulted for the receipt since the purchase order against which the receipt is done is unknown.

Unless the Receipt is matched to Purchase Order the Taxes does not default.

While matching Receipt with PO, Oracle Financials for India will provide the taxes from the Purchase Order and these taxes cannot be modified.

The option to claim CENVAT on receiving is not available on the Unordered Receipts screen. It is available while matching Receipt with PO . The Excise Records are updated for Material Receipt in RG23A/C Part I only on matching the Receipt to a Purchase Order.

No Accounting Entries are generated at the time of Receiving. The Accounting Entries are generated at the time of matching with Purchase Order.

You can also access the 'Claim CENVAT on Receipts' screen under Inventory Receiving to generate the Excise Entries and accounting for CENVAT if you do not claim CENVAT Credit while matching Receipt with PO.

After matching the Unordered Receipts, the User has to query the Receipt Number in the Receipt Localization screen and BOE has to be applied for the Receipt if the receipts tax line are having customs type of taxes.

Match Unordered Receipt

The Unordered Receipts needs to be matched to a Purchase Order later. CENVAT credit on Unordered Receipts can be claimed only once the Receipt is matched with a Purchase Order. In the flex field, user needs to select India Receipt as the context value and record the Excise Duty paying document details.

Navigation: Receiving - Match Unordered Receipts

The Excise related information like Excise Invoice, Excise Invoice Date and Claim CENVAT on Receipts would be entered. Receipt Localized window. *.

* CENVAT Credit cannot be taken for Unordered Receipt on Receipt of the Goods. Credit can be taken only on matching the Unordered Receipts with a Purchase Order. Query the Receipt from Receipt localized window and provide Excise information to claim. The provision for Tax Corrections at the time of Receipt is not available for Unordered Receipts. Hence User need to ensure that the Purchase Order has the actual tax figures.

India Localization Receipt Details

India Local Receipt Details form summarizes taxes, Excise Registers (both quantity and amount), Accounting, Costing and BOE details of receiving transactions.

  1. Navigate to India Local Purchasing > Receiving > Receiving Transactions Summary.

  2. Query the transaction to display the Receiving Headers Summary window.

  3. Click ‘Transactions’ to display the Receiving Transaction Summary window.

  4. Click View > Zoom to display India Local Receipt Details window.

In the Header Block

Field Description Description
Receipt Number Receipt Number that is queried will be displayed here.
Unit of Measurement UOM of the Item will be displayed here.
Quantity Quantity of the Item received will be displayed here.
Transaction Type Transaction Type will be displayed here.
Tax Amount Total Tax Amount of the Receipt Tax line will be displayed here.
Cenvat Amount Cenvat Amount of the Receipt Tax Line will be displayed here.
Item Class Item Class of the Item Received will be displayed here.
Excise Invoice Number Excise Invoice Number of the Vendor will be displayed here.
Excise Invoice Date Date of the Excise Invoice will be displayed here.
Processing Status This field displays process status related to Non-Cenvat Taxes included in the Receipt. This field displays following values:
E - Implies error during processing
Y - Implies successful completion of the program
X - means that taxes are not applicable to the receipt line
O - Implies missing setup
Cenvat Process Status This field displays process status related to cenvat taxes included in the receipt. This field displays following values:
E - Implies error during processing
Y - Implies successful completion of the program
X - means that taxes are not applicable to the receipt line
O - Implies missing setup
XT - Implies that correction could not be completed due to change in the period of receipt and the correction.
Process Message This message displays process message for Non-Cenvat Taxes. The message depends on the value in the Processing status.
Cenvat Process Message This message displays process message for Non-Cenvat Taxes. The message depends on the value in CENVAT Process status field.

In the Line Level

Field Description Description
Tax Tab  
Line Number Serial Number
Name Name of the Tax will be displayed here.
Type Type of Tax as selected while Defining Tax.
Rate Type Rate type will be displayed here.
It can either be Percentage Adhoc or UOM
Depending on the Tax Definition
Rate Rate of Tax as defined while Tax Definition.
Precedence / UOM Precedence used to calculate Taxable Basis. This field would be populated for percentage-based taxes.
In case of UOM based Taxes, Unit of Measure assigned to the Tax Code will be shown.
Currency Tax Currency will be displayed here.
Amount Amount of Tax will be displayed here.
Recovery % Recovery Percentage as specified while Defining Tax.
Recoverable The value in this field would be set to ‘Yes’ whenever the Tax is Recoverable in the context of the transaction.
In cases where a Recoverable Tax is not recovered due to certain Item and Organization setup, this field would reflect ‘No’ irrespective of the value in the ‘Recovery % ' field.
Modified Manually This will be ‘Yes’ when the Tax Amounts or the Taxes have been modified by the user.
Vendor Name of the Vendor will be displayed here.
In case of the First Party Taxes, the PO Vendor Name would be displayed here.
In case of Third Party Taxes, the Tax Vendor Name would be displayed here.
Vendor Site Vendor Site Name will be displayed here.
In case of the First Party Taxes, the PO Vendor Site would be displayed here.
In case of Third Party Taxes, the Tax Vendor Site would be displayed here.
Quantity Register Tab  
Organization Name of the Organization will be displayed here.
Location
Fin Year
Register Register type will be either RG23A or RG23C.
Sl No. Serial Number of the entry in the Quantity Register will be displayed here.
Creation Date
Excise Invoice Number Excise Invoice Number of the Vendor will be displayed here.
Excise Invoice Date Date of the Excise Invoice will be displayed here.
Transaction UOM UOM in which the Transaction has been made will be displayed here.
Primary UOM Primary UOM assigned to the Organization item will be displayed here.
Quantity Received Quantity Received will be displayed here.
Amount Register Tab  
Organization Name of the Organization will be displayed here.
Location Location of Receipt will be displayed here.
Fin Year Financial year in which the receipt was created will be displayed here.
Register Register type will be either RG23A or RG23C.
Sl No. Serial number of the entry in the amount register will be displayed here.
Creation Date Creation date of the CENVAT Register Entry will be displayed here.
Excise Invoice Number  
Date of the excise invoice will be displayed here.
Debit Amount debited to the register through the transaction will be displayed here.
Credit Amount credited to the register through the transaction will be displayed here.
Accounting Tab  
Transaction Date
Creation Date Creation date of the Accounting Entry will be displayed here
Account Number of the account in which the effect of the transaction is going will be displayed here.
Account Type This field displays the class of accounting entries.
Period Accounting period
Debit Amount Debited will be displayed here.
Credit Amount Credited will be displayed here.
GL Posting Status Displays the status of posting to GL
Sub Ledger Displays the status of posting to Ja_In_Rcv_Journals
Date of the receipt transaction will be displayed here.
This field displays the class of accounting entries.
Organization Name of the Organization will be displayed here.
Costing Tab  
Creation Date Date of the receipt transaction will be displayed here.
Account Number of the Account in which the effect of the transaction is going will be displayed here.
Period Displays Accounting Period
Debit Amount Debited will be displayed here.
Credit Amount Credited will be displayed here.
Organization Name of the Organization will be displayed here.
BOE Tab  
Customs Authority
Site Site of customs authority will be displayed here.
Agent Name
Number of the BOE will be displayed here.
Amount Amount applied against the BOE will be displayed here.

Claim CENVAT on Receipts

If you do not wish to take credit on inputs or capital goods immediately on Receipt, you can claim the credit from the Claim Credit on Receipts window. In the case of capital goods, balance Credit of 50% that can be availed in the Next Financial Year can be claimed through this screen.

While taking Credit on Capital Goods through this windows the Accounting Entries mentioned will get generated.

This form can be used to claim CENVAT Credit on Receipt if the CENVAT Credit is not taken at the time of Receipt because of non-availability of adequate information. Further, for Capital Goods the CENVAT Credit could be taken only after installation and thus this feature of claiming CENVAT at a later stage after the Receipt is provided.

  1. Receiving and CENVAT entries are not generated for Receipts with routing as Standard, unless CENVAT Credit is claimed.

  2. Ensure that CENVAT is claimed before the Purchasing and Inventory periods are closed.

Navigate to India Local Purchasing > India Localization > Receipts > Claim Modvat on Receipts > Find Receipts India Localization.

This Query Find window provides following checkboxes.

This feature would help you in querying eligible Receipts for Claim CENVAT, in a Batch Mode. This feature would be of great use to claim remaining CENVAT on Capital Goods (CGIN Items) purchased during the Previous Year.

Following would be the behavior in each combination of options above:

Combination B: 1: All purchases made in the previous year, for which CENVAT is available for claim would be fetched. This would include both RMIN and CGIN Items.

Rather this is an exclusion of Receipt lines in the current year (pending CENVAT Claim).

Combination C: 2: All CGIN purchases with CENVAT attached, not claimed completely would be fetched. This would include receipt lines of the current and also the previous year.

Combination D: 3: All CGIN purchases for which first 50% CENVAT has been claimed would be fetched. This would be irrespective of the year.

Combination F: 1+3: All CGIN purchases made in the previous year for which first 50% CENVAT has been claimed in the previous year would be fetched.

Combination G: 2+3: All CGIN purchases for which first 50% CENVAT has been claimed would be fetched. This would be irrespective of the year in which the goods are purchased.

The below mentioned screen will be used to claim CENVAT for the Receipts. These Receipts should have associated tax lines and CENVAT = 'Yes'

Navigate to India Local Purchasing > India Localization > Receipts > Claim Modvat on Receipts > Find Receipts India Localization.

Receipt Number (Displayed)

The Receipt Number for which CENVAT is to be claimed.

Receipt Date (Displayed)

Date on which the receipt has been entered.

Item (Displayed)

The Item for which the Receipt has been entered.

Description (Displayed)

Description of the Item.

Item Class

The Item Class of the Item will be defaulted in this field. By default, this will be CGIN or CGEX as defined in the Item Category flex-field.

Total CENVAT Amount

This field displays the total CENVAT Credit available on the Item

Claimed CENVAT Amount

If partial Credit is availed on the Receipt, this field displays the amount of credit that is already availed.

Claimed CENVAT Percentage

This field displays the Percentage of Credit availed on the item for the Receipt under reference.

CENVAT percentage to be availed

This field displays the percentage of credit which is available for claiming credit

Original Quantity

This field displays the Quantity of Goods received against Receipt under reference

Location

This field displays the Location in which the Receipt under reference was performed

Vendor Changed

You need to check this field whenever, the Vendor Name and Vendor Site has to be changed. This would enable the Vendor Name and Vendor Site field.

Vendor Name (Displayed)

Name of the Vendor from whom the Inventory is received. The PO Vendor would be displayed in this field. However, in case you have received the goods from a different Vendor, then you can update the Vendor Name with the Vendor from whom you have received the goods. To do this, check the ‘Vendor Changed’ Checkbox. Select a new Vendor and Vendor Site.

Vendor Site (Displayed)

Name of the Vendor Site from whom the Inventory is received. The PO Vendor Site would be displayed in this field. However, in case you have received the goods from a different Vendor, then you can update the Vendor Name with the Vendor From whom you have received the goods. To do this, check the ‘Vendor Changed’ Checkbox. After you update the Vendor Name you can select the Vendor Site in this field.

Excise Invoice No (Required) ENTER

You have to enter the Excise Invoice Number.

Excise Invoice Date (Required) ENTER

Date of the above Excise Invoice Number.

Claim CENVAT (Required) CHECK BOX

You have to enable this check box to take CENVAT credit on a particular Receipts

Unclaim CENVAT (Required) CHECK BOX

You have to enable this check box to take unclaim CENVAT credit on a particular Receipts.

Check All

Click this field to select all the Receipt Lines for processing.

Clear All

Click this field to deselect all the Receipts.

Unclaim All

Click this field to Unclaim all the Receipts and load Excise Amount to Item Cost.

Claim

Click this button, process the selected Receipt Lines. A single concurrent would be fired to process all the selected Lines.

Unclaim

Click this button, process the selected Receipt Lines for Unclaim. A single concurrent would be fired to process all the selected Lines.

You can select lines one at a time by Clicking on ‘Unclaim CENVAT’ checkbox on the line. Else, you can check the ‘Unclaim All’ checkbox on the header.

All selected lines are processed for Unclaim on clicking on the ‘Unclaim’ button.

  1. Oracle Financials for India supports Receipts corrections with IN60106. Entries to adjust taxes would be automated on saving Receipt corrections. Hence the ‘Modify’ facility has been removed from Claim CENVAT on Receipts’ screen.

  2. You cannot claim CENVAT for a receipt if the same combination of Excise Invoice Number, Excise Invoice Date has been used for another Receipt created in the current Organization from the same Vendor Site.

CENVAT Credit on Capital Goods

At the time of taking CENVAT Credit on Capital Goods, the user can define the percentage of CENVAT Credit the user wants to take immediately on Receipt of the Goods. For using this functionality, the user needs to carry out the steps mentioned below.

Following setups are mandatory for availing partial Credit on Capital Goods and to Claim the balance later.

Item should be classified as Excisable, Modvatable and Item class should be CGIN or CGEX.

After creating the Receipt, Excise Document details need to be provided in Receipt localized window. These values can also be filled in at the Receipts Line level. If “Claim CENVAT on Receipt” is checked, RG 23 C Part II Register Entries would be created for 50% of CENVAT applicable to the Receipt Line. else, if you don’t check will defer the claim of CENVAT. In such cases, you need to follow the “Claim CENVAT on Receipts” process (as specified in the previous section of this Chapter).

Remaining 50% of CENVAT Credit arising from the Capital Purchase can be claimed during the following year

Unclaim CENVAT

CENVAT can be claimed only on Receipt of documentary evidence indicating the Excise Duty Liability incurred by the Shipping Organization. There would be situations where the Organization might not receive such documentary evidence. In such cases the Excise Duty amount has to be included the Item Cost and the record should be eliminated from the list of records that have to be processed for CENVAT Claim.

In case the Item is Inventory Item then, such CENVAT Amount should be added to Item Cost if the costing method is ‘Average’. The same should be accounted as Purchase Price Variance, where the costing method is STANDARD. If the item is EXPENSE then the CENVAT amount needs to be added to Expense Account.

An option has been provided in the ‘Claim CENVAT on Receipts’ screen, where the user can identify the Receipt lines that have to be eliminated from the CENVAT Claim processing. Such records would be eliminated from CENVAT Claim processing & excise duty related to such records would be included in the Item Cost.

Navigate to India Purchasing > India Localization > Receipts > Claim CENVAT on Receipts

Through the above find Receipts Form you can find the Receipt for which you will like to unclaim CENVAT. After entering the required fields the “find” button has to be clicked to fetch the existing records for the criteria entered.

In the Claim CENVAT on India Local Receipts screen you can select all lines that you would like to Unclaim and eliminate them from further process of CENVAT Claim.

You can select lines one at a time by Clicking on ‘Unclaim CENVAT’ checkbox on the line. Else, you can check the ‘Unclaim All’ checkbox on the header.

All selected lines are processed for Unclaim on clicking on the ‘Unclaim’ button.

Returns to Vendor

A Return to Vendor transaction has to be created by the user Navigate from Return to Vendor India screen

When you create a return for material that has CENVAT applicability then you need to select Generate from process action LOV. This would ensure appropriate accounting for CENVAT taxes.

A Batch Number will be generated based on which ’India - Return to Vendor’ Report can be taken.

Navigate to India Local Purchasing > India Localization > Receipts > Return to Vendor (India) > Return.

After entering the required criteria - Excise Invoice Number, Batch Number and VAT Invoice Number, click Find to fetch the records depending on the criteria entered.

Quantity (Required)

The Quantity to be returned is entered in this field.

UOM (Required)

The Unit of Measure of the Item to be returned.

Return to (Required)

Destination of the Item to be returned whether to receiving or to Supplier

Supplier/Location (Conditionally Required )

Enter Location if the return to is receiving and if it is Supplier field will display name of the Supplier.

Return type to Reason (Optional)

This is available from the Details tab of the Receiving Returns of the base form.

After entering all the required fields save record. After saving the transaction navigate back to Return to Vendor-India to default the details.

Select Process action from the LOV and click on default button to default the action details to shipment lines.

On saving the record, Accounting Entries and Entries in RG23A-Part I & II or RG23C-Part I & II and PLA are created depending on the Item Class and Type of Organization

In case of Manufacturing Organizations, the Duty Registers selected depends upon the preferences set up done in the Additional Organization Info screen. If PLA is set as the last preference and the item returned is a capital good (CGIN Item) then, balance in RG 23C Part II would be considered first. PLA would be updated only if there no adequate balance in RG 23C Part II. However, balance in RG 23A Part II registers will not be considered.

RG 23D Register would be updated for Trading Organizations.

On completion of RTV transaction, the relevant excise registers will be updated and the print of the duty-paying document can be taken.

Return to Vendor in the Case of a Trading Item

Return to Vendor of a Trading will be done in the Standard Application form itself and the respective Issue entries will be passed in the RG23D Register and the same can be viewed through Transaction type Return to Vendor.

Return to SSI Vendor

Return to Vendor of a SSI would require a change in the rate of CENVAT Duty. To enter the revised Duty applicable to the Return, you can query an Existing Return transaction using Return to Vendor (India) screen. Here you have an option to specify the Revised Rate / Amount. Only Excise and Education CESS taxes will be displayed

Navigate to India Local Purchasing > India Localization > Receipts > Return to Vendor (India) > Inquiry.

Approval Workflow for Purchasing Documents with Localization Tax details

Oracle Financials for India now enables reporting and display of India taxes in purchasing approval workflow notifications. India taxes are included in the following:

In addition, you can modify the tax amount, precedence, vendor, and vendor site information at the time of approval.

Inquiry

Requisition Summary (Localized)

Use this View Requisition Summary to review a particular Requisition (Localized) by specifying its Number. All the Requisitions will be viewed if the user does not specify a single Requisition PO Number. By pressing the New Requisition button the user can create a new Requisition also.

Viewing Requisition Summary

In Oracle Financials for India, navigate to the India Local Requisitions Summary window from India Local Purchasing > India Localization > Requisitions > Requisition Summary (Localized).

Field Description Type Action Description
Requisition Number     The user need to specify the Requisition Number which he wants to review through this View Requisition Summary form otherwise all the Requisition will appear in the summary.
Preparer     The user need to review all the requisition prepared by a person, then by specifying the Name of the Preparer in this column he can get a summarized report on all Requisition raised by that Preparer.
Approval Status     If the user wants view all the Requisitions with a particular Approval Status (the Quick field for Approval Status are Rejected, Require Re-approval, Returned then he can specify that and view the summary report.
Order Number     The user can view the Requisition summary report for a particular purchase order by specifying the Order Number here.
Type (Optional)   By specifying the Requisition type like Purchase or Internal, he can view the reports of all Requisitions raised for a particular Type.
Requester (Optional)   By specifying a particular Requester Name, the user can view all the requisitions raised by that Requester.
Item (Optional)   By specifying a particular Item, the user can view all the requisitions raised for that Item.
Supplier (Optional)   By specifying a particular Supplier Name, the user can view all the requisitions raised for that Supplier.

If the user wants to view all the Requisitions then he need not to specify any of the above field for querying and can blind query through the Find button.

Note: The Assessable Value used for tax calculation falling under Excise/VAT regime is retrieved from Assessable Price list based on Item Category.

Quote Analysis (Localized)

You can use this feature to analyze your quotations. By navigating through Quote Analysis (Localized) you can view the Per Landed Unit Cost (for the item) including Localization Taxes.

Through this form the user can view the Quotations (Localized) raised by a specific query or a blind query.

Viewing Quotations

In Oracle Financials for India, navigate to India Local Purchasing > India Localization > Quotations > Quote Analysis (Localized).

Click Find without supplying values for any field to view all Local Quotations. You can further sort the results by specifying particular fields in the form like RFQ, Supplier, Quotation and respective quotations can be viewed.

Note: Only Non-recoverable portion of the taxes will be considered for calculation of per landed unit cost.

Purchase Order Summary

Use this View Purchase Order Summary to view a particular Purchase by specifying its Number and all the Purchase Orders will be viewed if the user does not specify any of the field. The user can do new release for a PO through New Release button and the user can create a new Purchase Order through the New PO button.

Viewing Purchase Orders

In Oracle Financials for India, navigate to India Local Purchasing > India Localization > Purchase Orders > PO Summary (Localized).

Field Description Description
Purchase Order Number The user need to specify the Purchase Order Number for which he wants to review through this View Purchase Order Summary Form.
Release Number The user need to the review all the Purchase Order Released under a Blanket Agreement, then by specifying the Release Number in this column he can get a summarized report on all Purchase Orders raised.
Supplier By specifying a particular Supplier, the user can view all Purchase Orders raised for that particular Supplier.
Ship To-Org By specifying a particular Ship To Inventory Organization Name, the user can view the entire PO raised for that Inventory Organization.
Bill To By specifying a particular Bill To Site Name of an Inventory Organization, the user can view all the PO raised for that Bill to Location
Type By specifying the Purchase Order Type like Standard, Blanket Order or Contract Agreement, he can view the report of all Purchase Order raised for a particular Type.
Item By specifying a particular Item, the user can view all the purchase orders raised for that Item.
Ship To By specifying a particular Ship To Site Name of an Inventory Organization, the user can view all the PO’s raised for that Ship To Location.
Buyer By specifying a particular Buyer Name, the user can view all the PO raised for that Buyer

Important: On Clicking Open Button in the PO Summary (Localized) window, Purchase Orders, Base Applications window would be opened.

The following column will be displayed in this Summary screen. The field wise description of the form is given below for ready reference.

Field Description Description
PO Number Purchase Order Number will be displayed
Release Number The Release Number for the Purchase Order will be displayed.
Line Number of the PO Line Number of the Purchase Order will be displayed.
Shipment Number of the PO Shipment Number of the Purchase Order is displayed.
Type of the PO Type of the Purchase Order will be displayed in this field.
Item Item Code of the Item is displayed.
Item Description Item description is displayed
UOM Unit of the Measurement is displayed in this field.
Quantity Quantity transacted will be displayed in this field.
Currency The Currency in which the transaction got recorded will be displayed.
Price Transaction Price is displayed in this field.
Amount Quantity multiplied by Price will be displayed.
Tax Amount Tax Amount will be displayed in this field.
Line Total Total of the Line Amount will be displayed in this field.
Ship To Location This field displays the Location to which the goods will be shipped.
Supplier Name Name of the Supplier will be displayed in this field.
Supplier site Supplier Site with which the transactions are to be made will be displayed.
Authorization Status This field displays the Authorization Status of the document.
Need by Date Need by Date for the item will be displayed in this field.
Buyer Name Name of the Buyer will be displayed in this field.

Retroactive Pricing

In some industries, it is a common practice for buyers and suppliers to agree on an interim price for a new part while negotiations for a final price are still in progress. Purchase orders for the new part are placed and payments made based on this interim price. In many cases the final price resulting from the negotiation process takes effect retroactively from an agreed upon date. The effect of this retroactive price change is that existing blanket releases for the item need to be priced again and invoices adjusted for price corrections along with the tax impact.

The Retroactive Pricing function allows price revision events to be propagated from the blanket agreement to the downstream documents relating to that agreement such as releases or standard purchase orders. Such price modifications on purchasing documents have a direct impact on the taxes applicable to the transactions.

The retroactive function lets you recalculate India taxes on downstream transactions.

Prerequisites

  1. Set the PO: Allow Retroactive Pricing of POs profile options to the following values:

    PO: Allow Retroactive Pricing of POs Profile Option Values
    Profile Value Description
    Open Releases Only Processes only releases or standard purchase orders that have not been received nor invoiced
    All Releases Consider all releases in the appropriate status irrespective of whether they have been received or invoiced

    Note: The retroactive pricing is disabled if you set the value to Never.

  2. Uncheck Use PO Encumbrance on the Financials Options window, Encumbrance tab.

    Navigation - India Local Purchasing > Oracle Purchasing > Setup > Organizations > Financial Options

Applying the Retroactive Pricing

In Oracle Payables, you first change the prices and run the ‘Retroactive Price Update of Purchasing Documents’ concurrent request to apply the revised prices to the existing purchase orders or releases. Once retroactive prices are applied, the tax amounts based on the item price need to be recalculated.

To recalculate the tax amounts, run the 'India Retroactive Tax Update of Receipts' concurrent request with the parameters described in the following table:

India Retroactive Tax Update of Receipts Concurrent Request Parameters
Parameter Description
Vendor Name Name of the supplier.
Vendor Site Vendor sites are displayed according to the vendor selected.
Agreement Number The agreement number is displayed according to the vendor and vendor site selected.
Effective From Enter an effective date for the retroactive pricing.
Cenvat Action Claim or unclaim tax benefits.
Supplementary Excise Invoice Number Supplementary Excise Invoice number.
Supplementary Excise Invoice Date Supplementary Excise Invoice date.
VAT Action Claim or unclaim VAT.
Supplementary VAT Invoice Number Supplementary VAT Invoice Number.
Supplementary VAT Invoice Date Supplementary VAT Invoice Date
Process Taxes for Downward Revision Select Y or N to process taxes for downward revision or not.

The India Retroactive Tax Update of Receipts concurrent request will do the following:

Note: Skip this process if the price changes in BPA or GPA that does not have any related document like POs, release, and receipts

The retroactive price change is not applicable in the following cases:

  1. The tax amount is calculated based on Assessable values such as Excise or VAT.

  2. The tax is a UOM based tax.

  3. The tax type is Adhoc.

  4. The tax is third party type.

Reports

This section provides overview and detailed descriptions of these reports:

India - Purchase Register Report

This report provides details of all purchases made for a vendor or for all the vendors for a given period. This report is based on the AP Invoices created for the purchases.

Report Submission:

Use the Submit Requests (India Local AP & PO Module Only) form and enter India - Purchase Register Report in the Name field to submit the report.

Report Parameters:

If you purchase for a specific vendor, then you can enter the name, else purchase for all the vendors will be reported.

If vendor name is specified in the above parameter, then the respective vendor number will be defaulted.

Period of Report (Required)

Enter the period for which you wish to take the Purchase Report for.

Report Headings:

Report headings provide you with general information about the contents of the report. Oracle lists Company Name and Operating unit information based on User parameter input.

Column Headings:

Sl. No.

Serial Number of the Line details will be reported.

Voucher No

Purchase Invoice Voucher Number will be reported

Vendor Name

Name of the Vendor will be reported.

Bill No & Date

Supplier Bill No & Date will be reported

PO Number. & Date

Purchase Order Number matched to the Invoice.

Remarks

Remarks appearing in the Purchase Voucher will be reported

Currency

Transaction Currency will be reported.

Net Amount

Purchase Invoice Line Amount will be reported.

The following taxes in a purchase invoice will be reported.

Excise Duty

Excise Duty amount associated in the transaction.

Customs Duty

Custom Duty Amount associated in the transaction.

LST (Local Sales Tax)

Sales Tax Amount associated in the transaction.

Insurance

Insurance Tax Amount associated in the transaction.

Freight

Freight Tax Amount associated in the transaction.

Octroi

Octroi Tax Amount associated in the transaction.

VAT Tax

Value Added Tax Amount associated in the transaction.

Service Tax

Service Tax Amount associated in the transaction.

Other (Other taxes if any )

Other Tax Amount associated in the transaction.

Total Amount

Total of the Purchase Invoice will be reported

India Receiving Accounts

Report Submission:

Use the Submit Requests (India Local PO Module) form and enter India - Receiving Accounts in the Name field to submit the report.

Report Parameters:

Organization Code (Optional)

Organization Code, for which you wish to take the Receiving Accounts report for.

Receipt Number (Optional)

Receipt Number of the above Organization, you wish to display the transaction details or to display all Receipt Numbers.

Line Number (Optional )

This parameter is specific to the above parameter. Line Number of the above receipt , you wish to view the transaction details or all Line Numbers of the above receipt will be displayed.

Account Type (Optional)

Account Type , you wish to display transaction details of particular Account Type or to display all Account Types details

Transaction Type (Optional)

Select the Transaction for which you want to generate the report type or to display all Transaction Type details.

From Date (Optional)

Date to print all the transaction details starting with the entered date.

To Date (Optional)

End Date to restrict the transactions till this date.

Report Headings:

Report Headings provide you with general information about the contents of the report. Oracle lists organization information based on user parameter input.

Column Headings:

Organization Code

Code of the Organization will be reported.

Receipt Number

Receipt Numbers will be reported.

Line Number.

Line Numbers of each transaction will be reported.

Item Description

Item details on which transactions has done will be reported.

Transaction type

A specific Transaction Type for which the report is printed.

UOM

Unit of Measure used in transaction will be reported.

Quantity

Quantity received in each transaction will be reported.

Account Type

Account Type used in each transaction will be reported.

Account Mode

Account Mode used in each transaction will be reported.

Account

General Ledger Account to track the accounting entries for a specific account.

Amount (Dr)

Column representing amount debited.

Amount (Cr)

Column representing amount credited.

Currency Code (Dr)

Currency used in transaction will be reported.

Currency Conversion Rate

Currency Conversion Rate used in the transaction will be reported if MRC is used.

Period

Period in a financial year will be reported.

Creation Date

Date on which the transaction was created.

Report Summary:

This section of the report lists the net activity of all accounts according to the transaction type.

Account

General Ledger Account to track the accounting entries for a specific account.

Transaction Type

Transaction Type of particular type will be reported.

Total Amount (Dr)

Total Amount debited for one particular transaction of the account.

Total Amount (Cr)

Total Amount credited for one particular transaction of the account.

Net Activity

Total of amount debited and amount credited for a particular account.

Total Net Activity for All Accounts

Total of amount debited and amount credited for all accounts.

Report Order:

Report is printed in the order of Receipt Number, Line Number, and Transaction Type for the selected Organization.

India - Purchases Report

Use India Purchases Report to generate transaction details for Purchases made Outside the State, Within the State and Unregistered Dealers.

Report Submission:

Use the Submit Requests (India Local PO Module) form and enter India - Purchases Report in the Name field to submit the report.

Report Parameters:

Report For (Required, Default)

Single Report can generate transactions carried Outside the State, Within the State, and Unregistered Dealers based on this parameter.

Organization (Required)

Select the Organization for which you wish to print the report.

Location (Optional)

Select the location for which you wish to print the report.

Supplier

Select the supplier if you wish to generate the report for a specific supplier.

Supplier Site

Select the Supplier if you wish to generate the report for a specific Supplier Site.

Start Date

Date Range to specify from which date these transactions needs to be picked.

End Date

Date Range to specify till which date these transactions needs to be picked.

Report Headings:

Provide you with general information about the contents of the report. Oracle lists organization information based on user parameter input.

Columns Headings:

Name of Vendor

Name of Vendor from whom the purchase was made.

Sales Tax Registration No. of Vendor

Sales Tax Registration No. of Vendor as entered in vendor entry form.

Invoice Number

Invoice Number of the purchase.

Invoice Date

Invoice Date of the Purchase.

Invoice Amount

Gross Amount as entered in Invoice.

Sales / VAT Tax Rate

Sales Tax Rate for the particular Invoice Line.

Sales / VAT tax Amount

Total Sales Tax Amount for the ST rate for the Invoice.

Report Totals

Invoice Total & Sales Tax total for the chosen period.

Report Summary:

This section of the report lists the summary (Tax summary) of Rate wise total for Sales Tax.

Total for Tax Type @ rate %

Total for the Sales Tax Rate for the chosen period.

Tax Total

Total Tax for the chosen period.

Report Order:

Report is printed in the order of Vendor Name, Invoice Date, and Tax Rate for the selected Organization.

India PLA Register Report

This report gives you complete details of Personal Ledger Account as per prescribed format specified by Central Excise Act. Format and columns of this report is same as specified by the Central Excise Act.

Use the Request Transaction Reports form and enter India PLA Register Report in the Name field to submit the report.

Organization (Required)

Enter a Organization, you wish to take the PLA Report for.

Location (Required)

Enter a Location, you wish to take the PLA Report for.

Transaction From/To Date (Required)

Oracle Financials for India allows the user to print selectively the transactions from a given date on wards.

Report Headings:

Report headings provide you with general information about the contents of the report. Oracle lists information as given in the report format of PLA Register.

Column Headings:

Sl. No.

Serial Number of the Register maintained in the order of transactions.

Date

Transactions Date.

Document No

Localization prints TR6 Challan Number.

Document Date

Localization prints TR6 Challan Number.

Basic Excise Duty

Localization prints cr_other_ed for Excise Duty.

Special Excise Duty

Localization prints cr_other_ed.

Additional Excise Duty

Localization prints cr_additional_ed.

Invoice No.

Localization prints dr_invoice_id.

Invoice Date

Localization prints dr_invoice_date.

Debit Excise Duty Amount

Derived as dr_basic_ed + dr_additional_ed + dr_other_ed.

Balance

Derived as cr_basic_ed + cr_additional_ed + cr_other_ed - dr_basic_ed- dr_additional_ed - dr_other_ed.

Central Excise Reports

All these Reports related Central Excise Act will be available in India Local INV, PO, AP, OE, & AR Modules in the respective report requests.

India RG 23A Part-I Report

This report gives you the Stock Account of 'Inputs' for use in or in relation to the manufacture of 'Final Products' and complete Quantitative Details as per format specified by Central Excise Act for an Inventory Organization and its Location. Format and columns of this report is as same as specified by the Central Excise Act.

Report Submission:

Use the Request Transaction Reports form and enter India RG 23A Part I Report in the Name field to submit the report.

Report Parameters:

Organization (Optional)

Enter the organization, you wish to take the RG Report for.

Location (Optional)

Enter a location, you wish to take the RG Report for.

Transaction From / To Date (Required, Default)

If the user wants to take report for a specific period, then he has to specify the period.

Report Headings:

Report headings provide you with general information about the contents of the report. Oracle lists information as given in the report format of RG Registers.

Column Headings:

Sl. No.

Serial Number of the Register for the Organization and Location, selected.

Date

Date of the Transaction seen in the Register.

Description of Inputs received.

Item Description for the Transaction will be seen in the Register.

Quantity Received

Quantity Received for the Transaction will be seen in the Register.

Bill of Entry No. & Date

Fields Receipt Number and Receipt Date are concatenated and printed.

Name & address of manufacturer

PO Vendor’s Name and Address.

Range and Division

Taken from the master data for the particular vendor.

Issued for use in - Chit no. and date

Blank.

Issued for use in - quantity

Issues for Clearance - AR-1 / GP-1 No. & Date

Issues for Clearance - Quantity

Sales Invoice quantity.

Otherwise - Document Id and Date

Otherwise - Quantity

Balance Quantity

Derived as sum (Received quantity - Goods issue quantity - sales invoice quantity - other. document quantity).

Officer’s Initials

Blank

Remarks

India RG 23A Part-II Report

This report provides you with the information that would be required to meet the Duty Register requirements specified under the CENVAT Credit Rules 2004.

This report can be submitted both for Raw Material and Capital Goods. You can also generate the report for a given date range.

Report Submission:

Use the Request Transaction Reports form and enter India RG 23A Part II Report in the Name field to submit the report.

Report Parameters:

Organization (Required, Default)

Enter the organization, you wish to take the RG Report for.

Location (Required, Default

Enter a location, you wish to take the RG Report for.

Register Type (Required, Default)

Select the Register Type here. Select ‘A’ for Raw Material and ‘C’ for Capital Goods

Transaction From Date (Required, Default

Enter the begin date for the report.

Transaction To Date (Required, Default)

Enter the end date for the report.

Report Headings:

Report headings provide you with general information about the contents of the report. Oracle lists information as given in the report format of RG Registers

Column Headings:

Sl. No.

Serial Number is dynamically generated when the reported is submitted.

Date

Date of the Transaction seen in the Register.

Opening Balance

Opening balance for Excise Duty Amount.

Opening Balance Edu. Excise

Opening balance for Education Cess Duty Amount.

Opening Balance Edu. CVD

Opening balance for CVD Education Cess.

ECC Code No of the Supplier

This field displays the ECC Number of the Supplier Site from where the inputs are received.

Range & Division

Duty Credited - Additional Duty

Total Credit Available -

Derived as opening balance + cr_basic_ed + cr_additional_ed + cr_other_ed .

Debit - Document No. & Date

Debit - (Basic + Additional)

Officer’s Initials

Blank.

Receipt Number

This field displays the corresponding Receipt Number.

Closing Balance

Opening Balance + (cr_basic_ed + cr_additional_ed) - (dr_basic_ed + dr_additional_ed) + (cr_other_ed - dr_other_ed).

Important: It is necessary that to run ‘India - RG Period Balances Calculation’ program with the last day of the month preceding the report dates. This program should be scheduled once for every month with the last of the month. If this is not done, the report would end with an error.

India RG 23C Part-I Report

This report gives you the Stock Account of 'Capital Goods' to be used in the manufacture of 'Final Products' and complete Quantitative Details as per format specified by Central Excise Act for an Inventory Organization and its Location. Format and columns of this report is same as specified by the Central Excise Act.

Report Submission:

Use the Request Transaction Reports form and enter India RG23C Part I Report in the Name field to submit the report

Report Parameters:

Organization (Optional)

Enter the organization, you wish to take the RG Report for.

Location (Optional)

Enter a location, you wish to take the RG Report for.

Transaction From/To Date (Required)

If the user wants to take report for a specific period then he has to specify the time periods.

Report Headings:

Report headings provide you with general information about the contents of the report. Oracle lists information as given in the report format of RG Registers.

Sl. No.

Serial Number of the Register for the Organization and Location, selected.

Date of Receipt

Date on which the Capital Goods were received is reported.

Description of Capital goods received.

Description of the Capital Goods received is reported.

Quantity received

Quantity of the goods of the Goods Received against the transaction is reported.

Range and Division

The Range and Division of the Organization where the goods have been received.

Date of Verification

The date on which the Capital Goods were issued to the production and verified.

Issued for Installation- Chit no. and date

Chit Number / Issue slip details through which the Capital Goods are issued along with the date.

Place of Installation

Place of Installation where the Capital Goods were installed in the factory premises.

Date of Installation

The Date on which the Capital Goods were installed.

Date of starting of use

Date on which the Capital Goods are put to use.

Removal of Capital Foods - Quantity

Otherwise - Document ID and Date

Otherwise - Quantity

Balance Quantity

Derived as sum (received_quantity - goods_issue_quantity - sales_invoice_quantity - oth_document_quantity).

Officer’s Initials

Blank.

Folio and Entry No. in part II

Remarks

Remarks as listed in the RG Registers.

India - CENVAT Monthly Return

This report in accordance with the format specified under Rule 7 (5) of CENVAT Credit Rules 2002. This report along with 'India - CENVAT Monthly Abstract' report gives you complete information as required under the rule.

This report can be submitted either for CENVAT credits availed on purchase of Raw Material or on Capital Goods.

Report Submission:

Use the Request Transaction Reports form and enter India - CENVAT Monthly Return in the Name field to submit the report.

Report Parameters:

Organization (Required, Required)

Oracle Financials for India displays the Default Organization (default). Enter the organization, you wish to take the RG Report for.

Location (Required, Default)

Oracle Financials for India displays the Default Location (default). Enter a location, you wish to take the RG Report for.

Register Type (Required, Default)

Select Register Type to print the report for Raw Materials or Capital Goods.

Transaction From Date (Required, Default)

Enter the begin date for the report.

Transaction To Date (Required, Default)

Enter the end date for the report.

Report Details:

Sl. No.

Serial Number of the credit taken. This will start with Sl. No. 1 at the beginning of the financial year and jump by one for each transaction.

Type of Document

System will default the Type of document that has been attached to the concerned Supplier Site. The type of the document is a new field attached to the Additional Supplier Information screen. For each Supplier Site, it is Required that the user needs to enter this information. The standard Document Type that is being widely used in the industry are Invoice, Delivery Challan, Bill of Entry, and Excise Challan.

Number and Date of the Document

This field displays the Identification Number of the Supplier document and date on which CENVAT credit has been taken on the Capital Goods.

Name of the Supplier

This field displays the name of the Supplier from whom the Capital Goods on which CENVAT was claimed was received.

Type of Supplier

An additional field is provided in the Supplier Additional Information screen to capture the type of the Supplier. Standard Supplier Types used in the industry are Manufacturer, Dealer, and Importer .

ECC Number of the Supplier

This field displays the ECC Number of the Supplier Site from where the inputs are received.

Date on which Input/Capital Goods Received

This field displays the Date of Receipt of Goods / Input.

Details of Credit taken

These fields displays the amount of CENVAT credit taken against the transaction.

Description

This field displays the description of the goods received.

Sub heading

This field displays the Tariff heading of the Goods received.

Quantity

This field displays the Quantity of the goods received.

Important: The value is derived by back working from the taxes. Because the taxes are rounded off, this back working might lead to a marginal difference.

India - CENVAT Monthly Abstract

This report forms the second part of the CENVAT Monthly Return Report in the format specified under Rule 7 (5) of CENVAT Credit Rules 2002. This report along with 'India - CENVAT Monthly Return' Report gives you complete information as required under the rule.

Report Submission:

Use the Request Transaction Reports form and enter India - CENVAT Monthly Return - Capital Goods in the Name field to submit the report.

Report Parameters:

Organization

Enter the organization, if you wish to take the India - CENVAT Monthly Return - Capital Goods report.

Location

Enter the location, if you wish to take the India - CENVAT Monthly Return - Capital Goods / Inputs report.

Transaction From/To Date

Enter the range of the dates, if you wish to take the India - CENVAT Monthly Return - Inputs report.

Material Type

Select from the LOV whether you need to run the abstract for Inputs or Capital Goods.

Column Headings:

Opening Balance

This field shows the Opening Balances based on the report parameter.

Credit taken during the month

This field takes into consideration the Total Amount of Credit availed during the period specified in the report parameter.

This field takes into consideration the total amount utilized for payment/debit of duty that is being adjusted to CENVAT credit on inputs/capital goods based on the report parameter.

Closing Balance

This field shows the total of unutilized amount of Credit availed as on a particular date for Inputs/Capital Goods based on the report parameter.

India RG-I Report

This report gives you the Daily Stock Account for Finished Goods, Scrap, Intermediate Products, and By-products as per format specified by Central Excise Act. Report is same as specified by the Central Excise Act.

Report Submission:

Use the Request Transaction Reports form and enter India RG-I Report in the Name field to submit the report.

Report Parameters:

Organization (Required, Default)

Oracle Financials for India displays the Default Organization (default). Enter the organization , you wish to take the RG Report for.

Location (Required, Default)

Oracle Financials for India displays the Default Location (default). Enter a location, you wish to take the RG Report for.

Transaction From/To Date

Oracle Financials for India allows the user to print selectively the transactions from a given date onwards.

Show All Items Stock (Default

Gives flexibility for the user to print all Items transacted during the period or in stock.

Report Headings:

Report headings provide you with general information about the contents of the report. Oracle lists information as given in the report format of RG Registers.

Column Headings:

Date

Transaction date.

Opening Balance

Derived as sum (balance packed + balance loose).

Quantity Manufactured

Will be populated when Finished Good is received.

Total

Derived as Opening Balance + Manufactured Qty.

Removal from factory - on payment of duty - Home Use

Removal from factory - on payment of duty - For export under claim

Removal from factory - without duty - For export under bond

Removal from factory - without duty - To other factories

For Other Purpose - Purpose

For Other Purpose - Quantity

Duty Rate

Excise Duty Rate.

Duty Amount

Excise Duty Amount.

Balance Quantity- In Finishing Room

Derived as Total - for_home_use_pay_ed_qty - for_export_pay_ed_qty - for_export_n_pay_ed_qty - to_other_factory_n_pay_ed_qty - other_purpose_n_pay_ed_qty

Balance Quantity- In Bonded Store

Closing Balance available in bonded store.

Signature of the Assessee / his agent

Blank

Report Order:

Report is printed in the order of Transaction Date applicable for that location and for that organization.

India OSP Pending Dispatch Report

Report Submission:

Use the Submit Requests (INV & PO Modules) form and enter India OSP Pending Dispatch Report in the Name field to submit the report.

Organization (Required)

Enter the organization for which you wish to take the Unapproved OSP Dispatches Report for.

Location (Optional)

Enter the location for which you wish to take the Unapproved OSP dispatches Report for.

Vendor Name (Skip for all)

Oracle Financials for India prints the 57F3 forms for this Vendor only, if you enter a value for this parameter.

Oracle Financials for India prints all the OSP items Unapproved starting with the date you enter for this parameter.

From Date (Optional)

Oracle Financials for India prints all the OSP items Unapproved starting with the Date you enter for this parameter.

To Date (Optional)

Oracle Financials for India prints all the OSP items Unapproved up to the Date you enter for this parameter.

Report Headings:

Report Headings provide you with general information about the contents of the report. Oracle Financials for India prints Organization related information, Report date and Sheet number on all pages, along with report heading on all pages.

Column Headings:

Vendor Name

Name of Vendor to whom the item was sent for further processing.

Work Order Number

Work Order Number of WIP Operation.

Nature of Work

Nature of OSP work to be performed on OSP Item.

57F3 Form Date

Date on which 57F3 form was created.

Item

Name of Item sent out for further processing.

Item description

Description of Item sent out for further processing.

Dispatch Quantity

Quantity of items sent out for further processing.

Excise Duty

Estimated Excise Duty (based on Assessable Value of Item) to be paid for OSP item.

Total

Excise Duty Totals for Vendor, Location, and Organization.

Report Order:

Report is printed in the order of Vendor Name, Due Date, Form Number, and Item description.

India OSP Pending Receipt Report

This report gives you the unapproved 57F4 Receipts in the organization, Location, for a given period of time and a given vendor. The output is listed Work Order Number wise

Report Submission:

Use the Submit Requests (INV & PO Modules) form and enter India OSP Pending Receipts Report in the Name field to submit the report.

Report Parameters:

Organization (Required)

Enter the organization for which you wish to take the Unapproved OSP Receipts Report for.

Location (Optional)

Enter the location for which you wish to take the Unapproved OSP Receipts Report for.

Vendor Name (Skip for all)

Oracle Financials for India prints the 57F3 Forms for this Vendor only, if you enter a value for this parameter.

From Date

Oracle Financials for India prints all the OSP items Unapproved starting with the Date you enter for this parameter.

To Date

Oracle Financials for India prints all the OSP items Unapproved upto the date you enter for this parameter.

Report Headings:

Provides you with general information about the contents of the report. Oracle Financials for India prints Organization related Information, Report Date, and Sheet Number on all pages, along with report heading on all pages.

Column Headings:

Vendor Name

Name of the Vendor to whom the item was sent for further processing.

57F3 Form Number

57F3 Form Number on which the Items were sent.

Form Date

Date of 57F3 Form.

Item Description

Description of Items sent out for further processing.

Despatch Quantity

Quantity of Items sent out for further processing.

Return Quantity

Quantity of Items returned till date.

Pending Quantity

Pending Quantity of Items not yet returned till date.

Duty Amount

Amount of Duty paid on Items sent out.

Due Date

Due Date calculated as ( From date + Expected duration of Processing/Manufacturing.).

Vendor Total Duty Amount

Vendor wise Total Duty Amount.

Location Total Duty

Location wise Total Duty Amount.

Organization Duty Total

Report’s Total Duty Amount for the Organization Chosen.

Report Order:

Report is printed in the order of Vendor Name, Due Date, Form Number, and Item Description.

India OSP Stock Register

This report is an extract of all 57F4 transactions in an Inventory Organization and Location for a given period of time and the format of the report is as specified by the Central Excise Act.

Report Submission:

Use the Submit Requests (INV and PO Modules) form and enter India OSP Stock Register in the Name field to submit the report.

Report Parameters:

Organization (Required)

Enter the organization for which you wish to take the 57F4 Register Report for.

Location (Optional)

Enter the location for which you wish to take the 57F4 Register Report for.

From Date (Optional)

Oracle Financials for India prints all entries in the register starting with the date you enter for this parameter.

To Date (Optional)

Oracle Financials for India prints all entries in the register up to the date you enter for this parameter.

Report Headings:

Report headings provide you with general information about the contents of the report. Oracle lists Organization Information based on user input.

Column Headings:

Description of Goods

Description of OSP Item.

Tariff Classification

Excise Item Tariff Classification.

Dispatch Quantity

Quantity of Item dispatched.

Identification marks, if any

Identification marks of OSP item, if any.

Premises/Factory to which removed

Premises/Factory to which OSP items were sent.

Challan No./Challan date

Date and Number of 57F4 Challan.

Nature of Processing required

Nature of Processing required for the OSP Item.

Rate and Amount of Credit Reversal

Rate and Amount of Excise Duty paid on removal of OSP items.

Reg. Name, Sl. No., & Date of Dr./Initials of Mfr./Supplier

Reg. Name, Sl No. and Date of Debit entry in the Excise Register.

Receipt Date / Clearance Date from Processor

Date of Receipt of Items in the factory.

Received Quantity/Unit of Measure

Quantity of Items Received till date.

Pending Quantity

Pending quantity of OSP item.

RG23A Sl. No, Credit Date and Re-credit Amount taken

Sl. No. , Date and Amount of Re-credit taken on Receipt of items.

Report Order:

Report is printed in the order of date of issue for the selected organization.

India Outside Processing Challan

This report gives you the challan required under rule 4 (5) of The Central Excise Rules. The output is listed Challan number wise.

Use OSP Form Report to print Challan for material sent for outside processing. The report, is divided into three parts. Data for PART I is populated by the system, during printing, while PART II and PART III data are to be manually filled up as and when required.

Report Submission:

Use the Submit Requests (INV & PO Modules) form and enter India Outside Processing Challan in the Name field to submit the report.

Report Parameters:

Organization Name (Required)

Oracle Financials for India displays the 57F4 Forms for the organization you enter for this parameter.

Location (Required)

Oracle Financials for India displays the 57F4 Forms for the location you enter for this parameter.

Fin Year (Required)

Oracle Financials for India displays the 57F4 Forms for the financial year you enter for this parameter.

Issue Date From (Optional)

Oracle Financials for India prints all the 57F4 Forms starting from the date you enter for this parameter.

Issue Date to (Optional)

Oracle Financials for India prints all the 57F4 Forms up to the date you enter for this parameter.

Form Nos. From (Optional)

Oracle Financials for India prints all the 57F4 Forms starting with the number you enter for this parameter.

Form Nos. To (Optional)

Oracle Financials for India prints all the 57F4 Forms up to the number you enter for this parameter.

Vendor (Optional)

Oracle Financials for India prints the 57F4 Forms for this vendor only, if you enter a value for this parameter.

Place (Optional)

Oracle Financials for India prints this name in Place field of 57F4 Forms.

Name of the Signee (Optional)

Oracle Financials for India prints this name in Signature of Manufacturer/Authorized Signatory field of 57F4 Forms.

Report Headings:

Report headings provide you with general information about the contents of the report. Oracle Financials for India prints OSP Challan Number, Vendor Name, and Sheet Number of Certificate on all pages, along with Report Heading.

Column Headings:

Description

Description of Item being dispatched for outside processing.

Identification marks and No. if any

Identification marks and No. if any for the item.

Tariff Classification

Tariff Classification of the item.

Quantity

Quantity and Unit of Measure of item being dispatched.

Unit assessable value

Assessable Value of item.

Excise Duty Reversal Rate

Excise Duty Reversal Rate applicable to item .

Excise duty reversal amount

Excise Duty Reversal Amount that can be claimed for the item.

Nature of Processing / Manufacturing

Nature of Processing / Manufacturing to be done on the item outside the factory.

Serial Number of Debit Entry in PLA and Date

Serial Number of Debit Entry in PLA and Date for Excise Amount Payment for the Form.

Factory/Place of Processing/manufacturing

Factory/Place where the items are being sent for further Processing / Manufacturing.

Date and Time of Issue

Date and Time of Issue of Items for outside processing.

Expected Duration of Processing/Manufacturing

Expected Duration of Processing/Manufacturing.

Report Order:

Report is printed in the order of 57F4 Challan Forms.