TDS NOT CALCULATED CORRECTLY FOR THRESHOLD CROSSING OF MULTIPLE THRESHOLD SETUP (Doc ID 2163782.1)

Last updated on AUGUST 22, 2016

Applies to:

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

Symptoms

On : 12.2.4 version, Tax Deducted at Source-Payables

ACTUAL BEHAVIOR
---------------
For X supplier exception cumulative setup is done as:
 
Rs 0 to 50000 TDS deduction 2%
Rs 50000 and above TDS deducted 10%
 
Case 1: Now for 1st invoice of Rs 30000 system is deducting 2%
Case 2: For 2nd Invoice of Rs 60000 system will deduct 10%


EXPECTED BEHAVIOR
-----------------------
In the above cases system should deduct 2% on Rs 20000 and 10% on Rs 40000 for the same invoice.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Cumulative Threshold Setup
2. Create a AP Standard Invoice
3. Validate the Invoice
4. Threshold is working fine as expected
5. Create another AP invoice crossing the earlier threshold limit.
6. The system is not working as expected

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform the correct Threshold deduction,which will imbalance the accounting entries and the Threshold Balances of the vendor.
The incorrect TDS will be deducted for the vendor invoice which will result in huge Tax penalties

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms