I am in the process of importing Sales Orders into GP2010 with eConnect. I am currently receiving the above error message and I have not been able to find away around. The following is the XML Code
<?xml version="1.0" encoding="utf-8" ?>
<ConnectionString>data source=IOSQL-QA;initial catalog=IOOPS;integrated security=SSPI;persist security info=False;packet size=4096</ConnectionString>
</eConnectProcessInfo>
<UpdateIfExists>1</UpdateIfExists>
<SOPNUMBE>DORD2048951</SOPNUMBE>
<CUSTNMBR>303-100006</CUSTNMBR>
<DOCID>303-MANORDER</DOCID>
<DOCDATE>2010-9-28</DOCDATE>
<MRKDNAMT>0.00000</MRKDNAMT>
<QUANTITY>36.00000</QUANTITY>
<PRCLEVEL>WS-DIP-US</PRCLEVEL>
<QTYTBAOR>36.00000</QTYTBAOR>
<ITEMNMBR>HHPK2-040-FP-0-US</ITEMNMBR>
<ITEMDESC>Hydroxycut Hardcore Pro Series Ignition Stix 40 x 2.6g Fruit Punch US</ITEMDESC>
<LOCNCODE>303-HAMB</LOCNCODE>
<QTYCANCE>0.00000</QTYCANCE>
<AUTOALLOCATELOT>1</AUTOALLOCATELOT>
<QtyShrtOpt>3</QtyShrtOpt>
<XTNDPRCE>863.64000</XTNDPRCE>
<UNITPRCE>23.99000</UNITPRCE>
</taSopLineIvcInsert>
<DOCID>303-MANORDER</DOCID>
<DOCDATE>2010-9-28</DOCDATE>
<CSTPONBR>C5-35546</CSTPONBR>
<BACHNUMB>GPLOAD</BACHNUMB>
<PRBTADCD>MAIN</PRBTADCD>
<LOCNCODE>303-HAMB</LOCNCODE>
<CUSTNMBR>303-100006</CUSTNMBR>
<SOPNUMBE>DORD2048951</SOPNUMBE>
<CREATECOMM>0</CREATECOMM>
<PYMTRMID>1% 10, NET 30</PYMTRMID>
<DUEDATE>2010-9-23</DUEDATE>
<ORIGNUMB>BKD231472</ORIGNUMB>
<SHIPMTHD>S - BEST WAY</SHIPMTHD>
<FRTSCHID>303-S-EXEMPT</FRTSCHID>
<DEFTAXSCHDS>1</DEFTAXSCHDS>
<MRKDNAMT>0.00000</MRKDNAMT>
<CREATEDIST>1</CREATEDIST>
<CREATETAXES>1</CREATETAXES>
<TAXSCHID>303-S-EXEMPT</TAXSCHID>
</taSopHdrIvcInsert>
</SOPTransactionType>
</eConnect>
I am not sure what it is causing the problem as the Quantity * Unit price does match out to the Extednded price.
I have also tryied to add a calculated field to the import as follows:
DIM EXTNDEDPRC as DOUBLE
EXTNDEDPRC = MATH.ROUND(_QUANTITY * _UNITPRCE,2,MIDPOINTROUNDING.AWAYFROMZERO)
return EXTNDEDPRC
This did not work either. Any help on this issue would be greatly appreciated.
Thanks
Don
*This post is locked for comments
I have the same question (0)
