Skip to main content
Microsoft Dynamics GP forum
Unanswered

Not able to update tax eConnect GP 2016

editSubscribe (0) ShareShare
ReportReport
Posted on by User Group Leader

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

Attachments
  • Suggested answer
    JodeRuiter Profile Picture
    JodeRuiter 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 User Group Leader 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 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 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 User Group Leader 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 on at
    RE: Not able to update tax eConnect GP 2016

    i have the same problem did you solved this issue?

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans