Gl wise tax amt for Service line item in PO

[former_member637283]

Hi Experts

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..

Regards,

[former_member197616]

Hi,

Do you want to have the tax from the PO conditions? or the amount posted on the GL account that is assigned with the tax during the  postings?

Use KONP for the PO conditions.This includes the taxes condition too.

Based upon the GL try reports S_ALR_87012279 2 / FS10N reports.

Regards,