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

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
arzzzae 10/21/2019 10:56:02 AM

Error when inserting line item with a different price

I am getting an error 299 when trying to insert a line item that has a different unit price than the default. Please see the error below. I tried several suggested solution like setting MRKDNAMT and MRKDNAMTSpecified  values but I the error still persists. Extended amount calculation looks correct as well.

 

Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned: Error Number = 299  Stored Procedure= taSopLineIvcInsert  Error Description = Unit Price calculation does not match out to Extended priceNode Identifier Parameters: taSopLineIvcInsertSOPNUMBE = PARTS00061       SOPTYPE = 2Related Error Code Parameters for Node : taSopLineIvcInsertSOPTYPE = 2QUANTITY = 5.0000UNITPRCE = 30.765MRKDNAMT = 0XTNDPRCE = 153.825Error Number = 4646  Stored Procedure= taSopLineIvcInsert  Error Description = Decimal Places passed in on UNITPRCE does not match setupNode Identifier Parameters: taSopLineIvcInsertSOPNUMBE = PARTS00061       SOPTYPE = 2Related Error Code Parameters for Node : taSopLineIvcInsertUNITPRCE = 30.765Error Number = 4647  Stored Procedure= taSopLineIvcInsert  Error Description = Decimal Places passed in on XTNDPRCE does not match setupNode Identifier Parameters: taSopLineIvcInsertSOPNUMBE = PARTS00061       SOPTYPE = 2Related Error Code Parameters for Node : taSopLineIvcInsertXTNDPRCE = 153.825<taSopLineIvcInsert>  <SOPTYPE>2</SOPTYPE>  <SOPNUMBE>PARTS00061       </SOPNUMBE>  <CUSTNMBR>403MB</CUSTNMBR>  <DOCDATE>10/15/2019</DOCDATE>  <ITEMNMBR>00.02016</ITEMNMBR>  <UNITPRCE>30.765</UNITPRCE>  <XTNDPRCE>153.825</XTNDPRCE>  <QUANTITY>5.0000</QUANTITY>  <MRKDNAMT>0</MRKDNAMT>  <DOCID>STDORD</DOCID>  <UpdateIfExists>1</UpdateIfExists>  <UOFM>Each</UOFM></taSopLineIvcInsert>   at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateEntity(String connectionString, String xml)   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction)   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateEntity(String connectionString, String sXML)   at MidwestJobs.Integrations.GreatPlains.Data.DataAdapter.SendDocument(eConnectType eConnect)

 

 

Version: GP 2015
Section: Dynamics GP, eConnect








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