I have 2 user-defined fields Purchasing Category and Purchasing Sub-category
I want to build a FMS on Purchasing category and Purchasing Sub-category.
Please look at the screenshots attached.
SELECT T0.[U_Purchasing_Catagory] FROM OITM T0 WHERE T0.[ItemsGrpCod] = $[$4.0.0].
Please let me know why this FMS doesn't work and suggest changes.