Share
Report
10Hi i wanted to get only purchased inventory transactions. But as this field is an enum type , so i have a hard time putting in the condition.
i know in X++ we use it like this ,
queryFilter.value(queryValue(StatusReceipt::Purchased));
However , I can’t find out anywhere what is the proper syntax I can use here for filtering my condition
FILTER(InventTrans,
AND(InventTrans.ItemId = @.ItemId,
InventTrans.DatePhysical = TransDate,
InventTrans.StatusReceipt = ‘Purchased’ /// I want this line corrected
)
)
All responses (
Answers (
