Category: Knowledge Base

AutoFormatExpr and AutoFormatType

Since NAV 2015 and later, using AutoFormatExpr and AutoFormatType on report columns has not produced the right results. This is because the functionality in Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central calling AutoFormatTranslate has been partly broken. Because of this, ForNAV now supports calling AutoFormatTranslate and using it to call Format directly by

Continue Reading

Data Matrix Barcodes

Usually, Data Matrix barcodes use character values of up to 128. However, it is possible to create Data Matrix barcodes with values in the full range of 0 to 255. This article describes how. First, you must change the barcode compaction mode to Binary.   When the barcode control is in binary mode, you can

Continue Reading

Set up the ForNAV Converter and the ForNAV Designer

This Knowledge Base article is relevant for ForNAV version 4.1.0.1718 and higher. To set up the source for table information, we have added an assist edit button to the ForNAV Converter and the ForNAV Designer setup dialogs:   In the dialog, you can choose the connection type from the drop-down menu and when you have

Continue Reading

Unmanaged Azure Active Directory

If your Microsoft Dynamics 365 Business Central Cloud solution hosted by Microsoft is authenticated via an unmanaged Azure Active Directory (AAD), then you must change the status to managed. Otherwise, your ForNAV Designer cannot authenticate and get access to the report and fields information in your Business Central Cloud. Most full Business Central Cloud installations

Continue Reading

List of Barcode types supported by the ForNAV Designer

Codabar Code11 Code128 Code39 Code39Extended Code93 Code93Extended CodeMSI DataBar DataMatrix DataMatrixGS1 EAN128 EAN13 EAN8 GS1-128 Industrial2of5 IntelligentMail Interleaved2of5 IFT14 Matrix2of5 PDF417 PostNet QRCode UPCA UPCE0 UPCE1 UPCSupplemental2 UPCSupplemental5

Continue Reading

Cross reference information

To support Microsoft Dynamics NAV/Dynamics 365 Business Central cross-reference tools, such as the Advanced Object Manager and Statical Prism, you can now create cross-reference information in ForNAV for fields used in the ForNAV report layout. In the Converter, you simply select the Add cross reference information in code checkbox:   This results in a new

Continue Reading

Uploading vs. changing the Microsoft Dynamics NAV / Microsoft Dynamics 365 Business Central license

The ForNAV Designer tries to get the report object source code directly from Dynamics NAV/Business Central. It uses the finsql.exe to export the object in text format. This step requires a NAV/Business Central developer license on the NAV/Business Central server. Because the finsql.exe uses the license on the server, it is not enough that you

Continue Reading

OData, Web Services, and Page 7702 not in the customer license

When running on a standard Microsoft Dynamics NAV or Microsoft Dynamics 365 Business Central license, you might have the issue that you cannot enable OData and you are not able to run the Web Service required by ForNAV, because you do not have permission to execute the page 7702 (Fields). The error message is: “Could

Continue Reading

Backslashes and line breaks

In Microsoft Dynamics 365 Business Central, a backslash sometimes represents a line break in the text. This works really well unless you actually want to display the backslash character instead of a line break! With ForNAV, you can show the backslash in a text box if the multiline property is set to no. If the

Continue Reading

Characters are shown as square boxes

Some output types, such as PDF or Microsoft Word can sometimes show characters as square boxes or not at all. The reason for this is typically that you are using a font that does not contain the characters that you are trying to display. Especially Asian languages use characters that are unknown to most Windows

Continue Reading