Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

EConnect Sale Order Invoice

Posted on by 660

I'm trying to create and sales invoice using eConnect. and I'm getting an error: Error Number = 3441  Stored Procedure taSopLineIvcInsert  Error Description = DOCID does not exist for document type. STDINV is in the DOCID and 3 is in the SOPTYPE . I also tried using the sample VB Sales Order Console Application and got the same error among others. Any ideas what I'm doing wrong. below is the XML.

<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOPTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateCustomerRcd xsi:nil="true" />
<taCreateCustomerAddress_Items xsi:nil="true" />
<taSopSerial_Items xsi:nil="true" />
<taSopLotAuto_Items xsi:nil="true" />
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>M10001</SOPNUMBE>
<CUSTNMBR>GAVLIMNE</CUSTNMBR>
<DOCDATE>2013-05-20</DOCDATE>
<ITEMNMBR>1</ITEMNMBR>
<QUANTITY>25</QUANTITY>
<UNITPRCE>42.000</UNITPRCE>
<UOFM>ST</UOFM>
<XTNDPRCE>1050.00</XTNDPRCE>
<ITEMDESC>BASE FREIGHT</ITEMDESC>
<NONINVEN>1</NONINVEN>
<DOCID>STDINV</DOCID>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items xsi:nil="true" />
<taSopTrackingNum_Items xsi:nil="true" />
<taSopCommissions_Items xsi:nil="true" />
<taSopLineIvcTaxInsert_Items xsi:nil="true" />
<taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
<taSopUserDefined xsi:nil="true" />
<taSopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taSopMultiBin_Items xsi:nil="true" />
<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>STDINV</DOCID>
<SOPNUMBE>M10001</SOPNUMBE>
<DOCDATE>2013-05-20</DOCDATE>
<CUSTNMBR>GAVLIMNE</CUSTNMBR>
<SUBTOTAL>1050.00</SUBTOTAL>
<DOCAMNT>1050.00</DOCAMNT>
<BACHNUMB>SOP Invoices 05-20-2013</BACHNUMB>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>

*This post is locked for comments

  • Verified answer
    Dean Manion Profile Picture
    Dean Manion 660 on at
    RE: EConnect Sale Order Invoice

    I guess it would help if I told you I was using eConnect 10.0 I did not quite understand where you were checking the Type ID but I went to tools-->Setup-->Sales-->Sales Order Processing and it had INVOICES in the Invoice ID field. I used it in the DOCID and it seemed to work. Thanks for pointing me in the right direction.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: EConnect Sale Order Invoice

    Goto -->Sales Transaction and check Type ID

     

    use lookup to see docType ID  is exist or not.

     

    Thanks
    Sandip

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans