Can someone give me the right formula?
I have a UDF field on OITM, called Std_Cost its for information purposes only its structure is Price
I am trying to query all items where the Std_Cost is 0 or null and I am not getting results.
SELECT T0."ItemCode", T0."U_AIS_STD_Cost" FROM OITM T0 WHERE T0."U_AIS_STD_Cost" =0
I just added the field and only have 1 item with a value, so I am expecting a lot of results.
Can someone give me the correct syntax on this?