Dynamics NAV and Business Central Language Captions

This information applies to Microsoft Dynamics NAV and Business Central data sources only.

When reporting from Microsoft Dynamics NAV or Business Central you can use any of these three options for referencing tables and fields when building reports

• Name
• Number
• Caption

In the below example of the Balance (LCY) field on the Customer table, you have the following options.

• Name: Balance (LCY)
• Number: 59
• Caption: ENU= Balance ($) ;ESM= Saldo ($) ;FRC= Solde ($) ; ENC= Balance ($)

In the Jet Data Source Settings you have the option of choosing which language module to utilize.

Microsoft Dynamics NAV 2009 R2 or earlier: General tab.

Microsoft Dynamics NAV 2013-2018 or Business Central: Display tab.

If you choose 000 then Jet Reports will use the table and field names.

If you choose a specific language then Jet Reports will use the table and field captions based on the language you have selected (table and field names will also work).

Only the languages currently loaded into Microsoft Dynamics NAV or Business Central will work.

The table and field numbers can always be utilized, regardless of the language selected.

Examples

1. Using the Balance (LCY) field noted above, the following functions will work if 000 is selected:

   =NL("Rows","Customer","Balance (LCY)")

   =NL("Rows","18","59")

   =NL("Rows","18 Customer","59 Balance (LCY)")

   Using the Balance (LCY) field noted above, the following function will not work if 000 is selected:

   =NL("Rows","Customer","Balance ($)")

   This function will not work because "Balance ($)" is a caption and is only available when using an appropriate language module

2. Using the Balance (LCY) field noted above, the following functions will work if ENU is selected:

   =NL("Rows","Customer","Balance ($)")

   =NL("Rows","Customer","Balance (LCY)")

   =NL("Rows","18","59")

   =NL("Rows","18 Customer","59 Balance (LCY)")

3. The selection you make in the Jet Data Source Settings also determines how you see tables and fields in the Jet Browser, JFX, Table Builder and Report Wizard.

   Using the Balance (LCY) field noted above with ENU selected in the Data Source Settings you will see Balance ($)

   Upon clicking on the Details tab of the Jet Browser, you would see the actual name and number of the field.