Skip to Content
0
Former Member
Aug 25, 2009 at 07:54 AM

Report development for tds deducted on expense GL accounts

167 Views

Dear Friends,

I have to develop one report for the with holding tax deducted on the expense GL accounts.

In the select lay out I will enter the expense GL range and company code and posting date range.

when I execute it has to show as

Total expenses in Rupees Total with holding tax in Rupees

G/L account Number xxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxx

When I click on the expense column it should show the line items related to that summary amount with respective vendor code

if i click on the with holding tax column system has to display the line items of the with holding tax amount with with holding base amount and with holding tax code.

Please guide me the logic if I'm using the BSEG table.

with regards