“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 – Account Format)

The above error means the table structure of one of the following tables is wrong. Each of these tables should have as many ACTNUMBR columns starting with ACTNUMBR_1 as the number of segments allowed in the Account Framework. If any of these tables has less number of columns than the maximum number of segments, it can mean that the table did not get created properly when the company was created. Users should contact Microsoft to fix the structure of these tables. If the table does not contain any data, it can be re-created using the SQL Maintenance in Dynamics GP.

Tables with ACTNUMBR columns:

AF00100
GL00100F1
GL00100F2
GL00100F3
GL00100F4
XLImport
XLVerAct
SE00400
SE000401
SE810000
SE90001
ME142807
GST007
BS2001
BS2004
BS2006