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


Timestamp:04/16/2015 11:55:21 AM Category:GP Exception Priority:1  EventId:102 Severity:Critical

                  Title:Exception while processing Expense Record GE102-104

           Message:Exception while processing Expense Record GE102-104 Transaction Count - 105Amount - 202.9500 Credit Entity - AMERIC05 Currency USDFirst ERP Account ID ---6070- Exception Message - Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned:

Error Number = 936  Stored Procedure= taPMDistribution  Error Description = Vendor number does not exist

Node Identifier Parameters: taPMDistribution

DOCTYPE = 1

VCHRNMBR = GE102-104

VENDORID = AMERIC05

DISTTYPE = 6

 

 

<taPMDistribution>

  <DOCTYPE>1</DOCTYPE>

  <VCHRNMBR>GE102-104</VCHRNMBR>

  <VENDORID>AMERIC05</VENDORID>

  <DISTTYPE>6</DISTTYPE>

  <DistRef>HEADSETS DIRECT, INC800-914-7996 AZ</DistRef>

  <ACTNUMST>6070-0-010-01</ACTNUMST>

  <DEBITAMT>202.95</DEBITAMT>

</taPMDistribution>

 

   at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateTransactionEntity(String connectionString, String xml)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateTransactionEntity(String connectionString, String sXML)

   at GorillExpense.IntegrationApp.Classes.GPeConnectPayablesInvoiceUpload.GPProcessSingleBatch(List`1 exp, List`1 memoFlds, Decimal total_amt)




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


Solution: Please make sure the highlighted vendor ID above exists in GP