Creating TDS invoices automatically from Debit Memos

Hi,

We work on R12 India Localization. Whenever we create a Standard Invoice and apply TDS to that invoice, a TDS invoice is automatically created by system the moment we validate the Standard Invoice. Some times, we have to book in a Debit Memo for the same transaction to the vendor. Now, in this case, we have to adjust the TDS amount manually.

For e.g. - We book in a Standard invoice for vendor X for Rs 1,00,000.00 and apply 10% TDS to it. When we validate the main invoice, system automatically generates the TDS invoice for Rs 10,000.00. Later on, we raise a Debit Memo of Rs 20,000.00. Now here, we have to manually adjust the TDS of Rs 2000.00.