Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
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
site