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,
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/.../
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
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 Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,257
André Arnaud de Cal... 913 Super User 2025 Season 2
Sohaib Cheema 611 User Group Leader
