It is difficult to mix data from another server into a Dynamics GP SmartList because of how the data link is opened within Dynamics GP. In fact I was unable to find a good general purpose solution in my search.

Oh no!

So I wanted to mention a work around that I haven’t seen proposed elsewhere. We used SQL Server one-way transactional replication to set up a copy of the foreign data inside our Dynamics GP database, and used that copy in the SmartList. It works well.

A happy chef

Setting up transactional replication and including additional tables (or views) in a SmartList are topics that are well covered elsewhere. I just wanted to mention that transactional replication can fill this need. Perhaps someone will come across this note in the future and be saved a little time.

Leave a Reply

Your email address will not be published. Required fields are marked *

 characters available