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
BethanyW 3/26/2015 3:26:10 PM

Help with eConnect QTYTBAOR

My customer wants all the quantities we import to go into QTYTBAOR so they do not affect inventory.  They adjust this field at the time they process & ship.

 

I tried setting QTYTBAOR = to the quantity ordered but I’m getting the eConnect error below.  I was able to get the order in when I set DEFPRICING = 1 but it no longer used the correct price level (PRCLEVEL) and it seemed to think there were 2 items instead of 1.  I tried removing the QUANITY field but that’s mandatory.  Can you help me understand what combination of values I need to set to make this work?  Thank you!

 

 

 

Error Number = 299  Stored Procedure= taSopLineIvcInsert  Error Description = Unit Price calculation does not match out to Extended price

Node Identifier Parameters: taSopLineIvcInsert

SOPNUMBE = ORD0046790

SOPTYPE = 2

LNITMSEQ = 16384

Related Error Code Parameters for Node : taSopLineIvcInsert

SOPTYPE = 2

QUANTITY = 1.00

UNITPRCE = 15.17

MRKDNAMT = Note: This parameter was not passed in, no value for the parameter will be returned.

XTNDPRCE = 15.17

 

 

<taSopLineIvcInsert>

  <SOPTYPE>2</SOPTYPE>

  <CUSTNMBR>XXXX</CUSTNMBR>

  <DOCDATE>03/26/2015</DOCDATE>

  <ITEMNMBR>XXXX</ITEMNMBR>

  <PRCLEVEL>XXXX</PRCLEVEL>

  <UNITPRCE>15.17</UNITPRCE>

  <XTNDPRCE>15.17</XTNDPRCE>

  <QUANTITY>1.00</QUANTITY>

  <QTYTBAOR>1.00</QTYTBAOR>

  <LNITMSEQ>16384</LNITMSEQ>

  <DOCID>STDORD</DOCID>

  <PRSTADCD>XXXX</PRSTADCD>

  <ReqShipDate>03/13/2015</ReqShipDate>

  <QTYFULFI>0</QTYFULFI>

  <QTYFULFISpecified>True</QTYFULFISpecified>

  <UOFM>Case</UOFM>

  <USRDEFND3>00003</USRDEFND3>

  <SOPNUMBE>ORD0046790</SOPNUMBE>

</taSopLineIvcInsert>

Version: All
Section: 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