SOC 1 Type 11 Reporting

Blog

Jet Remote Data Services with SMB Suite

Posted by Samantha DeLaire

Mar 28, 2018

SMB Suite will offer a hosted Jet Remote Data Service (JRDS) instance for our SMB Cloud GP customers beginning in Q2 2018.

The Jet Remote Data Service (JRDS) data source presents a three-tier architectural design with a service component that is hosted within Internet Information Services (IIS).  It provides a fast, secure connection method for environments where Jet users have Excel installed locally and their Dynamics GP system is hosted on a different domain.

 

Detailed information on Features (Dynamics GP): 

Friendly names for tables and fields

In Dynamics GP, you may notice that the table and field names that are listed in the Designer window are somewhat cryptic. The design tools in Jet Essentials and Jet Express (e.g. Table Builder, Browser, Report Builder,Jfx, etc.) can display your table and field names in several easily readable formats, similar to the Smart List window in GP.

The friendly name feature requires three tables - JETFPG, JETTMAP, and JETFMAP.  The GP Update Utility adds these tables to your database and populates them with them with the Friendly Names provided by Dynamics GP.

 

Jet Views

Jet Views are SQL views which bring together information from one or more SQL tables into a view that is designed for reporting from.  The Jet views have been designed around common report writing areas to make it easier for report designers to create reports.  The GP Update Utility adds SQL views to the GP company database with the prefix "Jet”.  These views include:

  • Jet CustomerMaster
  • Jet CustomerOpen Application
  • Jet CustomerOpen Transactions
  • Jet CustomerPeriod Balance
  • Jet Date
  • Jet FiscalPeriod
  • Jet GL Account
  • Jet GLTransactions
  • Jet Item AllLocations
  • Jet Item byLocation
  • Jet PayrollTransactions
  • Jet ProjectAccounting
  • Jet PurchaseDetail
  • Jet PurchaseHeader
  • Jet SalesDetail
  • Jet SalesHeader
  • Jet VendorMaster
  • Jet VendorOpen Applications
  • Jet VendorPeriod Balance

(this list subject to change in future updates).

 

SQL Roles

This GP Utility feature takes advantage of the Role-based security model in Dynamics GP by offering the user access to certain tables and views.  Jet Reports has created their own User Roles as well.

The JetAllUsers role provides users with access to the following tables: 

  • SY01500 on the Dynamics database
  • JET_DATE, JETFMAP, JETFPG, JETTMAP, JETVMAP on the company database*

 

For more information, please contact sales@smbsuite.com

 

Thanks!

Samantha DeLaire, Client Engagement Manager

Office 469.351.2138 | Mobile 949.246.3884 | Email sdelaire@smbsuite.com

7701 Las Colinas Ridge, Suite 100, Irving, TX 75063

Topics: Microsoft Dynamics GP, jet reports