Category: Knowledge Base

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

Sometimes, you might want to print sales shipment information on a posted sales invoices. Because this is a one-to-many relationship – one sales invoice might be linked to many sales shipments and vice versa – you must get multiple records from the database. Note: You can also use this article to get the invoices from

Sometimes, adding the same PDFs to each document in a report is not sufficient and you must apply different PDFs, depending on the data (for example, Language). To be able to add the set of PDFs needed in a report, the Pdf.Store(key,image) function needs to be added to OnPreReport. Pdf.AppendFromStore(key) + Pdf.PrependFromStore(key), needs to be

Updated December 2022 In some cases, customers still want to have a FIK code on their invoices. To make this possible, ForNAV has a built-in function string, CurrReport.FIK(CardType: Number, Number: String, Account: String): string,which you can use to create the FIK string. If you use Continia’s Payment solution, to create the following FIK string: +71<000000004040663+12345678<

By default, the line discounts are not displayed on the ForNAV Pro Forma Invoice. This is by design; the underlying code clears the values and recalculates the line amounts. If you want to use the original lines, you can create a new JavaScript record to read them from Business Central:   Keywords: ProForma

Under the Field List in the left pane of the Designer, you can find the Report Explorer:   You use the Report Explorer to edit a report using a tree view, in the following ways: You can move around data items, sections, and controls using drag-and-drop functionality. For example, you can: Move a data item

The VAT clauses in ForNAV work just like for any Business Central report. To set up VAT clauses, you must first create a new VAT clause. If necessary, you can set up translations for the VAT clauses as well. After you have created the VAT clause, you can add it to the VAT Posting Setup:

The ForNAV Report Pack 7.0 contains a set of out-of-the-box Excel reports to enable exporting aggregated data from the Business Central Ledger tables.   Each report can be run from their respective parent page (Customer List, Vendor List, and so on).   On the request page, you can select the language of the Excel sheet

With ForNAV 7.0, you can create a custom Excel report, which has several benefits.   You can: Create the report without writing AL code – it only requires knowledge about the Business Central data model. Easily add data from related tables. Create a separate Excel worksheet per data item, which is better suited for Excel

In situations where the normal use of the Printer Selection page is not enough to select the right printer for the current user, there is an event to help you override the printer selection. It is a standard event that is called before the request page is shown. The following code is an example of