Default Tax ID on Invoice Distribution DFF (India Localization)

 

Oracle says:

1st priority goes to manually attached TDS tax at invoice distribution level 
2nd Priority goes to  TDS tax default from  supplier additional information  site level 
3rd Priority goes to  TDS tax default  form supplier additional information at null site level

Note : If you want to deduct the TDS Invoice as per tax rate passed at TDS  Threshold setup in that case you have to remove the default tax from supplier additional information at site level as well as null site level and keep it only default section code .

Check your threshold setup which means at 

 AP Manager -> AP Tax Setups -> Setup -> Tax Setup -> India - Threshold Setup Form

For almost every Vendor Type - Section Code combination, there is a default Tax decided with the Rate.

To call this Tax as default value on DFF for a Supplier, on the AP Manager -> AP Tax Setups -> Supplier Information form, processor just populates the Default Section code and leaves the Default Tax value.

Only in case wherein user wants to override the tax coming from threshold, processor additionally populates the Default Tax value in the India AP Manager -> R12 AP Tax Setups -> Supplier Information form.

For following Supplier/Sites the value is defaulted in Distribution DFF

Query: 

SELECT   aps.vendor_id, aps.vendor_name, apsa.vendor_site_code,

         a.section_type, a.section_code, a.tds_vendor_type_lookup_code,

         jtax.tax_name, jtax.tax_id, tta.tax_id, jtax1.tax_name,

         nvl2(jtax.tax_name,  jtax.tax_name,jtax1.tax_name) final_tax

    FROM apps.jai_ap_tds_vendor_hdrs a,

         ap_suppliers aps,

         apps.jai_cmn_taxes_all jtax,

         apps.ap_supplier_sites_all apsa,

         jai_ap_tds_thhold_hdrs th,

         apps.jai_ap_tds_thhold_types tty,

         jai_ap_tds_thhold_taxes tta,

         apps.jai_cmn_taxes_all jtax1

   WHERE 1=1--(a.tax_id IS NOT NULL OR a.section_code IS NOT NULL)

     AND a.vendor_id = aps.vendor_id

     AND a.tax_id = jtax.tax_id(+)

     AND a.vendor_site_id = apsa.vendor_site_id(+)

     AND th.vendor_type_lookup_code = a.tds_vendor_type_lookup_code

     AND th.section_code = a.section_code

     AND th.threshold_hdr_id = tty.threshold_hdr_id

     AND tty.threshold_type_id = tta.threshold_type_id

     AND tta.tax_id = jtax1.tax_id(+)

     AND NVL (tty.TO_DATE, SYSDATE) >= SYSDATE

ORDER BY 2