HowTo #013

How to easily customize documents sent from Business Central? – part 1

Use Case:

Creating and setting up document templates can be time-consuming and expensive. When your company first implemented Business Central, the setup was tailored to your needs, but things change over time. Wouldn’t it be great if you could update these templates on your own?

That’s where this three-part series comes in. Each part covers a different aspect of report configuration. In this first part, we will focus on the document header.

Let’s dive in and see how you can make these changes easily!

HowTo: Customize the Header of a Report

01

Firstly, let’s have a look at what part of a document is meant by the Header. For example, we will have a look at the current header of a Sales Quote.

02

Go to Sales Quotes and open any Sales Quote by clicking on the blue underlined number.

03

In the top menu click on Print/Send and Print….

04

In the window that opens, click on the Preview button, to see how the Sales Quote would be printed with the current document template for Sales Quotes.

05

The part shown below is the Header. As you can see there is a left and a right part.

06

As you can see, there is already quite a lot of information shown. Let’s see how we can change this.

07

Close the document and go to Timber Reports.

08

Select the Line of the report you would like to customize and click on Edit in the top menu.

09

The Timber Report Header Setup opens. In the Header FastTab, you find all fields that are set up for the Left Header and Right Header, see below.

10

To show an additional field on either Header, simply fill the columns of a new line as follows. Let’s say you want to add the Description of the Customer Price Group.

  • Select the Table ID from which you want to add the Field. For this example, we choose Table ID 36, which automatically fills the Table Name to Sales Header.
  • Next, select the Field ID that you want to show. For this example, we choose Field ID 34, which automatically fills the Field Name to Customer Price Group.
  • Only if the Field selected has a relation with a different table, this automatically shows up in the Relation Table ID and the Relation Table Name. For this example, Relation Table 6 Customer Price Group shows up.
  • To choose a Field in this Relation Table, select a Field in the Relation Field Id column. For this example, we choose 10, which automatically fills the Relation Field Name column with Description.
  • If you want to print the line in Bold, Italic or Underlined, check the box under those columns.
  • Check the box in the Always Print Caption column to always show this Field, even when it is empty.
Extra tip: Of course, you can also change existing lines or delete lines to stop showing them in the Header. To edit a line, simply click on the field of the line you want to change. To delete a line, press the three points after the Table ID column and click Delete Line.
11

When you close the window after you made the changes, a notification pops up. Click Yes to save your changes.

12

To see what the changes look like, follow steps 2 to 5 to open a new preview of the specific document.

Conclusion

While you can only change one document template at a time, there is a lot of flexibility on what you want to show in the Header of each Report. Have fun discovering all the possibilities!

Feature of the Week

No ads: A new HowTo for acadon Software every week.
Customerday 25 Popup

Only for acadon customers

OnRoute App
Try our new OnRoute app free for 30 days!
timber tree
timber tree
acadon logo
The acadon AG has 40 years of experience in ERP software for the wood industry. As business optimizers, we develop tailored solutions and strategies for your company.
© 2024 acadon AG. All rights reserved.

Webinar registration

Request free demo now!