Category: Knowledge Base

Setting the default language and format region for a report

Normally, the language and formatting of decimal numbers and dates on a report are controlled by the individual user settings in Business Central, or by changing the language in AL-code using CurrReport.Language. However, in Business Central 23, Microsoft has added a new page, the Report Limits and Settings page, which can force the language and

Continue Reading

KB Text splitter

There are places in Business Central where you can write long pieces of text. One of these is the Work Description field on sales documents. When this text gets too long, ForNAV will normally cut it off at the end of a page. If you want to display the whole text, then it needs to

Continue Reading

HTML Splitter

Long HTML texts have been a problem with Business Central reporting for a while. HTML is designed to be used on webpages and emails and these don’t have page splits. Report documents do, however, therefore we need to break the HTML off in a logical place, so we can continue the text on the next

Continue Reading

ForNAV document labels

The ForNAV Customizable Report pack comes with several label reports, some more complex than others. A subset of these labels are the document labels: Sales Shipment Label Production Label Sales Order Label Purchase Receipt Label These reports print a label for each line on the document. They are designed to be easy to use and

Continue Reading

Change aging captions

This requires ForNAV Customizable Report Pack version 7.2.0.1 or later. Sometimes, it might be necessary to change the captions of the aging buckets in the ForNAV Customer Statement and Aged Accounts reports. These captions are dynamically generated depending on the date range that is specified in the reports. However, the text parts of these captions

Continue Reading

New labels and label features

In ForNAV 7.1, we replaced some existing labels with brand new reports. The reason we did this is that the old labels were no longer compatible with the best practice of ForNAV report customization. They were created when custom report layouts, cloning reports, and adding virtual Data Items were not easily possible. To be able

Continue Reading

Add item attributes to any Business Central report

With the release of ForNAV 7.2.0.1, you can now add item attributes to any ForNAV report. Adding item attributes works for any table that has the item number in either a No. field (like the sales line) or an Item No. field (like the warehouse shipment line). To add the item attributes to a ForNAV

Continue Reading

Set up the ForNAV Swiss QR reports

Like everything else in Switzerland, the Swiss QR bill needs to be precise, and everything is required to meet exact specifications, including the QR code with the Swiss flag, which has special requirements about size, resolution, quiet zone, and the flag. These requirements mean the built-in QR font in Business Central can’t be used and

Continue Reading

Add HTML text to your report in less than a minute

  For Microsoft Dynamics 365 Business Central 23, Microsoft has not only created a great HTML editor – but also made using it generic by creating an Entity Text Factbox Part that can be added to any page. Under the hood, the HTML is stored in the Entity Text table, which is also new in

Continue Reading

Region Format – Formatting values according to language

In Business Central 23, Microsoft has introduced the Format Region field on the Customer, Vendor, and Document Header pages to enable formatting to be different from the user language.   ForNAV supports an easier way of doing this: In the Designer, setting the Format using report language property to True means that the ForNAV report

Continue Reading