Finance | Project Operations, Human Resources, ...

Electronic Report Export to file server outside dynamics

(0) Share

Report

Posted on by Hossam Z. EL Hassan

Hi,

Is it possible to export the electronic report Trial Balance with Details to a file server outside of dynamics using file types. My requirement is to set a recurance on the report electronic report Trial Balance with Details to run on a daily basis were it will be exported to a file server outside of dynamics. This would be and FTP folder were it will be pushed to another system.

Thanks.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello Hossam,

To my knowledge that is possible only with a workaround.

The workaround can be to put the report first on a SharePoint library as the standard output destination.

Once the file is there, you can use PowerAutomate to move it to any other destination where you need it.

That's of course not perfect but it avoids making a system modification in D365FO.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Laura Manache Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Dear Hossam,

Thank you for reaching out to Microsoft community.

Please note that you can extend the standard code and specify a custom storage location for generated reports/documents that are using ER formats. The application programming interface (API) of the ER framework lets you extend the list of storage locations for documents that are generated using ER formats .

For further references and code source example, please consider the following articles:

docs.microsoft.com/.../er-custom-storage-generated-documents

docs.microsoft.com/.../er-custom-storage-generated-files

Please let us know if this helps or if you need any other information, and we will be more than glad to assist further. Also, kindly mark as verified if the answer is helpful.

With kind thoughts,

Laura

Was this reply helpful? Yes No
Hossam Z. EL Hassan 26 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot for the information. The report export to SharePoint is working now. I need to modify the excel layout as it is including a report title and some extra rows for groupings. Also I would like to make a version with summary of the records. Also I need to change the file format to CSV. Please help me to achieve that.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Hossam,

If you want to have a CSV file then there is no need to format the excel with a title and groupings because that will get removed/changed once you convert the excel to a csv.

What you can make us of to generate the csv from the excel file that you have on sharepoint is Powerautomate that can do the file conversion for you.

Best regards,

Ludwig

Was this reply helpful? Yes No
Hossam Z. EL Hassan 26 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Thanks, as you have mentioned I was able to successuffly export to csv and remove the header using PowerAutomate. Is still have extra rows that I need to remove which are the opening balance and closing balance for each account group. Also I need to generate this report as a summary for each account instead of generating it with the details for each transaction date. How can edit the source or design of this report.

Was this reply helpful? Yes No