Taxsum from different tax type

[former_member209725]

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.

Regards,

Ravi.

[Former Member · Accepted solution]

Hello Ravi,

Create two Groups One is Tax Code and Statype.

Pull the Tax amount on the Detail Section and insert summary of Tax Amount on Group Footer of Tac Code.

Suppress all the sections just display Group Footer of Tax Code and Display all the objects DocDate, DocNum, CardName, NumAtCard, City, LineTotal, VAT Amt, Excise Amt, CST Amt, Service Tax Amt, TDS Amt, Discount, Doctotal on the Group Footer along with the summary that you just created.

Let me know if this helps

Regards

Niraj