stevegray
4Penny.net
Points: 55409

1/17/2017 1:20:51 PM

The Transaction Qty (TRXQTY) exceeds the Qty available

This was a stumper. Took me a while to figure it out. Answer below.
 
Sql procedure error codes returned:
Error Number = 1789  Stored Procedure= taIVTransactionLineInsert  Error Description = The Transaction Qty (TRXQTY) exceeds the Qty available
Node Identifier Parameters: taIVTransactionLineInsert
IVDOCNBR = 00018477
IVDOCTYP = 1
ITEMNMBR = CAROL~REDWIRECUT~ES          
Related Error Code Parameters for Node : taIVTransactionLineInsert
TRXQTY = -3010.00000
TRXLOCTN = 004      
<taIVTransactionLineInsert>
  <IVDOCNBR>00018477</IVDOCNBR>
  <IVDOCTYP>1</IVDOCTYP>
  <ITEMNMBR>CAROL~REDWIRECUT~ES           </ITEMNMBR>
  <LNSEQNBR>16384.00000</LNSEQNBR>
  <UOFM>Each    </UOFM>
  <TRXQTY>-3010.00000</TRXQTY>
  <TRXLOCTN>004       </TRXLOCTN>
  <USRDEFND1>16032                                             </USRDEFND1>
</taIVTransactionLineInsert>
  <IVInventoryTransactionType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateItemRcd xsi:nil="true" />
    <taIVTransactionSerialInsert_Items xsi:nil="true" />
    <taIVTransactionLotInsert_Items>
      <taIVTransactionLotInsert>
        <IVDOCNBR>00018477</IVDOCNBR>
        <IVDOCTYP>1</IVDOCTYP>
        <ITEMNMBR>CAROL~REDWIRECUT~ES           </ITEMNMBR>
        <LOTNUMBR>16032               </LOTNUMBR>
        <SERLTQTY>3010.00000</SERLTQTY>
        <ADJTYPE>1</ADJTYPE>
        <LNSEQNBR>16384</LNSEQNBR>
        <LOCNCODE>004       </LOCNCODE>
        <AUTOCREATELOT>1</AUTOCREATELOT>
        <DATERECD>1/3/2017</DATERECD>
      </taIVTransactionLotInsert>
    </taIVTransactionLotInsert_Items>
    <taIVTransactionLineInsert_Items>
      <taIVTransactionLineInsert>
        <IVDOCNBR>00018477</IVDOCNBR>
        <IVDOCTYP>1</IVDOCTYP>
        <ITEMNMBR>CAROL~REDWIRECUT~ES           </ITEMNMBR>
        <LNSEQNBR>16384.00000</LNSEQNBR>
        <UOFM>Each    </UOFM>
        <TRXQTY>-3010.00000</TRXQTY>
        <TRXLOCTN>004       </TRXLOCTN>
        <USRDEFND1>16032                                             </USRDEFND1>
      </taIVTransactionLineInsert>
      <taIVTransactionLineInsert>
        <IVDOCNBR>00018477</IVDOCNBR>
        <IVDOCTYP>1</IVDOCTYP>
        <ITEMNMBR>GENSH~FIVEPOINTSARTISANBL~QS  </ITEMNMBR>
        <LNSEQNBR>32768.00000</LNSEQNBR>
        <UOFM>Each    </UOFM>
        <TRXQTY>-0.18000</TRXQTY>
        <TRXLOCTN>004       </TRXLOCTN>
        <USRDEFND1>                                                  </USRDEFND1>
      </taIVTransactionLineInsert>
    </taIVTransactionLineInsert_Items>
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taIVTransactionMultiBinInsert_Items xsi:nil="true" />
    <taIVTransactionHeaderInsert>
      <BACHNUMB>004 1/16       </BACHNUMB>
      <IVDOCNBR>00018477</IVDOCNBR>
      <IVDOCTYP>1</IVDOCTYP>
      <DOCDATE>1/17/2017</DOCDATE>
      <MDFUSRID>sgray          </MDFUSRID>
      <PTDUSRID>sgray          </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