Microsoft GP Real-Time Data Source

<< Click to Display Table of Contents >>

SmartConnect 2017

Microsoft GP Real-Time Data Source

A Dynamics GP real time data source may be used to push data from Dynamics GP every time an entity is updated (create or edit) within Dynamics GP.

 

To create a Dynamics GP real time data source:

1.On the Map tab, select Real Time Data Sources.
2.Select Microsoft GP Real Time Data Source as the real time data source type.
3.Double click the data source to be edited or select the Create button on the toolbar to create a new data source.
4.Select the Salesforce entity to trigger the real time data source.
5.Select the required Product
6.Select the required Series.
7.Select the required Table.
8.If more than just the base selected table is required for the SmartConnect integration, select the Define button at the bottom of the window to access Query Builder and define the required query.
9.Select the Companies button to open the companies window and define which GP companies should trigger this real time data source.
10.Select OK to save the data source.

Real Time Data Source GP

Real Time Data Source GP Companies

 

 

To add a Dynamics GP real time data source to a map:

1.Select create or select the Maps Quick Link and double click on the map to be edited.
2.If a new map enter the map id and description.
3.Select the Data Source button on the map toolbar.
4.Select Real Time Event as the data source type.
5.Select Microsoft GP Real Time Data Source as the Data Source.
6.Select the Product, Series, and Table to use for the data source.
7.Select the companies button to show the companies window and edit the GP companies that will trigger this data source and map. Note: selecting a company that is not selected on the real time data source screen will have no effect. Companies must be selected on the real time data source screen before they can be selected in this companies window.
8.To preview the columns that would be returned by this data source select the Preview button on the toolbar.
9.To validate the query select the Validate button on the toolbar.
10.Select OK to save the data source.

GP Real Time Data Source

 

GP Real Time Data Souce Companies

 

 

To register a Dynamics GP real time data source:

1.Open the SmartConnect map setup window. Using the Microsoft Dynamics GP interface go to Tools >> SmartConnect >> Map. For the external SmartConnect interface go to Map >> Setup, or select the Maps Quick Link and double click on the map to be edited.
2.If not already selected select the map to be registered.
3.Select the Register button on the map toolbar to open the Real Time Map List window. All maps linked the real time data source used in this map will be displayed.
4.Select the map(s) and event(s) that should trigger this real time data source.
5.If more than one map is linked to this real time data source, and the order the maps are required to run is important, select the Map Sequence button on the toolbar. This will open the Real Time Registration window and allow the order of maps to be specified. Specify the required map order and select OK to close the window. Note: maps must be selected in the real time map list window before they will appear in the real time registration window.
6.Select Process to update your changes. This will save your changes in SmartConnect and make the required changes to GP. Note: If users are logged into GP they will need to log out and in again before these settings will take effect.

Real Time Data Source Registration GP