Category: Knowledge Base

Add a repeater on your report

Add a repeater on your report In some cases, it is necessary to add a repeater to your Business Central reports. For instance, if you want to print one label for each item of quantity on your Sales Order. We have created the Repeater Line temporary table for this reason.   Usage scenario 1 –

Continue Reading

How to fill temporary tables in AL-code and use them in custom layouts

In the ForNAV Designer, you can add new data items to a layout without modifying the underlying AL-code. This has the benefit of easy deployment and maintenance, because the changes only exist in custom layout, which is data and not code. Data items require temporary tables to run and custom AL-logic to fill up the

Continue Reading

Upgrade ForNAV OnPrem from DLL to Universal Code

This article describes upgrading ForNAV on-premise from DLL to Universal Code. Universal code extensions are extensions that are optimized to run on cloud and don’t use DLLs, the local file system, and other features that are only accessible for on-premise extensions. PLEASE NOTE! You need to upgrade ForNAV to Universal Code before upgrading to BC22.

Continue Reading

Paper Sources and ForNAV Direct Print

The preferred way to control the paper tray used when printing from Business Central is to use the paper source setting on a direct printer definition. In the list of ForNAV direct printers, you can select the Printer Specific paper source and then choose from the list of available paper sources for the printer: The

Continue Reading

Using request page variables to filter JavaScript records

Read how to Add request page variables to a report as a prerequisite to this article Sometimes you might want to set a dynamic filter on a JavaScript record in order to get a specific record. With the ForNAV Designer is it possible to do this when editing an AL-object from Business Central Cloud or

Continue Reading

Add request page variables to a report

You can use the report property Request Page Variables to add variables to the report’s request page. The value of the variables can later be used in JavaScript expressions to control the layout of the report. You can use this property when editing AL-object reports in your own extensions. If you want to add request

Continue Reading

Migration from Custom Report Layouts to Report Layouts

With Business Central 20, Microsoft introduced a new custom report layout subsystem with a new table layout, which works in parallel with the current custom layout subsystem. Eventually, Microsoft will deprecate the old custom layout subsystem and all Business Central extensions will need to be changed to use the new subsystem. Because Microsoft knows that

Continue Reading

Hidden ForNAV Direct Print features

In a support case today, a partner wrote that Business Central Print does not support Duplex, based on information from this article: OnAfterDocumentPrintReady Event – Business Central | Microsoft Learn After having a closer look, there are even more things not supported by Business Central: default copies, color, duplex, and custom paper trays/bins. However, ForNAV

Continue Reading

ForNAV Report Service

Today, running ForNAV OnPrem depends on a DLL, which has become the de facto way of integrating with Dynamics NAV and Business Central. However, after the move from C/SIDE to extensions, widespread use of Docker, and having to support a different model on Business Central Cloud, the value of using a DLL has decreased. On

Continue Reading

Formatting dates and numbers in JavaScript expressions

When using dates and numbers in JavaScript expressions, you often need formatting to get the desired result. The CurrReport.DotNetFormat function is helpful here, because it uses the .net format library, which can format almost everything: CurrReport.DotNetFormat(<value>,'<dotnetformatstring>’)  CurrReport.DotNetFormat(<value>,'<dotnetformatstring>’,<languageid>) – formats a value using a .net format string using the current language or a specific language.   To

Continue Reading