I have a customized display session (Form type 3 – multi-occ+view+main) in which I would like to summarize the detail lines.

For example, the session will display the records as follows:

Picking List # 8709
Sales Order # 100452
Loc. /Item/Qty Ord/Qty Picked/Qty Loaded
D102 A 100 100 50
D102 A 75 75 75
D105 B 75 75 75
D105 B 50 25 25


I would like to total this display session by item, as follows:

Picking List # 8709
Sales Order # 100452
Loc. /Item/Qty Ord/Qty Picked/Qty Loaded
D102 A 175 175 125
D105 B 125 125 100


What commands would I use to accomplish this?
Would I use query extension or skip.io() ?

Thanks
Barb

First of all it would be much easier to us a report instaed a display session.

But a display session can be done, too. I've done this before an suggest to do it like that:

1. main.table.io/read.view and/org main.table.io/after.read: Here you have to use skip.io() so that only 1 lines per location + item gets displayed
2. The fields of that line (qty ordered, qty picked, qty loaded) have to be determined before display by one or more separate selects.

Regards
Günther