My Oracle Support Banner

OFI : Incorrect Tax Deducted at Source (TDS) Calculation For Matched Invoices Having Invoice Price Variance (IPV) Lines (Doc ID 2916115.1)

Last updated on MARCH 07, 2023

Applies to:

Oracle Financials for India - Version 12.2 and later
Information in this document applies to any platform.


Actual Behavior
Incorrect TDS amount generated for PO/receipt matched AP Invoice where IPV lines exists.

Expected Behavior
Expects correct TDS amount should be calculated for matched invoices having IPV lines.

Steps To Reproduce

The issue can be reproduced at will with the following steps:

1. Navigate to Oracle Purchasing > Purchase Orders > Purchase Orders.

2. Create Purchase Order (PO) for item having unit price=200 and qty=2 (say).

3. Navigate to Tools > India Tax Details and apply GST , lets say Tax rate=10%

Till this point of time below are the key details :-

Line amount=400
GST Tax rate=10%

4. Approve the PO.

5. Navigate to Oracle Purchasing > Receiving > Receipts.

6. Create receipt by confirming Tax and perform PO delivery.

7. Navigate to Oracle Payables > Invoice > Invoices.

8. Create AP Invoice by matching the receipt which we created in above steps , while matching take unit_price=100 and qty=2.

9. Validate the invoice and observe that wrong TDS got calculated as mentioned below.

Line amount=200
GST Tax rate=10%
TDS Tax rate=10%

TDS calculated=10% of 400(total line amount at PO/Receipt level)

TDS should have calculate as 20, i.e. 10% of line amount at AP invoice level i.e. 200


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.