10
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”)
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
Share
Report
All responses (
Answers (
