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 Payables

This chapter covers the following topics:

eTDS Returns

This feature is in accordance with the requirements of Income Tax Act. The Act mandates reporting of non-salary deductions through eTDS Returns. These certificates replace the existing Return in the Form 26.

Basic Business Needs

The feature enables generation of eTDS Certificates considering the following information:

This feature considers TDS Calculations in following situations:

Bill of Entry (BOE)

Customs Duty Liability arises on import of material. Customs Duty has to be paid in advance i.e., before the material is received in stores. The clearance of goods imported would be possible only after submission of the Bill of Entry in the specified format. This document details the goods imported in the consignment and the amount of Customs Duty liability for each commodity included in the consignment. Bill of Entry in Oracle Financials for India helps you manage the documentation process and account for the liability arising from the transaction.

Bill of Entry helps you manage the import process. Using BOE you can perform the following tasks:

Bill of Entry (BOE)

You must use this feature to capture the information required for the Bill of Entry report to be submitted to the Customs Authority.

While creating a Bill of Entry, you can now enter the Additional CVD percentage. This percentage is applied on the Total of all preceding taxes.

Calculation of Customs Duty

This feature helps you in calculation of the Customs Duty, Additional Duty and Surcharge based on the Assessable price entered for the transaction.

Creation of AP Invoice

An Approved AP Invoice would be automatically created for the Customs Authority with the Total Customs Duty liability arising from the transaction.

Control over Receipt Transactions

For the goods receipts that are created through India Local Receipts screen, which have Customs Duty of Tax, attached to it, a control would be placed, where you cannot quit the form until an appropriate BOE is attached to the receipt line. This would set-off the Customs liability arising from the transaction.

BOE Amount Write-Off

You have a facility to write off the Un-applied BOE amount in a BOE Invoice which no longer to be applied against any Receipts. If the Customs Duty paid need to be written off for any reasons, you can make use of this functionality. For example, the Customs Duty is paid through a BOE Invoice and during transit of goods from the port to the Organization; the duty paid goods were lost in transit. In such cases, the duty paid on such goods cannot be applied to the inventory receipt transaction and the duty paid need to be Written Off.

Reports

Payables generates the following reports applicable to India:

BOE Written off Report - Lists Bill of Entry (BOE) records written-off during the selected period.

Capture Personal Ledger Account (PLA) Payment

The Excise liability arising from the removal transactions needs to be settled within 5 days from the end of the Month / Period. The Duty can be discharged on debiting a current account, referred to as Personal Ledger Account (PLA). PLA credit is taken by depositing money in the banks on T.R.6 Challan. Capture PLA feature helps you capturing the information required for the PLA Report to be submitted to the Excise Authorities. This feature helps you in raising Invoice to capture and maintain account for the liability arising from the transaction.

Basic Business Needs

The Capture PLA Payments feature in Payables helps you manage the Excise Duty liability settlement process. Using this feature, you can:

Capture the information required to update the PLA Register

Account for the liability arising from the transaction

Control on updation of PLA Register

Important: An AP Invoice would be generated on saving the Capture PLA Payment transaction.

Major Features

Major features of PLA are mentioned below

PLA Payment

The net Excise Duty liability arising during the Month / Period has to be settled by a payment made through TR 6 Challan. The PLA Register would be hit when the payment is actually made to the Excise Authority and the user acknowledges this payment from the ‘PLA Invoices’ Screen. The Capture PLA Payment feature captures the information required for the updation of the PLA Register.

Creation of AP Invoice

An AP Invoice with status ‘Validated’ would be automatically created for the Total Amount on the Capture PLA Payment lines. This would take care of accounting the liability arising from the transaction.

Acknowledging PLA Payment

The PLA Register would be updated only when the PLA Payment is acknowledged. The Acknowledgment is allowed only when the AP Invoice created for this transaction is fully paid.

Tracking of Sales Tax Forms Issues

Overview

The reduced rates of Sales Tax are applicable based on issue of declaration forms to the Supplier. These forms would be as specified in the applicable Sales Tax Regime. For this you will have to keep track of the transactions that would qualify for concessional rate of Sales Tax. Further, you will have to keep track of details of Forms Issued and the Invoices included in each of the Forms.

Basic Business Needs

Sales Tax Issue tracking helps you manage the issue of Issue of declaration forms in order to avail concessional rate for Sales Tax. Using this feature you can perform the following tasks:

Third Party Taxes - Additions to Fixed Assets

Overview

Taxes and charges that are incurred on a transaction but are not paid to the Supplier of Goods are defined as Third Party Taxes in Oracle Financials for India. Third Party Taxes applicable to a transaction would depend on the Shipment terms. The terms used commonly are Ex-works and FOB. In cases where the terms of Shipment is Ex-works, the Seller delivers the goods at his premises. All costs incurred after this stage has to be borne by the Buyer. In case of Inland purchases, the cost components would be Freight, Insurance, Octroi and Entry Tax. In case of Imports the Third Party Taxes would be Freight, Insurance, Landing Charges, Inland Freight, Installation Charges and would also involve Basic Customs Duty, CVD and Customs Clearance Charges. On such transactions there is a good possibility of having multiple Third Party Vendors and Tax Authorities. Also, the amount paid would be consolidated by Third Party Vendor and Vendor Site.

Of these Tax Types, except for the Countervailing Duty, all others are Non-Recoverable Taxes. These have to be added to the Item Cost. In case of the Raw Material Purchases, the Average Cost has to be updated and in case of Capital Goods, the amount should be added to the Asset Cost.

Oracle Financials for India automates transfer of Third Party Taxes to Fixed Assets.

This feature automates transfer of following taxes/expenses to Fixed Asset Cost:

Third Party Taxes: Costs that are not billed to the PO Supplier but are incurred in the course of the transaction.

