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:

Symptoms

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 :-

qty=2
price=200
Line amount=400
GST Tax rate=10%
Tax=80
Total=480

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.

qty=2
price=100
Line amount=200
GST Tax rate=10%
tax=20
Total=220
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

Cause

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