DanielE
4Penny.net
Points: 7900

3/20/2017 11:10:11 AM

The Checkbook id (CHEKBKID) does not exist in the Checkbook Master Table - CM00100

The two errors below are similar and have the same root, so I'll blog them together:

 

Sql procedure error codes returned:
Error Number = 320  Stored Procedure= taPMTransactionInsert  Error Description = The Cash Amount Checkbook ID (CAMCBKID) does not exist in Checkbook Master Table - CM00100
Node Identifier Parameters: taPMTransactionInsert
BACHNUMB = EXPNS 0317    
VCHNUMWK = 00000000000000183
VENDORID = REIPAP1       
DOCNUMBR = 356963             
DOCTYPE = 1
DOCDATE = 3/21/2017
Related Error Code Parameters for Node : taPMTransactionInsert
CAMCBKID = BOP           
Error Number = 324  Stored Procedure= taPMTransactionInsert  Error Description = The Checkbook id (CHEKBKID) does not exist in the Checkbook Master Table - CM00100
Node Identifier Parameters: taPMTransactionInsert
BACHNUMB = EXPNS 0317    
VCHNUMWK = 00000000000000183
VENDORID = REIPAP1       
DOCNUMBR = 356963             
DOCTYPE = 1
DOCDATE = 3/21/2017
Related Error Code Parameters for Node : taPMTransactionInsert
CHEKBKID = BOP           
<taPMTransactionInsert>
  <BACHNUMB>EXPNS 0317     </BACHNUMB>
  <VCHNUMWK>00000000000000183</VCHNUMWK>
  <VENDORID>REIPAP1        </VENDORID>
  <DOCNUMBR>356963              </DOCNUMBR>
  <DOCTYPE>1</DOCTYPE>
  <DOCAMNT>170.37000</DOCAMNT>
  <DOCDATE>3/21/2017</DOCDATE>
  <PRCHAMNT>170.37000</PRCHAMNT>
  <CASHAMNT>170.37000</CASHAMNT>
  <CAMCBKID>BOP            </CAMCBKID>
  <CDOCNMBR>100019              </CDOCNMBR>
  <CAMTDATE>3/21/2017</CAMTDATE>
  <CAMPMTNM>1A31350984164AA4B663</CAMPMTNM>
  <CHEKBKID>BOP            </CHEKBKID>
  <TRXDSCRN>Reinert Paper &amp; Chemical(REIPA</TRXDSCRN>
  <CREATEDIST>0</CREATEDIST>
  <USRDEFND1>ZTEST                                             </USRDEFND1>
</taPMTransactionInsert>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <PMTransactionType>
    <taPMDistribution_Items>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>00000000000000183</VCHRNMBR>
        <VENDORID>REIPAP1        </VENDORID>
        <DISTTYPE>2</DISTTYPE>
        <ACTNUMST>101-1090-00-0000-</ACTNUMST>
        <DEBITAMT>170.37000</DEBITAMT>
      </taPMDistribution>
      <taPMDistribution>
        <DOCTYPE>1</DOCTYPE>
        <VCHRNMBR>00000000000000183</VCHRNMBR>
        <VENDORID>REIPAP1        </VENDORID>
        <DISTTYPE>6</DISTTYPE>
        <ACTNUMST>101-3400-00-0000-</ACTNUMST>
        <CRDTAMNT>170.37000</CRDTAMNT>
      </taPMDistribution>
    </taPMDistribution_Items>
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPMTransactionInsert>
      <BACHNUMB>EXPNS 0317     </BACHNUMB>
      <VCHNUMWK>00000000000000183</VCHNUMWK>
      <VENDORID>REIPAP1        </VENDORID>
      <DOCNUMBR>356963              </DOCNUMBR>
      <DOCTYPE>1</DOCTYPE>
      <DOCAMNT>170.37000</DOCAMNT>
      <DOCDATE>3/21/2017</DOCDATE>
      <PRCHAMNT>170.37000</PRCHAMNT>
      <CASHAMNT>170.37000</CASHAMNT>
      <CAMCBKID>BOP            </CAMCBKID>
      <CDOCNMBR>100019              </CDOCNMBR>
      <CAMTDATE>3/21/2017</CAMTDATE>
      <CAMPMTNM>1A31350984164AA4B663</CAMPMTNM>
      <CHEKBKID>BOP            </CHEKBKID>
      <TRXDSCRN>Chemical(REIPA</TRXDSCRN>
      <CREATEDIST>0</CREATEDIST>
      <USRDEFND1>ZTEST                                             </USRDEFND1>
    </taPMTransactionInsert>
    <taMdaUpdate_Items xsi:nil="true" />
  </PMTransactionType>
</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