Below we have outlined some helpful tips and tricks you may want to consider when creating the Template and Workbooks Report.

Word Template

When using tables, such as for the creation of Line Items use an unformatted table – this prevents any unwanted formatting being applied to values in the table when placeholders are filled.

When entering currency and numeric values into table cells set them to be right aligned so thattens, hundreds, thousands and so onalign nicely.

When using a placeholder for a percentage value, manually add the % symbol after the placeholder as this will not pull through to the Word Document.

Consider using tables with hidden borders, this will help format and align text nicely and help space out information once the merge fields have been populated. 

Placeholders within Headers and Footers will not bind. If you would like the Company Address repeated in the Header of every page, it must be hardcoded in the template. Therefore, if you have multiple Own Organisations, you will need to build a separate template for each Own Organisation.

Placeholders within Text boxes will not bind. If you want text to show in a particular area of your document, you will need to use tables.

Credit Note amounts are stored as negative numbers and therefore require calculated columns to pull them through into the template as positive amounts.

Report

When creating the Report you may want to prefix the Report with something such as  WORD in order to easily locate the reports associated to templates, alternatively you could apply a Template Category of “Word Add-in” as a means of locating them.

When building the Report, only apply criteria sparingly, try to create as simple Reports as possible so that they run quickly without criteria. More details on how to ensure reports run quickly can be found here

If you want dates in your template,  they’ll automatically appear in the format “dd-mmm-yyyy” for example “25-Dec-2020”.  If you want to change the output style of the date use the advanced tab in the Report column and change display as “default” to display as “date” and then select the format you want to see it in.