Regarding to filter

vandang

Hi experts,

I want to sum column Adjust cost according to each Item in Value Entry. I just use one only Value Entry Data Item, so I must sum Adjust cost and show on report.

EX:
Value Entry
Item no. Adjusted Cost
A 1
A 1
B 1

The expect report with only one Data Item : Value Entry
Item No. Adjusted Cost
A 2
B 1


Best Regards,

ssingla

Check about "GroupTotalFields" and Grouping on Reports.

vandang

ssingla wrote:

Check about "GroupTotalFields" and Grouping on Reports.

Thanks to ssingla,

After setting GroupTotalFields = Item No., report just show the last Item

ssingla

You need to define a appropriate key for value entry table for grouping on "Item No." in the report.

vandang

ssingla wrote:

You need to define a appropriate key for value entry table for grouping on "Item No." in the report.

The report can group each Item when I put it on GroupHeader. But it can't group by many Inventory posting groups (including Header and group total for each group) because GroupHeader is the highest level of report, is there any way to show many inventory posting group

Thanks