Modifying the Sales Invoice Format in Dynamics 365 Business Central Using Microsoft Word

Modifying Invoices in Dynamics 365

Most businesses require some customization to their reports and documentation; such as invoices, sales orders, etc.  With Microsoft Dynamics 365 Business Central, you don’t need a developer to help with this.  You get the options and flexibility needed using the well known interface, Microsoft Word.

Modifying the Sales Invoice format:

In the following example, I will show you how to modify the Sales Invoice format to add a field ‘Shipment Date’ and view the modified invoice.

First, use the global search to search for “Report Layout Selection”

Modify Sales Invoice in Dynamics 365

Highlight the report you would like to modify (in this example we will work with the Sales Invoice)

Select Process-custom layouts

Modify Sales Invoice in Dynamics 365

Click New and New again.

Be sure to turn on the option ‘insert word layout’ if you wish to modify in Microsoft Word.

Modify Sales Invoice in Dynamics 365

Next, click OK and then modify the description so you know which one you are working on.

Modify Sales Invoice in Dynamics 365

Now go to Process, then Export Layout to save the layout as a Word file.

Modify Sales Invoice in Dynamics 365

Open your Word file to modify the invoice.  Be sure the Field List is enabled on the developer tab in your Word program.  Next, select the source for the report (in this example, Standard_sales_invoice/1306).

Modify Sales Invoice in Dynamics 365

Drag and drop the field you would like to add to the report.  In my example, I’ve added the Shipment Date field to the invoice (drag and drop from the header field list on the left).

Modify Sales Invoice in Dynamics 365

Save and close the Word file and then back in Dynamics 365 Business Central, select Process, Import Layout and browse to your Word file.

Modify Sales Invoice in Dynamics 365

In the report layout selection window be sure to select the new layout as the selected layout if you would like it to print that one by default.

Modify Sales Invoice in Dynamics 365

Here we can see the Shipment Date now appears on the modified invoice.

Modify Sales Invoice in Dynamics 365

For more helpful tips and tricks using Microsoft Dynamics 365 Business Central, check out our great selection of blog posts.

Leave a Reply

error

Enjoy this blog? Please spread the word :)

RSS23
Follow by Email0
Facebook16
X (Twitter)34
LinkedIn47
Share