Hello all.
I am running GP10 on a SQL Express server locally.
After creating a new database using GP, I restored a copy of a database backup to it using SQL.
The restore is successful, however, upon clicking on SmartList -> Financial -> Account, I get a pop-up error saying "A get/change first operation on table 'GL_Account_MSTR' failed accessing SQL data."
Clicking on more info, i get "Number of results columns doesnt match table definition."
Anyone have any idea why this is happening and the solution for it?
Thanks in advance.
*This post is locked for comments
Thank you for the replies!
I will look into it :)
Have a great day!
The tables are SY003001 and SY00302.
There's a table in the DYNAMICS database that stores this, but I'll have to find it. However, if you go to one of the Company databases and run SELECT * FROM GL00100, you will see the different segments. If the Company was set up on a system that had a full install of segments (66 char / 10 Seg I think), you would see columns called ACTNUMBR_1, ACTNUMBR_2, ACTNUMBR_3......ACTNUMBR_9, ACTNUMBR_10. If the segments weren't being Used (for example, the company I am working for uses 7 of the 10 that were installed) you would see blanks in the extra columns. In my case ACTNUMBR_8. ACTNUMBR_9, ACTNUMBR_10 are blank columns.
If the install was done with only 4 Segemnts you would see ACTNUMBR_1, ACTNUMBR_2, ACTNUMBR_3, ACTNUMBR_4 and that's it.
If I can find the DYNAMICS table that corresponds to this, I will post again.
I have reinstalled my server and GP in order to solve the problem, this time keying in a matching account framework.
However I still would like to know if there is a way I can find out for sure from the GP or SQL server itself what is the account framework for a database, in case the person who had done the installation is not around in the future.
thanks in advance.
Hi David n K Day,
I believe the database restored is the same version with SP with my local one. I referred to the person doing the installation and the account framework is indeed different from the information she gave me. I am curious though, is there a way I can find out for sure from the GP or SQL server itself what is the account framework for the database and the one that I have now? Would appreciate the help!
Thanks~
I just typed out a long response and apparently it didn't post. Uugh.
To sum it up, I had this problem and it was account framework. I tried to restore a client's database over a company I created on the Microsoft VHD Tecnical Demonstration Toolkit and I got the same message. Not just smartlist but anything to do with GL accounts, like distributions and lookup windows. THe install you did and the database you are copying from have to have been installed with the same amount of Segments and Characters for the GL accounts. I think the Max is 66 char and 10 sements. I suggest always doing it that way(and there wouldn't be this problem). THat VHD with GP on it was installed with soemting like 4 segments and 20 characters, and that's why it didn't work for me.
It is trying to use stored procedres and send ACCTNUM_1, ACCTNUM_2, ACCTNUM_3.......ACCTNUM_10
And the SP only accepts ACCTNUM_1, ACCTNUM_2, ACCTNUM_3,ACCTNUM_4. That why it says the number of columns does not match.
Was the version for the database restored the same version and service pack as the client?
Does the system and the restored database have the same account framework?
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156