[Ravi]

I am trying to generate a Sales report, which includes

Item category from Item record,

Gross Total, Shipping Total, Tax total, customer name, invoice number, from Invoice record.

all i need is i need to group the transactions by Item Categoty and show sub total at each group.

I have tried to customize transaction type report, but here i am unable to get the shipping and tax amount fields

can you please explain me what type of report i have to generate and what i need to do to show sub total by item category group.
This is a cached copy. Click here to see the original post.

[Devika B.M.]

RE: Sub total by group

Hi

Since you need all columns based on Item Category Please choose first

column as Item Category.Under customization, select 1st column and tick the box for Group.select 2nd column and tick the box where it shows Group with previous column.

If you have already tick for the box Add Grand Total,you will now get

the subtotal for each category.

Hope this information helps.

[Author]

Posts