Cannot change account name in Great Plains 10.0

Posted on 2011-05-10
Last Modified: 2012-05-11
I have had this before and cannot locate the KB on customersource (not surprising).  When I try to change the name of a GL account I get the message

A save operation on GL_Account_MSTR cannot find the table.

Then I click okay and save again and I get

Record has been created since your last attempt to save it.  Changes will not be saved.

I think this has something to do with AA.  I accidentally installed it in the beginning.  Followed instructions on Customersource to fix this but still can't change the account name.

Question by:KateHulit
    LVL 18

    Expert Comment

    by:Steve Endow

    I don't see an exact match for that message, but there is KB 871600 which discusses the error "A get/change operation on table 'GL_Account_Index_MSTR' failed accessing SQL data".  The recommendation there is to restart the SQL Server service.

    "You will want to Stop and Start your SQL server to clear out your temporary tables. The error is stating that it can not locate the table on your SQL server which could have been caused a power fluctuation, loss of network communication or a server crash to name a few examples. Stopping and starting your SQL server will give it a fresh look at the databases and tables."

    Seems odd, but I guess it's worth a try.


    Steve Endow
    Dynamics GP Certified Trainer
    Dynamics GP Certified Professional

    Author Comment

    Tried that.  Did not work.  Here is what my SQL trace reported

    /*  Date: 04/27/2011  Time: 14:44:19
    BEGIN DECLARE @num int EXEC GPI.dbo.zDP_GL00100SI 851, '09', '5405', '10', '', '', '', '', '', '', '', '', '5405', 1, 'test', 1, 33, 1, 0, 0, 0, 0, 0xffffffff, 1, 0.0000000, 29860.00000, '2008.05.23', '2011.04.27', '', '', 1, 1, 1, 1, 0, 0, 0, 1, '', '', @num OUT SELECT @num END
    /*  Date: 04/27/2011  Time: 14:44:19
    SQLSTATE:(23000) Native Err:(2627) stmt(21046864):*/
    [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PKGL00100'. Cannot insert duplicate key in object 'dbo.GL00100'.*/
    /*  Date: 04/27/2011  Time: 14:44:19
    SQLSTATE:(01000) Native Err:(3621) stmt(21046864):*/
    [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.*/

    Like I said, I have tried most everything that I could find.  If you have any ideas I would Thank You greatly

    LVL 18

    Accepted Solution

    Hi Kate,

    Thanks for the info.

    If you are only trying to update the description of an existing account and then save that change, then there is definitely a problem with how your GP is saving that info.

    The SQL you posted is an Insert stored procedure, which is attempting to insert a new GL account record with Account Index 851.  That account index already exists, so the insert fails.

    Here is what I see when I update an existing account description:

    declare @p1 int
    set @p1=4
    exec sp_prepexec @p1 output,N'@P1 char(52),@P2 datetime,@P3 char(52),@P4 datetime,@P5 int',N'BEGIN UPDATE TWO.dbo.GL00100 SET ACTDESCR = @P1, MODIFDT = @P2 WHERE ACTDESCR = @P3 AND MODIFDT = @P4 AND ACTINDX = @P5 SELECT @@rowcount END ','Cash - Operating Account 1                          ','2011-05-16 00:00:00:000','Cash - Operating Account                            ','1980-01-01 00:00:00:000',1
    select @p1

    Open in new window

    My only guess is that there is a problem with how GP is determining whether an account already exists.  Because it doesn't think the account exists yet, it is calling the Insert procedure instead of performing an update.

    Unfortunately, I think you will need an MS support case to determine how to fix the problem.

    If you submit a Dex log and SQL log with your support request, I am assuming they should be able to identify the problem.


    Steve Endow
    Dynamics GP Certified Trainer
    Dynamics GP Certified Professional

    Author Closing Comment

    Had to call support

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
    Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now