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 !

I have the same question (0)

All responses (11)

Answers (0)

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Pierre,

If I understand you correctly, you want to use one single template for multiple legal entities. You can check if there is already a datasource connected for the legal entity company information (CompanyInfo). If not you can add this as a datasource to map the values in your template.

Was this reply helpful? Yes No
Pierre Willocquet 92 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Pierre Willocquet 92 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pierre Willocquet 92 on at

Like (0)

Report

Yes all these informations come from legal entites parameters

Was this reply helpful? Yes No
EvelynFoerster 180 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Qwaser on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Rafael Araujo 183 on at

Like (0)

Report

Hi Evelyn,

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

Thanks!

Was this reply helpful? Yes No