My Oracle Support Banner

Tax Deducted At Source (TDS) Amount Is Not Rounding Correctly If Invoice Having Multiple Lines Resulting In Lower TDS Calculation (Doc ID 2901991.1)

Last updated on OCTOBER 16, 2022

Applies to:

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

Symptoms

ACTUAL BEHAVIOR:
---------------------
TDS amount is not rounding correctly if invoice having multiple lines resulting in lower TDS calculation.

EXPECTED BEHAVIOR:
------------------------
TDS amount should be calculated with correct rounding off of amount as per the TDS regime setup for tax amount.

STEPS OF REPRODUCTION:
-------------------------
1. Go to Oracle Financials for India -> Tax Configuration -> Tax Regime
2. Query for TDS Regime and setup following rounding basis:
  -- Tax Amount as Nearest Rupee with Rounding Factor as 1
  -- Taxable Amount as Nearest Decimal with Rounding Factor as 2
3. Then create an Invoice using following navigation:
Payables Manager -> Invoices -> Entry -> Invoices
4. Create new invoice with 10 Item Lines (lets say) of amount 192. 
5. Go to Tools -> TDS Tax Details and attach 10% TDS tax on each lines.
6. Validate the Invoice after which TDS Invoice is generated with Amount as190.
 190 is calculated as [round Off (192*10%)]*10= 190

But ideally expectation is TDS should be calculated as [round off {(192*10%)*10}] =192

Cause

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
Symptoms
Cause
Solution
References


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