Category: Knowledge Base

Calculating sums in JavaScript

Sometimes it is useful to be able to calculate the total of a field across a table without running through all the records like the Rec.Calcsum() function does in AL. To do this, you can simply use the Sum value on a FieldExtension field: List.FieldExtensions.Amount.Sum If the field is a calculated field, Business Central will

Continue Reading

Changes to the Cloud ForNAV layout and custom layout format

In Microsoft Dynamics 365 Business Central 20 (2022 release wave 1), Microsoft is starting to move the Word rendering subsystem from being open for modification to a proprietary and closed system. As a replacement, Microsoft is introducing a new layout type that does not piggy back on the Word format. From the beginning, ForNAV cloud

Continue Reading

Signing PDFs

To sign a PDF, you can use the following JavaScript: CurrReport.PrinterSettings.Sign.Certificate = ForNAVFileStorage.Data; // the value must be a blob field containing the certificate. CurrReport.PrinterSettings.Sign.Password = ‘abc’; The certificate must be a valid pfx certificate. Keywords: digital signature signage

Continue Reading

Direct Printer Definitions

Before reading this article, please make sure you have familiarized yourself with the ForNAV Direct Print overview: https://www.fornav.com/direct-print/, and installed and configured the ForNAV Direct Print service or client.   With ForNAV 6.2 (and later versions), you can define local printers and print ForNAV, RDLC, and Word reports to them directly, without seeing the usual

Continue Reading

ForNAV Direct Print Service – Getting Started

Before reading this article, please make sure you have familiarized yourself with the ForNAV Direct Print overview: https://www.fornav.com/direct-print/. This step-by-step guide helps you to quickly set up the Direct Print service functionality of the ForNAV Customizable Report Pack in Microsoft Dynamics 365 Business Central. If you prefer, we also have a couple of Coffee Break

Continue Reading

Printing ForNAV, RDLC and Word reports directly to a server printer

This article is relevant for Business Central OnPrem customers only   Before reading this article, please make sure you have familiarized yourself with the ForNAV Direct Print overview: https://www.fornav.com/direct-print/.   With ForNAV 6.2, you can now print ForNAV, RDLC and Word reports directly to a printer OnPrem, without having to print to a PDF first

Continue Reading

Print to Excel and Print to Excel dataset

With Microsoft Dynamics 365 Business Central 19, the ForNAV Customizable Report Pack also can print to Microsoft Excel. In OnPrem, after you click Send to on the request page, you see the following:   In Business Central Cloud (requires ForNAV 6.2 or later version), it works a bit differently because ForNAV piggybacks on the Word

Continue Reading

Working with drag-and-drop in the ForNAV Designer

Single select Dragging fields or other values from the Field List is the easiest way to create new controls in the ForNAV Designer. For example, dragging the Name field from a Customer data item to an empty space in a section creates a new textbox control:   If you press the Shift key just before

Continue Reading

Upgrading ForNAV OnPrem reports to a newer version

  Re-conversion of reports no longer needed   Until now, it has been necessary to re-convert ForNAV reports to enable them to run on a newer version of Business Central and NAV. This is due to ForNAV OnPrem reports using a DLL and, because Business Central does not support side-by-side versions of DLL (unlike other

Continue Reading

ForNAV email body layouts

This article is relevant for ForNAV 6.2 and later versions, and Business Central 14 and later versions. The ForNAV Customizable Report Pack now comes with a set of email body layouts.   If you do not select an email body layout when you select a report (or it is a new installation), the default email

Continue Reading