Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Give Feedback

Dynamics NAV Language Captions


This information applies to Microsoft Dynamics NAV data sources only.

When reporting from Microsoft Dynamics NAV 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 ($)

Field_Name_Caption_Number.PNG

 

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

NAV_2009_language_module.png

 

Microsoft Dynamics NAV 2013-2016:  Display tab

NAV_2013_language_module.png

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 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.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments