Gl wise tax amt for Service line item in PO
there is a requirement to create a report based on GL maintained in PO (EKKN). In EKKN, if same GL maintained then amt will be clubbed together. For Example
Po Amt : 1000
Service Line Item 10 : XXXX - Value - 500 - Gl - 20501107
20 : XXXX - Value - 250 - Gl - 30811107
30 : XXXX - Value - 250 - Gl - 20501107
Tax Amt : 100
So as per above scenario, if we check EKKN then for GL 20501107 - Net value is 750. Now I want a report with Gl - Po Amt - Tax Amt - Total value.
Problem is i m not able to find Tax Amt Calculated on Services with GL 20501107 as there is no direct link between Service Line Item & Gl in PO.
Please help me to achieve this..