web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Filtering out ENUM Val...

Finance | Project Operations, Human Resources, ...

Answered

Filtering out ENUM Values in Electronic Reporting

(0) Share

Report

Report

Posted on by HR-05070626-0

16

Hi 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
)
)

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Mohamed Amine Mahmoudi 26,362 Super User 2025 Season 2 on at

Like (1)

Report

Filtering out ENUM Values in Electronic Reporting

Hi,

try this to use GetEnumValueByName function.

Please refer to this :

https://fernitudela.dev/2023/07/25/d365fo-base-enums-in-er-electronic-reporting-model-mapping-listoffields-and-getenumvaluebyname-functions/

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 683 Super User 2025 Season 2

#2

CA Neeraj Kumar 620

#3

Martin Dráb 563 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans