Skip to Content
0
Former Member
Mar 03, 2009 at 05:38 AM

Problem in Report regarding the Withholding Tax Type and Code

453 Views

Hi,

I have a report of related to TDS Details...my problem is that i want CESS Amt. / TDS Amt. / Surcharge Amt. in different columns...

i think this is possible only when we query on both Withholding Tax Type with Withholding Tax Code fields...like...

Withholding Tax Type ..........Withholding Tax Code

............EE........................................G2

............IE.........................................GT

............SE........................................G1

When meet the condition, it pick the value of CESS Amt. / TDS Amt. / Surcharge Amt..and transport the value in related column..

Please note that there is lots of Withholding Tax Type value with Withholding Tax Code value fields in the table, it is right to mention all the codes separetly in my code or any other method is possible..

Pls suggest...