cancel
Showing results for 
Search instead for 
Did you mean: 

Taxsum from different tax type

former_member209725
Participant
0 Kudos
57

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

former_member209725
Participant
0 Kudos

Hi Niraj,

Many thanks for replying. I tried but not succeeded. Let me try SQL view for this and will let you know.

Thanks,

Ravi.