web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect and state sal...
Microsoft Dynamics GP (Archived)

eConnect and state sales tax

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I am trying to do a new econnect integration.  I'm simply trying to create an order or quote.  I can get everything working that I need, but I can NOT get it to calculate state sales tax.  Are there any tricks that  I am missing?  I have tried about every combination I can think of and no luck.  When I open the tax information in the GUI, I can see the tax there, but it's not in the line item part at the bottom of the order.  It's like it isn't rolling down the tax info.  I have tried every combination of @I_vUSINGHEADERLEVELTAXES and @I_vCREATETAXES.  Nothing works.  Any documentation I need to read?  Any help would be greatly appreciated!!

I am writing directly to the stored procedures.  FYI.

Thanks!

Greg

*This post is locked for comments

I have the same question (0)
  • chadbruels Profile Picture
    chadbruels 1,588 on at

    Are you using DEFTAXSCHDS? Have you been successful in creating a transaction via the UI with State Sales Tax? Some of your code or some screenshots may be helpful.

  • Community Member Profile Picture
    Community Member on at

    Hello, thanks for the reply!  Yes, I have tried to send DEFTAXSCHDS with a 1 and a 0 and leaving it out all together.  If I enter the same order with the same customer in the UI it calculates sales tax properly.  I am not using .NET to access eConnect.  I am using Cold Fusion and am using the stored procedures.  However, I am able to do about everything I have tried, except calculating sales tax.  I truly believe it is some combination of data that I haven't tried yet.  I will attach a few screen shots of the order after it is put in the UI.  You will see that I am sending the tax info, it's just not adding it to the bottom of the order.  I can include my Cold fusion code if you need?  Thanks again!  This is driving me crazy.

    two.png

    two.png

  • chadbruels Profile Picture
    chadbruels 1,588 on at

    Is that Tax Detail ID (INST) your state sales tax?

  • Community Member Profile Picture
    Community Member on at

    Yes it is.

  • chadbruels Profile Picture
    chadbruels 1,588 on at

    <USINGHEADERLEVELTAXES>0</USINGHEADERLEVELTAXES>

    <CREATETAXES>1</CREATETAXES>

    <DEFTAXSCHDS>1</DEFTAXSCHDS>

    That XML is from the eConnect sample for a Sales Transaction using the tax engine to auto create the taxes. The example does not pass any tax amount value to any node and does not provide any tax schedule or detail ID. If you've ticked all those boxes and you're getting the tax created but not the tax amount at the document level then I'd offer two things. Either a third party customization is getting in the way or you should start a ticket with Microsoft.

    I'm sorry that is all I can offer. But I hold out hope there are smarter people than I in this forum who can offer more.

  • Community Member Profile Picture
    Community Member on at

    I wondered about a third party customization.  I believe it should be working, so that could be a possibility.  I will mess around some more with your suggestions and thank you SO much for your help!!!

  • chadbruels Profile Picture
    chadbruels 1,588 on at

    Here is the full eConnect example, just in case it sparks something. 

    <!-- Sales Order with CREATETAXES flag = 1.  Flag to auto create taxes with tax engine -->
<eConnect xmlns:dt="urn:schemas-microsoft-com:datatypes">
	<SOPTransactionType>
		<taSopLineIvcInsert_Items>
			<taSopLineIvcInsert>
				<SOPTYPE>2</SOPTYPE>
				<SOPNUMBE>ORDST2223E</SOPNUMBE>
				<CUSTNMBR>ALTONMAN0001</CUSTNMBR>
				<DOCDATE>2007-02-12</DOCDATE>
				<LOCNCODE>WAREHOUSE</LOCNCODE>
				<ITEMNMBR>ACCS-CRD-12WH</ITEMNMBR>
				<UNITPRCE>9.95</UNITPRCE>
				<XTNDPRCE>19.90</XTNDPRCE>
				<QUANTITY>2</QUANTITY>
				<MRKDNAMT>0</MRKDNAMT>
				<COMMNTID>TEST</COMMNTID>
				<COMMENT_1>cmt1</COMMENT_1>
				<COMMENT_2>cmt2</COMMENT_2>
				<COMMENT_3>cmt3</COMMENT_3>
				<COMMENT_4>cmt4</COMMENT_4>
				<ITEMDESC>Phone Cord - 12 White</ITEMDESC>
				<TAXAMNT>0</TAXAMNT>
				<QTYONHND>0</QTYONHND>
				<QTYRTRND>0</QTYRTRND>
				<QTYINUSE>0</QTYINUSE>
				<QTYINSVC>0</QTYINSVC>
				<QTYDMGED>0</QTYDMGED>
				<NONINVEN>0</NONINVEN>
				<LNITMSEQ>0</LNITMSEQ>
				<DROPSHIP>0</DROPSHIP>
				<QTYTBAOR>0</QTYTBAOR>
				<DOCID>STDORD</DOCID>
				<SALSTERR>TERRITORY 2</SALSTERR>
				<SLPRSNID>GREG E.</SLPRSNID>
			</taSopLineIvcInsert>
		</taSopLineIvcInsert_Items>
		<taSopHdrIvcInsert>
			<SOPTYPE>2</SOPTYPE>
			<DOCID>STDORD</DOCID>
			<SOPNUMBE>ORDST2223E</SOPNUMBE>
			<ORIGTYPE>0</ORIGTYPE>
			<SHIPMTHD>UPS GROUND</SHIPMTHD>
			<TAXAMNT>0</TAXAMNT>
			<LOCNCODE>WAREHOUSE</LOCNCODE>
			<DOCDATE>2007-02-01</DOCDATE>
			<FREIGHT>3.00</FREIGHT>
			<MISCAMNT>2.00</MISCAMNT>
			<TRDISAMT>0</TRDISAMT>
			<DISTKNAM>0</DISTKNAM>
			<MRKDNAMT>0</MRKDNAMT>
			<CUSTNMBR>ALTONMAN0001</CUSTNMBR>
			<CUSTNAME>Alton Manufacturing</CUSTNAME>
			<CSTPONBR>4859</CSTPONBR>
			<ShipToName>SERVICE</ShipToName>
			<ADDRESS1>P.O. Box 3343</ADDRESS1>
			<CITY>Detroit</CITY>
			<STATE>MI</STATE>
			<ZIPCODE>48233-3343</ZIPCODE>
			<COUNTRY>USA</COUNTRY>
			<PHNUMBR1>55553289890000</PHNUMBR1>
			<PHNUMBR3>55553200810000</PHNUMBR3>
			<SUBTOTAL>19.90</SUBTOTAL>
			<DOCAMNT>24.90</DOCAMNT>
			<PYMTRCVD>0</PYMTRCVD>
			<SALSTERR>TERRITORY 2</SALSTERR>
			<SLPRSNID>GREG E.</SLPRSNID>
			<USER2ENT>sa</USER2ENT>
			<BACHNUMB>TEST</BACHNUMB>
			<PRBTADCD>PRIMARY</PRBTADCD>
			<PRSTADCD>SERVICE</PRSTADCD>
			<FRTTXAMT>0</FRTTXAMT>
			<MSCTXAMT>0</MSCTXAMT>
			<ORDRDATE>2007-02-01</ORDRDATE>
			<MSTRNUMB>0</MSTRNUMB>
			<PYMTRMID>2% 10/Net 30</PYMTRMID>
			<USINGHEADERLEVELTAXES>0</USINGHEADERLEVELTAXES>
			<CREATECOMM>0</CREATECOMM>
			<CREATEDIST>1</CREATEDIST>
			<CREATETAXES>1</CREATETAXES>
			<DEFTAXSCHDS>1</DEFTAXSCHDS>
			<DYSTINCR>0</DYSTINCR>
			<RATEVARC>0.0500000</RATEVARC>
			<TRXDTDEF>1</TRXDTDEF>
			<RTCLCMTD>0</RTCLCMTD>
			<PRVDSLMT>1</PRVDSLMT>
			<DATELMTS>1</DATELMTS>
			<FREIGTBLE>1</FREIGTBLE>
			<MISCTBLE>1</MISCTBLE>
		</taSopHdrIvcInsert>
	</SOPTransactionType>
</eConnect>
  • Community Member Profile Picture
    Community Member on at

    Thanks!!

  • Community Member Profile Picture
    Community Member on at

    Ive tried copying your exact code and importing it with .NET econnect but am unable to get this to work.  Is something configured wrong that you might know of?

    Best,

    Falk0r

  • chadbruels Profile Picture
    chadbruels 1,588 on at

    Do you have an error you can share?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans