Hi, we have to enter a lot of prior FX Rates,i'm tempted to do a SQL script in DYNAMICS.DBO.MC00100 and enter them like this:
NOTE: the Currency ID is USD-UYU and the Rate Type id is USD-UYU-DAILY.
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-01 00:00:00.000','1900-01-01 00:00:00.000',42.1270,'2025-12-31 00:00:00.000');
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-02 00:00:00.000','1900-01-01 00:00:00.000',42.2260,'2025-12-31 00:00:00.000');
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-03 00:00:00.000','1900-01-01 00:00:00.000',42.2850,'2025-12-31 00:00:00.000');
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-04 00:00:00.000','1900-01-01 00:00:00.000',42.1080,'2025-12-31 00:00:00.000');
I just wonder if someone else tried it this way.
Have you tried Integration manager?