My Oracle Support Banner

GST TDS- System Is Creating RTN Of Higher Amount On Prepayment Application In Cases Of Concessional Rates When Standard And Pre-Payment Invoices Have Different Tax Rate (Doc ID 2782649.1)

Last updated on JUNE 12, 2021

Applies to:

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



Incorrect RTN invoice amount after prepayment application.
Excess amount is taken for creating RTN invoice. 


Upon Prepayment application RTN invoice should be of correct amount.

The issue can be reproduced at will with the following steps:
1. Create a Prepayment Invoice with TDS Tax Rate Percentage X, validate and generate TDS and CM invoice for the Prepayment invoice
2. Create a Standard Invoice with TDS Tax Rate Percentage 2X, validate and generate TDS and CM invoice for the Standard invoice
3. Apply prepayment to standard invoice and revalidate the invoice
4. Observe the RTN generated if of excess amount (Based on 2X Tax Rate ) than the expected amount (Based on X Tax Rate)


 Consider following scenario:

Standard invoice created with amount 100000 and TDS @2.0%
3-x5x6x6x1x3x-STD 100000
3-x5x6x6x1x3x-STD-TDS-SI-29284 2000
3-x5x6x6x1x3x-STD-TDS-CM-29284 -2000

Prepayment invoice created with amount 100000 and TDS @1.5%
3-x5x6x6x1x3x-PP 100000
3-x5x6x6x1x3x-PP-TDS-CM-29285 -1500
3-x5x6x6x1x3x-PP-TDS-SI-29285 1500

RTN generated upon prepayment application
3-x5x6x6x1x3x-STD-RTN-TDS-CM-29286 -2000
3-x5x6x6x1x3x-STD-RTN-TDS-SI-29286 2000

The following scenario occurred because of the concession provide by government during the COVID pandemic and later the concession was withdrawn.



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.