When multiple thresholds for TDS are setup, TDS is being calculated correctly for multiple rates, but for reporting purpose, it is required to bifurcate TDS deduction rate wise.
This can be added in TDS enquiry report.
For e.g. For below TDS threshold designer
Range ==> TDS Rate
0 - 240000 ==> 0%
240000 - 300000 ==> 0.25%
300000 - Max ==> 1%
For an invoice of 3,20,000, TDS Should be (60000*.25% + 20000*1%) = 350 which system is calculating perfectly. But in TDS enquiry report (Tax > Inquiries and reports > withholding enquiries > TDS/TCS enquiry), it shows like in single line.
Amount Origin : 320000
Percent :1
Withholding Tax : 350
It should show in 2 lines
Amount Origin : 60000
Percent :.25
Withholding Tax : 150
Amount Origin : 20000
Percent :.1
Withholding Tax : 200