Notifications
Announcements
No record found.
Hi All,
Can anyone help or provide a link, how to add or bind an Enum value or name in excel using electronic reporting report. Actually I want to create custom report (Excel) of Vendor transaction with enum value of transaction type.
Thanking you in advance.
Regards,
Vijay A Vishwakarma.
Hi Vijay,
I might have done something similar to what you are seeking (not 100% sure) for the Fixed Asset Roll forward report, which is also done via Electronic reporting and Excel format.
The client wanted to show the FIXED ASSET STATUS in the report.
However this is an ENUM field, so D365FO would allow me to just add the ENUM. So I used a formula to convert to a STRING, and this worked for me.
FAssetSTATUS: String = MID(TEXT(@.'>Relations'.AssetId.'book()'.Status),37,15)
Maybe it might be a solution for you.
Regards
James
The following blog mentions CASE function, for each enum value, type in the value you want to display in your report.
The formula is something like:
CASE(@.’purchLine()’.’getItemType()’, Po_Line_Type.Item, “Stock”,Po_Line_Type.Service, “Service”)
antoineabastian.wordpress.com/.../
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 551 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
