Finance | Project Operations, Human Resources, ...

Export format of electronic report

(0) Share

Report

Posted on by Talent

Is it possible to select different export format of an electronic report ? Say for example I want Sales invoice reort to be printed in Excel, XML, ad PDF. Can I do that? What is the process?

Apart fro ER are there any other way to generate PDF and XML data from FnO?

Thanks

All responses (5)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Export format of electronic report

Hi Talent,

ER can create e-invoices (XML with embedded PDF) that you can send to your customer.

There is, however, no related electronic signature feature available for that.

This would be something that requires adjustment.

Best regards,

Ludwig
Suggested answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: Export format of electronic report

I m not expert when it come to ER but I dont think it can send via webservice. For "send it to thirdparty (webservice )", you need a customization(You can create or save with ER and send with custom code)
Talent on at

Like (0)

Report

RE: Export format of electronic report

Thanks Ludwig.

I got some more clarity about the scenario now :

It is required to generate some document from F&O in the form of XML and PDF and send it to thirdparty (webservice ) . That document should also have an electronic signature on it.

Is it something that can be achieved by electronic messaging? Or is it a purely customization that needs to be done?

Thanks
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Export format of electronic report

Hi Talent,

That should be pretty easy.

You just have to define multiple ER output destinations; one that creates an Excel document, another one that converts it into a PDF, a third one that sends out the XML, etc.

Tipp:

Have a look at the ISO20022 payment file formats.

The include an XML and Excel documents that you can send out directly or send them out as converted PDFs

Best regards,

Ludwig
huijij 19,811 on at

Like (0)

Report

RE: Export format of electronic report

Hi Talent,

ER currently supports the TEXT, XML, Microsoft Word document, and OPENXML worksheet formats.

The reference hope it will help you.https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/general-electronic-reporting

About how to create a format mapping and the types of format mappings present in Electronic Reporting,you can go through

https://dynamicsmanuals.com/2019/10/06/electronic-reporting-in-depth-format-mapping-part-1-general/

regards