“When running only Changer for GL, does it change the accounts in the Payables distributions?” Yes, Changer will change the accounts in all modules.
Read More
“Can Account Format of a company in Dynamics GP be changed using Changer?” Account Format can be changed using Changer as long as the changes are made within the Account Framework (Maximum segments and maximum length for each segment) specified for the installation.
Read More
“Why are the Changer buttons dimmed even though the process is not running?” Changer was stopped before completion on the last run. The data from the following tables in the dynamics database should be deleted: CHG_ACT1, CHG_ACT2, CHG_ACT3, CHG_ACT4.
Read More
“Why are some GL Accounts not validating during the validation process?” Make sure the old and new accounts have the same ‘Posting Type’ and the same ‘Account Type’.
Read More
“Invalid column name IVIVOFAC error during the server installation of Changer.” This error is usually because of wrong structure of the Project Accounting table PA11801. This table should have as many IVIVOFAC columns (starting with IVIVOFAC_1) as the maximum number of segments defined in the account framework. If the Project Accounting module is being used, […]
Read More
“I am currently working in Changer and I received a message saying Please check the reject.rjt file for records rejected. Where would I find this file?” You will find this file in the same directory as the import file.
Read More
“I am getting an error ‘Invalid Object name XLImport’ while running Changer to change GL accounts.” You would get this error if Excel-based budgeting is not initialized. The following steps can be taken to eliminate this error message. In Great Plains, go to Cards > Financial > Budgets. You will be prompted to initialize Excel-based […]
Read More
“I am getting an error ‘Invalid column name EACCNBR_6’ during server installation of Changer.” This error implies that the table structure of one of the tables with column EACCNBR is wrong. The following tables would have this column: PM70500, IV70500, RM00700, UPR70500, MC10000, DTA00700. Each of these tables should have as many EACCNBR columns as […]
Read More
“Users are receiving an error ‘Invalid column name PERIODDT’ at 10% during server installation of Changer on Dynamics GP version 10.0” This error could be related to two tables: 1. Table XLImport of Excel Based Budgeting module. A new column PERIODDT was added to this table in version 10.0. If this column does not exist […]
Read More
“User gets the following error while trying to install Changer at 5%: SQL Error: 207(Microsoft)(ODBC SQL Server Driver)(SQL Server)Invalid column name ‘ACTINDX’. The progress window shows that ChangerGLIdx3 is being installed when the error comes up.” Check if Encore Business Solution’s Bank Reconciliation module is being used. If this module is used, check if the tables […]
Read More
“Users are getting ‘Invalid column name EMPLOYID’ message while installing Changer on version 2010 of Dynamics GP.” Check the File name in the Progress window when you receive this error. If the file name shows as CHG3180UPR, this error is related to Analytical Accounting tables. The following tables should have EMPLOYID field in version 2010 […]
Read More
“How to resolve the ‘Invalid column name VENDORID’ error while installing Changer?” Check the progress window to note down the stored procedure that is created when the error occurred. If the procedure name is CHG131PM, this is due to the fact that Wennsoft build is not the latest build. It is recommended to install the […]
Read More
“Is Changer compatible with with Microsoft SQL server 2008 and Windows Server 2008?” Changer for Microsoft Dynamics GP version 10.0 is compatible with Microsoft SQL server 2008 and Windows Server 2008.
Read More
“Invalid Column name PERIODID error at 85% during Changer server installation on GP version 10.0” This error indicates that Analytical Accounting is installed on the company but was not upgraded to version 10.0. Hence the table structure of table AAG00905 is wrong. There are two options to resolve this issue: 1. Upgrade AA to version […]
Read More
“Error while running Changer: Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <-=, >, >= or when the subquery is used as an expression.” This error would occur if one of the tables in the database has a database trigger. When the code (GL account/customer/vendor/item/employee) in […]
Read More
“Invalid object name error on tables EXT00503 and EXT00603 while running Changer on Microsoft Dynamics GP version 10.0“ A patch has been released (build 19) to deal with the non-existence of these tables. Download the current build of Changer, un-install Changer from Add/Remove Programs (from Programs and Features if you are using Windows Vista or […]
Read More
“Users get ‘Inavalid column name ACTNUMBR_x‘ error, x being any number between 2 and 10.” The Account Framework in Dynamics GP specifies the maximum number of GL segments allowed in any Dynamics GP company. The maximum segments allowed shows at the top right on Account Format Setup window in Dynamics GP (Tools – Setup – Company – […]
Read More
“When clicked on the lookup button on Payroll Changer Maintenance window, the employee lookup window does not open or is empty.” Contact CRG to make sure that Changer registration key is issued for the correct payroll module (US payroll or Canadian Payroll depending on the payroll module being used)
Read More
