sendow 4/28/2010 11:38:13 AM

Errors from IVInventoryTransactionType with taIVTransactionMultiBinInsert

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>

 

Version: Unknown or N/A
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3