Sage 300 2014 (62A)
We need to add a new currency rate type for several databases. We have a script to deploy an SQL script to all of our databases. So I tried to make that SQL script an Insert statement to the CSCRT table.
Running the INSERT statement on a test database did insert the record into the table, but it did not show up on the front-end. Looks like the Accpac Views somehow did not refresh the data from the back-end table.
Is there any way to achieve this so we will not have to log into every single database just to add a new record?
We need to add a new currency rate type for several databases. We have a script to deploy an SQL script to all of our databases. So I tried to make that SQL script an Insert statement to the CSCRT table.
Running the INSERT statement on a test database did insert the record into the table, but it did not show up on the front-end. Looks like the Accpac Views somehow did not refresh the data from the back-end table.
Is there any way to achieve this so we will not have to log into every single database just to add a new record?