Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

SmartList comes up with error message

Posted on by 85

 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

  • wkylie Profile Picture
    wkylie 85 on at
    Re: SmartList comes up with error message

    Thank you for the replies!

    I will look into it :)

    Have a great day!

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Re: Re: SmartList comes up with error message

    The tables are SY003001 and SY00302.

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: SmartList comes up with error message

    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.

  • wkylie Profile Picture
    wkylie 85 on at
    Re: SmartList comes up with error message

    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.

  • wkylie Profile Picture
    wkylie 85 on at
    Re: Re: Re: SmartList comes up with error message

     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~

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: SmartList comes up with error message

    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.

  • winthropdc Profile Picture
    winthropdc on at
    Re: SmartList comes up with error message

    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. 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans