Error: While sending an expense report to GP, you may get the following error -


Timestamp:4/2/2025 2:48:00 PM Category:Main GP Exception Priority:1 EventId:100 Severity:Critical

Title: Exception while processing GP Upload

Message: GPeConnectPayablesInvoiceUpload.cs Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned:


Error Number = 306 Stored Procedure= taPMTransactionInsert Error Description = Voucher Number (VCHNUMWK) already exists in PM Keys Master Table - PM00400

Node Identifier Parameters: taPMTransactionInsert

BACHNUMB = GORILLA

VCHNUMWK = GE647-0

VENDORID = HUNTCAR01

DOCNUMBR = GE647-0

DOCTYPE = 1

DOCDATE = 4/2/2025 12:00:00 AM


<taPMTransactionInsert>

<BACHNUMB>GORILLA</BACHNUMB>

<VCHNUMWK>GE647-0</VCHNUMWK>

<VENDORID>HUNTCAR01</VENDORID>

<DOCNUMBR>GE647-0</DOCNUMBR>

<DOCTYPE>1</DOCTYPE>

<DOCAMNT>1089.29</DOCAMNT>

<DOCDATE>4/2/2025 12:00:00 AM</DOCDATE>

<PRCHAMNT>1089.29</PRCHAMNT>

<CHRGAMNT>1089.29</CHRGAMNT>

<TRXDSCRN>022825 T. Haye</TRXDSCRN>

<CREATEDIST>0</CREATEDIST>

<USRDEFND1>GorillaIntegration</USRDEFND1>

<USRDEFND4>1</USRDEFND4>

<USRDEFND5>1</USRDEFND5>

</taPMTransactionInsert>

                 

================================================================================================================================

Solution: Please check if the expense report voucher number (for example, GE647-0) already exists in the Dynamics GP. This error typically occurs when the voucher was partially created during a previous integration attempt, resulting in a duplicate entry in the PM Keys Master Table. To resolve this issue, log in to Dynamics GP and search for the corresponding voucher number in the PM Keys Master Table or Payables Management. 


If the voucher already exists, delete the existing or partially created record after confirming that it is not linked to any posted transactions. Once deleted, return to the Gorilla Expense Integration App and try pushing the Expense Report. After reprocessing, verify that the expense report has been successfully integrated into GP with all the details. This will ensure that the duplicate voucher conflict is resolved and the integration proceeds successfully.