News / Knowledge Base

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

New ForNAV pricing to align with Microsoft pricing

Additional production environments on cloud In accordance with our strategy to follow the Microsoft pricing structure, we have decided to align our ForNAV Cloud pricing with Microsoft pricing and introduce a new price for additional production environments in Microsoft Dynamics 365 Business Central Cloud. If customers have additional production environments in the same tenant on

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