Hello,

We are trying to get a summarized list in excel of our item transactions by item code.

For example, if i'm looking at an item trasaction view of a specific item i see this...

Collapsed None
Item Code Name Date Quantity Type
WDGTA Widget A 1/1/2015 2 SO
WDGTA Widget A 1/2/2015 1 SO
WDGTA Widget A 1/3/2015 3 SO
(footer summary) 6

or if i collapse all i see this...
Collapsed All...
Item Code Name Date Quantity Type
WDGTA
(footer Summary) 6

However, if I try to export to excel i get all transaction details.  I can certainly use some excel magic to summarize the data but this is an extra step that i don't think is needed.  I only want to print or export to excel the collapsed all view.

Is it possible to get a summarized export or printout in item transactions or do I need to be using a different view?

I've been struggling with this for months.  Any suggestions would be appreciated.

Thanks

Mike