There is a requirement for an order report to be generated in Excel format. I came across an IFS document mentioning that this can be achieved via Report Plug-ins (Excel Plugin). Could someone help with this or share any documentation on how to proceed with the development?
Thanks in advance.
Regards
Best answer by Edwards
Hello,
I don’t have access to version 25R1 (using 24R1), but presuming its the same you should be able to look in the report definitions of an order report that already has the excel plugin layout definition, export it, and copy it to the report that you need to make exportable to excel.
For example, I exported the “ExcelPlugin.rpl” from the Customer Ledger Age Analysis report that already had the excel plugin layout in our environment, copied it to the purchase order report, and then when printing purchase order report it would create an excel file with the columns matching the report schema
Hope that helps. below are some images from my environment to showcase.
I don’t have access to version 25R1 (using 24R1), but presuming its the same you should be able to look in the report definitions of an order report that already has the excel plugin layout definition, export it, and copy it to the report that you need to make exportable to excel.
For example, I exported the “ExcelPlugin.rpl” from the Customer Ledger Age Analysis report that already had the excel plugin layout in our environment, copied it to the purchase order report, and then when printing purchase order report it would create an excel file with the columns matching the report schema
Hope that helps. below are some images from my environment to showcase.