Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Installing Friendly Table/Field Names and Views in GP


This article apples to Jet Reports 2009 through Jet Essentials 2012 R2.

If you are using Jet Essentials 2013 or later, please see the GP Update Utility article.

 


 

Friendly Names

If you are using Great Plains, you will quickly notice that the table and field names that are listed in the Designer window are somewhat cryptic. The Jet Essentials design tools (Browser, Report Builder, Jfx, etc.) can display your table and field names in several easily readable formats, similar to the Smart List window in Great Plains. The friendly name feature requires three tables which you can automatically create and populate using the Jet GP Update utility. This utility will add the JETFPG, JETTMAP, and JETFMAP tables to your database and populate them with them with the Friendly Names provided by Great Plains. This utility can be found in "C:\Program Files\JetReports\Great Plains\JetGPUpdate.exe".

Before running this utility you need to have configured a "Great Plains" data source in Jet Reports, have your Great Plains application open, and have "write" access to the SQL database.

Views

In Great Plains, you may have noticed that sometimes even with friendly names installed it is difficult to figure out what certain status field and type field values mean since they are often just lists of integers in the database. It is also difficult at times to figure out how certain tables are related for creating certain types of reports such as sales, purchasing, or general ledger reports. To solve both of these problems, Jet Reports has created Jet Views for some common report writing areas. These views can be installed by using the same Jet GP Update utility used to install friendly names. This utility adds SQL views to the GP company database with the prefix "Jet ". So the sales view is called "Jet Sales", the purchasing view is called "Jet Purchasing", etc. It also adds the Jet Date View and the JET_DATE table which is required to use the Jet Date view. Jet Date allows you to easily pull any dates you need out of the database.

Running the Utility

  • Run the "JetGPUpdate.exe" utility. You will see this message indicating the tables that will be added to your database.

  • Make sure you have the Great Plains application open and have logged in and click "Continue". The update utility will not let you continue until you open Great Plains and log in.

  • Choose the Jet Essentials Great Plains data source for which you would like to add Friendly Names.

  • Choose the Company and Great Plains Product for which you would like to add Friendly Names.

  • Choose whether to add Friendly Names, Views, or both. Click "Run" and the utility will run. You will need to run the utility for each Great Plains Product for which you want Friendly Names or you can select to run it for all products.

  • Once the utility is finished, configure your Great Plains data source to use Friendly Names and look for the Jet Views in the Jet design tools.

Friendly names are not necessary for Navision.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments