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
stevegray
4Penny.net
Points: 51075

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
site