Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Not able to update tax...
Microsoft Dynamics GP (Archived)

Not able to update tax eConnect GP 2016

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello, 

We are using eConnect through .Net. When we update the existing order, we are able to update all other fields of order, but taxes. 

Seems sending correct insert update flag. Sometimes call succeeds but I don't see tax updated. 

If we remove the update flag we get.

"eConnect Failure. Please see administrator. Description: Sql procedure error codes returned: \n\rError Number = 795 Stored Procedure= taSopLineIvcTaxInsert Error Description = Tax detail already exists\r\nNode Identifier Parameters: taSopLineIvcTaxInsert\r\nSOPNUMBE =

Any help in this area is much appriciated.

Thanks!

Timir Panchal

*This post is locked for comments

  • Suggested answer
    JodeRuiter Profile Picture
    JodeRuiter 978 User Group Leader on at
    Not able to update tax eConnect GP 2016
    I was able to get past this error by using Line Sequence numbers in my source data and mapping that sequence number in both the SOP Lines and the SOP Tax Lines.  Header level taxes set to 0.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not able to update tax eConnect GP 2016

    LNITMSEQ is the Line item sequence and defaults to 0. The documentation states "Header level taxes only specify tax information when the line sequence element of the <taSopLineIvcTaxInsert> XML node is set to 0", so you must be calculating the tax in each line item, rather than on the subtotal as a whole?

    Setting the LNITMSEQ value would work in that scenario, not in the scenario where the tax information is specified only in the header, I believe.

  • yoandy Profile Picture
    yoandy 115 on at
    RE: Not able to update tax eConnect GP 2016

    guys did you try pu this field

    linetax.LNITMSEQ 

    that works to me 

    taSopLineIvcTaxInsert_ItemsTaSopLineIvcTaxInsert linetax = new taSopLineIvcTaxInsert_ItemsTaSopLineIvcTaxInsert();
    linetax.CUSTNMBR = ClientOriginalId(order.Client);
    linetax.LNITMSEQ = detail.Id; 
    linetax.SOPTYPE = SOPTYPE;
    linetax.SOPNUMBE = salesHdr.SOPNUMBE;
    linetax.SALESAMT = line.XTNDPRCE;
    linetax.TAXDTLID = tProdcodeid1.Value;
    linetax.STAXAMNT = line.TAXAMNT;
    linestax.Add(linetax);

  • yoandy Profile Picture
    yoandy 115 on at
    RE: Not able to update tax eConnect GP 2016

    so in few words we can't use tax per line?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not able to update tax eConnect GP 2016

    This issue has not yet been solved, unfortunately.

    According to the eConnect Programmers Guide, tax values can be set/updated at the header level by settings values on the <taSopHderIvcInsert> XML node along with the <taSopLineIvcTaxInsert> XML node.

    As far as I can tell, and what the documentation states, we should be including all the correct data, but if we pass in a taSopLineIvcTaxInsert_ItemsTaSopLineIvcTaxInsert object (which gets serialized to the <taSopLineIvcTaxInsert> node), eConnect throws the exception OP outlined. If we don't include this information, we get a valid response, but the tax is not updated.

  • yoandy Profile Picture
    yoandy 115 on at
    RE: Not able to update tax eConnect GP 2016

    i have the same problem did you solved this issue?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,791 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans