?
Solved

Cannot change account name in Great Plains 10.0

Posted on 2011-05-10
4
Medium Priority
?
1,573 Views
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.

Thanks
0
Comment
Question by:KateHulit
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:Steve Endow
ID: 35731454
Hi,

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.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
0
 

Author Comment

by:KateHulit
ID: 35769390
Tried that.  Did not work.  Here is what my SQL trace reported

/*  Date: 04/27/2011  Time: 14:44:19
stmt(21046864):*/
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

Kate
0
 
LVL 18

Accepted Solution

by:
Steve Endow earned 2000 total points
ID: 35770155
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.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
0
 

Author Closing Comment

by:KateHulit
ID: 36097513
Thanks
Had to call support
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part III
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month16 days, 6 hours left to enroll

850 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