Dynamics Community Forum Thread Details

eConnect: Account numbers sent to taSopLineIvcInsert are being ignored

Please disregard this post--I seem to have looked at the wrong distribution accounts during my testing.

I have a GP 2013 SOP Invoice eConnect import where I need to specify the Sales and Markdowns account at the line level.

I have tried assigning accounts to the taSopLineIvcInsert SLSINDX and MKDNINDX nodes, but the imported invoice lines in GP do not have the accounts I specified--they have the default Markdown account specified at the company level.

The accounts are being properly serialized and are showing up in the XML being sent to eConnect.

<taSopLineIvcInsert_Items>
	<taSopLineIvcInsert>
		<SOPTYPE>3</SOPTYPE>
		<SOPNUMBE>88594195</SOPNUMBE>
		<CUSTNMBR>437010</CUSTNMBR>
		<DOCDATE>8/15/2014</DOCDATE>
		<LOCNCODE>CORPORATE</LOCNCODE>
		<ITEMNMBR>T1</ITEMNMBR>
		<UNITPRCE>1519.0000</UNITPRCE>
		<XTNDPRCE>227.8500</XTNDPRCE>
		<QUANTITY>1</QUANTITY>
		<MRKDNAMT>1291.1500</MRKDNAMT>
		<COMMENT_1>1000</COMMENT_1>
		<ITEMDESC>T1 Texas Owners</ITEMDESC>
		<NONINVEN>1</NONINVEN>
		<SLSINDX>000-4110-01</SLSINDX>
		<MKDNINDX>000-4520-01</MKDNINDX>
	</taSopLineIvcInsert>
	<taSopLineIvcInsert>
		<SOPTYPE>3</SOPTYPE>
		<SOPNUMBE>88594195</SOPNUMBE>
		<CUSTNMBR>437
		010</CUSTNMBR>
		<DOCDATE>8/15/2014</DOCDATE>
		<LOCNCODE>CORPORATE</LOCNCODE>
		<ITEMNMBR>T19.2</ITEMNMBR>
		<UNITPRCE>50.0000</UNITPRCE>
		<XTNDPRCE>7.5000</XTNDPRCE>
		<QUANTITY>1</QUANTITY>
		<MRKDNAMT>42.5000</MRKDNAMT>
		<COMMENT_1>801</COMMENT_1>
		<ITEMDESC>TX Revised 19.2 Mineral and Surface Damage</ITEMDESC>
		<NONINVEN>1</NONINVEN>
		<SLSINDX>000-4111-01</SLSINDX>
		<MKDNINDX>000-4520-01</MKDNINDX>
	</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>

The invoice imports fine, but here are the resulting distributions for this SOP line:

I've checked the other nodes on taSopLineIvcInsert and don't see any "Specified" flags or any other options that would seem to trigger the accounts being used--and since they are being serialized properly, that doesn't seem to be the issue.

Has anyone used the account index nodes at the SOP invoice line?

Any trick that I'm missing?

Quick Links

Leaderboard