Hello,
I would like to modify the standard vendor template to include additional columns and then save it back to the system but I cannot find the template. When I download the Excel template, the data entity name is VendVendor2Entity but I cannot find this entity in the document templates section. When I seach for vendors, I get the following list which does not include the view/amend vendors template.
Any help would be appreciated.
Regards,
Thank you very much.
Hi,
Thank you for reaching out to Microsoft community.
In D365FinOps, when an entity (e.g.VendVendor2Entity) has the same root datasource (table) as a form, it will be added by default as an option in the Open in Excel section of the Open in Microsoft Office menu. Open in Excel options can be found on frequently used forms, inclusing "All vendors" from where I believe you export the Vendor document template you are mentioning. Also, the Open in Office menu provides a default export for each data entity and the data export includes all the fields in the AutoReport group on that data entity.
Please kindly consult the below articles for more details:docs.microsoft.com/.../customize-open-office-menudocs.microsoft.com/.../office-integration-edit-exceldocs.microsoft.com/.../use-excel-add-in
Another quick option to export the VendVendor2Entity including the additional columns, might be through "Excel workbook designer" feature: docs.microsoft.com/.../office-integration
Please let me know if this helps or if you need any other information, and we will be more than glad to assist further.
With kind thoughts,Laura
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 814 User Group Leader
André Arnaud de Cal... 798 Super User 2025 Season 2
CA Neeraj Kumar 622
