Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

eConnect Node taSopHdrIvcInsert not updating FRTTXAMT when called

Posted on by
Hi,
 
I have an econnect XML where I am trying to update the Freight Tax Amount (FRTTXAMT) in SOP10100 for a Sales Order.
Can you please take a look at the econnect xml node and let me know if I am missing anything?
 
Note: I have commented Pre and Post to disable any customized logic to run.
 
Here is the eConnect XML:
 
Currently I have 22.93 as Freight Tax Amount and I am trying to update it to 0.
 
<taSopHdrIvcInsert>
<SOPTYPE>2</SOPTYPE>
<DOCID>ORDER</DOCID>
<SOPNUMBE>312491228</SOPNUMBE>
<ORIGNUMB></ORIGNUMB>
<ORIGTYPE>0</ORIGTYPE>
<TAXSCHID>Test</TAXSCHID>
<TXRGNNUM>000000</TXRGNNUM>
<FRTSCHID></FRTSCHID>
<MSCSCHID></MSCSCHID>
<SHIPMTHD>R&amp;L</SHIPMTHD>
<LOCNCODE>31983327</LOCNCODE>
<DOCDATE>2024-08-02</DOCDATE>
<FREIGHT>277.9126</FREIGHT>
<MISCAMNT>0.00000</MISCAMNT>
<TRDISAMT>0.00000</TRDISAMT>
<DISTKNAM>0.00000</DISTKNAM>
<MRKDNAMT>0</MRKDNAMT>
<CUSTNMBR>38113123</CUSTNMBR>
<CUSTNAME>001232</CUSTNAME>
<CSTPONBR>LNJNLNLKNJ</CSTPONBR>
<ShipToName>001232</ShipToName>
<ADDRESS1>test1</ADDRESS1>
<ADDRESS2>test2</ADDRESS2>
<ADDRESS3></ADDRESS3>
<CNTCPRSN>001232</CNTCPRSN>
<FAXNUMBR></FAXNUMBR>
<CITY>Mexico D.F.</CITY>
<STATE>DF</STATE>
<ZIPCODE>02300</ZIPCODE>
<COUNTRY>MX</COUNTRY>
<PHNUMBR1></PHNUMBR1>
<PHNUMBR2></PHNUMBR2>
<PHNUMBR3></PHNUMBR3>
<SUBTOTAL>2186.25000</SUBTOTAL>
<DOCAMNT>2667.46260</DOCAMNT>
<PYMTRCVD>0.00000</PYMTRCVD>
<SALSTERR></SALSTERR>
<SLPRSNID></SLPRSNID>
<UPSZONE>Nor</UPSZONE>
<USER2ENT>user1</USER2ENT>
<BACHNUMB>testbatch</BACHNUMB>
<PRBTADCD>B-123</PRBTADCD>
<PRSTADCD>S-123</PRSTADCD>
<FRTTXAMT>0</FRTTXAMT>
<MSCTXAMT>0</MSCTXAMT>
<TAXAMNT>0</TAXAMNT>
<ORDRDATE>2024-08-02</ORDRDATE>
<MSTRNUMB>1234567890</MSTRNUMB>
<PYMTRMID>Net 30</PYMTRMID>
<DUEDATE>2024-08-02</DUEDATE>
<DISCDATE>1900-01-01</DISCDATE>
<REFRENCE></REFRENCE>
<COMMAMNT>0.00000</COMMAMNT>
<CURNCYID>Z-US$</CURNCYID>
<XCHGRATE>0.0000000</XCHGRATE>
<RATETPID></RATETPID>
<EXCHDATE>1900-01-01</EXCHDATE>
<EXGTBLID></EXGTBLID>
<DYSTINCR>0</DYSTINCR>
<RTCLCMTD>0</RTCLCMTD>
<TIME1>1900-01-01</TIME1>
<DISAVAMT>0.00000</DISAVAMT>
<DSCDLRAM>0.00000</DSCDLRAM>
<DSCPCTAM>0</DSCPCTAM>
<COMMNTID>UNTITLED*</COMMNTID>
<GPSFOINTEGRATIONID></GPSFOINTEGRATIONID>
<INTEGRATIONSOURCE></INTEGRATIONSOURCE>
<INTEGRATIONID></INTEGRATIONID>
<ReqShipDate>2024-10-15</ReqShipDate>
<QUOEXPDA>1900-01-01</QUOEXPDA>
<QUOTEDAT>1900-01-01</QUOTEDAT>
<INVODATE>1900-01-01</INVODATE>
<BACKDATE>1900-01-01</BACKDATE>
<RETUDATE>1900-01-01</RETUDATE>
<CMMTTEXT></CMMTTEXT>
<DEFPRICING>1</DEFPRICING>
<PRCLEVEL>STD</PRCLEVEL>
<TAXEXMT1></TAXEXMT1>
<TAXEXMT2></TAXEXMT2>
<REPTING>0</REPTING>
<TRXFREQU>0</TRXFREQU>
<TIMETREP>0</TIMETREP>
<UpdateExisting>1</UpdateExisting>
<UpdateIfExists>1</UpdateIfExists>
</taSopHdrIvcInsert>

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,246 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,041 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans