This chapter covers the following topics:
You can create a Sales Order by navigating through the India Local Sales Order window. This enables defaulting and calculation of Localization Taxes. The defaulting is based on the three-way defaulting logic followed for India Localization i.e., based on Customer, Customer Site or Item Class. Alternatively, you can create a Sales Order from Internal Requisitions, using Import Orders feature. The localization taxes will flow to Fulfilled Orders India Localization. For the Deliveries created from India Local Sales Orders, taxes will flow to the same.
The Localization Tax information flows into Shipping Localized screen on completion of the packing, shipping and Inventory and Order Management Interface. This information flows to AR Transactions created based on such deliveries. The same information flows to Transactions after running the Auto Invoice program.
The Sales Order India Localized functionality caters to your tax calculation needs required for a Sales Order Transaction. You can:
Define Item category lists and attach the same to Customer and Customer Sites. Alternatively, an Item Class can be attached to a Tax Category. This would enable third level of Tax defaulting, which would apply only when the Tax Information does not default from Customer and Customer Site. This would be the basis for taxes defaulting to Transactions.
Assign Assessable Prices to Items. This price would be the basis for Excise Duty / VAT Taxes Calculation. The Assessable Price Lists can be attached selectively to Customer Sites.
Create Sales Orders by navigating through India Local Sales Orders window. This would automate tax defaulting and calculation.
Modify defaulted tax lines and add to the existing list.
Get overview information for Sales Order Lines, without localization taxes.
Create Sales Order for Excise exempted sales e.g., CT2, CT3. Relevant Certificate information can be recorded.
Create Sales Order for VAT Exempted Sales Order like Vat Exemption Item, Export, Inter State Sale, Sale to Specified parties, Transfer.
Automate calculation, recording and accounting of CENVAT Recovery (as specified under Rule 6 of The CENVAT Credit Rules 2002) for excise-exempted sale.
The Sales Order displays Assessable Value, which forms the base for calculation of Excise Duty.
The Sales Order also displays the VAT Assessable Value, which forms the base for calculation of VAT taxes.
Defaulting Taxes to India Local Sales Orders
You can use Localization taxes while creating a Sales Order in the Order Management. These taxes can be defaulted based on the Tax Defaulting Rules. The automatic Tax Defaulting is based on Item Category assigned to the Customer, Customer Site or based on the Item Class assigned to the Tax Category.
Tax Base Amount
You can define precedence logic to calculate Tax Base Amount on which the Tax Rate is applied. The Tax Base Amount can either be the line amount or line amount including other taxes calculated for the transaction.
Important: No precedence logic and tax rates are available for adhoc taxes.
Defaulting Assessable Value to India Local Sales Orders
You can use an Assessable Value that is different from the Sales Price while creating a Sales Order in the Order Management. This Assessable Price can be defaulted based on the Tax Defaulting Rules. The automatic defaulting is based on Price List assigned to the Customer, Customer Site or null Site.
Important: The Assessable Value is a display only field and cannot be edited by user on Sales Order. It is only controlled through Price List setups and Price List attachments.
Manual Changes to Defaulted Taxes to India Local Sales Orders
The Taxes defaulted can be changed manually, if required.
Tax Line can be deleted only when there is no dependent tax line.
You must Apply and Save after deleting defaulted taxes and before attaching New Taxes.
Record Excise Exemptions
You can choose the Exemption Type applicable to the Sales Order by selecting the Excise Exempted check box provided at the line level. This changes the Excise Value of that line to zero.
Record VAT Exemptions
You can choose the VAT Exemption Type applicable to the Sales Order. To do this, you need to select VAT Exemption Type, Date and Ref No at Header. This gets defaulted on all lines and changes the VAT value of all lines to zero.
If you require partial VAT Exemption viz., on some lines only, you need to deselect the VAT Exemption flag. You can also have a different type of VAT Exemption at line level.
CENVAT Recovery against Excise Exemptions
You can set up CENVAT Recovery % in the Organization Additional Information Screen in CENVAT Recovery % field using India Local Inventory Responsibility which will ensure CENVAT Recovery under Rule 6 of The CENVAT Credit Rules 2002 for the above Excise Exempted Transactions.
Splitting of Sales Order Lines
Any Splitting lines in the base Sales Order also split lines in India Local Sales Order. The Tax lines are then recalculated based on the revised line quantity.
Changes in Sales Order Lines
Changes made to Quantity in Base Sales Orders are automatically reflected in the Sales Order India Localization. Lines deleted from base order also get deleted from India Local Sales Order.
Cancellation in Sales Order Lines
A line cancelled in the base Sales Order changes the Quantity in Localization screen to zero.
Copying of Sales Orders
A Sales Order created by navigating through India Local Sales Order screen can be copied using the Copy Order feature. This will result in taxes flowing to Localization for the copied Order. While coping Order, if there is any change in the Assessable Price with respect to source Order line, then it results in recalculation of the taxes.
Important: Copy Sales Order feature can be used to create a RMA Order. An RMA Order taxes is based on shipping taxes and hence to avoid data inconsistency issues in localization tables, Copying of Sales Order is not possible unless such Order is already shipped & data is available in Localization shipping tables.
Localization does not currently allow copy of RMA Order to standard Order or existing RMA Order to new RMA Order.
Assessable Price Recalculation
Excise duties attached to the Order lines can be recalculated whenever there are changes in assessable price of items. This is helpful at the time of Budget/changes in Excise statutes. For further details refer Assessable price recalculation provided under reports.
Line Level Query in India Local Sales Order
You can now query for lines in Sales Orders India Localization screen once the Sales Order is queried. This feature would be helpful to find the lines in case where the item name is above 25 characters long or Sales Order has large number of lines.
Auto Query of India Local Sales Order
Clicking the Open Button on the India Local Sales Order displays the Base Sales Order Form to create an Order.
When you fill the base Sales Order form and save it, the details of the transaction are auto queried and displayed in the India Local Sales Order form. To view the details, navigate to the India Local Sales Order form. You can also query an existing Order in the Localized Sales Order form.
If you navigated away to multiple forms, Auto query does not work and you must click refresh to view the localization screen with requisite details.
Note: For details on generating VAT invoices for non-shippable items, refer to Generating VAT Invoices in the Oracle Financials for India Implementation Manual.
You can make changes to localized freight in the Order Management Module. You will also have a facility to add Localization Freight manually at this stage.
This information flows into Shipping Localized screen on completion of the Picking, Shipping and Inventory and Order Management Interface. Taxes entered in Sales Order cannot be changed at this stage. However, you can change or add freight details at this stage. The same information flows to AR Transactions after running the Auto Invoice program.
The Fulfilled Orders India Localized functionality lets you satisfy all your needs related to Freight addition required for a Shipment Transaction. You can:
Query a Fulfilled Order Transaction using Delivery Name, Order Number, Customer etc to find localization related details.
Add or change Freight type of Tax at this stage.
View Tax lines attached to each line of delivery.
On Completion of the ‘India - Excise Invoice Generation’ you can also view the Excise Invoice Number that has been generated against this delivery.
Query based on the Excise Invoice Number generated.
Query based on items. Option to view all Items in the delivery or only Items whose name has been entered in the query.
View details of the Duty paying Register that has been hit by the delivery transaction.
Enter AR3A Form Number and Date for Excise Exempted transactions.
Facility to Add Freight in Fulfilled Orders India localized
You have an option to change or add new freight lines using the Fulfilled Orders Localized screen.
Important: All the features mentioned here involving changes to transaction has to be completed before Auto Invoice happens, else the same will not flow to the AR Transaction.
Record AR3A Form Number and Date
You can record AR3A form Number and Date against individual shipment line for Excise-Exempted transactions for the purpose for tracking.
Reports
Receivables generates these reports for India:
India - Debtors Ledger Report - Lists all the transactions with the Customer to arrive at the net liability for the Customer. You can use this report to get Debtors Sub-Ledger.
India - Commercial Invoice for OM Report - This Report gives you the Commercial Invoice with Excise Invoice Number, Excise Details for a Sales Order against each delivery.
India - Forecast Excise Amount in RG Registers - Gives the Forecast for CENVAT and PLA Payments for a given Organization, Location Combination from As of Date to Entered Date.
Users can create RMA Orders with localized taxes in the Order Management. The taxes would be calculated for the RMA lines, based on the Original Sales Order.
The RMA Order India Localized functionality allows the user to satisfy all requirements related to Tax calculation required for a RMA Transaction. Users can create an RMA Order by giving:
Reference to the Original Sales Order
Reference to the Invoice
Without giving any reference.
Return Orders without Excise Component.
Reference to the delivery line shipped
Defaulting Taxes to India Local RMA Orders
You have an option to use Localization taxes while creating a return sale Order in the Order Management. These taxes can either be defaulted based on the Tax Defaulting Rules or can be attached manually. The automatic tax defaulting would be based Item Category assigned to the Customer, Customer Site or based on the Item Class assigned to the Tax Category. This is only applicable for the RMA Order created without reference and the reference is filled as ‘Legacy’. For a RMA Order created with reference taxes are defaulted based on the original delivery and cannot be changed.
Auto picking of Delivery Detail ID in India Local RMA Orders
Whenever a RMA Sales Order is created with reference, Localization taxes would be based on the shipment taxes and hence required entry of Delivery Detail ID. There is no need to search this delivery detail id, which would make the process tedious. On navigating to Localization Screen, the same gets automatically populated if the Sales Order reference is given.
Returns without Excise
Whenever a return takes place beyond the stipulated period by Excise Authorities, you are prevented from claiming CENVAT benefit on the returned goods viz., when returns are made beyond 180 days. Under such circumstances, many a times, it is necessary that the Credit Memo that is raised for such return be raised for the base amount without passing on the benefit of Excise Duty. For such kind of transactions, the days within which if return is made, the Excise to be allowed has to be mentioned in the Organization Additional Information in Excise Return Days field. This ensures that when any RMA is made beyond such stipulated period, the Credit Memo raised will be net of Excise.
RMA without Sales Tax
Whenever a return takes place beyond the stipulated period by Sales Tax Authorities, you are prevented from claiming the same in your Sales Tax Returns. Under such circumstances, many a times, it is necessary that the Credit Memo that is raised for such return be raised for the base amount without passing on the benefit of Sales Tax. For such kind of transactions, the days within which if RMA is made, the Sales Tax to be allowed has to be mentioned in the Organization Additional Information Sales Tax Return Days field. This ensures that when any RMA is made beyond such stipulated period, the Credit Memo raised will be net of Sales Tax.
Material Clearance without payment of duty under AR3A needs to be tracked for receipt of Re-warehousing Certificate. AR3A Receipt Tracking feature of Oracle Financials for India can be used to meet this requirement. All clearances under Excise Exemptions is recorded and on receipt of the authenticated document; the Receipt Date can be recorded. The data thus collected can be used to monitor the Rewarehousing Certificates that need to be received from Customers at any point of time.
The AR3A Receipt Tracking functionality allows user AR3A forms due from Customers. Users can:
Track AR3A Forms to be received from the Customers. You can enter the Date on which the Form is received.
Generate a Report to view the AR3A forms pending from each Customer.
India - AR3A Status Report lists all exempted sales transactions, while an Acknowledged AR3A form is pending from Customer.
India Local Order Management requires the following concurrent programs to be run:
This is a mandatory concurrent program, if you are using Excise Type of localization taxes, which generates Excise invoice Number against delivery and also hits Excise registers based on the Delivery ID (optional). You must schedule it to run after Inventory Interface and Order Management Interface and prior to AutoInvoice. This report does not generate any printable output.
This concurrent needs to be setup as incompatible to itself. If the same is not done and multiple users run it with blank Delivery_id, it would result in skipping Excise Invoice Numbers or alternatively hitting the Excise Register multiple times for the same delivery.
This concurrent is expected to be scheduled with blank Delivery id, which would pick and process all available deliveries. This is to be run with Delivery_id for specific cases where debug log is required for any problem reporting.
In case the users run it with delivery_id as a part of the process, then the concurrent needs to be scheduled to run atleast once a day without Delivery_id to ensure that any records skipped get Excise Invoice Numbers for the same day. Not doing this will result in sequencing issues when compared to Excise Invoice Dates.
The concurrent will process only those deliveries, which are OM interfaced and Inventory Interfaced.
This concurrent is for generating Excise Invoice Number and Accounting thereof. There is no rdf attached to the same and hence this is not supposed to generate any output.
This concurrent needs to be run prior to Auto Invoice import if the Excise Invoice Number is required to be seen in Localization AR tables.
This is an optional concurrent program that enables you to recalculate Excise Duty attached to Unshipped Orders, if there is a change in the assessable value of items. Excise Duty recalculation is done for those Unshipped Orders that satisfy the input criteria. This report does not generate any printable output. You can use this program to recalculate the Excise Duty and all dependent taxes on Open Sales Orders. The Excise Duty is recalculated to reflect the latest Assessable Prices applicable to the items included in the transaction. Using this feature, you can eliminate manual effort required to update all Open Sales Orders to reflect changes in Assessable Prices.
This concurrent can be invoked through India Local Order Management > Reports, Request > Single Request > India > Excise Duty Recalculation
| Field Description | Type | Action | Description |
|---|---|---|---|
| Start Order | Required | PICK | Enter the Sales Order from which you would like to effect Tax Changes |
| End Order | Required | PICK | Enter the Sales Order which you would like to take as the last document on which the change has to be effected. |
| Order Type | Required | PICK | Choose one of the Order Types from the list |
| Organization Id | Required | PICK | Choose one of the Organizations from the list. |
|
Important: On completion of the request the selected Sales Orders, provided they are open and have an Assessable Price applicable, are updated with the revised Tax Amounts |
All Accounting events will be accounted when the Base transaction line is being accounted. The ‘India Service Tax Processing’ Concurrent program processes the recovery Accounting events. This program must be scheduled at regular intervals. At each run, the program would create Accounting and Service Tax Repository entries for all eligible transactions.
This concurrent can be invoked through India Local Receivables > Reports, Request > Single Request > India > Service Tax Processing.
| Field Description | Type | Action | Description |
|---|---|---|---|
| Regime | (Required) | PICK HELP EDIT |
Select the Regime you have defined for Service Tax. |
| Tax Registration Number | (Required) | PICK HELP EDIT |
Select the Registration Number here. Organizations are logically grouped by Tax Registration Number. On selecting a Registration Number, all eligible transactions created in the related group of Organizations would be processed. |
| Transaction From Date | (Required) | PICK HELP EDIT |
Specify Transaction From Date here. |
| Organization Name | (Required) | PICK HELP EDIT |
Specify Inventory Organization here. |
The India - VAT Invoice Generation / Accounting concurrent program handles generation of VAT Invoice and passes requisite VAT Accounting entries for VAT type of taxes from Order Management. This program captures Value Added Tax localization taxes in Shipments and inserts VAT Invoice Number in India Local Shipment Table and Entries in GL interface. You have to schedule the concurrent to submit the request at suitable intervals.
Note: VAT Invoice Number is now supported for non shippable items in both Standalone AR Invoice and Sales Orders, if the Item is classified as VAT Item in Oracle Financials for India and defined as Non Shippable Item in the base inventory. For detailed information, please refer to Generating VAT Invoices in the Oracle financials for India Implementation Manual.
This concurrent can be invoked through India Local Order Management > Reports, Request > Single Request > Select ‘India - VAT Invoice Generation / Accounting > Schedule
Important: Please make it mandatory to Schedule this concurrent program.
The field wise detail description of the screen and its feature are described below for ready reference.
| Field Description | Type | Action | Description |
|---|---|---|---|
| Regime | (Required) | PICK EDIT |
You will have to pick the Regime here. Currently only ‘VAT’ (Value Added Tax) is available here. |
| Tax Registration No. | (Required) | PICK EDIT |
You will have to pick the Tax Registration Number that has been defined for VAT Regime here. This LOV will display all Registration Numbers defined by you for VAT Regime. |
| Organization | (Optional) | PICK EDIT |
You can choose the Organization here if you want to run the program for a specific Organization. |
| Location | (Optional) | PICK EDIT |
This will be enabled only if you select an Organization and you can choose the Location here if you want to run the program for a specific Location. |
| Delivery From | (Optional) | PICK EDIT |
This will be enabled only if you select an Organization and Location and you can choose the from Delivery id here if you want to run the program for a specific range of delivery ids. |
| Delivery To | (Optional) | PICK EDIT |
This will be enabled only if you select an Organization and Location and you can choose the end Delivery id here if you want to run the program for a specific range of delivery id’s. |
| Transactions from Date | (Required) | EDIT | Enter Transaction Date Range here. All transactions having transaction date between this range will be picked up for processing. |
| Transactions to Date | (Required) | EDIT | Enter Transaction Date range here. All transactions having transaction date between this range will be picked up for processing |
| Action | (Required) | PICK EDIT |
This is the type of action, which is expected. The program has three options 1) “GENERATE INVOICE NO” which will only generate VAT invoices for the selected Regime, 2) “PROCESS ACCOUNTING” which will make repository entries and pass GL entries for the selected Regime. 3) “PROCESS ALL” which will result in both generation of VAT Invoice and pass GL entries. |
| Generate Single Invoice | (Optional) | PICK EDIT |
You have an option of running the concurrent with “Yes” for this parameter which will then group delivery ids for each Customer and create a single VAT Invoice for each Customer instead of one VAT Invoice per delivery. |
| Default Invoice Date | (Optional) | EDIT | Using this option you can enter a Date for which you want the VAT Invoice Date and Accounting to happen. This is useful mainly for cases where shipment happens as say 11:45 pm on Month end & you are running the concurrent during the next month but want the accounting to happen on a date different from current date. This will however not impact the number series & hence care should be taken to process all pending invoices prior to running the concurrent for the next period. |
| Debug Switch | (Required) | PICK EDIT |
Default value of this parameter is “No” but the same can be changed to “Yes” to see the debug messages when required. |
This program is a mandatory program to be run for generating VAT Invoice Number and generation of Accounting Entries.
This concurrent will show the following error “Excise Invoice generation program has not been run for various reasons” or “Excise Invoice Generation is not generated yet for this Delivery. Please run the Excise Invoice Number generation Number for delivery: ” when you have setup ‘Same Invoice No for Excise and VAT Regimes’ as ‘Y’ for this Registration Number and try to run this program prior to running Excise Invoice generation or if the Excise Invoice Generation has errored out for this delivery.
This concurrent will show the following error “Document sequencing setup not done at Registration number level” if you try to run the same without defining the Document sequencing for the given Registration Number.
This concurrent will show the following error “Document Numbers are exhausted. Please set the End Number to a larger value” when the last Number as setup in document sequencing has been reached & hence cannot generate a VAT Invoice Number.
When VAT Invoice Number generation happens after the AR Invoice is created, localization AR table does not have VAT Invoice Number imported from localized shipping tables. Hence care should be taken to run the VAT Invoice Generation program prior to creation of AR Invoice.
When this concurrent is run with parameter of ‘GENERATE INVOICE NO’ Accounting Entries are not passed.
Running the concurrent after Booking order will result in picking only Non-shippable lines that are fulfilled and if the concurrent is run after shipment it will result in a single number for Shippable & non shippable items.
RMA for a non-shippable line results in updating of Recovered Account directly, instead of reversing the original entry.
For detailed information, refer to India Local Advanced Pricing chapter in the Oracle Financials for India User manual.
This Section elaborates on the transactions for which you can default and calculate the Localization taxes. This would be possible only when you create the transactions navigating through the localization windows.
In Oracle Financials for India, the Sales Orders are designed handle tax impacts on Sales Orders and Sales Returns.
In order to use India Local taxes, you need to navigate to the open standard application Sales Order screen by navigating through Sales Order (Localized) screen. You need to complete Standard Applications Order form. On saving the Sales Order in the standard applications, data required for the localized Sales Order will get created. Based on the tax defaulting set ups, the localization taxes will get calculated automatically. For defaulting the taxes are depended on the tax defaulting set up hierarchy mapped for localization taxes. Taxes can get defaulted based on the association of Item Category to the Customer Sites or based on the Tax Category set up. You have an option to Delete or Add localization taxes if you need to modify the defaulted taxes. Deletion of taxes will be restricted if the taxes intended for deletion has an impact on the tax precedence calculation.
The India Local Sales Order is a view form, shows the Item, UOM, Quantity Ordered, Item Category List, Unit Price, Order Line amount, which are defaulted from Standard Apps Sales Order form. However, you can change the defaulted Service Type before closing or shipment of the order.
Tax Amount, Line Amount and Assessable Value will be defaulted and are also displayed but you can modify that in the India Local Tax Details form through Taxes.
You need to use the same screen for creating Sales Orders and RMA Orders.
If the Customer has a Letter of Credit and shipment against such Order is to be matched against a Letter of Credit, then the Order must be marked as LC enabled by ticking on the LC Flag.
In Oracle Financials for India, navigate to the India Local Sales Order window from India Local Order Management > Orders , Returns > Orders/returns (Localized)
| Field Description | Type | Action | Description |
|---|---|---|---|
| Header level | |||
| Customer Name/Number | (Displayed) | The Customer Name and the Number will be displayed here from Standard Apps Sales Order Form. | |
| Order Type | (Displayed) | The Order Type selected in the Standard Apps Sales Order Form will be displayed here. | |
| Order Number | (Displayed) | The Order Number allotted in the Standard Apps Sales Order Form will be displayed here. | |
| Order Date | (Displayed) | The Order Date of the Standard Apps Sales Order Form will be displayed here. | |
| Ship To Location | (Displayed) | Ship To Location Id of the Customer will be displayed here from Standard Apps Sales Order Form. | |
| Order Line total | (Displayed) | The Order Line Amount appearing in the Standard Apps Sales Order Form in will be displayed here. | |
| Tax total | (Displayed) | This field shows the total of the Localization taxes worked out for the Sales Order/Sales Returns Order. | |
| Excise Exempt Type | (Optional) | If you need to carry out an exempted transaction, the Exemption Type needs to be picked up in this field. For transactions on payment of duty, this field need to be left as null. Whenever you pick for an Excise-Exempted Transaction you need to enable the Excise-Exempted Flag in the line level. The excise exemption options are: CT2 IND This option needs to be mapped to the requirements under Rule 20 of the Central Excise Rules. This Amount will not be accounted in the Receivable. CT2 OTH IND In case the Customer needs to be Debited for the Excise Duty under of the Central Excise Rules, this option need to be used. As per the provisions of the above rule, Duty debited should not be debited to the Customer. CT3 IND. This option needs to be picked up for clearance of goods to 100% Export Oriented Units without payment of Duty against CT 3 Certificate. Excise Exempted Certificate IND / Excise Exempted Certificate - Others - IND This option may be used for transactions without payment of duty |
|
| LC Flag | (Optional) | CHECK BOX | This field should be ticked for marking the Order as a LC enabled Order. |
| Field Description | Type | Action | Description |
|---|---|---|---|
| Exemption Ref. No. | (Required/Optional) | You can use this field to input the details of the Document/Transaction on which Exemption is claimed from payment of Duty. | |
| Excise Exempt date | (Required/Optional) | You need to enter date CT2 Form, CT3 Form, Excise Exemption Certificate respectively. | |
| VAT Exemption Type | (Optional) | If you need to carry out an VAT Exempted Transaction, the Exemption Type needs to be picked up in this field. For Transactions where VAT is payable, this field need to be left as null. Whenever you pick for an VAT Exempted transaction, all the lines get the VAT exempted flag and the VAT Exemption type defaulted. If for any line, VAT Exemption is not applicable, then you can uncheck the VAT Exemption for such line. The VAT Exemption types are:
|
|
| VAT Exemption Date | (Required/Optional) | This field becomes required when VAT Exemption Type is selected. | |
| VAT Exemption Refno | (Required/Optional) | This field becomes required when VAT Exemption Type is selected. | |
| Order Total | (Displayed) | The Total Order Amount including Order Line Amount and the Tax Amount for all the Items in an Order will be displayed here. | |
| Line level | |||
| Line Number | (Displayed) | The Line Number appearing in the Standard Apps Sales Order Form will be displayed here. | |
| Shipment Line Number | (Displayed) | The Shipment Line Number appearing in the Standard Apps Sales Order Form in will be displayed here. | |
| Item | (Displayed) | The Item selected in the Standard Apps Sales Order Form for a line will be displayed here. | |
| Item Description | (Displayed) | The description of the item Standard Apps Sales Order Form for a line will be displayed here. | |
| UOM | (Displayed) | The UOM for the above Item appearing in the Standard Apps Sales Order Form in will be displayed here. | |
| Quantity | (Displayed) | The Quantity entered in the Standard Apps Sales Order Form for a line in will be displayed here. | |
| Tax Category | (Displayed) | The Tax Category associated to the above item in the Item Category List will be displayed here. | |
| Unit Price | (Displayed) | The Unit Price of the Item will be displayed here. | |
| Assessable Value | (Displayed) | The Assessable Price as defined in the system for this Item will be displayed here. | |
| Extended Price | (Displayed) | Extended Amount is the multiplication of Quantity and Unit price for a item appearing in a line. | |
| Tax Amount | (Displayed) | Tax Amount for a item in a line is displayed here. If you modify the tax lines, then the modified Tax Amount for a item from the India Local Tax details form will be displayed here. | |
| Line Amount | (Displayed) | The Line Amount is the total of Extended Amount and the Tax Amount for a line. | |
| Excise Exempted | CHECK BOX | If a Line Item is exempted from Excise Duty, then you need to enable this Flag. This is enabled only if you select an Excise Exempted Transaction. | |
| VAT Exemption Flag | CHECK BOX | Once at header level a Order is marked as VAT Exempt, this check box will get checked. If any particular line is not supposed to be VAT Exempt, the box should be unchecked. | |
| VAT Exemption Type | (Optional) | If you need to carry out an VAT Exempted Transaction, the Exemption Type needs to be picked up in this field. For Transactions where VAT is payable, this field need to be left as null. Whenever you pick for an VAT exempted transaction, all the lines get the VAT Exempted flag and the VAT Exemption type defaulted. If for any line, VAT Exemption is not applicable, then you can uncheck the VAT exemption for such line. The VAT Exemption types are:
|
|
| VAT Exemption Date | (Required/Optional) | This field becomes required when VAT Exemption Type is selected. | |
| VAT Exemption Refno | (Required/Optional) | This field becomes required when VAT Exemption Type is selected. | |
| Refno | (Displayed) | The reference number of the item on the sales order | |
| [ ] | (Optional) | EDIT | Enter line-specific additional detail and Save. |
Important: The Sales Order will display following message when for any line the Tax Setup is not made and as a result does not have taxes. This is useful mainly to ensure that all the items entered in the Sales Order have appropriate tax setup.
India Local Tax Details screen displays Taxes for the current line in the Sales Order- Localized screen. All the Taxes related to that Sales Order line could be viewed by clicking the Taxes Button. You can view the Taxes defaulted for the Item and have an option to Update/Add/Delete the taxes defaulted. If you make some changes in the defaulted taxes, you need to click the apply button to make the tax modifications effective. After applying the Tax modifications, you need to save the record.
You can check the Tax Name, Tax Type, Tax Rates, Unit of Measurement, Precedence logic for calculation of taxes and the taxes calculated for each line item. No precedence logic and tax rates will be available for an adhoc type of tax.
In Oracle Financials for India, navigate to the India Local Tax Details window from India Local Order Management > Orders > Returns > Sales Order (Localized) > Taxes
All the above fields are displayed as per the taxes defined in the window for an item associated with a respective customer.
Important: System will show the following message & open the tax window in display mode based on status of the Sales Order line.
Similarly Taxes will be shown in a display mode when a Sales Order line status is reflected as ‘SHIPPED’. Please refer the Alert.
In any event of data inconsistency where the taxes in the above tax window do not match with the taxes as displayed in the India Local Sales Order the base shipment will be stopped with the following message:
“ ORA-20405 - Taxes are not matching in JA_IN_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID”
Under this condition, Query the Sale Order & open the above tax window. Correct the tax lines & then carry out Shipment.
When deleting defaulted taxes, you need to click on Apply and Save to save the deletions prior to adding new taxes. No doing so will result in deletion of newly added taxes as well.
In Oracle Financials for India, the localized information of the Sales Return Order can be viewed from the India Local Sales Order screen and the fields are discussed in earlier. You need to click the return tab region to view the tax related information/localized item information pertaining to a Sales Return Order.
Taxes on Sales Return Order appears as default and displayed in read only mode when the Return corresponds to a delivery detail id. The Tax details are opened in editable mode only when such Return is made without reference and taxes are based on the setup definitions.
The Screen can be invoked through India Local Order Management > Orders, Returns > Sales Order (Localized) > Return Tab
Line Level Details :
| Field Description | Type | Action | Description |
|---|---|---|---|
| Line Number | (Displayed) | The Line Number appearing in the Standard Apps Sales Order Form will be displayed here. | |
| Delivery Detail id | (Required) | The Delivery Detail id against which this RMA Line is being entered. Taxes from Shipment are supposed to be based on the delivery Detail id entered here. | |
| Item | (Displayed) | The Item selected in the Standard Apps Sales Order Form for a line will be displayed here. | |
| Item Description | (Displayed) | description of the item in the Standard Apps Sales Order Form for a line will be displayed here. | |
| UOM | (Displayed) | The UOM for the above Item appearing in the Standard Apps Sales Order Form in will be displayed here. | |
| Quantity | (Displayed) | The Quantity entered in the Standard Apps Sales Order Form for a line in will be displayed here. | |
| Unit Price | (Displayed) | The Unit Price of the Item will be displayed here. | |
| Assessable Value | (Displayed) | The Assessable Price as defined in the system for this Item will be displayed here. | |
| Line Amount | (Displayed) | Line Amount is the multiplication of Quantity and Unit Price for a Item appearing in a line. | |
| Service Type | (Displayed) | The Service Type entered in the Standard Apps Sales Order Form for a line in will be displayed here. | |
| Allow Excise Tax | CHECK BOX | Unchecking this would mean that the Credit Note generated against such RMA Order should be without Excise Duty | |
| Allow Sales Tax | CHECK BOX | Unchecking this would mean that the Credit Note generated against such RMA Order should be without Sales Tax | |
| [ ] | (Optional) | EDIT | Enter line-specific additional detail and Save. |
RMA Receipts should be created using the new screen (common for PO Receipts and RMA Receipts). You should navigate from this screen to the base receiving screen and complete the RMA receipt transaction. You should capture additional details related to the receipt, such as RMA Type, Excise Invoice details etc. in the India Localization screen.
The user has the facility to use the “Populate Defaults” feature. This feature allows the users to populate same Excise Invoice number and date for multiple lines.
Localization will create entries depending on Return Type.
| Return Type | Effect in RG Registers and accounting |
|---|---|
| Production Input | Update Register for Quantity depending on Item Class. Update RG 23 A part II information CENVAT Flag Is Checked and corresponding accounting are passed This Type need to be used by units who will be using the Sales Returns as their Raw Materials. For e.g., Foundry Units, where a casting is returned as defective due to air crack, the defect cannot be cured, but the defective casting can be recycled. For this type of transactions, the Organization needs to file declarations and get the consent/acknowledgment from the Local Excise Authorities. |
| Return Under 173L | This Option is no Longer valid due to changes in Excise Laws. |
| Scrapped | No RG Register update will be made. Excise Expenses account will be debited for Excise Amount. |
| FG Return | No RG Register update will be made. Excise Expenses account will be debited for Excise Amount. |
Following are the Accounting entries passed based on the Return type.
RMA Receipts considered as ‘Production Input’
CENVAT Credit For Excise and CVD Taxes
| Account | Debit | Credit |
|---|---|---|
| CENVAT A/c | Tax Amount | |
| Excise Paid Payable Account | Tax Amount |
RMA Receipts considered as ‘Finished Goods Return’
Localization accounting entry for Excise Tax treatment
| Account | Debit | Credit |
|---|---|---|
| Excise Expense a/c | Excise Amount | |
| Excise Paid Payable Account | Excise Amount |
Excise duty paid will be written off as Excise expense Account.
RMA Receipts considered as ‘Scrap’
| Account | Debit | Credit |
|---|---|---|
| Scrap Cost a/c | Item cost | |
| Sub Inventory a/c | Item cost |
Localization accounting entry for Excise Tax treatment
| Account | Debit | Credit |
|---|---|---|
| Excise Expense a/c | Excise Amount | |
| Excise Paid Payable Account | Excise Amount |
(Excise Duty Paid will be written off as an expense account)
The following are the possible scenario in the case of Customer Return for a Trading Item in a Trading Organization
Transaction/Description
RMA Receipts - The goods are totally damaged and the Customer is not looking for any replacement. RG23D- Receipts entry will be passed for the Rejected Qty. Ref. Document: The Customer Invoice for returning the goods.
RMA Receipts - Customer is looking for Replacement. No RG23D Entry RMA Receipts as well return to Customer will be handed through separate D.C or valid documents.
RMA Return - For the above RMA Receipts No RG23D Entry RMA return to Customer will be handed through separate D.C or valid documents.
Important: The Dealers need to inform to the Range Superintendent regarding the Goods Returns.
Oracle Financials for India also provides the LC functionality. The following are the details how the user can use the LC Functionality.
LC Master holds the Master Information. You can record the details of the Letter of Credits received by the Organization. He should be able to make amendments, view the transactions against each LC and the Balance available at any point of time.
Navigation: India Local Order management > Letters of Credit > Letters of Credit > Master
| Field Description | Type | Action | Description |
|---|---|---|---|
| LC Number | (Displayed) | The LC Number is system generated, once the details are entered and saved to create an LC. | |
| Reference Number | (Required / Protected) | EDIT | Reference Number is required to be entered while creating a new LC. |
| LC Type | (Required / Protected) | PICK | The LC Type has to be chosen from available LOVs. This enables you to record the type of LC as one of ‘Revolving’, ‘Revocable’, ‘Irrevocable’ and ‘Confirmed Revocable’. There is no change in behavior based on LC Type. |
| Customer Name/Number | (Required) | EDIT | You can pickup a valid Customer for whom Localization setup exists and his Number. |
| Description | (Required) | EDIT | Description of the LC is entered. This is not protected from updation and can be edited latter on. |
| [ ] | (Optional) | EDIT | Enter line-specific additional detail and Save. |
| Original Amount | (Required) | EDIT | LC is opened with an Initial Amount. |
| Balance Amount | (Displayed) | This Balance Amount is defaulted after each matching against the LC. | |
| Start Date | (Required / Protected) | EDIT | Start Date From which the entered LC is effective. |
| End Date | (Required / Protected) | EDIT | End Date till which the entered LC is effective |
| Negotiation Days | (Required / Protected) | EDIT | Negotiation Days as per the LC |
| Last Negotiation Date | (Required / Protected) | EDIT | Last Negotiation Date of the LC |
| Credit Period | (Required / Protected) | EDIT | Credit Period for the LC |
| Last Ship Date | (Required / Protected) | EDIT | Last Date until which Shipment can be carried out against this LC |
| Issue Bank Name / Issue branch Name / Issue Bank Address | (Required / Protected) | EDIT | Issue Bank Details of the LC |
| Negotiation Bank Name / Negotiation branch Name / Negotiation Bank Address | (Required / Protected) | EDIT | Negotiation Bank Details of the LC |
| Remarks | (Optional) | EDIT | Remarks of the LC can be entered. Not Protected from updation. |
| Qty. Amendment | Button | This screen has been provided to amend Quantity matched, for any possible user mistake. | |
| Amendments | Button | This screen has been provided to amend LC Values and details, for any possible user mistake. | |
| View Transactions | Button | This screen has been provided to view all transaction done against the specific LC. |
To refer the Screen Navigate through : India Local Order Management - Letters of Credit - Letters of Credit - Master - Qty Amendment Button.
| Field Description | Type | Action | Description |
|---|---|---|---|
| Order Header | (Optional) | EDIT | Order Number |
| Order Line | (Optional) | EDIT | Order Line id |
| Qty Released | (Optional) | EDIT | Quantity Received against the Order. |
| Qty Matched | (Optional) | EDIT | Quantity Matched against the LC |
| LC Type | (Optional) | EDIT | The LC Type against which matching is done |
| LC Number | (Optional) | EDIT | The LC Number for which the record is being displayed |
| Amount | (Optional) | EDIT | The Amount matched against the particular LC |
To refer the Screen Navigate through : India Local Order Management - Letters of Credit - Letters of Credit - Master - Amendment Button.
| Field Description | Type | Action | Description |
|---|---|---|---|
| SL / No | (Required) | EDIT | SL No of the Amendment |
| LC Number | (Optional) | EDIT | LC Number against which Amendment is to be entered |
| Amd Date | (Optional) | EDIT | Date of Amendment |
| Amd Amount | (Optional) | EDIT | Revised / New LC Amount |
| Negotiation Date | (Optional) | EDIT | New Negotiation Date as per Amendment. |
| Shipment Date | (Optional) | EDIT | Revised Last Shipment Date as per Amendment |
| Description | (Optional) | EDIT | Description for the Amendment. |
To refer the Screen Navigate through : India Local Order Management - Letters of Credit - Letters of Credit - Master - View Transactions Button.
| Field Description | Type | Action | Description |
|---|---|---|---|
| SL / No | (Display) | SL No of the Transaction | |
| Customer Id | (Display) | Customer Number against which LC pertains | |
| Order Header | (Display) | Order Number | |
| Order Line Num | (Display) | Line Number of the Order | |
| Qty Released | (Display) | Quantity Released against the Order | |
| Qty Matched | (Display) | Quantity Matched against this LC | |
| LC Type | (Display) | LC Type for the given LC | |
| LC Number | (Display) | LC Number to which the Order line is matched | |
| Amount | (Display) | Amount of the Order Line for this LC |
Navigation: India Local Order management - Letters of Credit - Letters of Credit - Matching
This will be displayed as entered in the Base Apps Sales Order Screen. LOV's are available.
At Line Level
| Field Description | Type | Action | Description |
|---|---|---|---|
| Customer Name | Required | Name of the Customer will be entered for the LC transactions to be matched. | |
| Customer Number | Number of the Customer will be entered for the LC transactions to be matched. | ||
| SL / No | (Display) | SL No of the Transaction | |
| Order Number | (Required) | LOV | Order Number which needs to be Matched |
| Order Line Number | (Required) | LOV | Order Line Number which needs to be Matched |
| Delivery Detail ID | (Required) | LOV | Delivery Detail ID which needs to be Matched |
| Item Name | (Display) | Item Name | |
| Qty Released | (Display) | Quantity Released against the Order | |
| Qty Matched | (Required) | Quantity to be Matched against this LC | |
| LC Type | (Display) | LC Type for the given LC | |
| LC Number | (Display) | LC Number to which the Order line is matched |
Important: If an Order is LC enabled, the Delivery needs to be matched fully with a LC for the Customer prior to fulfilling orders, else system will prevent the Shipment from taking place, till such Matching is completed.
If the Matched Quantity is not equal to the quantity being shipped, the base shipment will be stopped with the following message:
‘ ORA-20401 LC Matched Quantity - X should be equal to Shipped Quantity - Y for LC enabled Orders’
In the given case match the balance quantity & then try shipping.
If the Order is Attached to Bond Register / LUT (Letter of Undertaking) Excise Duty and Excise Cess will not be considered for LC Matching.
LC Matching can be carried out provided the LC Balance is equal or more than the Order Amount.
The Fulfilled Orders India Localization form is used to search and display the shipment information for both the shippable and non-shippable items. It also supports GL drilldown of journal lines, viewing and update of tax information for non-shippable items, generating VAT accounting and VAT invoice number and import Order and tax information for non-shippable items
You can enter any one of the following fields, such as Departure Name, Customer, Order Number, Batch Name, Ship date, Delivery Name, Warehouse, Order type, Waybill to help in specific query of records in the Fulfilled Orders Screen.
Before dispatching the goods, the Sales Order needs to be released and the shipping need to be Confirmed through the standard application. You need to take enough care to ensure that the correct taxes are defaulted in the Sales Order before Releasing/Confirming the shipment of the Order.
Warning: The localization taxes cannot be modified once the Order is Released/Shipped
Immediately on order fulfilment, Excise related records get updated. You can view the Excise and Other Tax Information related to the Shipment using Fulfilled Orders - Localized screen. You can query for an existing Shipment based on the Order Number/Delivery Number.
You have an option to add any taxes of tax type Freight in the tax region of the Fulfilled Orders localized screen. The freight added in this screen will be considered while running the Auto Invoice program and the same will get accounted in the Receivables Module.
In Oracle Financials for India, navigate to the Shipment Confirmation India Localization window as follows:
Shipping > Confirm Shipments > Fulfilled Orders (Localized) > Find
| Field Description | Type | Action | Description |
|---|---|---|---|
| Operating Unit | (Required) | (Pick) | The Operating Unit for which the Shipment needs to be queried. |
| Header level | (Display only) | Relevant Shipping Information like Delivery Name, Order Number, Customer Name, Order Type, Ship To, Excise Exemption Type, Way Bill Number, Line Total, Excise Exemption Reference Number, Excise Exemption Date, Tax Total, Order Total Amount, Currency, Item Name, Excise Invoice No and VAT Invoice No are displayed. Checking the Matching Items Only flag returns only those items that match the shipment details entered. |
Fields discussed below pertains to the localized information.
| Field Description | Type | Action | Description |
|---|---|---|---|
| Excise Exemption Type | (Display only) | Excise Exemption Type will be displayed if an Order is against CT2,CT3 and Exemption Certificate. | |
| Excise Exemption Ref No | (Display only) | Excise Exemption Reference Number of CT2,CT3 and Exemption Certificate will displayed if an Order is against CT2,CT3 and Exemption Certificate. | |
| Excise Exemption Date | (Display only) | Date of CT2,CT3 and Exemption Certificate will displayed if an Order is against CT2,CT3 and Exemption Certificate. | |
| Tax amount | (Display only) | Total Tax for the Shipment will be displayed . | |
| Total amount | (Display only) | Total Amount (Total Line Amount + Total Tax Amount) for the Shipment will be displayed. | |
| Item Name | (Display only) | You can use this field to query in all Orders with the Item entered here. On executing this query the system would fetch all Shipments that have the specified item in the lines. | |
| Matching Items Only | (Display only) | You can use this field in combination with ‘Item Name’ field. On executing a query with this field checked in combination with Item Name, the system would fetch all shipments that contain this Item. The lines would be restricted to the queried Item. | |
| Excise Invoice No | (Display only) | You can use this field query on all shipments. On querying on the Excise Invoice No. all shipments with this Excise Invoice Number would be retrieved. | |
| VAT Invoice No | (Display only) | You can use this field query on all shipments. On querying on the VAT Invoice No. all shipments with this VAT Invoice Number would be retrieved. | |
| Line Level | |||
| Shipped | (Display only) | Checking this flag states that the item is shippable. | |
| Line number | Line Number of the Item displayed against the delivery will be displayed | ||
| Order Line No | Order Line number of the item displayed against the delivery. | ||
| Item Name | Item Code of the Item shipped against the line covered under the delivery will be displayed. | ||
| VAT Exemption Date | (Display Only) | Displays the VAT Exemption Date. | |
| Reference no. | (Display Only) | Reference number of the item shipped against the line will be displayed. | |
| VAT Invoice No | (Display only) | VAT Invoice No. of the shipment will be displayed. | |
| [ ] | (Optional) | EDIT | Enter line-specific additional detail and Save. |
Important: If tax details do not get populated in the above screen, (even due to invalid / disabled triggers) the same is treated, as Shipment without taxes and taxes will not flow to Accounts Receivable Module. In such cases, User has to raise a Debit Note for Tax Amounts in Receivables & pass Manual Entries in Excise Registers.
Note: You can view the GL Drilldown accounting lines by clicking Show transactions on the Tools menu of the Confirm Shipment India Localization form.
Bond Register
In the Sales Order if you select an Order Type associated with the ‘Bond Register’ Excise Transaction Type, duty will not be debited in any of the duty paying registers. Instead, the duty will be debited to the running bond account balance.
Shipment created based on these Order Types would be considered for the update to Bond Register. A record would be created in the Bond Register on running the ‘Excise Invoice Generation’ program. The Bond Amount would be reduced by the Amount of Transaction.
The system would raise an application error and interface trip stop would complete with an error, whenever, the amount of Bond Credit is lesser than the Excise Duty applicable to the Export Transaction. The same would not be applicable to the Bonds that have been checked as LUT’s.
The system would also raise application error where the Shipment Date is greater than the Bond Expiry Date.
You can view the Transactions under Bond through the View Bond Register screen. The duty amount debited in the Bond Register can be credited on admission of the proof of export by the Excise Authority.
To view the transactions related to the Bond, select the Organization, Location and Bond Number. The lines would reflect the transactions related to the Bond. Bond Amount entered in the Define Bond Register screen would be shown as the Bond Credit. This would be the first transaction. A record would be created for every shipment transaction with the Transaction Name as ‘Bond Sales’. Register Balance would be reduced to the extent of this Excise Duty on the transaction.
India Local Order Management - Setup - Registers - Bond Register Summary
| Field Description | Type | Action | Description |
|---|---|---|---|
| Operating Unit | (Required) | (Pick) | The Operating Unit for which the Bond Register is being queried. |
| Organization Name | (Enter) | The Inventory Organization for which you want to check the Bond Register | |
| Location | (Enter) | The Inventory Location for which you want to check the Bond Register | |
| Bond Number | (Enter) | User can select appropriate Bond Number from the list of LOV’s. User can select a value in this field only after selecting the Organization and Location. | |
| Bond Expiry Date | (Displayed) | Value in this field would be displayed on selecting the Bond Number. | |
| Letter of Undertaking. | (Displayed) | Check box | This would be a display field and would indicate whether the Bond is a Letter of Undertaking. |
| Transaction Name | (Displayed) | The Transaction Name will be displayed here for the transaction line. | |
| Transaction Amount | (Displayed) | The Transaction Amount will be displayed here for the transaction line. | |
| Register Balance | (Displayed) | The Register Balance post the given transaction | |
| Order / Invoice | (Displayed) | Wether the transaction has come from an Order or a Manual Invoice from AR Module. | |
| Order Invoice Number | (Displayed) | The Order / Invoice Number will be displayed here for the transaction line. | |
| Transaction Type | (Displayed) | The Transaction Type will be displayed here for the transaction line. | |
| Excise Invoice Number | (Displayed) | The Excise Invoice Number will be displayed here for the transaction line. | |
| Export Approval No | (Displayed) | The Export Approval Number will be displayed here for the transaction line under which the proof of export is admitted. |
On receipt of proof of export for a particular transaction, you can take credit of the Bond amount in the view Bond Register. This you can do by navigating to Tools, Enter Approval Number. This would display a sub window where you can record the Approval Number. On saving the record, the duty amount will get credited in the running Bond Account.
Tools - Enter Approval Number.
This displays the sub window where the user can record the Approval Number. On saving the record, the duty amount will get credited in the running bond account.
In Oracle Financials for India, navigate to the Bond Register Summary India Localization window as follows:
India Local Order Management > Setup > Registers > Bond Register Summary > Tools > Enter approval No
| Field Description | Type | Action | Description |
|---|---|---|---|
| Organization/Location | (Displayed) | The Inventory Organization and its Location will be displayed here from the transaction line. | |
| Transaction Type | (Displayed) | The Transaction Type will be displayed here from the transaction line. | |
| Order Invoice Number | (Displayed) | The Invoice Number will be displayed here from the transaction line. | |
| Transaction Amount | (Displayed) | The Transaction Amount will be displayed here from the transaction line. | |
| Export Approval No | (Required) | ENTER | You can record the AR4 Number and the document reference under which the proof of export is admitted. |
Important: The Number once entered is not allowed to be changed and due care needs to be taken while entering the same to enter the correct value.
The facility provided is to enter the number against each invoice only and group entry features are not possible.
Excise Exempted Sales Orders
By selecting an Excise Exemption Type from the Localized Sales Order, you clear excisable goods without payment of duty under specific conditions. Excisable goods can be cleared from the factory without payment of duty to a 100% Export Oriented Unit against CT 3 Certificates under the cover of AR3. Excise Exemption options available for the users.
See Also: The features of excise exemption are discussed in detail under the topic Sale Order - Localized.
Clearance without payment of Duty under AR-3A needs to be tracked for Receipt of Re-warehousing Certificate. This legal requirement can be mapped through this functionality. All clearances under Excise Exemptions will be recorded in this screen and on Receipt of the Authenticated Document, the receipt date can be recorded. By viewing this screen, you can monitor the Re-warehousing certificates that need to be received from the Customers at any point of time.
Through the find query form you can view the AR3A forms to be received for a particular Customer or all Customers.
In Oracle Financials for India, navigate to the India Local AR3 Form Receipt Tracking window as follows:
India Local Order Management > Customers > AR3 A form Receipts Tracking
| Field Description | Type | Action | Description |
|---|---|---|---|
| Customer Block | Details regarding the Customer will be displayed. | ||
| Customer Name | (Displayed) | Customer Name will be displayed. | |
| Customer Number | (Displayed) | Customer Number of the above Customer will be displayed. | |
| Customer Site | (Displayed) | Customer Site (Ship to) will be displayed. | |
| Transaction Block | (Displayed) | Details regarding the transaction will be displayed. | |
| Type | Type of transaction either Order or Invoice will be displayed. | ||
| Source | (Displayed) | Source for the above type of transaction will be displayed. | |
| Number | (Displayed) | Number of the transaction will be displayed. | |
| Form Block | Details regarding CT2, CT3 and Excise Exemption Certificate will be displayed. | ||
| Form | (Displayed) | Form Type like CT2,CT3 and Excise Exemption will be displayed. | |
| Number | (Displayed) | Number of CT2,CT3 and Excise Exemption Certificate will be displayed. | |
| Date | (Displayed) | Date of the CT2, CT3 and Excise Exemption Certificate will be displayed | |
| AR3A details block | Details of AR3A Forms for a transaction will be displayed here and once the AR3A forms is received back from a Customer, the same can be entered in this block in received date column. | ||
| Delivery Number | (Displayed) | Delivery Number will be displayed. | |
| Delivery Name | (Displayed) | Delivery Name will be displayed | |
| Delivery Date | (Displayed) | Delivery Date will be displayed | |
| AR3A Form Number | (Displayed) | AR3A Form Number will be displayed. | |
| Date | (Displayed) | AR3A Form Date will be displayed. | |
| Received Date | (Enterable) | The Date on which the AR3A forms were received back from the Customer. After receipt of an AR3A form, it will be removed from the outstanding list of AR-3A form to be received from a Customer. |
Important: Delivery Number, Name and Date will be visible only for Order Management transactions and will not show any value for Manually entered Receivable transactions.
In the Find window, Order/Invoice refers to query option of querying for an Order entered through Order Management or Invoice entered through Transactions (Localized) in Receivables. Invoice does not list Imported Invoices against Order Management.
This section provides overview and detailed descriptions of these reports:
Commercial Invoice
India - Excise/VAT Invoice Template
This report gives you the Commercial Invoice that covered “ISSUE OF INVOICE UNDER CENTRAL EXCISE RULE 57G OR 57T”. This section is no longer valid, however the report is not dropped so that the fields appearing in the report can be used as an example or base for client required output to generate and print Invoices.
Report Submission
Use the Submit Requests (India Local AR and OM Modules) form and enter India- Commercial Invoice Report in the Name field to submit the report.
Report Parameters
| Parameter | Description | Required/Optional | Action |
|---|---|---|---|
| Organization | Enter the organization from which delivery of goods is made. | Optional | Pick |
| Location | Enter the location of the organization. | Optional | Pick |
| Customer | Enter the customer name. | Optional | Pick |
| Order/Invoice | Quick field for this field are Order and Invoice. | Optional | |
| Invoice | Commercial Invoices that the user wants to print. | Required |
This report gives you the Invoice Template, provided as an example of the Excise/VAT Invoice that is to be generated. Fields appearing in the report can be used as an example or base for Customer required output to generate and print Invoices. You can use this template to customize your requirement of invoice printing as appropriate.
Note: The format of the actual invoice is left to the manufacturer to decide and hence only a generic template is provided.
This report is primarily based on Shipping data, and will not handle the following:
Standalone AR Invoices (entered through Transactions Localized)
Invoices for Bill Only Workflow
Excise Invoice generated for RTV
Excise Invoice generated for Manual PLA and RG23A/C, RG1 entry
Report Submission
Use the Run Reports from India Order Management module to be invoked from the order management reports request group and enter India Excise/VAT Invoice Template in the Name field to submit the report.
Report Parameters
| Report Parameter | Type | Action | Description |
|---|---|---|---|
| Organization Name | Required | PICK | The Inventory organization for which the report is being generated. This allows all Inventory organizations and does not restrict based on Operating Units attached to the user. |
| Location | Optional | PICK | The Inventory Location for which the report is being generated. This needs to be left blank if all locations are to be printed. This gets enabled only if the Inventory Organization is selected. |
| From Date and To Date | Required | Start Date and End Date for which the report is being run. This can be used leaving the number blank in case you want to generate the report for a range of transactions. This field is however required to restrict printing of invoices to a specific year when there are same numbers across various years in the given organization location combination. | |
| Delivery | Optional | PICK | LOV shows list of all available Deliveries based on From Date and To Date entered. Selecting a value in this field indicates user wants to print a single document for which he already has the number. |
Note: When a Single Delivery has both excisable and non-excisable material to be shipped together, the same would display in a single invoice split into two. This is because the Excise Invoice number is a header level field in the report but stored at line level in the current product architecture, when a invoice which has both excisable and non excisable items being shipped together, the report will show All excisable lines as one invoice with Excise Invoice number in header and will show all non-excisable lines as a separate invoice with Excise Invoice number appearing as blank.