Hi all,
Am doing a search for sales orders over a period of time and need to limit the location to one of our four inventory locations (warehouse 1). I have that down with:
CASE WHEN {item.inventorylocation}={location} THEN 1 ELSE 0 END
This captures everything except for non inventory items for sale, which obviously have no location. I've had little luck with incorporating both the location and item sub type 'for sale' in the Sql statement.
Any ideas??