Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Micah 4/12/2012 1:29:15 PM

Unable to increment next document number from Sales Type ID Setup or Sales Document Setup after 1000 attempts

There is a system exception being thrown that I haven’t seen before and is preventing transactions from processing.  Information is below.

Detail:

Source Procedure: taGetSopNumber

Error Number: 3419

Error Description: Unable to increment next document number from Sales Type ID Setup or Sales Document Setup after 1000 attempts

 

Stack:

   at Microsoft.Dynamics.GP.eConnect.GetSopNumber.ExecuteSopGetNextProcedure(Int32 SOPTYPEKey, String DOCIDKey)

   at Microsoft.Dynamics.GP.eConnect.GetSopNumber.GetNextSopNumber(Int32 SOPTYPEKey, String DOCIDKey, SqlConnection connection)

   at Microsoft.Dynamics.GP.eConnect.GetNextDocNumbers.GetNextSOPNumber(IncrementDecrement incdec, String DOCIDKey, SopType docType, String BackOfficeConnString)

   at Microsoft.Dynamics.GP.eConnect.SOPTransactionType.GetSOPDocumentNumber(XElement sopTypeNode, XElement docIdNode)

   at Microsoft.Dynamics.GP.eConnect.SOPTransactionType.ParseTransctionHeader(String[]& nodeNames)

   at Microsoft.Dynamics.GP.eConnect.SOPTransactionType.ParseTransactionLines()

   at Microsoft.Dynamics.GP.eConnect.MessageManager.ParseTransactionTypes(EntityMessage message)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateEntity(String connectionString, String sXML)

   at Microsoft.Dynamics.GP.EConnectAdapter.ExecuteWrite(String xml, String typeName, Context context, BusinessEvent eventType, BusinessObjectEventArgs args, EventLocation eventLocation)

   at Microsoft.Dynamics.GP.EConnectAdapter.Create(BusinessObject businessObject, Context context, Policy policy)

   at Microsoft.Dynamics.GP.GreatPlainsBusinessService.PersistForCreate(BusinessObject businessObject, Context context, Policy policy)

   at Microsoft.Dynamics.Common.BusinessService.Create(BusinessObject businessObject, Context context, Policy policy)

 

 

 

 

Version: GP 2010
Section: Web Services








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables