Skip Headers

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

India Local Receivables

This chapter covers the following topics:

Transactions (Localized) Overview

You can create transactions with localized taxes in the Receivables module. The taxes would be calculated for the item, based on Tax defaulting setup. You will also have a facility to add localization taxes manually.

Where information flows into Transactions while running the auto invoice program, the localization taxes defined in order management module would flow into Transactions (localized) window.

The Transactions (Localized) functionality lets you satisfy all your needs related to Tax calculation required for an Accounts Receivables Transaction. You can:

Major Features

Defaulting Taxes to Receivables Invoice

You have an option to use Localization taxes while creating an invoice in the Receivables module. 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.

Manual Changes to Defaulted Taxes to Receivables Invoice

The Taxes defaulted can be changed manually, if required. You can also change the defaulted Service Type before completing the transaction.

Note: In case the transactions are imported from Order Management, Service Type cannot be changed using this form.

Generation of Excise Invoice

If the Invoice that you have created has excise type of taxes, you can generate an Excise Invoice for the transaction. All excise related registers will get updated on completion of the transaction.

Generation of VAT Invoice

If the Invoice that you have created has VAT type of taxes, and the item is marked as VAT able you can generate an VAT Invoice for the transaction. The tax repository will get updated on completion of the transaction.

Update of Excise Registers

Update of Excise Registers would be based on the set up of Bond registers. Based on the Bond Register that is attached to the Transaction Type (in the Bond Register Setup) used for the transaction, corresponding excise records would be updated.

Tax Base Amount

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

Match Receipts

If the creating the Invoice for a trading organization, you can match the Invoice line to a Receipt. On doing this the excise amount would be proportionately passed on to the Invoice line.

Taxes on Credit / Debit Memo created against a Receivable Invoice

When the receivables Invoice created has the taxes applicable, and if the Credit Memo or Debit Memo is created against the given Invoice, then it will also consider all the taxes applicable for the Invoice (proportional to the quantity or percentage as specified).

Record Excise Exemptions

You can choose the Exemption Type applicable to the transaction. The effect on the Accounting entries and excise registers would vary based on the option chosen in this field.

Record VAT Exemptions

You can choose the Exemption Type applicable to the transaction. The VAT tax will be changed to Zero if the same is marked as VAT Exempt.

Choose Update of RG Registers

You have an option to update the Payment Registers selectively. This you can do by un-checking the Update RG Flag.

Choose Register Preferences

By default, the duty will get debited in the register based on the register preference set up in the Additional Organization Information. User has an option to change the duty paying register for each transaction.

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-Debtors Trial Balance Report - Lists the closing balance for Customers as on date.

Total Sales Report - Lists the Sales transactions made from an Inventory Organization during the selected period.

Managing TCS Trasactions

Order to Cash Cycle

  1. Enter a normal sales order with TCS Taxes. Save and Book it.

    Note: If the customer billing exceeds Threshold limits, the Order will not show the Surcharge. This is because Order entry or booking is not a financial transaction and the event, when surcharge is applicable, is Shipping and invoicing only. Also, as Surcharge needs to be reversed when the total Threshold decreases, such surcharge is not displayed in the order even after shipping or closure of order line.

  2. Pick Release and fulfil the order. When you fulfil the order with Surcharge limit exceeded, the Surcharge and Cess get auto-assigned.

  3. Run Autoinvoice for this Order, which will import the Invoice into Receivables. Run the India Local Concurrent for Processing Order Lines to AR, which will populate these taxes in Oracle Receivables. You can query the AR invoice from the IL screen using the transaction number.

Bill Only Cycle

  1. Enter a normal ‘Bill Only’ sales order with TCS Taxes. Save and Book it.

    Note: If the customer billing exceeds Threshold limits, the Order will not show the Surcharge. Book this order. In bill only cycle, surcharge and cess on surcharge get included and computed on running the AutoInvoice.

  2. Run Autoinvoice for this Order, which will import the Invoice into Receivables. Run the India Local Concurrent for Processing Order Lines to AR, which will populate these taxes in Base Receivables.

Standalone Receivables Invoice

  1. Navigate to Transactions Localized , Open and create the transaction.

  2. Then?

Advance Receipts

  1. Create a normal receipt with Payment Method as Receipt for TCS.

  2. Navigate to View > Zoom before saving the receipt. This will open the India Local Cash Receipts window.

    Field Description Type Action Description
    Customer Name Display   The customer for whom the receipt is being entered.
    Customer Number Display   The customer number for which the receipt is being entered.
    Customer Site Display   The customer site for which the receipt is being entered.
    Receipt Number Display   The receipt number that is being entered.
    Receipt Amount Display   The receipt amount that is being entered.
    Organization Required PICK The Inventory Organization against which this receipt is being entered.
    Item Classification Required PICK The Item class for which this concurrent is being run.
    Tax Category Required PICK The Tax Category for this receipt based on which Taxes will be deducted.

    Note: Only Tax Categories with TCS Tax Type will be displayed in the LOV.

    TCS Document No. Display   The TCS document that gets generated for this receipt.
    Total Tax Amount Display   The Total TCS Tax amount that got charged to this receipt.
  3. Enter Organization, Item Classification and Tax Category and click on Taxes. If the taxes are found in order, click Confirm and close the taxes window.

    Note: For a confirmed Receipt, taxes will be view only and cannot be modified.

    TCS is charged only when you Confirm the Taxes. If you do not confirm the receipts, the same will be shown in the TCS Exception Report. You must navigate to the Receipt and Confirm the taxes, else these receipts will be nullified during settlement.

    Note: Once the Settlement Process is carried out, the Receipt cannot be cancelled.

  4. Run the AutoInvoice program for TCS Debit Memo.

    Note: The Debit memo created will only be visible in Transactions and not in the Transactions Localized screen.

TCS Settlement

  1. Run TCS Settlement Report

  2. TCS Settlement

  3. Validate and pay AP invoice

  4. Update Payment Additional Information

  5. Finalize Settlement

  6. Run India - Generate TCS Certificates

Run TCS Settlement Report

You must run the TCS Settlement Report before carrying out the actual settlement process. Navigate to View > Request > Submit a New Request from India Local Receivables or India Local Payables responsibility.

Field Description Type Action Description
TAN No Required PICK The TAN No. for which this concurrent is being run.
Organization Name Optional PICK The Inventory organization for which TCS Settlement is being run.
Settlement Date Required   Settlement date for which this concurrent is being run.
Item Classification Required PICK The Item class for which this concurrent is being run.

Running the TCS Settlement report can give you the following information to be verified:

TCS Settlement

After verifying the India TCS Settlement Report output, perform the TCS settlement by navigating to India Local Receivables > Period End > Settlement.

Settlement Date can be entered only upto sysdate-1 i.e. yesterday's date. A settlement cannot be carried out on current date as there can be some transactions carried out in current date after settlement, which will then remain pending in the system.

The Process button will be active only when the Net Balance Amount (Payable amount) is shown Negative. If the Credits are more than the Debits and there is no payment due, then you cannot process a settlement. In such cases the Process button will appear disabled.

Note: When the TCS Settlement process is carried on the TCS repository, feeding any new data to the repository will result in data inconsistency. TCS Settlement carried out once cannot be reversed.

Clicking Process will invoke a concurrent of Localization Payables Open Interface Import (Payables Open Interface Import), which will create an AP Invoice on the TCS authority selected.

Validate and Pay AP Invoice

Login with Payables responsibility and validate and pay the AP invoice in Oracle Payables.

Updating Payment Additional Information

To update payment additional information, navigate to India Local Receivables > India TCS/VAT/Service Tax > Period End > Additional Payment Information.

Note: Clicking New will let you enter details for new Payment to be made. Find let's you search for existing payment details.

Field Description Type Action Description
Header information      
Tax Authority Type Display   This needs to be set to ‘India TCS Authority’ for TCS settlement.
Tax Authority Display   The Vendor name which was used for making the TCS Challan at time of TCS Settlement.
Tax Authority Site Display   The Vendor site which was used for making the TCS Challan at time of TCS Settlement.
Item Classification Display   The TCS Item class for which TCS Settlement was carried out.
Line Information      
Settlement Date Display   The Date when TCS Settlement was carried out
TAN Number Display   The Organization TAN Number for which Settlement was carried out.
TCS Amount Display   The basic TCS Amount that was settled.
Surcharge Amount Display   The Sucharge on TCS Amount that was settled.
Education Cess Amount Display   The Education Cess on the TCS and the Surcharge amount that was settled.
Total TCS Amount Display   The Total TCS amount that got settled. This is sum of the TCS Amount, surcharge amount and Education Cess amount shown in the preceding three columns.
Check Date Display   The Check date with which this settlement was paid.
Check Number Display   The Payment Document number using which the TCS settled amount was paid.
BSR Code Required   This is a seven digit numeric code that is required to be printed on the TCS Certificate and in eTCS returns
Check Deposit Date Required PICK The date when the Check was deposited with TCS Authority
Bank Name Required PICK The Bank Name that would get printed on the TCS Certificate.
Challan Number Required   The five digit numeric challan number with which the TCS was paid. This would be printed on the TCS Certificate.

Finalize Settlement

To finalize the TCs settlement, navigate to India Local Receivables > India TCS/VAT/Service Tax > Period End > Settlement Payment Details.

Run India - Generate TCS Certificates

Run the India - Generate TCS Certificates from View > Requests > Submit a new Request, from India Local Receivables or India Local Payables responsibility. Running this request will generate TCS Certificate numbers against each customer for the settlement. If you want to issue certificates quarterly and settlement is carried out monthly, then run this request every quarter and not after each settlement.

Field Description Type Action Description
From Date Required   From Date for which TCS Certificates that needs to be generated.
To Date Required   To Date for which TCS Certificates that needs to be generated.
TAN Number Required PICK TAN Number for which TCS Certificates that needs to be generated.
Tax Authority Required PICK Tax Authority under whose jurisdiction TCS Certificates needs to be generated.
Tax Authority Site Required PICK Tax Authority site under whose jurisdiction TCS Certificates needs to be generated.
Customer Name Optional PICK Customer for whom TCS Certificates that needs to be generated.
Customer Site Optional PICK Customer Site for which TCS Certificates that needs to be generated.

Tracking of ST Forms Receipts

Introduction

You can use this feature to track sales tax concessional forms to be received from the customers. On receipt of the form, the details of the concessional forms received can be recorded in this window.

This form can be effectively used to monitor and track the Sales tax Forms that need to be received from Customers.

Basic Business Needs

The ST Forms Receipt Tracking functionality lets you track the Concessional forms due from Customers. You can:

Reports

Receivables generates this report for India:

India - ST Form Customer Report - Use Sales Tax Form Customer Report to track customers for whom you have given Sales Tax discount and you have not yet received the ST Forms for an Invoice. Where the Form has been fully or partially received against Invoices.

AR 3A Form Receipt Tracking Overview

Material Clearance without payment of duty under AR-3A needs to be tracked for receipt of re-warehousing certificate. AR-3A Receipt Tracking feature of Oracle Financials for India can be used to meet this requirement. 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 the contents of this screen, users can monitor the re-warehousing certificates that need to be obtained from customers at any given point of time.

The AR-3A Receipt Tracking functionality enables you to keep track of the AR-3A forms due from Customers. Using this functionality, you can:

Using the find query form, the User can view the AR3A forms to be received for a particular customer or all customers.

Navigate to India Local Receivables > Customers > AR3 A form Receipts Tracking

The field wise description of the screen is given below.

Field Description Type Action Description
Customer Name (Optional/Required)   The User can enter Customer Name from whom the AR3A Forms are to be received. If nothing is specified here, then all the outstanding AR3A form for all the Customer will be shown / displayed.
Customer Number (Displayed)   Customer Number of the above Customer will be displayed here.
Customer Site (Optional)   If the User wants to view the outstanding AR3A for a specific Customer Site (Ship to), then he can specify this field.
Order/Invoice (Optional)   Quick field are Order or Invoice
Order/Invoice No (Optional)   A specific Order / Invoice Number can be specified for which the User wants to view the outstanding AR3A.
Excise Exemption Type (Optional)   CT2, CT2 others, CT3 can be specified
AR-3A form (Optional)   AR-3A form number can be specified
Through AR-3A form, India Local Receipts Tracking the user can enter the receipt of AR3A form from a Customer.
Customer Block      
Details regarding the customer will be displayed. (Displayed)    
Customer Name     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     Details regarding the transaction will be displayed.
Type (Displayed)   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 & Excise Exemption Certificate will be displayed.
Form (Displayed)   Form Type like CT2,CT3 & Excise Exemption will be displayed.
Number (Displayed)   Number of CT2,CT3 & Excise Exemption Certificate will be displayed
Date (Displayed)   Date of the CT2,CT3 & 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 User received back the AR3A form from the Customer. After receipt of a AR3A form , the same will be removed from the outstanding list of AR-3A form to be received from a customer.

Delivery Number, Name & Date are visible only for Transactions, which are imported from Order Management Responsibility and not applicable to Manual Transactions entered in Receivables using Transactions (Localized) Form.

Reports

Receivables generate this report for India:

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

RG Consolidation

The excise rules allow monthly settlement of liabilities arising during the period. Oracle Financials for India provides a feature ‘Allow Negative Balance’, using which you are allowed to complete a sales transaction; even-though the register balances are not adequate. The PLA Register will be updated irrespective of a negative balance.

To calculate the net liability during monthly settlement, you can use the RG Consolidation feature. The RG Consolidation window:

You can also transfer a part of the available credit to offset negative PLA balance. To do this, specify the amount that needs to be maintained in the CENVAT accounts on completion of the transaction. Accordingly, the system will make Debit entries in the CENVAT registers and credit entries will be generated in the PLA register. For the balance amount, system will create a PLA Invoice.

The RG Consolidation feature lets you completes sales transactions in spite of inadequate credit balance. You can:

Major Features of RG Consolidation

Allow Negative Balance

You can enable update of PLA with debit transactions even when the PLA balance is negative.

Track Register balances for each Organization, Location combination

RG Consolidation window provides you an overview of the balances of Excise Registers and PLA. You can try a combination of transfers and see its corresponding effect on PLA balance.

Create PLA Payment and AP Invoice

On saving the changes in RG Consolidation, based on the intended balance of PLA a PLA Payment and AP Invoice are created. However, the PLA Register will not be updated with this transaction until the Invoice is paid and the PLA Payment is acknowledged.

Enabling the 'Allow negative balances in PLA' checkbox in the Additional Organization Information screen allows you to run his PLA Account with negative balances. The Excise Duty liability needs to be adjusted on fortnightly basis and an RG Consolidation screen is provided to adjust the Credit Balance available in CENVAT Accounts while working out the actual amount that needs to be paid on account of Excise Liability. You can specify the amount that needs to be maintained in the CENVAT Accounts and PLA Account on completion of the transaction. Accordingly, the system will make Debit Entries in the CENVAT registers and Credit entries will be generated in the PLA Register. For the balance amount, system will create a PLA Invoice.

Important: The RG Consolidation functionality is not supposed to be used for creation of Positive balance in PLA.

This is to be only used to make the Negative PLA Balance to Zero by consolidating the Positive Balances available in RG 23A & C Registers or making a payment for the Negative PLA Balance after consolidation.

The backdated RG Consolidation feature lets you specify a Consolidation Date and will only return those transactions or balances that were created till the supplied date. To be able to do this, you must have enabled the ‘-Ve Balance in PLA’ checkbox for the Organization Location combination by navigating to the Accounting Info tab under India Local Inventory ->Setup ->Organizations ->Additional Information. In the Register Preferences tab, set up PLA as preference 1. While it is possible to do a backdated RG Consolidation without the mandatory setup but skipping it will result in negative RG Register balances post consolidation and the same cannot be rectified as it has cascading effect on balances, registers and accounting.

Once the PLA Invoice is generated by the RG Consolidation transaction, you must make the payment before submitting fresh transactions. The system will disallow any subsequent RG Consolidation transaction till payment is made for the Invoice generated by the previous transaction.

Navigate to India Local Receivables > India Localization > Registers > RG Consolidation Screen. The field wise description for this screen is given below.

Field Description Type Action Description
Operating Unit (Required) (Pick) Operating unit for which the RG Consolidation is being carried out.
Organization Name/Location Name (Required) (Pick) Select Organization and Location name.
Consolidation Date     The Date on Consolidation needs to be recorded
Previous consolidation date     System will display the Previous Consolidation Date
Closing balance as on date     The closing balance of different duty paying registers as on date will be displayed in this field
Closing balance as on consolidation date     The closing balance of different duty paying registers as on consolidation date will be displayed
Desired closing balance     User needs to input the desired values on completion of the transaction
Net Debit     Debit from each register for the transaction will be displayed
Remarks     This field displays the remarks for set off entries
User remarks     User can enter the transaction text in this column
Authority/Location     Name and Site of the Excise Authority needs to be picked in this field
TR6 Challan Number / TR-6 Date     User needs to record the TR6 Challan Number and date through PLA amount is being credited
Payment id     On saving the record, a batch id will be created and the same will be displayed.

Important: On completion of the transaction Debit Entries will be generated in the CENVAT Registers and corresponding Credit Entries will be generated in the PLA Register. Apart from that PLA will be credited with the amount of PLA Invoice generated through the transaction. Users need to ensure that payment towards this Credit is made on the same day.

For Creating a positive PLA Balance please use the PLA Invoice.

Note: You can view the GL Drilldown Accounting lines by clicking the Show Transactions button on the Tools menu in RG Consliodation form.

Supplementary Transactions Overview

There would be instances in your business where the customer balances are affected by price and tax rate changes for a retrospective period. For all such changes you can use the Supplementary Transactions feature of Oracle Financials for India. Using this feature, you can identify the source documents affected by these changes, calculate the amount for which an Invoice or a Credit Memo has to be raised and automate creation of such Invoice or Credit Memos.

The Supplementary Transactions feature of Oracle Financials for India helps you in tracking and accounting the price and tax changes. You can:

Major Features

Supplementary Transactions can be raised on account of the following

In both cases either a Supplementary Invoice or Credit Memo will be raised based on the retrospective changes. The transactions, which will have an effect on account of Price changes, will be listed through the following Mapping Type.

Cases Handled

Consider the following products and the following cases:

Product Name Original Price (In rupees) Revised Price (In rupees)
Prod.A 100.00 120.00
Prod.B 100.00 90.00

Also, consider the following:

Tax code Original Rate Revised Rate
Tax Code - Excise 10% 12%
Tax Code - LST 8% 2%
Tax Code - Sales tax 5% 3%
Tax Code - Octroi 3% 5%

The following are the possible scenarios and treatment on the above cases.

Case I

Only Price Revision (Increase) but no change in Tax rate.

Invoice with original price for 100 Quantity of Prod.A raised on March 20, 1999 and a revised price list has been introduced with retrospective effect from March 15, 1999 and the user need to raise a Supplementary Invoice.

Parameter Original Price (in rupees) Revised Price (in rupees) Supplementary Invoice
Net sales (100 x 100 ) 10000.00 12000.00 2000.00
Add : Taxes 1000.00 1200.00 200.00
Tax code - Excise (10 %) 550.00 660.00 110.00
Tax code- Sales tax (5%)      
Tax code - Octroi 3%) 346.50 415.80 69.30
Total 11896.50 14275.80 2379.30

Supplementary Invoice may be raised for RS. 2379.30

If the user decides to raise a Supplementary Invoice, then the following accounting entry will be passed in this case.

Dr. Receivable a/c 2379.30

Cr. Revenue a/c 2000.00

Cr. Excise duty a/c 200.00

Cr. Sales Tax a/c 110.00

Cr. Octroi duty a/c 69.30

Case II

Only Price Revision (Decrease) but no change in Tax Rate.

Invoice with original price for 100 Quantity of Prod.B raised on March 20, 1999 and a revised price list has been introduced with retrospective effect from March 15, 1999 and the user need to raise a Credit Memo.

Parameter Original Price (in rupees) Revised Price (in rupees) Credit Memo
Net sales (100 x 100 ) 10000.00 9000.00 1000.00
Add : Taxes      
Tax code - Excise (10 %) 1000.00 900.00 100.00
Tax code- Sales tax (5%) 550.00 495.00 55.00
Tax code - Octroi (3%) 346.50 311.85 34.65
Total 11896.50 10706.85 1189.65

Credit Memo may be raised for Rs. 1189.65

If the user decides to raise a Credit Memo, then the following accounting entry will be passed in this case.

Dr. Revenue a/c 1000.00

Dr. Excise Duty a/c 100.00

Dr. Sales Tax a/c 55.00

Dr. Octroi duty a/c 34.65

Cr. Receivable a/c 1189.65

Case III

Change in Tax Rate but no Change in Price.

Invoice with original price for 100 Quantity of Prod.A raised on March 20, 1999 with Original Tax Rate and revised Tax Rate has been put into use w.e.f from March 15th 1999 and the user need to raise a Supplementary Invoice.

Parameter With Original Tax Rate Revised Tax Rate Supplementary Invoice
Net sales (100 x 100 ) 10000.00 10000.00 0.00
Add : Taxes      
Tax code - Excise (10 %) 1000.00 (12%) 1200.00 200.00
Tax code- Sales tax (5%) 550.00 (3%) 336.00 -214.00
Tax code - Octroi (3%) 346.50 (5%) 576.80 230.30
Total 11896.50 12112.80 216.30

Supplementary Invoice may be raised for Rs. 430.30

Credit Memo may be raised for Rs. 214.00

Case IV

Change in Tax Rate but no Change in Price.

Invoice with original price for 100 Quantity of Prod.A raised on March 20, 1999 with Original Tax Rate and Revised Tax Rate has been put into use w.e.f from March 15th 1999 and the user needs to raise a Credit Memo.

Parameter With Original Tax Rate Revised Tax Rate Credit Memo
Net sales (100 x 100 ) 10000.00 10000.00 0.00
Add : Taxes      
Tax code - Excise (10 %) 1000.00 (12%) 1200.00 200.00
Tax code- Sales tax (8%) 880.00 (2%) 224.00 -656.00
Tax code - Octroi (3%) 356.40 (5%) 571.20 214.80
Total 12236.40 11995.20 241.20

Credit Memo may be raised for Rs. 656.00

Supplementary Invoice may be raised RS. 414.80.

Case V

Change in Price and also change in Tax Rate.

Invoice with original price for 100 Quantity of Prod.A raised on March 20, 1999 with Original tax rate . The Revised Price and Revised Tax Rate has been put into use w.e.f from March 15, 1999 and the User need to raise the Supplementary Invoice.

Parameter With Original Tax Rate Revised Price or Tax Rate Credit Memo
Net sales (100 x 100 ) 10000.00 (120%) 12000.00 2000.00
Add : Taxes      
Tax code - Excise (10 %) 1000.00 (12%) 1440.00 440.00
Tax code- Sales tax (8%) 880.00 (2%) 268.80 -611.20
Tax code - Octroi (3%) 356.40 (5%) 685.44 329.04
Total 12236.40 14394.24 2157.84

Supplementary Invoice may be raised for Rs. 2769.04.

Credit Memo may be raised for RS. 611.20.

Price / Tax changes

The user can decide and execute the kind of mapping he likes to do to identify the transaction which are having impact on account of Price / Tax changes this screen

In Oracle Financials for India, navigate to India Local Receivables > Transactions > Supplementary Transactions > Price/Tax Changes.

Field Description Type Action Description
Ledger (Required) PICK HELP Ledger name needs to be entered by the user from LOV to view the transaction.
Organization (Optional) PICK HELP The Organization name can to be entered / selected by the user from LOV to view the transaction. If this is left blank then the transaction for all the Organization will be displayed.
Customer Name (Optional) PICK HELP The Customer name can be entered by the user from LOV to view the transaction related to a particular Customer. If this is left blank then the transaction for all the Customer will be displayed.
Customer site (Optional)   The Customer Site can be entered by the user from LOV to view the transaction related to a particular Customer Site . If this is left blank then the transaction for all the Customer will be displayed.
Batch Id (Optional)   The User can specify the Batch Id to view the Supplementary Transactions corresponding to the Batch Id

By invoking the new button, the user can perform the desired mapping:

In Oracle Financials for India, navigate to India Local Receivables > Transactions > Supplementary Transactions > Price/Tax Changes > New/Find.

Field Description Type Action Description
Header Level      
Ledger (Required) PICK HELP The Ledger name needs to be entered by the user from LOV
Organization (Optional) PICK HELP The Organization name can to be entered by the user from LOV. If this is left blank then the transaction for all the Organization will be considered.
Functional Currency (Displayed)   Functional Currency in a Set of Book will be displayed here.
Customer Name (Optional) PICK HELP Users can select Customer Name from LOV. If Customer Name is left blank then the transaction for all Customers will be considered in the mapping.
Customer Site (Optional) PICK HELP Users can select Customer Site from LOV. If Customer Site is left blank then the transaction for all Customers will be considered in the mapping.
Batch Id (Displayed)   Generates Batch Id for set of mapping and displayed in these fields. Based on this Batch Id, the user can run the concurrent program to raise Supplementary Transactions.
Line Level (Required) PICK HELP The Quick fields available for Mapping Type are Price List, Assessable Price List, Invoice Price List, and Tax.

Mapping Type: The Usability of the Quick fields.

Field Description
Price List used for mapping between Price Lists: OE and AR instances
Assessable Price List
used for mapping between Assessable Price Lists: case OE and AR instances
Invoice Price List used for mapping to identify Invoices due to price changes in the case of standalone AR instances
Tax This will used to do mapping between Tax Codes.
Field Description Type Action Description
Existing Name (Required) PICK HELP This can be an Existing Price List or Tax Codes depending upon the Mapping type selected by the user.
New Name (Required) PICK HELP This can be a New (Revised) Price List or Tax Codes depending upon the Mapping type selected by the user.
Conversion Rate (Optional) ENTER If any foreign currency Price List is considered for mapping, then the user needs to specify the Conversion rate here.
Effective from Date (Required) ENTER This meant for the retrospective date from this the tax / Price list has been changed.
Effective to Date (Required) ENTER This meant for the end date up to which the mapping will be done.

After entering the proper details the User needs to save this screen and system will generate a batch id.

Concurrent Request

After entering mapping details, user has to run a concurrent request to identify the transactions, which are to be considered for raising Supplementary Invoices, Credit Memo & Debit Memo by specifying the respective Batch_Id.

In Oracle Financials for India, navigate to India Local Enter Transaction from India Local Receivables > Reports > Other > Run > Single Request > India > Generate Suggestive Supplementary Transactions.

Choose Batch ID. This should be number generated in the ‘Batch id’ field of Price/Tax/Assessable Value changes window.

Generate / Memos / Invoices

After running the concurrent request, you can find the Supplementary Transaction for which the Supplementary Debit Memos and Credit Memos will be raised.

In Oracle Receivables - India Localization, navigate to the Supplementary transactions window as follows:

India Local Receivables > Transactions > Supplementary Transaction > Generate DR/CR Memos/Invoices

Field Description Type Action Description
Ledger (Required) PICK HELP Ledger name needs to be entered by the user from the LOV in which the user wants to view the Supplementary Transaction.
Customer Name (Optional) PICK HELP If the User wants to view the supplementary transactions, which are related to a particular Customer, then he can specify that Customer name here by selecting from the LOV.
Customer Site (Optional) PICK HELP If the User wants to view the Supplementary Transactions that are related to a particular Customer Site, then he can specify that Customer Site here by selecting from the LOV.
Organization (Optional) PICK HELP If the User wants to view the Supplementary Transactions which are related to a particular Organization, then he can specify that Organization here by selecting from the LOV.
Invoice No (Optional) PICK HELP If the User wants to view the Supplementary Transactions which are related to a particular Invoice, then he can specify that Invoice Number here by selecting from the LOV.
Invoice Date (Optional) PICK HELP If the User wants to view the Supplementary Transactions for specific Invoice Date, then he can specify that Invoice Date.
Status (Optional) PICK HELP This represents the status of the Supplementary Transactions. The quick fields available are ‘Invoice Raised’ and ‘Invoice not raised’
Processed Date (Optional) PICK HELP If the User wants to view the Supplementary Transactions for specific Process Date, then he can specify that Date.
Supplementary transactions (Optional) PICK HELP This represents type of Supplementary Transactions. The quick fields available are ‘Supplementary Invoice ’, ‘Credit Memo’ and ‘Debit Memo’.
Suppl. Inv. Type      
Batch Id (Optional) PICK HELP This represents Batch Id for which the Supplementary Transactions are processed.

The User can view the calculated Supplementary Invoices and Credit Memos through this screen and generate Supplementary Invoice and Credit Memos.

In Oracle Financials for India, navigate to the India Local Supplementary Transaction from India Local Receivables > Transactions > Supplementary Transaction > Generate DR/CR Memos/Invoices

The following facilities are available in this screen for the user:

The User can select all the transaction or an individual transaction for which Supplementary Invoice/Credit Memo will be raised. In addition, the user can consolidate two or more transaction and raise a single Supplementary Invoice/Credit Memo. After the user confirms a Supplementary Transaction, that transaction can be exported to AR transactions form.

Field Description Type Action Description
Supplementary transaction block      
Raise Invoice (Required) CHECK Once the User confirms a Supplementary Transaction, then he can enable this check box to export that transaction to AR transactions
Supplementary Invoice Type (Displayed)   The supplementary transactions type like ‘Supplementary Invoice’, ‘Credit Memo’ and ‘Debit Memo’ will be displayed here.
Invoice Number (Displayed)   The Original Invoice Number will be displayed here.
Invoice Date (Displayed)   The Original Invoice Date will be displayed here.
Customer Number (Displayed)   Customer Number for whom the Original Invoice was raised will be displayed here.
Customer Name (Displayed)   Customer Name for whom the Original Invoice was raised will be displayed here.
Existing Amount (Displayed)   Original Invoice Line Amount + Tax line amount of the Original Invoice will be displayed here.

Important: The details for this Existing amount can be seen in the Existing Amount details Block.

Revised Amount (Displayed)   Revised Amount + Revised Tax amount on account of Price/Tax/Assessable Price changes will be displayed here.

Important: The details for this Revised amount can be seen in the Revised Amount details Block.

Line Difference (Displayed)   Line Amount Difference on account of Price changes will only be displayed here.
Excise Difference (Displayed)   Excise amount Difference on account of Price/Tax/Assessable Price changes will only be displayed here.
Other Tax Difference (Displayed)   Taxes other than Excise amount Difference on account of Price/Tax/Assessable Price changes will only be displayed here.
Suppl Inv.Status (Displayed)   The Status like ‘Invoice Raised’ and ‘Not Raised’ will be displayed here.
Set of Book Name (Displayed)   Set of Book Name will be displayed here.
Customer Site (Displayed)   Customer Site (Bill to) will be displayed here.
Functional Currency (Displayed)   Functional currency for a Set of Book will be displayed here.
Field Description Type Action Description
Organization (Displayed)   Organization Name will be displayed here.
Process date (Displayed)   Process date will be displayed here.
Existing amount Block      
Existing Net Sales (Displayed)   The Original Invoice Line amount will be displayed here.
Existing Excise Amount (Displayed)   The Original Invoice Tax amount of excise type alone displayed here.
Existing other taxes (Displayed)   The Original Invoice Taxes amount other than of Excise Type will be displayed here.
New amount Block      
New Net Sales (Displayed)   The New Invoice Line amount will be displayed here.
New Excise Amount (Displayed)   The New Invoice Tax amount of excise type alone displayed here.
New other taxes (Displayed)   The New Invoice Taxes amount other than of Excise Type will be displayed here.
Select All Button     After verifying the Supplementary transaction , if the user wants to mark all the transaction which are to be exported to AP Invoices, then he can use this button.
Consolidate   CHECK BOX If the User wants to consolidate two or more supplementary Invoices or Credit Memos, then he needs to enable consolidate check box after marking the respective transaction lines.
Export Button     The marked transaction will be exported into AR transaction table through this button.
Line Details button     Users can view the Lines details form
Field Description Type Action Description
Header Details block      
Invoice Number (Displayed)   Original Invoice Number will be displayed here.
Supplementary Invoice Type (Displayed)   The corresponding Supplementary Invoice Type will be displayed here.
Existing Amount (Displayed)   Original Invoice Line Amount + Tax line amount of the Original Invoice will be displayed here.
Revised Amount (Displayed)   Revised Amount + Revised Tax Amount on account of Price/Tax/Assessable Price changes will be displayed here.
Line Details block      
Line No (Displayed)   Line No of an Original Invoice will be displayed here.
Item (Displayed)   Item in a line of original Invoice will be displayed here.
Description (Displayed)   Description of an Item in a line of the original Invoice will be displayed here.
Quantity (Displayed)   Number quantity of an Item in a line of the original Invoice will be displayed here.
UOM (Displayed)   UOM of the above item will be displayed here.
Old Selling Price (Displayed)   Existing selling price as appearing in the original Invoice will be displayed here.
New selling price (Displayed)   New selling price as per the Revised Price List for an item will be displayed here.
Difference Amount (Displayed)   Line Amount Difference on account of Price changes will only be displayed here.
Difference Excise Amount (Displayed)   Excise amount Difference on account of Price/Tax/Assessable Price changes will only be displayed here.
Difference other Tax (Displayed)   Taxes other than Excise amount Difference on account of Price/Tax/Assessable Price changes will only be displayed here.
Tax Details button     User can view the Tax details for a Line by invoking the Tax Details button as well as modify the tax line amount and delete unwanted Tax lines.
Field Description Type Action Description
Line No (Displayed)   The respective Line No of the Tax screen will be displayed here.
Existing Tax (Displayed)   The Existing Tax Code will be displayed here.
Existing Tax Type (Displayed)   The Existing Tax type will be displayed here.
Existing Tax Rate (Displayed)   The Existing Tax rate will be displayed here.
Qty Rate (Displayed)   In the case UOM type of tax, Tax Rate per UOM will be displayed here.
UOM (Displayed)   UOM for a Existing Tax will be displayed here.
New Tax (Displayed)   The Revised (new) Tax Code will be displayed here.
New Tax Type (Displayed)    

The Revised Tax type will be displayed here.

Field Description Type Action Description
New Tax Rate (Displayed)   The Revised Tax rate will be displayed here.
New Qty Rate (Displayed)    
      In the case UOM type of tax, Revised Tax Rate per UOM will be displayed here.
New UOM (Displayed)   UOM for a Revised Tax will be displayed here.
Existing Tax Amount (Displayed)   Existing Tax amount as per the Original Invoice tax lines will be displayed here.
New Tax Amount (Displayed)   Revised Tax amount as per the Revised Invoice tax line will be displayed here.
Difference Amount (Displayed/Editable)   Difference amount in the Tax lines will be displayed here.

You can modify the Tax line only in the following manner:

In addition, the user needs to save the tax screen after verifying the Tax calculation.

By using the Export Button, a user can transfer the supplementary Invoices to the AR transaction screen and needs to run the Auto Invoice Program to raise the Supplementary Invoice/Credit Memo.

Proper transaction sources needs to be defined in receivables for supplementary transactions. For set up, please refer to the post installation setups.

If you wish to consolidate two or more supplementary Invoices or Credit Memos, you must enable the consolidate checkbox after marking the respective transaction lines.

The transactions to be consolidated should have the same transaction currency; otherwise the consolidated Invoice will be incorrect.

Reports

Receivables generates these reports for India:

Supplementary Transaction Details Report - Lists Supplementary Invoices and Credit Memos raised or to be raised for the Original Invoice.

Supplementary Invoice Consolidation Report - Lists the Consolidated Supplementary Invoice raised for the period.

Duty Drawback Processing

Drawback means the rebate on duty chargeable on any imported material or excisable material used in manufacture or processing of goods that are manufactured in India and exported out of India. The duty drawback is equal to sum of

Custom Duty paid on Imported Inputs.

Excise Duty paid on Indigenous Inputs.

No Duty Drawback is allowed if

The input is obtained without payment of any Custom Duty under various exemptions schemes, OR

CENVAT credit is claimed on the indigenous inputs OR

If there is a negative value addition to the goods i.e. the value of exported goods is less than the imported goods.

Basic Business Needs

In your Business you should be able to:

Associate Proof of Export (POE) details for export type of Sales Invoice, Calculate Duty drawback by, identifying the lowest level components used in production of finished goods and then trace the receipt of each component and corresponding document of payment of duty.

Ensure that an Invoice is considered only once for claim.

Ensure that a receipt is considered only to the extent not claimed.

Reverse the CENVAT claimed if duty drawback is to be claimed.

Print duty drawback claim report giving Invoice wise details of input component, details of Excise/Customs Duty payment document and claim amount.

Major Features

Maintenance of Proof of Export (POE)

For export type of removals, you are able to associate POE details.

Maintenance of Duty Drawback claimable

You are provided with option to capture duty drawback claimable with each tax name of type ‘Customs’ or ‘CVD’.

Submission of Duty Drawback claims

You are provided with facilities for Generation of Duty drawback claims (Automatic) this will give you choice of receipt selection method, i.e. FIFO or LIFO Generation of Duty drawback claims (Manual) in addition to choice of receipt selection this will give you choice of selection of individual Receipt.

Report to help tracking duty draw back.

Duty drawback processing will:

Ensure that an Invoice is considered only once for claim.

Ensure that a receipt is considered only to the extent not claimed.

Reverse the CENVAT claimed if duty drawback is to be claimed.

TDS Certificates Received Overview

For certain sales where Tax Deduction at Source is applicable, the customer would make provision for such deduction and issue a Certificate in Form 16A. You can use the TDS Certificates feature of Oracle Financials for India to record the details of the Certificate received and the deduction details. In addition, the user can create Credit Memo through Auto Invoice in the Interface menu by specifying Request name as Auto Invoice Master Program, Invoice source as TDS Credit Memo, From / to Customer for whom he wants to create the Credit Memo and default date. It is imperative that ‘Customer Additional Information’ is setup along with Transaction source & Transaction Type as specified in this document to successfully import the TDS Credit Memo. The feature is only for recording of TDS Certificates received from Customers and is not for any issue of TDS Certificates to Customers for deducting TDS against Discounts/Schemes/Credit Memo etc.

The TDS Certificates feature lets you track the TDS Certificates received from the customer. You can:

In Oracle Financials for India, navigate to India Local Receivables > India Localization > Collections > TDS Certificates.

Field Description Type Action Description
Customer Name (Required) EDIT HELP PICK The used needs to select Customer Name from the LOV. Only those Customers who have Localization setup are shown here
Customer Number (Defaulted)   This will be a default value or the user can select from LOV. Only those Customers who have Localization setup are shown here
Location (Required) EDIT HELP PICK The user needs to specify the Location of the customer from LOV. Only those Customer Locations having Invoices are shown here.
Memo Line (Optional) EDIT PICK The user needs to specify the Memo line from LOV which help in determination of Accounting segments when auto accounting is used.
Name Required EDIT TDS Certificate Name can be entered in this field
Number Required EDIT An alpha numeric value can be entered for recording TDS Certificate number
Certificate Date Required EDIT PICK The TDS Certificate Date is to be entered here
Received Date Required EDIT PICK The Date of receipt of TDS Certificate is to be entered here
Amount Required EDIT The Amount of TDS Certificate that has been received
Description Required EDIT The narration / user enterable details against this TDS Certificate.

Reports

Receivables generates this report for India:

India - Receivable Tracking Report - This report lists the certificates received from the customers and its corresponding details.

Setting Up Concurrent Programs

India - Local Concurrent for processing order lines to AR

The India - Local Concurrent for processing order lines to AR program handles localization tax flow from Order Management to Receivables. This program captures localization taxes in Shipments and inserts Tax lines in AR Invoices and Credit Memos imported from Order Management. You have to schedule the concurrent to submit the request at suitable intervals. Please make it mandatory to Schedule this concurrent program.

The concurrent ‘AR Tax and Freight Defaultation’ would automatically run to Insert Tax lines in AR Invoices created manually.

India Local Receivables - Reports - Other - Submit Requests - Select ‘India Local Concurrent For Processing Order Lines to AR’ - Schedule

Important: You can schedule this concurrent either for the current Operating Unit or for all Operating Units. In order to run this for all Operating Units, enter ‘Yes’ in ‘Process for All Operating Units’ parameter.

If the Concurrent is being run / scheduled for all Operating Units, the Parameter for Process for All Organizations has to be set as “No” else it will result in data inconsistency.

This Request will not process Records that are revenue recognized / GL Posted and hence it is imperative that this Request be run prior to revenue recognition & GL Posting. Any errors should be cleared prior to GL Posting.

Setting Incompatibilities

India - Importing Excise Invoice Numbers to AR

From ONT Patchset ‘H’, when interface trip stop happens, first Order Management Interface occurs and then the Inventory Interface occurs. This is reverse to what was happening prior to ONT patchset ‘H’.

Due to this reason when shipment is done, interface trip stop gets executed and in case the inventory interface goes into warning due to reasons unknown, the delivery id of the shipment does not feature in the excise Invoice generation programs parameter.

As the Order Management interface is completed, this order is interfaced to AR and an AR Invoice is created.

When Excise Invoice number generation happens after the AR Invoice is created, localization AR tables do not have Excise Invoice number imported from Localization Shipping Tables. In short, Excise Invoice Number present in fulfilled orders localized screen is not imported to AR localization tables.

This program is encapsulated as a stored procedure and takes the Start Date, End Date and Invoice number as the parameter. This parameter shows a list of all Invoice numbers where Excise Invoice number is generated in shipment but is not present in the AR tables.

The concurrent program can be invoked by submitting a single request from the Other Reports request group in India Local Receivables Responsibility. You can also schedule this concurrent request in case these issues are frequent in your instance.

India - ST Forms Receipt Processing

Submitting ‘India - ST Forms Receipt Processing’ concurrent program would generate Invoice details required for Receiving Sales Tax Forms.

This concurrent program is available in India Local Receivables Responsibility. This request would check for all Invoices that have Sales Tax with concessional Form applicability. Only validated Invoices would be considered for processing. The Invoice would be considered for Processing only if it was not processed earlier. Processed Invoices would be considered conditionally based on the changes to the document. This concurrent is for processing data and does not result in any printable output.

You can submit this request from:

India Local Receivables - Reports - Other Reports - ‘India - ST Forms Receipt processing’

Field Description Type Action Description
Operating Unit (Display Only)   Value determined from the Profile values
From Date Mandatory   Low Value of Invoice Date to filter the Invoices
To Date Mandatory   High Value of Invoice Date to filter the Invoices
Process for All Operating Units?     If you select ‘Yes’ in this field, then, the program would process Invoices corresponding to all Operating Units defined in the system. Else, only those related to the Operating Unit determined from Profile would be processed.
Customer     This will be used to filter the data related to given Customer, otherwise all Customer’s related data is processed.
Customer Site     This will be used to filter the data related to given Customer site, otherwise all Customer Site’s related data is processed.
Enable Trace     On selecting ‘Yes’ in this field, a Raw Trace File would be generated for this request.
It is a prerequisite to have ‘Enable Trace’ checked for ‘India - ST Forms Issue Processing’ Concurrent Program.

India - Program to Generate eTCS Quarterly Returns

Use the Submit Requests from India Local Receivables and enter India - Program to Generate eTCS Quarterly Returns in the Name field to submit the concurrent request.

Concurrent Parameters

Field Description Type Action Description
Legal Entity Required PICK The Legal Entity for which the report is being generated.
Org TAN Number Required PICK The Organization TAN Number for which the report is being generated.
Organization Required PICK The Inventory Organization for which the report is being generated.
Financial Year Required PICK The Financial year for which the report is being generated.
Quarter of the Fiscal Year Required PICK The Quarter of the Fiscal year for which the report is being generated.
Collection Code Required PICK The Collection code for which the report is being generated. This can be any of the following values:
  • Alcoholic liquor for human consumption

  • Timber obtained under a forest lease

  • Timber obtained under any mode other than forest lease

  • Any other forest product not being timber or tendu leave

  • Scrap

  • Parking Lot

  • Toll Plaza

  • Mining and Quarrying

  • Tendu Leaves

Tax Authority Required PICK The Tax authority for which the report is being generated.
Tax Authority Site Optional PICK The Tax authority site for which the report is being generated.
Seller Name Required   The Seller Name that needs to appear on the report.
Seller State Required PICK The Seller State that needs to appear on the report.
Address Changed since Last Return? Required PICK Enter ‘Yes’ or ‘No’ to the question of ‘Address Changed since last return’.
Collector Status Required PICK The Collector Status of ‘Central Government’ or ‘Others’ that needs to appear on the report.
Person Responsible for Collection Required   The Name of Person responsible which needs to be printed on the report.
Designation of Person Responsible Required   The Designation of Person responsible which needs to be printed on the report.
Address of the Person Responsible Required   The Address of Person responsible which needs to be printed on the report.
State of the Person Responsible Required   The State of Person responsible which needs to be printed on the report.
PIN of the Person Responsible Required   The PIN Code (Postal Code) of Person responsible which needs to be printed on the report.
Responsible Person’s Address Changed since Last Return ? Required   Enter ‘Yes’ or ‘No’ to the question of ‘Responsible Person’s address changed since last return’.
Start Date Optional   The start date from which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.
End Date Optional   The end date till which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.
Provisional Receipt Number Optional PICK The Provisional Receipt Number in case the return has been filed earlier.
File Path Required PICK The file Path where the Flat file needs to be located. Ensure that write permission exists for the given file path.
File Name Required PICK The name of the Flat file that is generated.
Action Event Required PICK The Concurrent can be run with any one of the following three parameters :
  • F – Generate the Flat File

  • H - Generate the Flat File with Headers

  • V – Validate the Data

This concurrent will not generate a report output but would generate a flat file at you specified location, which can be used to file eTCS Quarterly returns.

India - Program to Generate eTCS Yearly Returns

Use the Submit Requests from India Local Receivables and enter India - Program to Generate eTCS Yearly Returns in the Name field to submit the concurrent request.

Concurrent Parameters

Field Description Type Action Description
Legal Entity Required PICK The Legal Entity for which the report is being generated.
Org TAN Number Required PICK The Organization TAN Number for which the report is being generated.
Organization Required PICK The Inventory Organization for which the report is being generated.
Financial Year Required PICK The Financial year for which the report is being generated.
Collection Code Required PICK The Collection code for which the report is being generated. This can be any of the following values:
  • Alcoholic liquor for human consumption

  • Timber obtained under a forest lease

  • Timber obtained under any mode other than forest lease

  • Any other forest product not being timber or tendu leave

  • Scrap

  • Parking Lot

  • Toll Plaza

  • Mining and Quarrying

  • Tendu Leaves

Tax Authority Required PICK The Tax authority for which the report is being generated.
Tax Authority Site Optional PICK The Tax authority site for which the report is being generated.
Seller Name Required   The Seller Name that needs to appear on the report.
Seller State Required PICK The Seller State that needs to appear on the report.
Address Changed since Last Return? Required PICK Enter ‘Yes’ or ‘No’ to the question of ‘Address Changed since last return’.
Collector Status Required PICK The Collector Status of ‘Central Government’ or ‘Others’ that needs to appear on the report.
Person Responsible for Collection Required   The Name of Person responsible which needs to be printed on the report.
Designation of Person Responsible Required   The Designation of Person responsible which needs to be printed on the report.
Address of the Person Responsible Required   The Address of Person responsible which needs to be printed on the report.
State of the Person Responsible Required   The State of Person responsible which needs to be printed on the report.
PIN of the Person Responsible Required   The PIN Code (Postal Code) of Person responsible which needs to be printed on the report.
Responsible Person’s Address Changed since Last Return ? Required   Enter ‘Yes’ or ‘No’ to the question of ‘Responsible Person’s address changed since last return’.
Start Date Optional   The start date from which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.
End Date Optional   The end date till which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.
Provisional Receipt Number Optional PICK The Provisional Receipt Number in case the return has been filed earlier.
File Path Required PICK The file Path where the Flat file needs to be located. Ensure that write permission exists for the given file path.
File Name Required PICK The name of the Flat file that is generated.
Generate Headers Required PICK The Concurrent can be run with any one of the following two parameters:
  • No – Generate the Flat File

  • Yes - Generate the Flat File with Headers

This concurrent will not generate a report output but will generate a flat file at your specified location, which can be used to file eTCS Annual returns.

Managing Receivables Transactions

This Section elaborates Transaction cycles in India Localization Accounts Receivables Module. This section gives further details on using Transactions (Localized), AR-3A Form Tracking, Supplementary Invoices and TDS Certificates Received.

Transactions (Localized)

Transactions with localized taxes can be created in the Receivables Module. The taxes will get calculated for the item based on the tax defaulting set ups or taxes can be added to the transactions manually.

Transactions in AR with can be created through the Auto Invoicing where the transactions done in Order Management Module will get interfaced to the Receivables Module. The taxes from the Order Management Module will be interfaced to AR while running the Auto Invoice Program.

The other option is to create stand-alone AR transactions in AR with localization taxes. Based on the tax defaulting set up the localization taxes and freight will get calculated for the transaction. Based on the set up in Bond Register, Excise transactions will get recorded in the respective Excise Records and Excise Invoices can be created. User needs to select appropriate transaction sources which are associated wit bond register for updating the excise related registers and records. If the user selects a transaction source that is not associated with the Bond Register no updates will be done in the Excise Registers and no Excise Invoice will get generated for the transaction.

Important: If a transaction is created with Excise Duty and completed by clicking the complete button, user should not un apply the transactions. If the user un applies the transaction, the excise taxes debited in the Excise Registers will not be reversed and this might lead to further complications in adhering to the Excise Rules and Procedures.

Also note that base applications recalculates taxes on the event of Incompletion and Completion. Thus localization taxes would be replaced with ZERO if user Incompletes and Completes an already Completed Invoice. The Incompletion feature should not be used for making corrections to Invoice imported from Order Management else the taxes would get replaced with zero in the base applications screen.

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

India Local Receivable > India Localization > Transactions > Transactions (Localized)

The User can navigate through the Select Receipts button to perform the Matching of Receipts quantity. Once the user saves the Matching Screen, Excise Tax Amount will be replaced by the Excise Amount from the Receipt Tax Line for the proportionate quantity.

Field Description Type Action Description
Operating Unit (Required) (Pick) The Operating Unit for which the Transaction is being entered.
Organization (Required) EDIT HELP PICK The user needs to specify the Inventory Organization name from LOV in which the transactions is going to be accounted
Location (Required) EDIT HELP PICK The user needs to specify the Location of an Inventory Organization from LOV in which the transaction is going to be accounted.

After entering the above information the user can navigate to Enter Invoice Standard Apps form where the transaction Number, Customer details and Item details will be entered to create a transaction, save and complete the Standard Apps transaction. Depending upon the Tax category attached to the item for the customer, the tax lines will be defaulted.

Important: If the user enters a Transaction using Transactions screen directly without navigating through Transactions (Localized) screen, the above Organization & Location are not captured for the mentioned transaction. This would result in such transaction not being query enabled on the Transactions (Localized) Screen even at a latter date.

Field Description Type Action Description
Customer Name (Defaulted)   The Customer name will be defaulted here after the Transaction has been entered in Standard Applications form.
Customer Number (Defaulted)   This will be the defaulted Customer Number.
Transaction Number (Displayed)   The Transaction number will be displayed here once the user has entered and saved the data in the Standard Apps Form.
Transaction Type (Displayed)   This will be displayed depending upon the transaction type selected in the Standard Apps Form.
Source (Displayed)   This will be displayed depending upon the source selected in the Standard Apps Form.
Excise Exemption Type (Required/Optional)   If the user needs to carry out an exempted transaction, the exemption type needs to be selected from this field. For transactions on payment of duty, this field needs to be left as null. Whenever the user picks for an Excise Exempted Transaction the user needs to enable the excise exempted flag in the line level.
Excise Exemption date (Required/Optional)   The user needs to enter date CT2 form, CT3 form , Excise Exemption Certificate respectively.
Excise Exemption Ref. No. (Required/Optional)   The user can enter CT2 Form No , CT3 Form No, Excise Exemption Certificate Number based on the above Exemption type he selected.
VAT Exemption Type (Optional)   If you need to carry out an VAT Exempted Transaction, the exemption type needs to be picked up in this field. For transactions where VAT is payable, this field need to be left as null. Whenever you pick for an VAT Exempted Transaction, all the lines get the VAT Exempted Flag and the VAT Exemption type defaulted. If for any line, VAT exemption is not applicable, then you can uncheck the VAT exemption for such line. The VAT Exemption types are:
Vat Exemption Item
Export
Inter State Sale
Sale to Specified parties
Transfer
VAT Exemption Date (Required/Optional)   This field is required when VAT Exemption Type is selected.
VAT Exemption Refno (Required/Optional)   This field is required when VAT Exemption Type is selected.
Tax Amount Block      
Tax Total (Displayed)   Tax amount of the Standard Apps Form will be displayed here.
Line Total (Displayed)   Total amount of the transaction including tax for a line will be displayed here.
Transaction Total (Displayed)   The total transaction amount will be displayed here.
Update RG Flag (Displayed)   This will be enabled only when the transaction batch source is having an association with any of the Four Register Types being Bond Register (For Exports), Domestic with Excise, Domestic without Excise, Export with Excise for that Organization and Location. The user can update the flag when the check box is checked to make it unchecked. The vice versa is not possible.

Important: By default, the duty will get debited in the register based on the register preference set up in the Additional Supplier Information. User has an option to change the duty paying register for each transaction.

Field Description Type Action Description
Line block (Conditionally Required)   In the case of CT2 and CT3 Transaction, Form AR3A needs to be accompanied with the shipment, then the User needs to specify the AR3A form Number in this field. AR3A form tracking will be done for Customer wise which will be useful to the User to follow up the outstanding AR3A form from his Customer in order to submit to the Excise Dept.
Line Number (Displayed)   The line number is displayed here.
AR 3 A form Date (Conditionally Required)   AR3A form date needs to be entered here by the User.
Exempted Flag (Conditionally Required) CHECK BOX The user needs to enable this Flag to do a transaction under any of the above exempted type for a line item.
VAT Exemption Flag   CHECK BOX Once at header level a Invoice is marked as VAT Exempt, this check box will get checked. If any particular line is not supposed to be VAT Exempt, the box should be unchecked.
VAT Exemption Type (Optional)   If you need to carry out an VAT Exempted Transaction, the exemption type needs to be picked up in this field. For transactions where VAT is payable, this field need to be left as null. Whenever you pick for an VAT Exempted Transaction, all the lines get the VAT exempted flag and the VAT Exemption type defaulted. If for any line, VAT Exemption is not applicable, then you can uncheck the VAT exemption for such line. The VAT exemption types are:
  • Vat Exemption item

  • Export

  • Inter State Sale

  • Sale to Specified parties

  • Transfer

VAT Exemption Date (Required/Optional)   This field is required when VAT Exemption Type is selected.
VAT Exemption Refno (Required/Optional)   This field is required when VAT Exemption Type is selected.
[ ] Optional EDIT Enter line-specific additional detail and Save.

The following buttons are available in the Enter Transaction India Localization form and their features.

Button name Description Purpose
Open Button For creating transactions in stand alone AR with localization taxes, user needs to navigates to the Standard Application transaction screen only through the Transaction - Localized Screen. Before opening the Standard Application Transaction Screen, user needs to specify the Organization and Location in the Localization Screen. The user can open Standard Apps Transaction form through this button.
Select Register User needs to open the select register button only if he needs to change the Duty Paying Registers, which are being defaulted. The user can select Excise Register, which is to be for a transaction. The
Register will be defaulted as per the preference set in Organization Additional Information but the user is empowered to change the Register by using this button. Such change can only be made if It is a inventory item and the balance in register is sufficient to cover the Excise Duty Payment
Taxes User needs to verify the taxes that are being defaulted based on the tax defaulting set ups. He can modify the taxes if required.
This can be done by clicking the taxes button.
The user can view tax lines and modify the tax lines for a transaction.

After entering the above information, the user can navigate to Enter Invoice Standard Apps form through that the Transaction Number, Customer details and Item details will be entered. Save and Complete the Standard Apps form and depending upon the Tax Category attached to the Item for a Customers, the tax lines will be defaulted.

If the Tax lines has Excise Type of Tax then the System by itself will default the Excise Record to be used for the transaction depending upon the Order of Reference defined for Excise Record in the Organization Accounts Information. However, the user can change the Register and Excise Invoice Number will be allotted once the transaction is completed in the Enter Transaction India Localization Form. After Save and Close the above Standard Apps Form.

If the ‘Taxes’ Button is clicked for a once completed Transaction, System will show the following message:

It is imperative that Taxes are available on the Invoice prior to completion. Hence On trying to complete a Invoice when the concurrent ‘AR Tax and Freight Defaultation’ is running, System will show the following message :

In the above case, you need to allow the concurrent to complete, requery the Invoice and then complete.

On similar lines, it is required that the Localization taxes get processed prior to GL Posting. Hence if you try to Post a record to GL when the Taxes for the same are not yet processed, GL Posting will result in the following error:

'AR-ARGLTP: -20131 ORA-20131: India Taxes found in ja_in_temp_lines_insert table. "

This is as per intended behavior of the product to stop you from GL Posting AR Transactions where India Localization Tax processing is pending. The above error is applicable for both Manually entered transactions as well as Imported transactions from Order Management. You can find details of such transaction by running the following query for the month where you are trying to GL Post:

Select * from ja_in_temp_lines_insert;

Note: You can view the GL Drilldown Accounting entries by clicking Show Transactions on the Tools Menu in Enter Transaction India Localization form.

Reprocessing Errored OM Tax Records

The concurrent ‘India Local Concurrent for processing Tax Lines to AR’ for processing of Tax Lines for Invoices created through Order Management runs in batch mode. Whenever, some of the Tax Lines remain unprocessed due to some error, the error message is captured by localization. This feature provides with an option to view these error records and corresponding messages and mark them eligible for Reprocess. You would also have an option to delete these records.

To view the error records, navigate to

India Local Receivables - Control - India - Resubmit AR Tax and Freight

The form shows Invoice Number, Number of distribution Lines, Customer Id, Customer Name, Total Tax Amount, Last Updated Date and Error Message for all Tax Lines (grouped by Invoice Number) that have ended in an error during ‘India Local Concurrent for processing Tax lines to AR’ program.

The user can check the records for resubmitting only one at a time

For Resubmission of the Error Invoices

Check 'Re-Submit' for the Invoices that need to be resubmitted Click on ‘Submit’ button.

Submit the concurrent ‘India Local Concurrent for processing Tax lines to AR’ for these Invoices to get processed.

For Deletion of the Error Invoices

Check 'Delete' for the Invoices that need to be deleted.

Click on Submit button.

The above delete option is mainly useful in cases where the Debit Memo for Taxes has already been raised for the Tax Amount & the Tax Line is no longer required to be processed. This marks the line as deleted & does not show the record next time as eligible for reprocessing.

Important: The form would merely show / display the Invoices eligible for reprocessing. You have to explicitly run the concurrent ‘India Local Concurrent for processing Tax lines to AR’ for these Invoices to get processed.

Caution: It is advisable to check this Form Prior to Running GL Posting and clear all the records from this Form. Base Applications Revenue Recognition Program does not post a tax line if it does not have a revenue attached and hence if resubmission option is used for a record post GL Posting then such record remains as an unposted tax line & interferes with period closing. In case of such event happening, the only option is to mark such tax line as posted with a data fix & pass manual entries for the tax amount in GL.

Resubmission of a record post GL Posting will not result in processing of the record & will remain stuck in the form. The only option post GL posting is to delete the record using this Form & pass manual Debit Memo for the tax portion to rectify the receivable amount.

With the current architecture, GL Posting is stopped for a transaction if the taxes are found to be stuck in the above form. GL Posting would show the following error:

“AR-ARGLTP: -20131 ORA-20131: India Taxes found in ja_in_temp_lines_insert table. "

You need to either get the taxes processed or deleted (post necessary correction of receivable amount) prior to GL Posting such stuck records.

Using Sales Tax Declaration Forms - Receipt Tracking

Sales by Registered Dealers, to Registered Dealer would be eligible for Concessional Rate of Sales Tax. This would require identification of transactions that are eligible for such rates. Also, the Declaration Form to be issued by the Buyer in order to avail such rate.

You can record details of Sales Tax declaration forms for each of the Sales Invoice. India Localization provides you with a feature to define Form Names, Define Taxes with Declaration Forms attached, Tracking Invoices for which these Forms have to be received, Record details of Forms received and query and view the Received Form details.

Prerequisites

Before creating the Transactions with Concessional Rates of Sales Tax, following setups need to be done:

Before you record details of Concessional Forms to be issued to Supplier, following need to be done:

Recording details of Sales Tax Declaration Forms:

To record details of Sales Tax Declaration forms, navigate to ‘Define Sales Tax Form Details’ window as follows

India Local Receivables - Customers - Receipt ST Forms

In ‘Find ST Form Details’ screen, enter the Customer Name, Customer Site and Form Type in order to query for Invoices against which Forms are not yet received. You can enter other query criteria to find specific Invoice.

Details to enter in each of the fields would form criteria for the records fetched.

You can fetch specific records based on the values entered in the query criteria.

The field wise description for the screen "Find Sales Tax Form Details" to receive the ST Forms is given below

Field Description Type Action Description
Find ST form Details
Issue/Receipt (Display only)   This field gets populated as Issue / Receipt based upon the Responsibility Selected.
Issue in case of Payables and Receipt in case of Receivables.
Party Name     Party Name as defined in the ST form related data. Compared against the Party Name as available in the Invoices to which Sales Tax Forms is applicable.
Party Site     Party Site as available in the Invoices to which Sales Tax Forms is applicable.
Form Type     Form Type’s which are applicable to the Sales Tax attached to the Invoices.
Invoice from Date     Invoices having Invoice Date starting from this date onwards would form a part of the query criteria for matching. Viewing matched records. Should be a valid date in ‘DD-MON-YYYY’ format
Invoice To Date     Invoices having Invoice Date till this date would form a part of the query criteria for matching. Viewing matched records Should be a valid date in ‘DD-MON-YYYY’ format
Fin Year     Fin year as applicable to the ST Form related data for querying already entered Forms.
Form Number     Form Numbers that are issued to the Supplier, Supplier Site and Form Type that was earlier entered in system.
Issue/Receipt Date     Enter a Date, which might match with the Receipt Form’s Transaction Date.
View Forms Button     Button, which upon being clicked invokes the ‘View Sales Tax form Details’ Screen
Issue/Receive Forms     Button, which upon being clicked invokes the ‘Define Sales Tax form Details’ Screen

Based on the query criteria, the system fetches the Invoices to be matched. This information would be displayed in ‘Define Sales Tax Forms Details’ screen.

The find window serves the dual purpose of entry of new forms by querying of Transactions where form entry is pending and the purpose of querying already entered forms to check details.

This screen has Header and Detail sections

Header Section

This section allows you to create form detail like Fin year, Form Number Form Amount, Form Date and Transaction date. These details can be entered for a combination of Customer Name, Customer Site, Form Type and Operating Unit.

The Customer Name, Customer Site and Form Type are populated as the context information from the Query Find Screen.

Its mandatory to enter Fin Year, Form Number Form Date and Transaction date fields before proceed to the detail section to select Invoices.

You may choose to key in the Form Amount and proceed to the detail section for selecting Invoices to match the Form Amount. Else, you can leave the form amount to be automatically populated upon save, based on the sum of all Invoice level Form Amounts.

Match All

On checking Match All field, the system automates matching based on the header form amount.

To use this feature, it would be a pre-requisite to enter Fin Year, Form Number, Form Amount, and Form Date and Transaction Date fields.

The Match all Checkbox is unchecked, by default.

Un-checking the checkbox causes the detailed Invoice level form amount to be set to zero.

Queried Amount

Queried Form Amount fields displays the total Form Amount that can be matched across all unmatched Invoices.

This is a display only field and cannot be modified.

Detail Section

This section displays unmatched Invoices in Receipt Tab Page. The records would be grouped based on the combination of Invoice and Transaction Id.

The sum of all Invoices level Form Amounts entered is displayed at the bottom in the Total Form Amount display field.

Important: It is mandatory that the sum of detail level Invoice Form Amounts match with header Form Amount. This is applicable only when you enter the Form Amount.

In case of Invoices with negative tax target amounts the form amount entered should exactly be equal to that of the Tax target amount.

The amount to be tracked (Tax Target amount) reflects the base amount on which Sales Tax is calculated and does not include the sales tax amount. Viz., the amount will be net of sales tax amount and not the Invoice value.

On saving the entered details, the Header Block is refreshed and the Form details are set to blank. Also, the Detail block is refreshed and only unmatched and partially matched records are fetched. The cursor returns to the header.

Issued Forms can be viewed through the 'View Sales Tax Form Detail' Screen

The field wise description for the screen 'View Sales Tax Form Detail' to receive the ST Forms is given below

Field Description Type Action Description
Define Sales Tax Form Header Block (Matching Header)      
Party Name (Display only)   Context Information carried over from Query Find Screen
Party Site (Display only)   Context Information carried over from Query Find Screen
Form Type (Display only)   Context Information carried over from Query Find Screen
Fin Year Required   User defined Fin Year Value to be selected from list of values as defined in the Tax Year Setup
Form Number Required   Sales Tax Form Number to be defined by the user. This needs to be unique for a Party Name , Party Site, Org ID, Form Type , Party Type and Fin year combination
Form Amount     The form Amount needs to exactly match with the sum of all Invoice level detailed form amounts.
Form Date Required   Should be a valid date in ‘DD-MON-YYYY’ format
Transaction Date Required   Should be a valid date in ‘DD-MON-YYYY’ format
Match All Default Value ‘N’   Requires a valid value for Fin Year , Form Number, Form Amount, Form Date and Transaction Date when checked. Matches all the Invoice level records based on the form amount value.
When unchecked , sets all detail level Invoice form amount to 0.
Queried Form Amount (Display only)   Displays Total Form Amount that can be matched across all unmatched Invoices
Field Description Type Action Description
Sales Tax Form Detail Block (Matching Detail) - Receipt Side      
Order/Invoice (Display only)   Indicates whether the record is an Order or an Invoice. Values are ‘ORDER’, ‘INVOICE’.
Invoice Number (Display only)   This is the Invoice Number
Source Type (Display only)   This field displays the Transaction Type related to the record.
Order Number (Display only)   This field displays the Order Number. This would not be displayed for Manual AR Invoices.
Tax Target Amt (Display only)   This field displays the Taxable Basis for used for calculating Sales Tax.
Matched Amount (Display only)   This field displays the Matched Amount based on the previous matches.
Form Amount for each record cannot be greater than Matched Amount reduced from Tax Target amount for that record.
Form Amount     In case of Invoices sum of Invoice level form amount and Matched amount cannot be greater than Tax target amount.
In case of Invoices with Negative Tax Target Amounts the form amount needs to be exactly same as that of tax target amount.
Total Form Amount (Display only)   Sum of all Invoice level Form amounts.

Viewing Received Forms

You can view the Sales Tax Forms Received by clicking on the ‘View Forms’ button on the ‘Find ST Forms Details’ window. This would open ‘View Sales Tax Form Details’ window.

You will have to enter Customer, Customer Site and Form Type Details before you query for the Issued Forms.

This window has three sections Header, Details and Sub-Details.

Header Section

The section shows Customer Name, Customer Site and Form Type. These details are populated as the context information from the Query Find Screen.

Sales Tax Form Details

This section displays Form details based on the query criteria specified in the Query Find screen.

Sales Tax Form Sub-Details

This section displays all matched Invoice grouped by combination of Invoice Number and Transaction Number.

For each Invoice the Tax Target amount verses the Matched Amount is displayed based on the above grouping.

The field wise description for the screen 'View Sales Tax Form Details' form is given below.

Field Description Type Action Description
View Sales Tax Form Header Block      
Party Name (Display only)   Context Information carried over from Query Find Screen
Party Site (Display only)   Context Information carried over from Query Find Screen
Form Type (Display only)   Context Information carried over from Query Find Screen
View Sales Tax Form Detail Block
Fin Year (Display only)   Fin Year as created from the Match Detail Screen.
Form Number (Display only)   Form Number as created from the Match Detail Screen.
Form Date (Display only)   Form Date as created from the Match Detail Screen.
Transaction Date (Display only)   Transaction Date as created from the Match Detail Screen.
Form Amount (Display only)   Form Amount as created from the Match Detail Screen.
View Sales Tax Form Sub Detail Block - Receipt Side
Order/Invoice (Display only)   Indicates whether the record is an Order or an Invoice. Values are ‘ORDER’ , ‘INVOICE’.
Invoice Number (Display only)   This is the Invoice Number
Source Type (Display only)   This field displays the Transaction Type related to the record.
Order Number (Display only)   This field displays the Order Number. This would not be displayed for Manual AR Invoices.
Tax Target Amt (Display only)   This field displays the Taxable Basis for used for calculating Sales Tax.

Reports

This section provides overview and detailed descriptions of these reports:

Commercial Invoice

This Report gives you the Commercial Invoice’s generated.

PCDATA cannot be inserted: This report was for “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 / base for Client required output to generate and print Invoices. This is applicable for Trading Invoice only and not for Invoice under Manufacturing Organization.

Report Submission

Use the Other Reports in India Local Receivables form and enter India- Commercial Invoice Report in the Name field to submit the report.

Report Parameters

Organization (Optional) PICK

Enter the Organization from which delivery of goods is made

Location (optional) PICK

Enter the Location of the Organization.

Customer (Optional) PICK

Enter the Customer Name

Order/Invoice (optional)

Invoice (Required)

Commercial Invoice the user wants to take

Report Headings

Report headings provide you with general information about the contents of the report and the user entered parameters.

Column Headings

This reports provides following information

Item

Item Classification

Quantity

Total Amount

Duty Amount

Duty Per Unit

ST Form Customer Report

Use Sales Tax Forms due from the Customers to track Customers for whom you have given Sales tax discount and you have not yet received the ST Forms for an Order/Invoice.

Report Submission

Use the Submit Requests (India Local Receivables Module) form and enter India ST Forms Customer Report in the Name field to submit the report.

Report Parameters

From Date (Required)

Enter a date from which you wish to take the Sales Tax Forms Report. The date is based on the transaction date of the Invoice.

To Date (Required)

Enter an end date till which you wish to take the Sales Tax Forms Report. The date is based on the transaction date of the Invoice.

Matching Info ? (Required) PICK

This decides the type of report output

Following are the options available :

M - Matched Amount (Partial & Fully Matched) (When Matched Amount is not Zero)

P - Partially Matched (When Tax Target Amount is not equal Matched Amount)

F - Fully Matched (When Tax Target Amount not equal Matched Amount)

U - Unmatched ST forms details (When Matched Amount is 0).

Party (Optional ) PICK

Enter the party for which you wish to take the Sales Tax Forms Customer Report. It displays a list of Customer Names for those Customers for whom Localization setup is done. If not entered it will result in picking of all Customers where details are available.

Party Site (Optional) PICK

Enter the party site for which you wish to take the Sales Tax Forms Customer Report. It displays a list of Customer Sites for which Localization setup is done. If not entered it will result in picking of all sites pertaining to the Customer based on details available.

Organization (Optional ) PICK

Enter the Organization for which you wish to take the Sales Tax Forms Customer Report. It displays a list of Organizations for which Localization setup is done. If not entered it will result in picking of all Organizations based on details available.

Location (Optional ) PICK

Enter the Location for which you wish to take the Sales Tax Forms Customer Report. It displays a list of Locations for which Localization setup is done for the Organization selected earlier. If not entered it will result in picking of all locations based on details available.

Report Headings

Report headings provide you with general information about the contents of the report. Oracle lists Organization Information based on User parameter input. Organization Name, Address on the Top left Corner Organization’s LST Registration Number and CST Registration Number on the Top Right Corner

Column Headings

Party No.

Customer Number to whom the Sale was made.

Name of Customer

Name of Customer to whom the Sale was made.

Customer site

Name of Customer Site.

Order Number

The Sales Order Number is displayed in this column for a Auto Invoiced Invoice. For a manual AR Invoice , it displays “N/A”

Order Date

The Sales Order Date for the Sales Order associated with the Invoice is displayed in this column for a Auto Invoiced Invoice. For a manual AR Invoice , it displays “N/A”

Invoice Number

Invoice Number of the Invoice is displayed here. This is same as the Transaction number available in AR.

Invoice Date

Invoice date of the Invoice is displayed here. This is same as the Transaction date available in AR.

Excise Invoice Number

Excise Invoice Number for the Invoice is displayed here. This is based on the Excise Invoice Number available in AR.

Excise Invoice Date

Excise Invoice Date for the Invoice is displayed here. This is based on the Excise Invoice Date available in AR.

Invoice Amount

Displays the Total Invoice Amount of the Invoice. It includes Line amount and tax amount.

Item

Description of Item sold.

Form Type

Displays the Sales Tax Form type attached to the tax.

Tax Rate

Sales tax rate for the particular Invoice Line.

Taxable Amount

Displays the amount based on which the sales tax is calculated.

In addition to the above, the following columns are displayed in case of Matched ST Forms.

Matched Amount

This column displays the amount matched.

Form Number

This column displays the form number, which was matched.

Form Date

This column displays the form date of the form the matching was done.

Form Amount

This column displays the form amount, which was matched.

Report Order

Report is printed in the order of Inventory Organization, Customer, Customer Sales Tax Registration Number, Form type and Invoice Date for the selected parameters.

India Total Sales Report

This report gives you the total sales made from a Inventory Organization for a given period with tax details.

Report Submission

Use the Other Reports India Local Receivables form and enter India - Total Sales Report in the Name field to submit the report.

Report Parameters

Organization (Required) PICK

India Localization displays the Default Organization (default). Enter an Organization, you wish to take the Total Sales Report for.

Location (Optional) PICK

Enter a Location ( Skip for all) , you wish to take the Total Sales Report for.

Period of report (Optional )

Enter the period for which you wish to take the Total Sales report for. If From & To dates are not entered then all Sales till date will be reported.

Report Style (Optional) PICK

Following options are available ‘Show Both Detail and Summary’, ‘Show only Detail’ and ‘Show only Summary’

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

Sales Invoice No. & Date

Invoice Number and Date of Sales.

Sales Tax Registration No. of Customer

Central Sales Tax Registration No. of Customer as entered in Customer Entry Form.

Name of Customer

Name of the Customer to whom the sale was made.

Gross Amount

Gross Amount as entered in Invoice.

Line Amount

Line Amount for a line for which LST or CST exists.

Sales Tax Rate

Sales tax rate for the particular Invoice Line.

Sales tax Amount

Total sales tax amount for the ST rate for the particular Invoice Line.

Certificate Type & Number

ST Form Type & Number, if any, for the particular Invoice Line.

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 Taxes for Total Sales.

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 Invoice Date and Tax Type for the selected Organization.

Important: It is mandatory to have Ship to Address for a Invoice to appear as a Transaction in this report. The Customer should have setup of Customer Additional Information at site level.

The Invoice Created should have Sales Tax / CST or VAT type of Tax. If such type of tax is not chargeable, a Tax with 0% needs to be attached to the transaction for the same to appear in this report.

India - Debtors Ledger Report

Use this Report to get Debtor Ledger with complete details of Invoices, Debit Memos & Receipts.

Report Submission

Use the Other Reports (India Local Receivable module Only) form and enter India - Debtors Ledger Report in the Name field to submit the report.

Report Parameters

Customer Name (Optional) PICK

If the User wants Debtor Ledger for a specific Customer, then he need to enter Customer Name here otherwise Ledger for all the Customers for a given period will be reported.

Customer Number (Defaulted) PICK

Customer Number of the above Customer will be defaulted here.

Customer Type (Optional)

If the User wants Debtor Ledger for a specific Customer Type, then he need to enter Customer Type in this field otherwise Ledger for all the Customers for a given period will be reported

Start Date (Required)

End Date (Required)

Org ID (Optional) PICK

If the User wants Debtor Ledger for a specific Inventory Organization, then he needs to enter Org ID in this field otherwise Ledger for all the Organizations for a given period will be reported

Report Headings

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

Column Headings

The Opening Balance for a Customer Multiple Currency wise will be sorted first

and the Transaction for the period will be considered and the Closing Balance will be arrived in Multiple Currency.

GL Date

GL Date for the transaction will be reported.

Order No

Sales Order Number will be reported

Trx Number

Trx Number is meant for the respective Invoice, Debit Memo, Credit Memo Numbers.

Trx Date

Transaction date will be reported.

Receipt Number

Receipt Number will be reported

Receipt Date

Receipt Date will be reported

Remarks

Remarks in the respective transaction will be reported

Account Code

Respective account code of a transaction will be reported

Description

Account Code Description will be reported

Currency

Transaction currency will be reported

Exchange Rate

Payment Voucher Invoice No and Date will be reported

Transaction Dr Amt

Debit Amount in a foreign currency transaction will be reported.

Transaction Cr Amt

Credit amount in a foreign currency transaction will be reported.

Functional Dr Amt

Rupee equivalent for the Debit amount will be reported.

Functional Cr Amt

Rupee equivalent for the Credit amount will be reported.

Debtors Trial Balance Report

Report Submission

Use the Submit Requests (India Local AR modules Only) form and enter India- Debtors Trial Balance in the Name field to submit the report.

Report Parameters

Customer Name (Optional) PICK

If the User wants Debtor Trial Balance for a specific Customer, then he need to enter Customer Name here otherwise Trial Balance for all the Customers for a given period will be reported.

Customer Number (Defaulted) PICK

Customer Number of the above Customer will be defaulted here.

Customer Type (Optional)

If the User wants Debtor Trial Balance for a specific Customer Type , then he need to enter Customer Type in this field otherwise Debtor Trail balance for all the Customers for a given period will be reported

Start Date (Required)

End Date (Required)

Report Headings

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

Column Headings

Sl.No

Serial Number of the Trial Balance will be reported.

Customer Type

Customer Type will be reported

Customer Name

Customer Name will be reported.

Customer Code

Customer Code (Number) will be reported.

Currency

The Transaction currency will be reported.

Entered Amount

Closing Balance of a Customer in Foreign currency will be reported.

Rupee Amount

Rupee equivalent of a Customer will be reported

Supplementary Transaction Details Report (AR)

This Report gives the Supplementary Invoices, Credit Memos raised/to be raised for the Original Invoice

Report Submission

Use the Submit Requests (India Local AR modules Only) form and enter India-Supplementary Transactions Details Report in the Name field to submit the Report.

Report Parameters

Customer Name (Optional) PICK

If the User wants this Report for a specific Customer, then he need to enter Customer Name here otherwise this report give details for all the Customers for a given period will be reported.

Customer Number (Defaulted) PICK

Customer Number of the above Customer will be defaulted here.

Invoice Number (Optional)

If the User wants to see Supplementary Transaction for a specific Invoice, then he, need to enter that here.

Process Date (Optional)

For a Process date , the user can take the Report.

Supplementary Invoice Type (Optional)

Quick code are : Supplementary. Invoice, Credit Memo, Debit Memo

Report Headings

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

Column Headings

Sl. No

Serial Number of the Trial Balance will be reported.

Invoice

Original Invoice will be reported

Date

Date of the Original Invoice will be reported.

Amount

Amount of the Invoice will be reported.

Supplementary Invoice Type

Type like Supplementary Invoice, Credit Memo and Debit Memo will be reported. Amount of the Invoice will be reported.

Net Sales

Net Sales amount of the Supplementary Transaction will be reported.

Excise

Excise duty of the Supplementary Transaction will be reported.

Sales Tax

Sales Tax of the Supplementary Transaction will be reported.

CST

CST of the Supplementary Transaction will be reported.

Others

Others taxes of the Supplementary transaction will be reported.

Effective Amount

This is the amount for which the Sup.Inv, Credit Memo, debit Memo is raised.

Order By

Original Invoice Number

Supplementary Invoice Consolidation Report (AR)

This report gives you the Consolidated Supplementary Invoice raised for a period

Report Submission

Use the Submit Requests (India Local AR modules Only) form and enter India-Supplementary Invoices Consolidation Report in the Name field to submit the Report.

Report Parameters

Customer Name (Optional) PICK

If the User wants this Report for a specific Customer, then he need to enter Customer Name here otherwise this report give details for all the Customers for a given period will be reported.

Customer Number (Defaulted) PICK

Customer Number of the above Customer will be defaulted here.

Process Date (Optional)

For a Process date , the user can take the Report.

Supplementary Invoice Date (Optional)

For a particular Supplementary date, this report can be requested

Supplementary Invoice No (Optional)

For a particular Supplementary Number, this report can be requested

Supplementary Invoice Type (Optional)

For a particular Supplementary Type of Invoices, this report can be requested

Report Headings

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

Column Headings

Sl. No

Serial Number of the Line will be reported.

Item

Item name will be reported

Description

Description of the Item name will be reported

Line Amount

Excise

Excise duty of the Supplementary Invoice (Consolidated) will be reported.

Sales Tax

Sales Tax of the Supplementary Invoice (Consolidated) will be reported.

CST

CST of the Supplementary Invoice will be reported.

Others

Others taxes of the Supplementary Invoice will be reported.

Total Amount

This is the amount for which the Sup. Inv, Credit Memo, Debit Memo is raised.

Status of AR3 A form Report

This Report gives you the details about the AR 3A forms to be received from Customer.

Report Submission

Use the Submit Requests (India Local AR modules Only) form and enter India-AR3A Status Report in the Name field to submit the Report

Report Parameters

Organization/Location (Optional) PICK

If the User wants this Report for a specific Organization/Location, then he need to enter Organization Name here otherwise this report give details of AR3 A for dispatches made from all the Org/Location.

Customer Name (Optional) PICK

If the User wants this Report for a specific Customer, then he need to enter Customer Name here otherwise this report give details for all the Vendors for a given period will be reported.

Customer Number (Defaulted) PICK

Customer Number of the above Customer will be defaulted here.

Transaction Type (Optional )

Invoice / Order can be selected by the User.

Process Date (Optional)

For a Process date , the user can take the Report.

Invoice Number (Optional)

For Specific Invoice this report can be taken.

Excise Exemption Type (Optional)

CT2 or CT3

Status (Optional)

Quick fields are ALL, RECEIVED & NOT RECEIVED

Order

To be filled

Report Headings

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

Column Headings

Customer Name

Customer site

Transaction Type

Transaction Number

Transaction Date

Delivery Name

Delivery Number

Delivery Date

Excise Exempt Type

Excise Exempt Date

AR3 A Form No

AR3 A Form Date

Received Date

Date on which the AR3A form received back from the Customer.

Others

Others taxes of the Supplementary Invoice will be reported.

Total Amount

This is the amount for which the Sup. Inv, Credit Memo, debit Memo is raised.

Duty Draw Back Report

Report Submission

Use the Submit Requests (OE & AR Modules) form and enter India - Duty Drawback Report in the Name field to submit the Report.

Report Parameters

Organization (Required) PICK

Enter the Organization for which you wish to take the Duty Drawback Report for.

Location (Required) PICK

Enter the Location for which you wish to take the Duty Drawback Report for.

From date (Optional)

India Localization prints all claims for Duty drawback for the selected Organization starting with the date you enter for this parameter.

To date (Optional)

India Localization prints all claims for Duty drawback for the selected Organization up to the date you enter for this parameter.

Report Headings

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

Column Headings

AR4 No.

Number of Proof if export certificate (AR4).

Date of Removal

Date of removal of Export Goods from the Factory.

Item Description

Description of Item being exported.

Destination

Destination for the goods being exported.

Quantity

Quantity of items being exported.

UoM

Unit of Measure of items being exported.

Value

Value of Goods being exported.

Item code

Imported Item code.

CET Code

CET Code of Imported Item.

Item description

Description of Item that was imported for Manufacturing export item.

Rev

Revision No./name of Imported Item.

Quantity

Quantity of Items Imported.

UoM

Primary Unit of Measure of Items Imported.

BoE No.

Bill of Entry Number of Imported Item.

BoE date

Date of BoE of Imported Item.

Item code

Imported Item code.

Duty Drawback Amount

Amount of Duty paid on Imported Item that is being claimed back.

Total Duty Drawback Amount

AR4 number wise Total duty drawback amount.

Grand Total

Report’s Total duty drawback amount.

Report Order

Report is printed in the order of Shipment Date of Exported Items and Imported Item Description.

Journal Voucher Report

This reports provided the Listing of Journals created for a given period with the respective sources

Report Submission

Use the Submit Requests form(India AP and AR modules) and enter India - Journal Voucher in the Name field to submit the Report.

Report Parameters

Source (Optional) PICK

The user wants to take journals of a particular source, then he can specify that name

JV No (optional) PICK

Specific Journal Number , the user wants to take a report, otherwise left blank.

Period Order/Invoice (Required)

Start Date and End Date

Report Headings

Report headings provide you with general information about the contents of the report and the user entered parameters.

Column Headings

GL Date

JV Number

JV Date/GL Date

Narration

Source

AC Code

Description of the Account

Dr Amount

Cr Number

India - Cash / Bank Book Report

The user takes Cash/Bank Book as per his requirement for a range of period.

Report Submission

Use the Submit Requests (India Local AP & AR Module Only) form and enter India-Cash/Bank Book Report in the Name field to submit the Report.

Report Parameters

Bank Name (Required) PICK

Bank Name for which the User wants to take the Bankbook for a given period.

Account Number (Required) PICK

Account Number of the Above bank for which the User wants to take the Bank book for a given period.

Book Type (Required)

Either ‘B’ meant for Bank Book or ‘C’ meant for Cash book can be selected by the User from the LOV. This does not have an impact on the printout other than changing of the heading of the report.

Start Date (Required)

End Date (Required)

Report Headings

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

Column Headings

GL Date

GL Date for the transaction will be reported.

Voucher No & Date

Voucher Number and Date will be reported

Check Number & Date

Check Number and Check Date will be reported

Bill No & date

Supplier Bill No & Date will be reported

Vendor Name/Customer Name

In the Case of Payments , the vendor Name will be reported. In the Case of Receipts, the Customer Name will be reported. For charges in the Bank Book , this field won’t be having any details.

PO Number. & Date

PO Number for the respective purchase will be reported

Remarks/Narration

Remarks / Narration appearing in the Receipts and Payments vouchers will be reported

Account Code

GL Account for the respective Receipts and Payments will be reported.

Description

Description of the GL Account for the respective Receipts and Payments will be reported.

Receipts

Receipts Amount will be reported into this column.

Payments

Payments Amount will be reported into this column.

Balance

Balance Amount in the Cash/Bank will be reported into this column.

Important: Cash Book Report will be generated by specifying the Book Type ‘C’

India - Service Tax Pending Liability Report

This Report gives you the details of Service Tax Pending Liability. This Report shows all the unpaid / partly paid AR Invoices for which Service Tax Liability has not yet arisen.

Report Submission

Use the Other Reports form (India Local Receivable module) and enter India - Service Tax Pending Liability Report in the Name field to submit the Report.

Report Parameters

Registration Number (Required) PICK

The Registration Number for which the report is being generated.

Organization (Optional) PICK

The Operating Unit for which the report is being generated.

As on Date (Required)

The Date as on which the report is being generated.

India - Service Tax Pending Recovery Report

This Report gives you the details of Service Tax Pending Recovery. This Report shows all the unpaid / partly paid AP Invoices for which Service Tax Recovery (Credit) has not yet been availed.

Report Submission

Use the Other Reports form (India Local Receivable module) and enter India - Service Tax Pending Recovery Report in the Name field to submit the Report.

Report Parameters

Primary Registration Number (Required) PICK

The Registration Number for which the report is being generated.

As on Date (Required)

The Date as on, which the report is being generated.

Report Sample :

India - Service Tax ST3 Report

This Report gives you the details for filing the Service Tax return in ST3 Form.

Report Submission

Use the Other Reports form (India Local Receivable module) and enter India-Service Tax ST3 Report in the Name field to submit the Report.

Report Parameters

Field Description Type Action Description
Registration Number Required PICK The Registration Number for which the report is being generated.
From Date and To Date Required   Start Date and End Date for which the report is being run.
Organization Optional PICK The Inventory Organization for which the report is being generated.
Service Type Optional PICK List of all available Service Types, as selecting a value in this field indicates user wants to print report for a single Service type

India ER1 Report

This Report gives you the detailed data for submission of ER1 report.

Report Submission

Use the Other Reports form(India AR module) and enter India ER1 Report in the Name field to submit the Report.

Report Parameters

Organization (Optional) PICK

The Inventory Organization for which the report is being generated.

Location (Optional) PICK

The Inventory Organization 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.

Start Date and End Date (Required)

Start Date and End Date for which the report is being run.

Service Tax Registration Number (Optional) PICK

The Service Tax Registration Number for which the report is being generated.

Operating unit (Optional) PICK

The Operating Unit for which the report is being generated. This gets enabled only if the Service Tax Registration Number is selected.

Name of the Assessee (Optional)

The Name of the Organization which needs to be printed on the report. This is the actual name to be printed and would not be picked from Organization setups.

Group Quantitative Data (Required) PICK

The Report can be either printed for the Inventory Items or for Item Tariff. The values to be selected are ‘I’ for Item or ‘T’ for Tariff. Please see the note below for report behavior on selection of this value.

Important: Report Behavior for Group Quantitative Data : Item: When Item is selected Quantitative data in report is grouped based on individual inventory item and column ‘Description of goods’ will be displaying the Inventory Item description. Tariff: When Tariff is selected Quantitative data in report is grouped based on Item Tariff provided in India Item Attributes setup (related to Excise) and further grouped based on distinct primary UOM. In this case the column ‘Description of goods’ will be left blank as the Tariff description is currently not captured by India Localization. User needs to enter the Item Tariff description in such cases.

India TCS Certificate

Use the Submit Requests from India Local Receivables and enter India TCS Certificate in the Name field to submit the report.

Report Parameters

Report Parameter Type Action Description
Legal Entity Required PICK The Legal Entity for which the report is being generated.
Financial Year Required PICK The Financial year for which the report is being generated.
TAN Number Required PICK The TAN Number for which the report is being generated.
Collection Code Required PICK The Collection code for which the report is being generated. This can be any of the following values:
  • Alcoholic liquor for human consumption

  • Timber obtained under forest lease

  • Timber obtained under any mode other than forest lease

  • Any other forest product not being timber or tendu leave

  • Scrap

  • Parking Lot

  • Toll Plaza

  • Mining and Quarrying

  • Tendu Leaves

Certificate Nos. from Optional PICK The Certificate Nos. from for which the report is being generated.
Certificate Nos. to Optional PICK The Certificate Nos. to for which the report is being generated.
Certificates from Date Optional   The Certificates from date for which the report is being generated.
Certificates to Date Optional   The Certificates to date for which the report is being generated.
Customer Optional PICK The Customer for which the report is being generated.
Name of Signee Optional   The Name of Signee which needs to be printed on the report.
Designation Optional   The Designation of Signee which needs to be printed on the report.
Place Optional   The Place where TCS Certificate is issued and which needs to be printed on the report.
Organization Required PICK The Inventory Organization for which the report is being generated.

India - TCS Form 27B

Use the Submit Requests from India Local Receivables and enter India - TCS Form 27B in the Name field to submit the report.

Report Parameters

Report Parameter Type Action Description
Legal Entity Required PICK The Legal Entity for which the report is being generated.
Org TAN Number Required PICK The Organization TAN Number for which the report is being generated.
Organization Required PICK The Inventory Organization for which the report is being generated,
Financial Year Required PICK The Financial year for which the report is being generated.
Quarter Optional PICK The Quarter of the Fiscal year for which the report is being generated.
Previous Receipt Number Required PICK The Previous Receipt Number in case the return was filed earlier.
Collection Code Required PICK The Collection code for which the report is being generated. This can be any of the following values:
  • Alcoholic liquor for human consumption

  • Timber obtained under forest lease

  • Timber obtained under any mode other than forest lease

  • Any other forest product not being timber or tendu leave

  • Scrap

  • Parking Lot

  • Toll Plaza

  • Mining and Quarrying

  • Tendu Leaves

Person Responsible Required   The Name of Person responsible which needs to be printed on the report.
Responsible Person Designation Required   The Designation of Person responsible which needs to be printed on the report.
Responsible Person Address Required   The Address of Person responsible which needs to be printed on the report.
Responsible Person City Required   The City of Person responsible which needs to be printed on the report.
Responsible Person State Required   The State of Person responsible which needs to be printed on the report.
Responsible Person Pin Required   The PIN code (Postal Code) of Person responsible which needs to be printed on the report.
Responsible Person Telephone Required   The Telephone Number of Person responsible which needs to be printed on the report.
Responsible Person email Required   The email Address of Person responsible which needs to be printed on the report.
Start Date Optional   The start date from which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.
End Date Optional   The end date till which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.

India TCS Quarterly Report

Use the Submit Requests from India Local Receivables and enter India - TCS Quarterly Report in the Name field to submit the report.

Report Parameters

Report Parameter Type Action Description
Legal Entity Required PICK The Legal Entity for which the report is being generated.
Org TAN Number Required PICK The Organization TAN Number for which the report is being generated.
Organization ID Required PICK The Inventory Organization for which the report is being generated.
Fin Year Required PICK The Financial year for which the report is being generated.
Quarter Optional PICK The Quarter of the Fiscal year for which the report is being generated.
Collection Code Required PICK The Collection code for which the report is being generated. This can be any of the following values:
  • Alcoholic liquor for human consumption

  • Timber obtained under forest lease

  • Timber obtained under any mode other than forest lease

  • Any other forest product not being timber or tendu leave

  • Scrap

  • Parking Lot

  • Toll Plaza

  • Mining and Quarrying

  • Tendu Leaves

Tax Rates Type Required PICK The Tax rate type for which the report is being generated i.e. ‘Lower Rates’ ‘Standard Rates’ or ‘Exempt Rates’.
Provisional Receipt Number Required PICK The Provisional Receipt Number in case the return has been filed earlier.
Person Responsible Required   The Name of Person responsible which needs to be printed on the report.
Responsible Person Designation Required   The Designation of Person responsible which needs to be printed on the report.
Responsible Person Address Required   The Address of Person responsible which needs to be printed on the report.
Responsible Person City Required   The City of Person responsible which needs to be printed on the report.
Responsible Person State Required   The State of Person responsible which needs to be printed on the report.
Responsible Person Pin Required   The PIN code (Postal Code) of Person responsible which needs to be printed on the report.
Responsible Person Telephone Required   The Telephone Number of Person responsible which needs to be printed on the report.
Responsible Person email Required   The email Address of Person responsible which needs to be printed on the report.
Start Date Optional   The start date from which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.
End Date Optional   The end date till which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.

India TCS Annual Report

Use the Submit Requests from India Local Receivables and enter India - TCS Annual Report in the Name field to submit the report.

Report Parameters

Report Parameter Type Action Description
Legal Entity Required PICK The Legal Entity for which the report is being generated.
Org TAN Num Required PICK The Organization TAN Number for which the report is being generated.
Organization ID Required PICK The Inventory Organization for which the report is being generated.
Fin Year Required PICK The Financial year for which the report is being generated.
Collection Code Required PICK The Collection code for which the report is being generated. This can be any of the following values:
  • Alcoholic liquor for human consumption

  • Timber obtained under forest lease

  • Timber obtained under any mode other than forest lease

  • Any other forest product not being timber or tendu leave

  • Scrap

  • Parking Lot

  • Toll Plaza

  • Mining and Quarrying

  • Tendu Leaves

Tax Rates Type Required PICK The Tax rate type for which the report is being generated i.e. ‘Lower Rates’ ‘Standard Rates’ or ‘Exempt Rates’.
Seller Address Changed? Required PICK The Provisional Receipt Number in case the return has been filed earlier.
Responsible Person Name Required   The Name of Person responsible which needs to be printed on the report.
Responsible Person Designation Required   The Designation of Person responsible which needs to be printed on the report.
Responsible Person Place Required   The Address of Person responsible which needs to be printed on the report.
Start Date Optional   The start date from which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.
End Date Optional   The end date till which this report needs to be printed. This date should pertain to the same quarter as entered in earlier parameter.