• 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…

    Read more

  • 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…

    Read more

  • 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…

    Read more

  • 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…

    Read more

  • 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…

    Read more

  • 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…

    Read more

  • 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;

    Read more

  • 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…

    Read more

  • 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…

    Read more

  • 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…

    Read more