News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) SQL and Exchange Table

Microsoft Dynamics GP (Archived)

SQL and Exchange Table

(0) Share

Report

Report

Posted on by Irwin Tang

210

I am trying to find a way to automate daily exchange rates into GP.

It is ok to do it in SQL and not through integration manager? IE. setup some procedures to just insert the rates into the table? What will that DEX_ROW_ID column be filled with?

Thanks!

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (2)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: SQL and Exchange Table

We have a free product to import exchange rate feeds, please take a look into the below and let me know if you are interested:

mohdaoud.blogspot.com/.../currency-exchange-rates-feed-importer_4319.html
Verified answer

L Vail 65,271 on at

Like (0)

Report

Re: SQL and Exchange Table

Hi Irwin,

I think you'll be fine by populating the table directly. It's commonly done this way in my world.

Kind regards,

Leslie
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: SQL and Exchange Table

Hi Irwin,

You should not have to specify a value for the Dex_Row_ID column because they are managed automatically by SQL Server.

Hope this helps.

Adam

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans