Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

eConnect Sales Order with kits in GP9

383 views
Skip to first unread message

James

unread,
Oct 8, 2008, 6:21:00 PM10/8/08
to
I am using the the sample eConnect code to create a Sales Order and it is
failing with kits.

I am using GP 9 with SP2 and I have multi bin turned on, with external
fulfiment through an add on called MDS.

Is there some special parameters I need to set for creating a sales order
with kits though eConnect. Non-kit items are working fine.

The error I am getting is:

Event Type: Error
Event Source: Microsoft.GreatPlains.eConnect
Event Category: None
Event ID: 791
Date: 10/8/2008
Time: 4:00:28 PM
User: N/A
Computer: SISYPHUS
Description:
Microsoft.GreatPlains.eConnect Version=9.0.0.0
Microsoft.GreatPlains.eConnect

Sql procedure error codes returned:
Error Number = 7220 Stored Procedure taSopMultiBin Error Description =
Bins for the item have already been assigned for the qty fulfilled on the line
Node Identifier Parameters: taSopMultiBin

SOPNUMBE = ZALBOX-S-00000337
SOPTYPE = 2
ITEMNMBR = 511111


Error Number = 7191 Stored Procedure taSopLineIvcInsertComponent Error
Description = Unable to update SOP Default Bins
Node Identifier Parameters: taSopLineIvcInsertComponent

SOPNUMBE = ZALBOX-S-00000337
SOPTYPE = 2
ITEMNMBR = 511111


Error Number = 115 Stored Procedure taSopLineIvcInsert Error Description =
Unable to insert the component record
Node Identifier Parameters: taSopLineIvcInsert

SOPNUMBE = ZALBOX-S-00000337
SOPTYPE = 2


<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>ZALBOX-S-00000337</SOPNUMBE>
<CUSTNMBR>Z0002</CUSTNMBR>
<DOCDATE>10/08/2008</DOCDATE>
<ITEMNMBR>511111</ITEMNMBR>
<UNITPRCE>1.00</UNITPRCE>
<XTNDPRCE>1.00</XTNDPRCE>
<QUANTITY>1</QUANTITY>
<DOCID>MDS</DOCID>
<INTEGRATIONSOURCE>1</INTEGRATIONSOURCE>
<QTYFULFI>0</QTYFULFI>
</taSopLineIvcInsert>
at
Microsoft.GreatPlains.eConnect.eConnectMethods.ExecStoredProcedures(String
xml)
at
Microsoft.GreatPlains.eConnect.eConnectMethods.eConnect_EntryPoint(String
ConnectionString, ConnectionStringType ConnectionType, String sXML,
SchemaValidationType ValidationType, String eConnectSchema)


Chris Roehrich [MSFT]

unread,
Oct 17, 2008, 5:05:39 PM10/17/08
to
I am able to reproduce this error. Actually I received a 7228 error first
which says "Error Number = 7228 Stored Procedure taSopMultiBin Error
Description = A sales order fulfillment bin is not set up for this item or
site" and it references the Kit Item number. I have a bin on the site I
am passing and it is not possible to have a bin on a Kit item. So I think
there is an issue with this edit check for Kit Items with Multi Bin
enabled. To workaround this error I then did add a default sales order
fulfillment bin on my component items and then this gave me the same 7220
error you are running into.

I am going to check into this in the next few days regarding integrating
sales order kit items with multi bin and will update the thread with my
findings.

Thanks,
Chris

Chris Roehrich [MSFT]

unread,
Oct 21, 2008, 5:44:19 PM10/21/08
to
I was able to pass the below XML document with Kit Item that has two
component items with multi bin enabled. It was pointed out to me that I
was missing the <KitCompMan>1</KitCompMan> element in the
<taSopLineIvcInsert> node. Once I did this it went in fine:

<eConnect>

<SOPTransactionType>

<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>econ000002</SOPNUMBE>
<CUSTNMBR>AARONFIT0001</CUSTNMBR>
<DOCDATE>10/15/2017</DOCDATE>
<UOFM>Each</UOFM>
<ITEMNMBR>BEER KIT</ITEMNMBR>
<UNITPRCE>50.00</UNITPRCE>
<XTNDPRCE>50.00</XTNDPRCE>
<QUANTITY>1</QUANTITY>
<ITEMDESC>Budget Breakfast Briefing - Dublin 04-12-2008</ITEMDESC>
<LNITMSEQ>16384</LNITMSEQ>
<DOCID>STDORD</DOCID>
<TAXSCHID>USASTCITY-6*</TAXSCHID>
<ADDRESS1>Maitland Advisory, Dublin</ADDRESS1>
<ADDRESS2>16 Windsor Place</ADDRESS2>
<ADDRESS3>Dublin 2</ADDRESS3>
<AutoAssignBin>0</AutoAssignBin>
<LOCNCODE>WAREHOUSE</LOCNCODE>
<KitCompMan>1</KitCompMan>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items>
<taSopLineIvcInsertComponent>
<SOPNUMBE>econ000002</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<ITEMNMBR>YEAST</ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<QUANTITY>1</QUANTITY>
<CUSTNMBR>AARONFIT0001</CUSTNMBR>
<AutoAssignBin>0</AutoAssignBin>
</taSopLineIvcInsertComponent>
<taSopLineIvcInsertComponent>
<SOPNUMBE>econ000002</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<ITEMNMBR>HOPS</ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<QUANTITY>1</QUANTITY>
<CUSTNMBR>AARONFIT0001</CUSTNMBR>
<AutoAssignBin>0</AutoAssignBin>
</taSopLineIvcInsertComponent>
</taSopLineIvcInsertComponent_Items>
<taSopMultiBin_Items>
<taSopMultiBin>
<SOPNUMBE>econ000002</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<ITEMNMBR>YEAST</ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<CMPNTSEQ>16384</CMPNTSEQ>
<BIN>1</BIN>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
<taSopMultiBin>
<SOPNUMBE>econ000002</SOPNUMBE>
<SOPTYPE>2</SOPTYPE>
<ITEMNMBR>HOPS</ITEMNMBR>
<LNITMSEQ>16384</LNITMSEQ>
<CMPNTSEQ>32768</CMPNTSEQ>
<BIN>1</BIN>
<QUANTITY>1</QUANTITY>
</taSopMultiBin>
</taSopMultiBin_Items>
<taSopHdrIvcInsert>
<SOPTYPE>2</SOPTYPE>
<DOCID>STDORD</DOCID>
<SOPNUMBE>econ000002</SOPNUMBE>
<TAXSCHID>USASTCITY-6*</TAXSCHID>
<CREATETAXES>1</CREATETAXES>
<LOCNCODE />
<DOCDATE>10/15/2017</DOCDATE>
<CUSTNMBR>AARONFIT0001</CUSTNMBR>
<ShipToName>SHIPPING</ShipToName>
<ADDRESS1>Maitland Advisory, Dublin</ADDRESS1>
<ADDRESS2>16 Windsor Place</ADDRESS2>
<ADDRESS3>Dublin 2</ADDRESS3>
<CNTCPRSN>Rory Kerr</CNTCPRSN>
<FAXNUMBR>--01 663 5801</FAXNUMBR>
<COUNTRY>Ireland</COUNTRY>
<DEFPRICING>1</DEFPRICING>
<BACHNUMB>econ_docs</BACHNUMB>
</taSopHdrIvcInsert>
</SOPTransactionType>
</eConnect>

0 new messages