Download and install Service Pack 1 for Microsoft Dynamics GP 2013.
Customers
https://mbs.microsoft.com/customersource/downloads/servicepacks/MDGP2013_PatchReleasesPartners
https://mbs.microsoft.com/partnersource/downloads/servicepack/MDGP2013_PatchReleasesIf you are currently only Microsoft Dynamics GP 2013 and cannot install Service Pack 1 immediately, refer to the steps below for a workaround.
1. Have all users exit Microsoft Dynamics GP 2013.
2. Make a SQL backup of the system database. If you have upgraded from a previous release, the system database is DYNAMICS.
3. If you have already experienced the error above, run the following script in the SQL Server Management Studio to remove the invalid records from the SY07140 table in the system database. Run the script below against the system database.
Delete SY07140 where CMDDICTID = 1
4. Run the script below to create a trigger on the SY07140 table to remove the invalid records automatically moving forward.
/*Microsoft Dynamics GP 2013 Trigger - CR10167*/
if exists (select * from sysobjects where id = object_id('dbo.SY07140InsertTrigger') and sysstat & 0xf = 8)
drop trigger dbo.SY07140InsertTrigger
GO
create trigger dbo.SY07140InsertTrigger
on SY07140
for insert
as
begin
Delete SY07140 where CMDDICTID = 1
end