AaronT
4Penny.net
Points: 7650

7/27/2016 4:49:15 PM

The Quantity available for this lot is less then the passed in SERLTQTY

I discovered a subtle issue in taIVTransactionLotInsert that is worth talking about.

The error:

Sql procedure error codes returned:
 
Error Number = 2094  Stored Procedure= taIVTransactionLotInsert  Error Description = The Quantity available for this lot is less then the passed in SERLTQTY
Node Identifier Parameters: taIVTransactionLotInsert
IVDOCNBR = 00017789
IVDOCTYP = 1
ITEMNMBR = CAROL~SHADOWGRAYVELOUR~MS    
LOTNUMBR = 14-645             
SERLTQTY = 9975.00000
 
<taIVTransactionLotInsert>
  <IVDOCNBR>00017789</IVDOCNBR>
  <IVDOCTYP>1</IVDOCTYP>
  <ITEMNMBR>CAROL~SHADOWGRAYVELOUR~MS     </ITEMNMBR>
  <LOTNUMBR>14-645              </LOTNUMBR>
  <SERLTQTY>9975.00000</SERLTQTY>
  <ADJTYPE>1</ADJTYPE>
  <LNSEQNBR>49152</LNSEQNBR>
  <LOCNCODE>004       </LOCNCODE>
  <DATERECD>7/27/2016</DATERECD>
</taIVTransactionLotInsert>
 
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <IVInventoryTransactionType>
    <eConnectProcessInfo xsi:nil="true" />
 
    <taIVTransactionLotInsert_Items>
      <taIVTransactionLotInsert>
        <IVDOCNBR>00017789</IVDOCNBR>
        <IVDOCTYP>1</IVDOCTYP>
        <ITEMNMBR>CAROL~SHADOWGRAYVELOUR~MS     </ITEMNMBR>
        <LOTNUMBR>14-645              </LOTNUMBR>
        <SERLTQTY>9975.00000</SERLTQTY>
        <ADJTYPE>1</ADJTYPE>
        <LNSEQNBR>49152</LNSEQNBR>
        <LOCNCODE>004       </LOCNCODE>
        <DATERECD>7/27/2016</DATERECD>
      </taIVTransactionLotInsert>
    </taIVTransactionLotInsert_Items>
 
    <taIVTransactionLineInsert_Items>
      <taIVTransactionLineInsert>
        <IVDOCNBR>00017789</IVDOCNBR>
        <IVDOCTYP>1</IVDOCTYP>
        <ITEMNMBR>CAROL~SHADOWGRAYVELOUR~MS     </ITEMNMBR>
        <LNSEQNBR>49152.00000</LNSEQNBR>
        <UOFM>Each    </UOFM>
        <TRXQTY>-9975.00000</TRXQTY>
        <TRXLOCTN>004       </TRXLOCTN>
        <USRDEFND1>14-645                                            </USRDEFND1>
      </taIVTransactionLineInsert>
    </taIVTransactionLineInsert_Items>
 
    <taIVTransactionHeaderInsert>
      <BACHNUMB>STOCKCNT160727 </BACHNUMB>
      <IVDOCNBR>00017789</IVDOCNBR>
      <IVDOCTYP>1</IVDOCTYP>
      <DOCDATE>7/27/2016</DOCDATE>
      <MDFUSRID>pn      </MDFUSRID>
      <PTDUSRID>pn      </PTDUSRID>
    </taIVTransactionHeaderInsert>
  </IVInventoryTransactionType>
</eConnect>
4Penny.net
Version: All
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