Combining duplicate results

[ignite922]

Guys,

I'm writing a new Progress result query but the output has duplicate result, please example see below:

Item Description Safety Stock On Hand On Order Qty WIP Alc Jb
------- ------------ ------------ -------- ------- ------- --------
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00

How do I combine all the same results into one line, like this:

Item Description Safety Stock On Hand On Order Qty WIP Alc Jb
------- ------------ ------------ -------- ------- ------- --------
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00

Please see my attached query file. Appreciated your help!

 

[Emma J]

Guys,

I'm writing a new Progress result query but the output has duplicate result, please example see below:

Item Description Safety Stock On Hand On Order Qty WIP Alc Jb
------- ------------ ------------ -------- ------- ------- --------
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00

How do I combine all the same results into one line, like this:

Item Description Safety Stock On Hand On Order Qty WIP Alc Jb
------- ------------ ------------ -------- ------- ------- --------
1-0121 xxxx FOR xxx 2,630.00 3,124.00 0.00 0.00 158.00

Please see my attached query file. Appreciated your help!

You are getting MRP records for each item. You are not out puting this info so why read it? I may be missing something. If you do want the MRP quantities you need to do a 'for each MRP' loop.