Hi,
I tried to produce a saved search which details the quantities sold plus available quantities at multiple locations.
I can not find a logical way to do this and am not even sure if it is possible.
Essentially the users would like to see 2 things:
a. stock level at location a and location b
b. number of sales orders from location a and locations b of a particular order type
I tried the following formulas:
CASE WHEN {transaction.type} = 'Sales Order' AND {transaction.custbody1} = 'Direct' THEN {transaction.Quantity} end CASE WHEN {transaction.type} = 'Sales Order' AND {transaction.custbody1} <> 'Direct' THEN {transaction.Quantity} end
Above formulas work just fine until I try to add inventory columns and the entire saved search then displays incorrect numbers: It happens when I try to add something like this:
CASE WHEN {inventorylocation} = '1.Wholesale Fulfillment' THEN {locationquantityavailable} ELSE 0 END
The figures do not seem to add up in any case, and I am not sure of how to make the dates range specified by the user take effect.
Not sure if this is possible or if there is a better way of achieving this information summary for the user?
Thanks,