Help with Crystal Formula

[cis12232004]

I created this formula in the Select Expert menu to return only those inventory IDs that have items still outstanding:

{PurchOrd.RcptStage} = "P" and
{RptCompany.RI_ID} = ToNumber(RIPARAM( "RI_ID" )) and
{@QtyOpen} <> 0.00

This formula works fine but now the Warehouse Manager says he wants the report to return all items in a Purchase Order where any inventory items are outstanding. I am stumped. Can someone please givej me another perspective because I have been going over this and tried several amendments but did not get the results that I need.

Thanks.

 

[synapsevampire]

What does " Purchase Order where any inventory items are outstanding" mean? Items not yet shipped, or?

In general the items list of a PO should have a ship qty and date for each item, so you would probably look at those where there's a difference between the order qty and ship qty, or those items with a null ship date.

Try posting technical inforamtion:

Crystal version
Database/connectivity used
Example data (show tables/fields involved)
Expected output

-k