Author: Jan Sillemann

How to translate attachment names

The event subscribers mentioned in this article were tested with Business Central 2023 release wave 1 (BC22). We cannot guarantee the correct working on different Business Central versions, as these event subscribers might change between versions. When Business Central generates email attachment filenames, it uses a hardcoded way of generating them. For Business Central 2023

Continue Reading

Password protection of PDF files

You can password protect PDF files using JavaScript in the PreReport trigger:  CurrReport.PrinterSettings.PdfEncryption.OwnerPassword = ‘MyOwnerPassword’; CurrReport.PrinterSettings.PdfEncryption.UserPassword = ‘MyUserPassword’;     And you can use the DataExtractionAllowed, PrintingAllowed, ModificationAllowed, and InteractivityAllowed properties to specify what you can do when using the UserPassword:  CurrReport.PrinterSettings.PdfEncryption.DataExtractionAllowed = false; CurrReport.PrinterSettings.PdfEncryption.PrintingAllowed = true; CurrReport.PrinterSettings.PdfEncryption.ModificationAllowed = false; CurrReport.PrinterSettings.PdfEncryption.InteractivityAllowed = true;

Continue Reading

How to hide line captions based on expressions

Note: This requires as a minimum version 7.0.0.0 of the ForNAV Designer and extensions A recurring issue in report design is how to hide column headers when there is no value in any of the records in that column. For example, in the following order, we have not yet added a unit price (highlighted in

Continue Reading

Client print multiple documents

When using ForNAV Direct Print, you can choose to let a central Windows service handle all your print jobs, or you can download the jobs and print them automatically from the web client. The latter option is called client print, and this is often used if you do not have a centralized printer setup. It

Continue Reading

Use the address from the Responsibility Center instead of the address from the company information on document reports

On document reports, sometimes you might want to use the address from the Responsibility Center instead of the address from the company information. To enable this, you have to modify the template: Create a new ResponsibilityCenter JavaScript record linked to the Responsibility Center code on the header. Modify the source expression of the control on

Continue Reading

Support for reports with lots of pictures

Using thumbnails instead of full-size images for picture-heavy reports Often, you might want to mix text and pictures in a report. However, Business Central has a number of limitations in terms of the size of the dataset and the maximum time to create the report output, which limits the combined size of pictures a single

Continue Reading

Add aging buckets on Aged Accounts Receivables

Minimum requirement: ForNAV Report Pack version 7.1.0.2 There are several ForNAV reports that display aging information. They display the age of the open entries. By default, the aging is displayed in five buckets, from current to older than the last date. The following reports print aging: The Customer Statement Aged Accounts Receivable Aged Accounts Payable

Continue Reading

Automatic selection of bank accounts in Business Central reports

In ForNAV 7.1 and higher, it is possible to set different purposes for your bank accounts and to generate your reports with the right bank account number automatically. The Bank Account Selections function works on the following tables: “Sales Header” “Sales Shipment Header” “Sales Invoice Header” “Sales Cr.Memo Header” “Return Shipment Header” “Return Receipt Header”

Continue Reading

Direct Print and Follow-Me Printing

Do you want to use ForNAV Direct Print with a Follow-Me print solution? Here is a helpful hint on how to successfully combine the two. You might find it challenging because the Follow-Me print software typically uses the user ID on the print job to determine where to send it. Unfortunately, with the service-based edition

Continue Reading

Install the ForNAV Report Service on Docker

With the new addition of the Report Service, you also need to install it when you want to run ForNAV in a Dockerized Business Central installation. To do this you: Build your Business Central container but open port 8080 as well. Copy the ForNAV installer and the universal code extension files Install the ForNAV Report

Continue Reading