Announcements
No record found.
Hello guys,
I have created my custom template(copy of existing of ledger journal template) and uploaded under office integration > document templates.
But my custom template was not displaying in the "Open lines in excel" options
How can i achieve this?
Thanks in advance for the help
Hi Chaitanya ,
Some templates are defined in the code. For example the template you are looking for is in the class LedgerDailyJournalExcelTemplate defined on the following line of code.
private const DocuTemplateName ExcelTemplateName = resourceStr(LedgerJournalLineEntryTemplate);
Because this is private variable , you wont be able to change it , so the option is to create your own class by duplicating LedgerDailyJournalExcelTemplate class and define your new template there and use it.
Hi Chaitanya,
Did you reload the system Templates from Organization administration > Setup > Office integration > Document templates?
Sukrut is correct. However, there is an alternative. You can replace the standard template with your copy. If you do need the standard template, then you should follow the guidelines mentioned by Sukrut. If you want to replace the standard with your version, you can first download the Excel file and make your changes. I think you already did this. Then you can create a new template. On the dialog, change the template name to the existing name, e.g. 'LedgerJournalLineEntryTemplate'. It will then ask you to replace the current one.
Hi Chaitanya raj，
Yes, as mentioned you need to create a new class to extend DocuTemplateRegistrationBase class and implement LedgerIJournalExcelTemplate.
A tutorial：www.alithya.com/.../dynamics-365-for-finance-and-operations-customize-the-standard-excel-template
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!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 658
André Arnaud de Cal... 468 Super User 2026 Season 1
Syed Haris Shah 333 Super User 2026 Season 1
