Category: Knowledge Base

Add HTML text to your report in less than a minute

  For Microsoft Dynamics 365 Business Central 23, Microsoft has not only created a great HTML editor – but also made using it generic by creating an Entity Text Factbox Part that can be added to any page. Under the hood, the HTML is stored in the Entity Text table, which is also new in

Continue Reading

Region Format – Formatting values according to language

In Business Central 23, Microsoft has introduced the Format Region field on the Customer, Vendor, and Document Header pages to enable formatting to be different from the user language.   ForNAV supports an easier way of doing this: In the Designer, setting the Format using report language property to True means that the ForNAV report

Continue Reading

Sending debug reports to ForNAV

In ForNAV 7.1.x.xx and higher, you can download a debug file of your report from Microsoft Business Central. In certain cases, you can send this file to the ForNAV support desk and get them to analyze your report to figure out the problem. Procedure When a report does not work the way you want or

Continue Reading

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