Updating GP Dynamics SQL Server Customer Master RM00101 Through ODBC Linked Tables in Access??
Posted on 2011-09-10
I have a Access Front-End application that connects to Dynamics SQL Server using ODBC Linked Tables like RM00101, RM20101, SOP30200, SOP30300 to create various custom Receivables and Sales analysis/reports. This application was built for a client and has been running for several years. The client uses the two USERDEFINED fields on the customer record in the Customer Master table (RM00101) to store some status types of the accounts and this is updated monthly from within the Access Front-End using a query. Works great and never had any problems.
The client is doing an overhaul of all the customers in the RM00101 table (I exported it to Excel) and now have a need to programmatically update the following fields using a SQL query in Access on the linked table without having to use the Great Plains GUI to call up 10,000 customers manually.
CUSTCLAS, INACTIVE and HOLD
My question is, will updating the three fields above without going through the GUI cause other problems within Dynamics?? My concern is there could be other form events that are triggered from the GUI update to change other tables, etc. and just running a SQL query on the customer master could leave some things out of sync within Dynamics. Probably not but I don't want to run a update on those fields then have the endusers getting all sorts of error messages when navigating Dynamics with the GUI.
The INACTIVE and HOLD seems like they would be restricted to just the Customer Master for obvious reasons but the CUSTCLAS could very well be populated in several other tables.
Any input will be greatly appreciated.