Skip to content
+1-888-319-3663

COMMUNITY FORUM

Using "Changing Only" for Data Source Type with multiple GP tables

Lewis asked 4 years ago
When using “Changing Only” for Data Source Type with joining multiple GP tables (SY01200 & PM00200)..  Can the “Microsoft Change Data Source” Data Source Type be used or  will the “MSSQL Table Change Data Source” Data Source Type be required?
 
Example
 
SELECT * FROM PM00200
    LEFT JOIN SY01200 ON PM00200.VENDORID = SY01200.MASTER_ID AND
                   PM00200.VADDCDPR = SY01200.ADRSCODE AND
                   SY01200.MASTER_TYPE = ‘VEN’
 
 
Answers
Lorren Zemke Staff answered 4 years ago
Lewis,
You can use the either the Dynamics GP Change Only or MSSQL Change Data Source. In both cases, click on the modify button and you will then be able to add additional tables to your query.
The main point to understand is that you need to make sure you use the right join type to ensure you get data when the integration executes. As above, you have a Left Join, so within the Modify query window, you can right click the link line and choose that proper join type.
 
Lorren
Lewis replied 4 years ago

Lorren.. Thank you for the reply, this question is resolved.


If you would like to submit an answer or comment, please sign in to the eOne portal.