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)