Category: Knowledge Base

Change aging captions

This requires ForNAV Customizable Report Pack version 7.2.0.1 or later. Sometimes, it might be necessary to change the captions of the aging buckets in the ForNAV Customer Statement and Aged Accounts reports. These captions are dynamically generated depending on the date range that is specified in the reports. However, the text parts of these captions

Continue Reading

New labels and label features

In ForNAV 7.1, we replaced some existing labels with brand new reports. The reason we did this is that the old labels were no longer compatible with the best practice of ForNAV report customization. They were created when custom report layouts, cloning reports, and adding virtual Data Items were not easily possible. To be able

Continue Reading

Add item attributes to any Business Central report

With the release of ForNAV 7.2.0.1, you can now add item attributes to any ForNAV report. Adding item attributes works for any table that has the item number in either a No. field (like the sales line) or an Item No. field (like the warehouse shipment line). To add the item attributes to a ForNAV

Continue Reading

Set up the ForNAV Swiss QR reports

Like everything else in Switzerland, the Swiss QR bill needs to be precise, and everything is required to meet exact specifications, including the QR code with the Swiss flag, which has special requirements about size, resolution, quiet zone, and the flag. These requirements mean the built-in QR font in Business Central can’t be used and

Continue Reading

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