Category: Knowledge Base

Custom Address Formatting

In ForNAV 6.0, you get additional options to format addresses. We have extended the FieldGroups function to work with the new Custom Address Format functionality in Business Central. For this to work, in the Countries/Regions table, in the Address Format column, you must select Custom. If you do not set a Custom format you can,

Continue Reading

Update ForNAV Cloud

When Microsoft introduces new versions of Microsoft Dynamics 365 Business Central Cloud/SaaS, customers are automatically upgraded to the latest version of Business Central. When it comes to apps (such as the Customizable Report Pack from ForNAV), you must manage the update yourself. For this, Microsoft has added a new feature to the Business Central Admin

Continue Reading

Adding different watermarks to each page

Sometimes you might want to have different watermarks in the report output. To do this, you can use one of the following two options: Use the ReportForNav.LoadWatermark (AL) or the ReportForNav.AddWatermark (JavaScript)  functions in OnPreReport to set up the watermark per page: In AL: ReportForNav.LoadWatermark(<pageno>,<outstream>) In JavaScript: CurrReport.AddWatermark(<pageno>,<blobfield>) Where pageno is interpreted as 0 =

Continue Reading

1ClickFactory and ForNAV

This article is relevant for ForNAV 6.0.0.2064 and newer versions. The target audience for this article is ForNAV customers who are connecting to a Business Central service tier running on a server hosted by 1ClickFactory (1Click). ForNAV and 1ClickFactory are working together to make it as easy as possible to use the ForNAV Designer and

Continue Reading

License Validation

This article is relevant for ForNAV installations OnPrem or private cloud. If you are running ForNAV for Microsoft Dynamics 365 Business Central Cloud/SaaS, please write a mail to support@fornav.com. You might find yourself in a situation where you have a ForNAV license installed but you continue to see the Trial message on your reports. There are a

Continue Reading

What are the advantages of using ForNAV over Microsoft Word when it comes to reporting?

In Microsoft Word, doing anything other than simple totaling – such as adding fields, data items or data from related tables – requires considerable development work, for example, you have to have different columns for different formatting because using Word in Business Central does not allow for macros or scripting. Maybe you’ve found it impossible

Continue Reading

Backup when saving from the ForNAV Designer to a server

When developing on Business Central, you might assume that your data and extensions are safe from being deleted, and it is very easy to forget to take backups, especially on sandboxes where there is no customer critical data.   However, your extensions or customer layouts can easily be deleted by mistake or automatically, for example:

Continue Reading

FieldExtensions and FieldGroups

This Knowledge Base article is relevant for ForNAV Designer version 5.5 and higher.   Until now, it has required some coding in JavaScript to format pairs of captions/values and to hide the caption if the value is blank.   For example, in the ForNAV report pack, the standard footer looked like the following: [ CompanyInformation.PhoneNo 

Continue Reading

JavaScript Records

We have extended the JavaScript Record functionality so that most database operations can be done without writing JavaScript code.   To change or add a JavaScript Record in a report, in the Property Grid, in the Records row, click the assist edit button (…).   In the Collection Editor, you can now add or change

Continue Reading

Calculating week numbers

JavaScript does not have a built-in function to calculate the ISO week number from a day. Therefore, to get the week number, in the ForNAV Designer, you must paste the following code into the OnPreReport trigger:   Date.prototype.getWeek = function() {   var date = new Date(this.getTime());   date.setHours(0, 0, 0, 0);   // Thursday

Continue Reading