Finance | Project Operations, Human Resources, ...

Dynamics Footer on my electronic reporting

(0) Share

Report

Posted on by Pierre Willocquet

Hello everyone,

I have created my own electronic reporting for purchase orders. But i want the footer to be dynamics with the informations regarding the legal entities: TVA number, adress etc... Is there any documentation on this ?

Thanks !

All responses (11)

Answers (0)

Adis 4,078 Super User 2025 Season 1 on at

Like (0)

Report

Dynamics Footer on my electronic reporting

Hi,

This may help:

How to make Dynamic Footers in Excel templates with Dynamics 365 Electronic Reporting - YouTube

Kind regards, Adis
Rafael Araujo 182 on at

Like (0)

Report

RE: Dynamics Footer on my electronic reporting

Hi Evelyn,

How could I set a font color for a specific text of footer?

Thanks!
Qwaser on at

Like (0)

Report

RE: Dynamics Footer on my electronic reporting

Hi.

I have a question regarding this thread.

I also need data in the footer and manage to do that, though I would like to control some data be in the left side, some centered and some on the right side.

When setting this manually in Excel I get the following:

Though when I set this in ER using alignment as follows:

It center it all:

Any ideas?

Also is it possible to put in a logo in the footer?
EvelynFoerster 174 on at

Like (0)

Report

RE: Dynamics Footer on my electronic reporting

Hi Pierre,

I got it managed by using CHAR(10) in the formula that forces a line break in footer:

You even can use VBA codes for formatting header and footer:

docs.microsoft.com/.../formatting-and-vba-codes-for-headers-and-footers

Kind regards

Evelyn
Pierre Willocquet 92 on at

Like (0)

Report

RE: Dynamics Footer on my electronic reporting

Yes all these informations come from legal entites parameters
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Dynamics Footer on my electronic reporting

Hello Pierre,

Is the information that you hold in your second screenprint all included in your legal entities form in D365FO?

I am especially thinking about the EUR amount that is visible there.

Best regards,

Ludwig
Pierre Willocquet 92 on at

Like (0)

Report

RE: Dynamics Footer on my electronic reporting

Thanks for your response. I still have issues. Here is how it is mapped in my electronic reporting:

So I have 4 lives centered

Here is how it is diplayed afterwards:

I would like to have 4 lines. Can you help me please ?

Thank you
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Dynamics Footer on my electronic reporting

Hi Pierre,

This should not be too difficult.

The standard Purchase Order Excel ER does not have a specific footer but you can add it as you would do it normally in Excel.

Once this is done then you just need to upload the adjusted Excel template and map the newly added fields.

You can find a TecTalk from MS here that gives an example how this can be achieved.

community.dynamics.com/.../techtalks

Best regards,

Ludwig
Sukrut Parab 71,687 Moderator on at

Like (0)

Report

RE: Dynamics Footer on my electronic reporting

Are you facing any issues while setting up your own footer ? You can create your own footer and use your mapped fields which pulls company information in the footer.
Pierre Willocquet 92 on at

Like (0)

Report

RE: Dynamics Footer on my electronic reporting

Yes this is correct. I know where to find the company informations and how to mapp it, but I want it be present in the footer of the report (so it would be present in every page of the report). Is there any functionnality (like in excel) where you can set up a footer ?