Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

Dynamics NAV Language Captions


This article applies to Microsoft Dynamics NAV data sources only.

 

When reporting from Microsoft Dynamics NAV you have three options for 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 Professional 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-2016 > Display tab

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

If you choose a specific language then Jet Professional 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.

 

 

Using the field noted above "Balance (LCY)" 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 field noted above "Balance (LCY)" the following function will not work if '000' is selected:

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

 

 

Using the field noted above "Balance (LCY)" 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)")

 

 

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 field noted above "Balance (LCY)" 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