Non-Recoverable Customs Duty: Customs Duties that are paid to the Customs Authorities through Bill of Entry (BOE).

Defining TCS Authority

TCS Authority needs to be defined for settlement of TCS Taxes and payments. You can identify a TCS authority by assigning the Supplier Type as India TCS Authority. To classify a supplier as a TCS Authority, access Supplier window from India Local Payable > Supply Base > Suppliers.

Managing TDS Transactions

This Section elaborates on the effect of TDS setup on Actions applied to an Invoice. You can see the impact on the Supplier Liability, Accounting and generation of TDS Certificates.

Invoices with TDS Codes

When you create an AP Invoice, the TDS gets calculated based on the TDS Threshold Setup done.

India Distributions Global Descriptive Flexfield

Usage of earlier Invoice Distributions Descriptive Flexfield has been discontinued and the same functionality has been implemented through India Distributions Global Descriptive Flexfield.

The users should ensure that at least one segment of this India Distributions Global Descriptive Flexfield is marked as ‘Enabled’. The users should not make any of the segments as ‘Required’.

Following are the details of the Global Descriptive Flexfield:

Application: Regional Localizations

Title: JG_AP_INVOICE_DISTRIBUTIONS

Context Field Values:

Code: JA.IN.APXINWKB.DISTRIBUTIONS

Name: Invoice Distributions

Description: Asia/Pacific Invoice Distributions Information

Apart from the above, there are no changes from a user perspective in the TDS functionality due to migration of the Descriptive Flexfield to Global Descriptive Flexfield.

Prerequisites

Before you can use the TDS feature on Invoices, you should have completed the mandatory setup defined in the Setup Documentation.

1. TDS On AP Invoices and Prepayments

The TDS calculation and creation of the TDS related Invoices would take effect, during the Validation of an AP Invoice, with either TDS Code attached in Invoice Distributions or with a TDS Tax Name attached in the TDS Thresholds Setup

2. On Validation of a Standard Invoice or a Prepayment Invoice

When you validate a Standard Invoice or a Prepayment, the Supplier would be debited to the extent of Tax Deducted by means of a Credit Memo, while the Balance of Tax Authority would be increased by means of a Standard Invoice.

Thus, balance due to the Supplier would be net of the Credit Memo created on Validation. You should take adequate care to consider such Credit Memos while making the Payment to the Supplier.

3. On Application of Prepayment Invoice to Standard Invoice

When you apply a Prepayment to a Standard Invoice, both are subject to Tax Deduction, Invoices would be created for the reversal of the TDS deducted on the Prepayment. This is done by creating:

You need to ensure that Prepayment with multiple distributions, each having a different TDS Section applicable, should not be applied to a Standard Invoice. To deal with such cases, you have to create a Separate Prepayment Invoice for each of such Payments.

4. Amount considered for reversal on Prepayment Application

The following are

5. On Un-Applying Prepayment Invoice applied to a Standard Invoice

When you un-apply a Prepayment to Standard Invoice, both of these subject to Tax Deduction, Invoices would be created to reverse the effect of the Invoices created on application of the prepayment. Standard Invoice would be created for the TDS Authority and a Credit Memo would be created for a Supplier.

6. On Canceling Standard Invoice

On canceling a Standard Invoice for which Tax has been deducted, the Invoice created for the Tax Authority would be canceled and a Standard Invoice to the extent of the Tax Deducted an Standard Invoice would be created for the Supplier.

However, there would not be any effect on these Invoices if the Invoice for the Tax Authority is already paid.

You have an option to cancel the Supplier Invoice while you are voiding the Payment for the Invoice. In such cases, Invoices to Tax Authority would also be cancelled. However, it is necessary that the Tax Authority Invoice is not yet paid.

TDS Invoice Payments

Navigation: India Local Payables - India Localization - Others - India TDS Challan

In this screen, the user can capture the information of TDS payment details. This screen would list all Payments made to TDS Authorities where the Challan information has not been entered. The user would then be able to enter the attribute information for these payments.

The user will create an AP Invoice in the base application for payments to be made to the TDS Authorities. After creating the AP Invoice, the user will query this Invoice in the India Local TDS Payments screen and update the Additional Information here.

Find TDS Parameters field wise description.

Field Description Type Action Description
Tax Authority   EDIT, PICK User needs to select the Tax Authority Name from the LOV.
Tax Authority Site   EDIT, PICK User needs to select the Tax Authority Site Name from the LOV
From Date   EDIT, PICK Enter the date range
To Date   EDIT, PICK Enter the date range
Clear   BUTTON Pressing this button will clear the screen.
New   BUTTON Pressing this button will take the user to the next screen wherein the user can select different TDS Invoice payments and enter the Challan Number details.
Find   BUTTON Pressing this Button, system will find all the TDS Challan Details, which are created earlier.

Field wise details of TDS Challan Details Screen

Field Description Type Action Description
Tax Authority   EDIT, PICK User needs to select the Tax Authority Name from the LOV.
Tax Authority Site   EDIT, PICK User needs to select the Tax Authority Site Name from the LOV
Check Number   DISPLAY System will query the existing data.
Check Date   DISPLAY System will query the existing data.
Currency Code   DISPLAY System will query the existing data.
Amount   DISPLAY System will query the existing data.
Check Deposit Date   EDIT The Date on which the Check has been deposited into government treasury needs to be entered for TDS Payments being made & printed on the TDS Certificates / Returns
Challan Number   EDIT User should enter the value of Challan issued by the Income Tax Department that has to be submitted along with the remittances of TDS Amounts. This information is used in TDS Certificates issued to the Vendor and at time of Tax Returns
Bank Name   EDIT, PICK Enter the value of Bank in which, the TDS payment / Challan is deposited.

TDS Certificate Generation

You can generate TDS Certificate to be issued as per the Income Tax Act. Based on the TDS Section and Tax Authority, you should first generate the TDS Certificate. One TDS Certificate can be issued for all the TDS deductions for a Vendor based on the transaction range or individual TDS Certificates can be generated for each TDS Deduction.

Navigation: India Local Payables - India Localization - Others - Generate TDS Certificates

Field Name Type Action Description
TAN Number (Required)   The user should pick the value from the LOV.
Operating Unit     Select the appropriate value from the LOV
Certificate Period (Required)   You need to specify the period the period for which he wants to generate the TDS Certificate.
These dates will be compared against the Invoice Dates of the Invoices generated for TDS Authority.
Section (Required) EDIT HELP PICK You need to specify the TDS Section for which he wants to generate the TDS Certificate.
Tax Authority (Optional) ENTER You can specify a particular Tax Authority Name for whom he wants to generate the TDS Certificate.
Vendor Name (Required) ENTER You need to specify a particular Vendor Name for whom he wants to generate the TDS Certificate.

Generating eTDS Returns

You can generate eTDS Returns using 'India - Program to Generate eTDS Certificates' Concurrent program. Prior to that you should completed validating Supplier Invoices and made payments to Invoices generated for TDS Authorities.

The concurrent program should be run for a Particular TAN Number for a given Financial Year.

As the output would be flat file, the users would be provided with an option to generate the file with separators and Headers. The file can be generated in this format by checking 'Generate Headers' parameter of the Concurrent request. Using this file user can check the records and the appropriate values. On finding that the data is correct, you can choose select the file with same parameters, without headers. The file would be saved at the path specified in the ‘utl_file_dir’ parameter of the Database.

To generate eTDS Returns, navigate to ‘India - Program to Generate eTDS Certificates’ as follow:

India Local Payables - View Requests (M) - Submit New Requests.

This request facilitates

The user should specify following information in the following parameters

  1. TAN Number: User should select the value from the LOV. The User should select the TAN Number value for which, the return is to be generated.

  2. Financial Year: User has to select the Financial Year value for which, the returns have to be generated.

  3. Organization: Select the value of Organization for which, the returns have to be generated.

  4. Tax Authority: Select the Income Tax Authority for which the TDS Invoices have been generated and paid.

  5. Tax Authority Site: Select the Vendor Site code of the Income Tax Authority.

  6. Deductor Name: Enter the Name of the Deductor.

  7. Deductor State: Select the appropriate value for the State from the LOV.

  8. Address Changed Since Last Return? : Select the value ‘Yes/No’ from the LOV.

  9. Deductor Status: Select the appropriate value from LOV.

  10. Person Responsible for Deduction: Enter the Name of the Person Responsible.

  11. Designation of Person Responsible: Enter the Designation of Person Responsible for deduction.

  12. Challan Start Date: Enter the From date range .

  13. Challan End Date: Enter the To Date Range

  14. File Path: Select the Default value from the LOV. This value will be selected based on the util_file_dir parameter value of the database.

  15. File Name: Enter the Name of the flat file name and the eTDS returns flat file will be generated with this name.

  16. Generate Headers: Select the values ‘Yes/No’ from the LOV.

  17. If the value ‘Yes’ is selected, then system will generate a flat file including Headers (columns).

  18. If the value ‘No’ is selected, system will generate a flat file which can be validated against the file validation utility of NSDL.

Service Type Review

Service Type Review lets you capture the Service Type for those transactions where it was either not captured during the transactions or could not be captured for some reason. We recommend you to carry out this review before carrying out settlement. You also have an option of querying existing records to view and change he captured Service Type for any existing Transaction.

Navigate to India Local Payables > India TCS/VAT/Service Tax > Period End > Service Tax Repository Review.

Field Description Type Action Description
Source   PICK The source from which the Repository entry has been carried out and would give LOV values of Payables, Receivables, Manual and Distribution.
Organization     This lists the Inventory Organizations for which you need to find the transactions
Location     Lists Locations based on the Organization selected.
Transaction Dates: From     This is to enter a date range from which the repository records needs to be displayed.
Transaction Dates: To     This is to enter a date range to which the repository records needs to be displayed.
Include Settled Transactions Optional Checkbox Checking this will enable query of already settled transactions.
Query Read Only Optional Checkbox Checking this will enable query in read only mode i.e. view mode.
Query Only records with Null Service Type Optional Checkbox Checking this will enable query of records where Service Type is null & hence requiring update.

This search lists all the Service Tax Repository Transactions for the given find criteria. You have an option of Defaulting Service Type from setup. Alternatively, use a Service Type specified in this search results. The Service Type can then be defaulted only to those records where Service Type is null.

Note: Settlement cannot be carried out till you ensure that the Service Tax balance is transferred from Operating Unit to Inventory Organizations. Also, you need to ensure that all the transactions are classified by the right Service Type.

Service Type Review also lets you view accounting entries made against Service Tax. Navigate to India Local Payables > India TCS/VAT/Service Tax > Period End > Service Tax Repository Review. Click View Accounting to view the accounting entries for a particular Service Tax repository entry.

Note: You can view the GL drilldown accounting entries using the Show transactions button on the Tools menu of the Service Tax Repository Review form.

BOE Invoices

Generating BOE Invoices

You can create the BOE Invoices for all the import purchases and the liability will be recognized to the Customs Authority and any Advance Payment can be made before the actual receipts of material.

To enter BOE Invoices, navigate to the India Local Bill Of Entry window.

Field Name Type Action Description
BOE Number (Display only)   Select from the LOV depending upon the BOE for which the Invoice is to be generated.
BOE Type (Required) EDIT HELP PICK Select from the LOV depending upon the nature of transaction.
Customs Authority (Required) HELP PICK Select the respective Vendor Name or Customs Authority Supplier from the LOV.
Site (Required) EDIT HELP PICK Defaulted Site for a respective Vendor or Customs
Authority Supplier from the LOV.
Agent Code (Optional) EDIT HELP PICK Enter the Agent Code who is dealing this particular Import Shipment.
Inventory Organization (Required) EDIT HELP PICK The user defined Inventory Organization
need to be picked up from LOV where this import is going to be accounted.
Location (Required) EDIT HELP PICK Location for that Inventory Organization is
to be picked from LOV where this import is
going to be accounted.
Bill of Lading Date (Optional)   The user can enter the Bill of Lading date.
[ ] (Optional) EDIT Enter line-specific additional detail and Save.
Port Type (Optional)   Select the Port Type like Sea, Air and Land from the LOV.
Import Dept. Block
Sl.No (Optional)   The user can enter the Serial Number allotted by the Import Dept.
Date (Mandatory)   The user can enter the BOE date as specified in the BOE Document.
Rotation Block
Rotation No/date (Optional)   The user can enter the Rotation Number and the Date allotted by the Import Dept.
Amounts Block
BOE Amount (Defaulted)   The BOE Amount and Applied Amount will be defaulted from BOE Details form.
Shipment Information Block
Shipment Information     The following fields (ie) Vessel Name, Consignment Country, Port Name, Origin Country are optional and the user can enter relevant details for personal reference.
BOE Item Independent Flag (Optional)   You can use this option to create an Item Independent BOE. You can define a BOE for a Dummy Item and this can be used to match the Customs liability on any Item.

BOE Line Details

Field wise description of BOE Line Details is given below

Field Description Type Action Description
Number   ENTER The Number of packages will be mentioned here.
Description (Optional) ENTER The Description of the packages can be mentioned here.
Serial Number (Optional) ENTER Serial Number of the Item packed with the Description of the packages can be mentioned here.
Quantity (Required) ENTER The total Quantity imported and for which the Customs Duty is to be paid.
UOM (Required) ENTER UOM of the Item.
Item Name (Required) ENTER Item Name need to be specified for calculating Customs Duty Item wise.
Customs Tariff (Optional) ENTER Customs Tariff Number under which the duty will be assessed.
Duty Code (Optional) ENTER The Customs Duty under which the duty will be calculated.
Assessable value (Required/Optional) ENTER The total Assessable Value of the goods on which the duty will be calculated.
For Basic Customs duty Rate (%) (Required) ENTER The Rate of Basic Customs Duty as applicable on the goods as per duty code of the Customs Tariff.
Amount     Basic Duty Amount calculated on the Assessable Value of the goods and defaulted.
Exemption Notification (Optional)   If the goods are exempted from duty, then the user can mention the Exemption Notification under which the goods are exempted
For Additional Duty (Displayed
/ Optional)
   
Additional Value (Optional)   This displayed amount is the total of Assessable Value plus Basic Duty Amount and on this amount the Additional Duty will be calculated.
Rate (%) (Required) ENTER The Rate of Additional Customs Duty as applicable on the goods as per duty code of the Customs Tariff.
Amount     Additional Duty Amount can be calculated on the Additional Value and displayed.
For CVD
Cess
(Displayed/Optional)    
Assessable
Value
    This is the Additional Duty Amount based on which, the CVD Cess % would be calculated.
Rate (%) (Required)   CVD Cess % Rate as applicable on the goods as per the duty code of the Customs Tariff
Amount     CVD Cess amount
For
Surcharge
Duty
(Required/Optional)    
For
Surcharge
     
Cumulative
Value
    Amount on which Surcharge duty is calculated
Rate (%) (Required) ENTER The Rate of Surcharge as applicable on the goods as per duty code of the Customs Tariff.
Amount (Displayed)   Amount of Surcharge calculated.
For Customs Cess      
Assessable Value (Display)   This value is the sum of Basic Duty Amount, Additional Duty Amount, CVD Cess amount and Surcharge Amount. This is the Amount based on which, the Customs Cess % would be calculated.
Rate (%) (Required) ENTER Customs Cess Rate
Amount (Optional)   Customs Cess Amount, which gets calculated on the Customs Cess Assessable value for the Rate specified for the Customs Cess
Total Customs Duty (Displayed) ENTER This indicates the total liability on account of Customs Duty payable to the Customs Authority Vendor.
      On saving the transaction, an Invoice will automatically get generated, validated and ready for payment. The payment may be made through regular Oracles Payables functionality.

BOE Write Off

You have a facility to Write Off the Un-applied BOE amount in a BOE Invoice which no longer to be applied against any Receipts.

You have to query for the BOE Number and activating the BOE Write Off button would display the BOE Write Off screen.

The added column to this BOE Invoice form in the Amount Block.

Filed wise description for BOE Write Off is given below

Field Name Type Action Description
Amount to Write off (Displayed/Required)   The User has to enter the Write Off Amount, which no longer required. By default the Balance remaining in a BOE Invoice will be displayed here but the User can override and change the Amount.
Write off date (Required)   The User has to enter the Date on which he is Writing Off a BOE Invoice.
Write off Reason (Optional)   The User has to enter the reason for the Write Off in this optional field.

Once the User saves this screen the entered amount will be written from BOE Invoice and the Written Off column in the Amount Block of the BOE Invoice form will be updated.

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

PLA Invoices/Payment

Navigation, India Local Payable > India Localization > Invoice Entry > PLA Invoices

Field wise details for the PLA Invoice / Payment is given below

Field Description Type Action Description
Payment_Id (Defaulted)   This is the system generated Payment_Id after entering data and save this form.
TR6 Challan No/Date (Required) ENTER The user can enter TR6 Challan Number and Date through which the PLA Payment will be made.
Inventory Organization (Required) EDIT HELP PICK The user defined Inventory Organization need to be picked up here from LOV.
Location (Required) EDIT HELP PICK Location for that Inventory Organization is to be picked up from LOV.
Acknowledgment Block     The Acknowledgment Flag will be enabled after the PLA Payment is made and the user can update the Acknowledgment Date. Only after Acknowledgment is received and the Acknowledgment Flag is enabled the PLA Register will be updated.
PLA Amount (Displayed)   This is the displayed total line amount of Excise Duty proposed to pay.
Authority (Required) EDIT HELP
PICK
Select the respective Vendor Name or Commissioner of Excise from the LOV.
Site (Required) EDIT HELP
PICK
Select the Site for the above selected Vendor from the LOV.
PLA Details Block (Required)    
Item Tariff   ENTER Enter Item Tariff under which this PLA payment will be made.
Item Sub Heading     This is defaulted field as per the Item Tariff.
Basic Amount/Additional Amount/Other Excise (Required) ENTER The user has to specify how he wants to pay in Basic, Additional, and Other Excise Duty through this TR6 Challan.

Note: You can view the GL Driildown Accounting lines by clicking Shows Transactions on the Tools menu in PLA Register manual entry India Localization form

On saving the transaction, a PLA Invoice will be automatically generated, validated and ready for payment. This Invoice Number has a prefix of ‘PLA’. The payment for this Invoice may be made through regular Oracle Payables functionality.

Only after entering the Acknowledgment Date, PLA Register balance will be updated.

Using Sales Tax Declaration Forms - Issue Tracking

Overview

Purchases made by Registered Dealers, from 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 in order to avail such rate has to be tracked.

You can issue Sales Tax declaration forms for each of the transactions. Oracle Financials for India provides you with a feature to define Form Names, Define Taxes with Declaration Forms attached, Tracking Invoices for which these Forms have to be issued, Record details of Forms issued and query and view the Form details.

Prerequisites

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

Before recording details of Concessional Forms to be issued to Supplier, following needs 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 Payables - India Localization - Suppliers - Issue ST Forms

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

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

Field Description Type Action Description
Issue/Receipt (Display only)   This field gets populated as Issue / Receipt based upon the Application chosen.
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     Financial Year as applicable to the ST Form related data.
Form Number     Form Numbers that are issued to the Supplier, Supplier Site and Form Type.
Issue/Receipt Date     Enter a Date, which might match with the Issued Form’s Transaction Date.
View Forms Button     Button, which upon being clicked invokes the ‘View Sales Tax form Details’ Screen
Issue/Receive Forms Button     Button, which upon being clicked invokes the ‘Define Sales Tax form Details’ Screen

On clicking the ‘Issue/Receive Forms’ button, the system fetches the Invoices to be matched. This information would be displayed in ‘Define Sales Tax Forms Details’ screen.

This screen has Header and Detail Sections

Header Section

This section allows you to record Form details such as Financial Year, Form Number Form Amount, Form Date and Transaction Date. These details can be entered for a combination of Supplier Name, Supplier Site, Form Type and Operating Unit.

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

Its mandatory to enter Financial 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.

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 Issue Tab Page. The records would be grouped based on the combination of Invoice and Purchase Order

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

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. This is invoked by clicking on the ‘View Forms’ option in ‘Finds ST Form Detail’ window.

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 Financial 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 Form Type and Fin year combination
Form Amount Required   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 the entire 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
This amount would be Sum of Matched Amounts reduced from Sum of Tax Target Amounts.
Sales Tax Form Detail Block (Matching Detail) - Issue Side
Invoice Number (Display only)   To be filled
Invoice date (Display only)   To be filled
Po/Requisition Num (Display only)   To be filled
Document Type (Display only)   To be filled
Tax Target Amt (Display only)   To be filled
Matched Amt (Display only)   To be filled
Form Amount     In case of + ve invoices sum of invoice level form amount and Matched amount cannot be greater than Tax target amount.
In case of - ve invoices 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 Issued Forms

You can view the Sales Tax Forms Issued 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 Supplier, Supplier 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 Supplier Name, Supplier 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 Invoices grouped by combination of Invoice Number and Purchase Order.

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

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 - Issue Block
Invoice Number (Display only)   This is the Transaction Number
PO / Requisition Amount (Display only)   This field displays the Purchase Order Number
Document Type (Display only)   This field displays the Document Type.
Tax Target Amt (Display only)   This field displays Tax target amount.
Matched Amount (Display only)   This field displays Matched Amount

Generating Records for Sales Tax Issue Tracking

Invoice Details required for issuing Sales Tax Forms would be generated by submitting ‘India - ST Forms Issue Processing’ concurrent program.

This concurrent program is available in India Local Payables 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.

You can submit this request from India Local Payables Submit Requests ‘India - ST Forms Issue Processing’.

Field Description Type Action Description
Operating Unit (Display only)   Value determined from the Profile values
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.
From Date Mandatory   Low Value of Invoice Date to filter the Invoices.
To Date Mandatory   High Value of Invoice Date to filter the Invoices.
Supplier     If you would like to process records for a specific Supplier then, select a Supplier Name in this field.
Supplier Site     This will be used to filter the data related to given Supplier Site, otherwise all Supplier Site’s related data is processed.
Re Process not issued invoices     This would consider all Invoices in the selected date range for processing. Also, those Invoices that have been processed earlier would be re-processed. Hence, all revised actions and status on Invoices would be considered for re-processing.
Invoices for which Forms are already issued would be left unprocessed.
Enable Trace     On selecting ‘Yes’ in this field, a Raw Trace File would be generated for this request.
It is a pre-requisite to have ‘Enable Trace’ checked for ‘India - ST Forms Issue Processing’ Concurrent Program.

India - FA Mass Additions

After creation of Receipts, user should submit request for creation of Payables Invoices for the Third Party taxes that are included in the receipts. Meanwhile, user would create the Payables Invoices for the PO Vendor (Base Invoice). These Invoices would be either created manually or automated by submitting ‘Pay on Receipt Auto Invoice’ program for the receipt.

Once a Receipt matched AP Invoice is validated, approved and accounted, they would qualify for FA Mass Additions. User can schedule Mass Additions Create program to carry these lines to Fixed Assets. This program would only process base Invoices. As soon as this program completes successfully, ‘India - Mass Additions Creation’ program would be submitted automatically. This request would scan for all Third Party Taxes and Customs Duties applicable to the purchase. In cases where the Receipt includes any such Tax, this program would create one line per Receipt Tax line in Fixed Assets Mass Additions.

The user can view these requests in ‘Prepare Mass Additions window. These lines will carry the Invoice and PO Numbers of the First Party Invoice. The user can either create New Assets or Add these lines to an existing Asset or Merge them to another line.

‘India - Mass Additions Creation’ program can also be submitted explicitly. This can be used in exceptional scenarios where the third party tax lines are not transferred to FA.

This request can be invoked from ‘India Local Payables View Submit Requests - India Mass Additions Create’.

Define Invoice Tolerance Limits

Overview

As per Indian Central Excise Act and Income Tax Act, the Excise duty and TDS amount will be rounded off to the nearest Rupee and in effect the AP Invoices, the Header Amount and the Distribution Amount will have minor difference. Base Applications Invoices feature places an hold on Invoices that have difference between Header Amount and Distribution Amount.

Invoice Tolerance feature provided by Oracle Financials for India allows you to setup the Tolerance Percentages and Amounts. Wherever a hold is placed on Invoices due to difference in Distributions Total and the Invoice Header, then, the system would check for the tolerance limits setup for Organization. If the difference Amount falls within the specified limit, then this inserts an Additional Invoice Distribution line for the Difference Amount and the Invoice is Approved. This line would have the line type as ‘ Miscellaneous’ and the charge Account would be as specified in the Invoice Tolerance Setup for the Organization.

In cases where you are Re-Approving the Invoices, the system would check for the existence of an Distribution line for Rounding Amount. If one exists, then the amount of this line would be updated with the revised difference.

India Local Payables - India Localization - Setup - Others - Invoice Tolerance

Field Description

Operating Unit

User can select the Operating Unit value from the LOV.

Enable Percent Tolerance Flag

You need to enable this Flag if you want to allow Percentage based Tolerance limits. This Percentage would be applied on the Header Amount. On activating this flag, you will have to specify the Upper Percentage Value and Lower Percentage Value.

Enable Amount Tolerance Flag

You need to enable this Flag if you want to allow Amount based Tolerance Limits. On activating this flag, you will have to specify the Upper and Lower Value.

Important: Where you have specified both Percentage and Amount Tolerances then both will be applied on the Invoice and the Minimum of the two is considered as the Tolerance Limit.

Tolerance Charge account _ Id

You need to specify the GL Account to which the Rounding amount should be debited/credited.

View / Resubmit / Delete Error Tax Lines

Overview

The concurrent ‘To insert tax distributions for pay on receipt’ for processing of tax Lines for ERS Invoices created based on Purchase Receipts 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 Payables - India Localization - Other - India - Resubmit Taxes for Pay on Receipt.

The form shows Invoice Number, Number of distribution Lines, Invoice Date, Error Date, Invoice Amount, Vendor Name, Vendor Site Code and Error Message for all Tax Lines (grouped by Invoice Number) that have ended in an error during 'India - To Insert Taxes For Pay On Receipt’ program.

The user can check the records for resubmission either one or all at a time. If you would like to resubmit only one record then, you have to check the Re-Submit checkbox on the line. In you wish to resubmit all records, and then check the ‘Re-Submit All’ checkbox.

For Resubmission of the Error Invoices

For Deletion of the Error Invoices

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

Click on Submit button.

Reports

This section provides overview and detailed descriptions of the following reports:

Form 16A Report

Use Form 16A Report to print Form 16A (As per Statutory Format) for sending it to Vendors. ‘ORIGINAL’ is printed on the Form when printed for the first time and ‘DUPLICATE’ will be printed for subsequent prints of same Certificate.

If some problem occurs during printing of Certificate for first time (e.g. Printer Paper jam etc.), then navigate to ‘View TDS Certificate - India Localization ‘ Form in AP Module and set the ‘PRINT FLAG’ of corresponding certificate to ‘N’, then the next Print will print ‘ORIGINAL’ on the Certificate.

Report Submission

Use the Submit Requests (India Local Payable Module only) form and enter India TDS Certificates in the Name field to submit the report.

Report Parameters

TAN Number (Mandatory)

Select the value from the LOV.

Financial Year (Mandatory)

System will display all the Financial Years from the LOV Based on the transactions will be processed.

Organization (Optional)

Select the value from the LOV. System will use this Organization details for printing the address on the report.

Certificate Nos. From (Optional)

India Localization prints all the Certificates starting with the Number you enter for this parameter.

Certificate Nos. To (Optional)

India Localization prints all the Certificates up to the Number you enter for this parameter.

Certificate From date (Optional)

India Localization prints all the Certificates starting From the Date you enter for this parameter.

Certificates To date (Optional)

India Localization prints all the Certificates up to the Date you enter for this parameter.

Vendor (Optional)

India Localization prints the Certificates for this Vendor only, if you enter a value for this parameter.

Name of the Signee (Optional)

India Localization prints this Name in Full Name field of Certificates

Designation (Optional )

India Localization prints the Designation of the Signee on the report.

Place (Optional)

India Localization prints this Name in Place field of Certificates

Report Headings

Report Headings provide you with general information about the contents of the report. India Localization prints Certificate Number and Sheet Number of certificate on all pages, along with report heading.

Also on the first page of the Certificate Name & Address of the Company Deducting the Tax, Tax Deduction A/c No. of the Deductor, PAN / GIR No. of the deductor, TDS circle where Annual returns are filed u/s 206, Name & Address of the Person in whose a/c it is credited, PAN / GIR no. of Payee & the period are printed.

Also at the end of each certificate Total amount of tax deducted for the particular vendor (for the period) is printed in Words.

Column Headings

Invoice Date

Date of Invoice.

Amount Paid or credited (Rs.)

Invoice amount.

Amount of Income tax

Amount of Tax Deducted at source.

Challan Number and Date

Challan Number and Date on which tax was deposited to Central Govt. A/c.

Name of bank where tax is deposited

Name of bank where tax was deposited.

Report Order

Report is printed in the order of Invoice date for a certificate.

TDS at prescribed rate Report

Use TDS at prescribed rate Report to calculate Tax deducted at source for a company or others for various TDS categories like Rent, Technical / Professional Services, and Payments to Contractors/Subcontractors etc.

Report Submission

Use the Submit Requests (India Local Payable Module Only) form and enter India TDS at prescribed rate Report in the Name field to submit the report.

Report Parameters

Organization TAN Number (Required) PICK

Select the value from the LOV.

FIN Year (Required) PICK

Select the value from the LOV.

Organization (Optional) PICK

Select the value from the LOV.

TDS Payment type (Required) PICK

Enter a TDS Payment type, you wish to take the TDS at prescribed rate Report for.

Supplier Organization Type (Required) PICK

Enter a Supplier Organization type (Company or others), you wish to take the TDS at prescribed rate Report for.

Period of Report (Optional)

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

PAN Number of the Company

PAN Number of Company for which TDS has been deducted.

Name of the Company

Name of Company for which TDS has been deducted.

Address of the Company

Address of Company for which TDS has been deducted

Amount Credited or Paid

(Invoice) Amount paid or credited whichever is earlier.

Date on which Amount Credited or Paid whichever is earlier

(Invoice) Date on which Amount paid or credited whichever is earlier.

Amount of Tax Deducted

Amount of Tax Deducted for the Invoice

Date of Deposit

Date on which Tax was deducted for the Invoice.

Date on which Tax was paid to the Credit of the Central Government

Date on which Tax was paid to the credit of the Central Government.

Tax Deduction Certificate Number

TDS Certificate Number which was sent to the Supplier informing him the TDS details.

Date of furnishing of TDS Certificate to Company

Date on which TDS Certificate was sent to the Supplier Company.

Report Totals

Invoice Amount Total and TDS Amount Total for the report.

Report Order

Report is printed in the order of Vendor Name, Certificate Number and Invoice Number for the selected Organization.

India - Cash / Bank Book Report

The Cash/Bank Book can be printed as per user requirement for a range of period.

Report Submission

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

Report Parameters

Bank Name (Required) PICK

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

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

Supplier Bill Number and 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.

India-Creditors Ledger Report

Use this Report to get Creditors Sub-Ledger with complete details of Invoices, Debit Memos and Payments.

Use the Submit Requests (India Local Payable modules Only) form and enter India-Creditors Ledger Report in the Name field to submit the report.

Report Parameters

Vendor Name (Optional) PICK

If the User wants Creditor Ledger for a specific Vendor, then he need to enter Vendor Name here otherwise Sub Ledger for all the Vendors for a given period will be reported.

Vendor Number (Defaulted) PICK

Vendor Number of the above Vendor will be defaulted here.

Vendor Type (Optional)

If the User wants Creditor Ledger for a specific Vendor Type, then he need to enter Vendor Type in this field otherwise Sub Ledger for all the Vendors for a given period will be reported

From Date (Required)

To Date (Required)

Vendor Site (Optional) PICK

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.

PO No

PO Number will be reported

Organization Name

Name of the Organization Location where in the transaction taken place will be reported.

Batch Number

Batch Number for the transaction will be reported.

Invoice Type

Invoice Type will be reported

AP Invoice No / Date

AP Invoice Voucher No and Date will be reported

Supplier Bill No / Date

Supplier Bill Number will be reported

Payment voucher No / Date

Payment Voucher / Invoice No and Date will be reported

Check No and Date will be reported

Description

Description appearing in the Invoice or Payment Voucher will be reported

Account Code

GL Account for the respective transaction will be reported

Currency

Transaction currency will be reported

Exchange

Foreign Currency Dr

Debit amount in a foreign currency transaction will be reported.

Foreign Currency Cr

Credit amount in a foreign currency transaction will be reported.

Rupee Equivalent Dr

Rupee equivalent for the Debit amount will be reported.

Foreign Currency Cr

Rupee equivalent for the Credit amount will be reported.

India-Creditors Trial Balance Report

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

Report Parameters

If the User wants Creditor Trial Balance for a specific vendor, then he need to enter vendor name here otherwise Trial Balance for all the vendors for a given period will be reported.

Vendor Number of the above Vendor will be defaulted here.

Vendor Type (Optional)

Vendor Type will be shown in this column.

Account Code (Optional)

CL Account code will be printed here

As of 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.

Vendor Type

Vendor Type will be reported

Vendor Name

Vendor Name will be reported.

Vendor Code

Vendor Code (Number) will be reported

Currency

The Transaction currency will be reported.

Entered Amount

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

Rupee Amount

Rupee equivalent of a vendor will be reported

Total : Total Vendor Balances in INR

Total for the Vendor is shown in RS

Order by : Liability Account wise

India-Statement of Account for Suppliers

This statement of account of Creditors shows Invoice wise outstanding to a Vendor

Report Submission

Use the Submit Requests (India Local Payable modules Only) form and enter India- Statement of Accounts for Suppliers in the Name field to submit the report.

Report Parameters

Vendor Name (Optional) PICK

If the User this Report for a specific Vendor , then he need to enter Vendor Name here otherwise Statement of accounts for all the Vendors for a given period will be reported.

AS on Date (Required) PICK

Up to a Specific Date

Aging interval like 30 days or 15 days can be entered by the User

Number of Interval (Optional)

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

AP Voucher No

AP Voucher No will shown here

Bill no

Supplier Bill Number

Bill date

Supplier Bill No

Vendor Name

Vendor Name will be reported.

Amount

Amount of the Bill

Remarks

Remarks will be shown here

India - BOE Write Off Report

This Reports gives the Details of Written off Bill of Entry for a given period

Report Submission

Report Parameters

BOE Number (Optional) PICK

BOLE Number will be shown here

BOE Type (Optional) PICK

BOE Type will be shown here

Vendor Number of the above Vendor will be defaulted here.

Start Date (Required)

Start Date will be shown here

End Date (Required)

End date will be shown here

Report Headings

Column Headings

The following field will be reported

Bill no

Supplier Bill Number

Bill date

Vendor Name will be reported.

Amount

Outstanding Invoice Amount will be reported.

Remarks

Remarks like ‘Partly Paid’ will appear for Partly paid Invoice.

India-TDS Related Invoices Report

This Report provides with the list of All Invoices for which TDS has been calculated. For each such Invoice, all TDS Related Invoices generated for the Invoice are shown.

Event

Invoices shown

On Validating a Standard/Prepayment Invoice

Credit Memo generated for the Supplier

On Applying Prepayment Invoice to a Standard Invoice

Invoice generated for the Supplier

On UnApply Prepayment Invoice to a Standard Invoice

Credit Memo generated for the Supplier

On Cancellation of Standard Invoice

Standard Invoice generated for the Supplier

Report Submission

Report Parameters

Operating Unit defaults from the one specified for the Responsibility

From Date (Defaulted) PICK

Enter a Date here. This date is compared against the Invoice Date of the Invoices for which Tax is Deducted at Source.

To Date (Optional)

Enter a Date here. This date is compared against the Invoice Date of the Invoices for which Tax is deducted at Source

Report Headings

Report headings displays name of the Report and the Period for which this Report is generated.

The Report Details Section has two parts. One that shows the details of the Base Invoice for which TDS is calculated and the next, which lists out all TDS Invoices, related to the Base Invoice.

Column Headings

Invoice Name

This field displays the Type of Invoice and the Invoice for which this is generated.

Invoice Number

This field displays the Invoice Number

Invoice Amount

This field displays the Invoice Amount.

Invoice Currency

This field displays the currency applicable to the Invoice

Vendor Name

This field displays the Vendor Name.

Vendor Site

This field displays the Vendor Name.

TDS Section

This field displays the Income Tax Section under which TDS is calculated

TDS Tax Name

This field displays the Name of the TDS Tax.

TDS Tax Rate

This field displays the Rate.

India - VAT Returns Report

India – VAT Returns Report provides data related to sales and purchases, which can be used to fill state-specific VAT return forms. Use the Submit Requests / Other Reports form (India Accounts Payable / India Accounts Receivable) and enter India VAT Returns 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.
Organization Number Optional PICK The Inventory organization for which the report is being generated.
Location Optional PICK The Inventory Location for which the report is being generated. This needs to be left blank if all locations are to be printed. This gets enabled only if the Inventory Organization is selected.
From Date and To Date Required   Start Date and End Date for which the report is being run.

Account Payables Standalone Invoice

The standalone AP invoice is an invoice created manually by a user in Oracle Account Payables module that does not matches either to a purchase order or a receipt. The support for standalone AP Invoice functionality allows the India localization users to compute taxes such as service tax on standalone AP invoices. Primarily standalone AP invoices are raised for non-item based expense or service activities.

Value Added Tax (VAT) or Sales Tax (ST) can now be attached to invoices where item information is not critical. You can also add non-recoverable taxes of 'Any Other' type to standalone invoices. You can also use the non-recoverable tax type to add other miscellaneous charges to the invoice.

Computing Taxes on Standalone AP Invoices

You can compute taxes on standalone AP invoices in the following two ways:

Defaulting Taxes to Standalone AP Invoices

You can assign a tax category directly to a supplier site for defaulting of taxes on standalone invoices. You can do this by defining the tax category on the Supplier Tax Information India Localization window, see Defining Supplier Additional Information for the detailed information.

Tax defaulting to Standalone AP invoices happens only if a tax category is assigned at supplier site used in the invoice and when you have the invoice line in the AP Invoices workbench.

Manual Tax Computation

You can also add a tax category or tax lines manually if these were not attached at the supplier site level. You can also modify the defaulted taxes on this window. To add a tax category or tax lines, perform the following:

  1. Navigate to the invoice.

  2. Select the Lines tab.

  3. Select the invoice line.

  4. Select Tools > IL Tax Details from the menu to navigate to the India Localization Taxes window.

  5. Select the tax category at the header level, the taxes associated with this category are shown in the tax lines.

  6. Alternatively, you can also add each tax line and add precedences accordingly.

Treatment on Specific Invoices

Service Tax Recovery

If a service tax is attached to a standalone invoice line and is recoverable, then such recoverable service tax is created as a separate tax line (miscellaneous type) with the appropriate accounting code combination specified in the service tax recovery setup at the time of saving the invoice.

On validation of the invoice, the recoverable portion of the service tax is populated to the service tax repository.

Till recent, Oracle Financials for India did not allow picking the exchange rate at the time of application of the receipts. It used the Exchange rate available while entering the Invoice. The current enhancement complies with the service tax regulations and the service tax liability on foreign currency transactions is accounted based on the exchange rate applicable on the receipt date. Oracle Financials for India passes an accounting entry to bridge the rate difference between the invoice date rate and the receipt date rate.

The Service Tax interim liability is squared off based on the differential rate and the liability is not counted as part of P&L but deposited to government treasury.

Reports

All the following service tax recovery reports include the service tax information on standalone invoices.