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.