My Oracle Support Banner

Tax Deducted at Source (TDS) Invoice Is Getting Generated With Incorrect Amount When Prepayment Is Applied Before Validating the Standard Invoice (Doc ID 2959489.1)

Last updated on JULY 07, 2023

Applies to:

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

Symptoms

When prepayment is applied to the Standard Invoice which is in 'Never validated Status', TDS Invoices are getting generated with incorrect amount.

The issue can be reproduced at will with the following steps:
1. Navigate to India Local Payables --> Invoice -- Invoice.
2. Create a Prepayment with TDS, Validate the invoice and make payment.
3. Now Create a standard Invoice with TDS and amount greater than prepayment.
4. Apply Prepayment to the Standard Invoice before validation.
5. Observe that TDS is generated with incorrect amount.

Sample :

Invoices
Invoice Type Invoice Num Invoice Amount TDS Percentage TDS Invoice Amount
Prepayment 1 3000 10% 300
Standard Invoice 2 4000 (2 lines) 10% 400

1. Create prepayment invoice with 3000 and attached 10% TDS
2. Validate the invoice and TDS Invoice with 300 has been generated. Now make the payment.
3. Create a Standard Invoice with 2 lines 3000 accrual and 1000 item line.
4. Attach 10% TDS on both lines and explicitly save TDS tax details at TDS form. 
4. Apply the prepayment before validating the invoice. 
5. Post validation, TDS Invoice generated with 400 amount which is incorrect.

Changes

 

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
Changes
Cause
Solution


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