Skip to Content
May 09, 2016 at 09:38 AM

Taxsum from different tax type


Dear Experts,

I am making a report(Purchase Register Report) based on AP Invoices, I have taken all necessary tables and made report, I have taken field like DocDate,Cardname,NumAtCard,City,LineTotal and Doctotal. Upto this level report is good. Now I have to add taxes with respective tax code wise. For Example VAT, in PCH4 there are 2 statype for this 1 & 7, I want to sum these and fetch in report, same for excise it has 4 statypes.

End Report should be like below :

DocDate, DocNum, CardName, NumAtCard, City, LineTotal, VAT Amt, Excise Amt, CST Amt, Service Tax Amt, TDS Amt, Discount, Doctotal

Kindly suggest me what should I do to achieve this.