Need HSN Summary tax in form level in SAP BYDESIGN

[raghubetageri]

Hi Experts,

I have a requiremnt in which line item HSN code summary is required in form level.

For example : productID HSN PRICE

BOOK 18302 45 RS

PEN 18302 5RS

Pencil 18302 10Rs

METAL 10000 12200Rs

For this i need HSN code summary For the first 3 line item HSNCODE is same and 4th Line item HSNCODE is different. So i need like as shown in below:

HSN Tax(cgst/sgst)

18302 10rs

10000 5rs

Let me know how this can be done. Thanks

[CHANDRESHJAIN]

hi

maintain data in this format from sales invoice , then use pivot table as required

regards

chandresh jain

[CHANDRESHJAIN]

i use pivot table with sales invoice

[raghubetageri]

Please can you explain in detail.It will be helpful..

Thanks

[CHANDRESHJAIN]

hi

if you need any service from my side regarding maintaining data in this format from sales invoice and generating HSN summary , i am available for freelancing work.

regards

chandresh jain