I am receiving some strange errors when I try and include multi-bin data as part of an inventory transaction import with eConnect 10.0.4.
The inventory adjustment imports fine without multi-bin. But when I add the multi-bin, eConnect is returning errors that make it seem like the multi-bin record can't be included as part of the inventory transaction. It is as if eConnect is trying to commit the multi-bin transaction before the IV Adjustment is saved. Based on this, I'm assuming I will need to import the IV transaction first, then import the multi-bin, which I can do, but seems odd for this transaction.
Anyone else experienced this?
The errors I get when I include multi-bin:
Sql procedure error codes returned:
Error Number = 5927 Stored Procedure taIVTransactionMultiBinInsert Error Description = Document Number does not exist
Node Identifier Parameters: taIVTransactionMultiBinInsert
Error Number = 5932 Stored Procedure taIVTransactionMultiBinInsert Error Description = Item does not exist on the document
Node Identifier Parameters: taIVTransactionMultiBinInsert
Error Number = 5936 Stored Procedure taIVTransactionMultiBinInsert Error Description = Bin does not exist - set Create Bin flag
(CreateBin) = 1 if you want to create it.
Node Identifier Parameters: taIVTransactionMultiBinInsert
Error Number = 5945 Stored Procedure taIVTransactionMultiBinInsert Error Description = The quantity passed in for Multi Bin is greater than what was passed to the line
Node Identifier Parameters: taIVTransactionMultiBinInsert
My full XML:
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<IVInventoryTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taIVTransactionSerialInsert_Items xsi:nil="true" />
<taIVTransactionLotInsert_Items xsi:nil="true" />
<taIVTransactionLineInsert_Items>
<taIVTransactionLineInsert>
<IVDOCNBR>00000000000000174</IVDOCNBR>
<IVDOCTYP>1</IVDOCTYP>
<ITEMNMBR>CC 750</ITEMNMBR>
<TRXQTY>1250.0</TRXQTY>
<UNITCOST>0.23</UNITCOST>
<TRXLOCTN>REDRIVER</TRXLOCTN>
</taIVTransactionLineInsert>
</taIVTransactionLineInsert_Items>
<taAnalyticsDistribution_Items xsi:nil="true" />
<taIVTransactionMultiBinInsert_Items>
<taIVTransactionMultiBinInsert>
<IVDOCNBR>00000000000000174</IVDOCNBR>
<IVDOCTYP>0</IVDOCTYP>
<ITEMNMBR>CC 750</ITEMNMBR>
<QUANTITY>1250.0</QUANTITY>
<BIN>RED RIVER PLANT</BIN>
</taIVTransactionMultiBinInsert>
</taIVTransactionMultiBinInsert_Items>
<taIVTransactionHeaderInsert>
<BACHNUMB>MXIV0416</BACHNUMB>
<IVDOCNBR>00000000000000174</IVDOCNBR>
<IVDOCTYP>1</IVDOCTYP>
<DOCDATE>2010-04-16</DOCDATE>
<POSTTOGL>0</POSTTOGL>
<MDFUSRID>MAXADMIN</MDFUSRID>
</taIVTransactionHeaderInsert>
</IVInventoryTransactionType>
</eConnect>