TDS - Wrong TDS deduction if the exceptional setup in done in between fin year (Doc ID 2366203.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

Problem Summary:

---------------------

Wrong TDS deduction if the exceptional setup in done in between fin year

Steps :

---------

1)Define the new supplier CS_SUPPLIER_5

2)Define the following tax
CS_TDS_194C_12_PER @ 12%
CS_TDS_15 @15%
CS_TDS_2 @2%
CS_TDS_10 @10%

3)Define the TDS tax category
S_TDS_TAX_CATEGPRY¿ : CS_TDS_194C_12_PER
CS_TDS_TAX_CATEGORY_15 : CS_TDS_15
CS_TDS_TAX_CATEGORY_2 : CS_TDS_2
CS_TDS_TAX_CATEGORY_10 : CS_TDS_10

4)Define the third party Registration of supplier "CS_SUPPLIER_5"
and pass the default section code as "TDS Section 194(CS)"

6) Did the normal threshold setup for "COMPANY-IND' and "SEC 194(CS)"
as per following

0 to 50000 @ 12%
50001 to no limit @ 15%

7) Create the 1st invoice (CS_IDFC_1)
10000 @12% = TDS Credit Memo /TDS SI 1200 as per expected

8) Create the 2nd invoice ( CS_IDFC_2 )
50000 @ 12.6% = 6300 ( 40000*12= 4800 + 10000*15= 1500 ) as per expected

9) No do the exceptional threshold setup in between the fin year ,

10) Exceptional threshold setup :

61000 to 100000 @ 2%
100001 to no limit @ 10%

and assign the supplier i.e CS_SUPPLIER_5

11) Create the 3rd invoice (CS_IDFC_3)
10000 @ 2% = 200 Rs available on TDS tax details form but TDS invoice not
generated

12) Create the 4th invoice (CS_IDFC_4)
20000 @ 2% = 400 Rs available on TDS tax details form but TDS invoice not
generated

13) Create the 5th invoice (CS_IDFC_5)
20000 @ 2% = 400 Rs available on TDS tax details form but TDS invoice not
generated

14) Create the 6th invoice (CD_IDFC_6)
20000 @ 2% = 400 Rs available on TDS tax details from and TDS invoice
also generated

If system consider only exceptional threshold setup in that case TDS
amount should be on 200 Rs on 6th invoice ( 10000@2% = 200)

15) Create the 7th invoice ( CS_IDFC_7)

50000 @10% = 5000 Rs , Find that TDS invoice generated for 5000 Rs but it
should be
30000@2% = 600 + 20000*10= 2000 = 2600 only

Cause

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