Should the following "Outstanding orders" RLIST statement work ??

LIST ORDERS LIMIT NUM_ORDERED # NUM_SENT ITEM NUM_ORDERED NUM_SENT

Where all the fields are associated multivalues, I wish it did, or doesnt LIMIT work mv to mv ??

This as been a problem with Mv's forever. Here's how we do this:

If this has to be done in a standard report:

Create a DICT item which returns 1 if order qty and ship qty are the same for the mv's, return a 0 if false. Let's call it QTY_EQL for now:

then

LIST ORDERS WITH QTY_EQL=0 ← this will get the orders in question

                                and prevent bogus entries  

BY @ID BY ITEM LIMIT QTY_EQL=0 ← the exploding sort keeps the amv's together on output

NUM_ORDERED ITEM NUM_ORDERED NUM_SENT

The downside of doing this is that it can take considerable time

Don Miller

Thank you Don, your idea worked great !

View this thread on the forum...