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.