showing only items with a Qty

[itguymike]

I have 1000 products with each one having up to 10 locations for that part.
i am looking to show only parts with a qty that is in either QCHOLD, QUARANTINE or SHORTDATED or where there is no qty (out of stock) in any location for that part. Any ideas how to go about this. started with what is below:


{PART_LOCATION.WAREHOUSE_ID}='XXXXX' AND
{PART.PRODUCT_CODE} like ["XXXXXX","xxxxx","xxxxxxx"]
and {PART_LOCATION.LOCATION_ID}= ['QCHOLD','QUARANTINE','SHORTDATED']

this shows me those locations but some of these locations have no parts in them, rather just show those locations only if they have a qty in them.

hope this makes some sense

mike

 

[Charliy]

{PART_LOCATION.WAREHOUSE_ID}='XXXXX' AND
{PART.PRODUCT_CODE} like ["XXXXXX","xxxxx","xxxxxxx"]
and (({PART_LOCATION.LOCATION_ID}= 'QCHOLD' and {table.quantity > 0)
or
({PART_LOCATION.LOCATION_ID}= 'QUARANTINE' and {table.quantity > 0)
or
({PART_LOCATION.LOCATION_ID}='SHORTDATED' and {table.quantity > 0))

 

[itguymike]

thank you for getting back to me, looks like it worked perfectly, will check it to make sure, thank you again.