Announcements
No record found.
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 !
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.
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 ?
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.
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
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
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.
Yes all these informations come from legal entites parameters
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
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?
Hi Evelyn,
How could I set a font color for a specific text of footer?
Thanks!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 659
André Arnaud de Cal... 465 Super User 2026 Season 1
Syed Haris Shah 304 Super User 2026 Season 1
