335
as far as i know that there is no IN operator available in X++
here is the solution for learners.
Alternative of IN operator in X++ AX 2012
select sum(Qty) from InventTrans
where InventTrans.ItemId==_itemID
&& (InventTrans.StatusReceipt == StatusReceipt::Purchased
|| InventTrans.StatusReceipt==StatusReceipt::Received)
&& inventTrans.DateFinancial <= _perDate;
*This post is locked for comments
I have the same question (0)
I would like to vote for JOIN.
instead of IN operator you can think to set a join with other table or join with temp table, in a way that you keep values that you are looking to put IN, inside a table and make an inner join or exists join
Share
Report
All responses (
Answers (
