Dynamics Community Forum Thread Details

Unable to sync the Order from Ecommerce to GP

Hi All,

I am unable to send the Order from Ecommerce to GP and it ithrows an error as Unable to get Payment Number like below.

Sql procedure error codes returned: Error Number = 38 Stored Procedure= taCreateSopPaymentInsertRecord Error Description = Unable to get payment number Node Identifier Parameters: taCreateSopPaymentInsertRecord SOPNUMBE = SOD00079892 SOPTYPE = 2 PYMTTYPE = 3 2 SOD00079892 FRIASJO79902 11/24/2021 129.23 VISA & MC VISA XXXXXXXXXXXX0062 05/01/2026 3

I am wandering for this solution.Can any one suggest me on this.

Thanks,

Pavan

Categories:

Microsoft Dynamics GP

Looking at this taCreateSOPPaymentInsertRecord procedure for eConnect, specifically at error 38, the code for this error is here:

if (@I_vSOPTYPE in(2,3,5,6))

begin

if (((@I_vDOCNUMBR = '') and (@I_vAction = 1) and (@I_vSOPTYPE in(3,6))) or

((@I_vDOCNUMBR = '') and (@I_vAction = 1) and (@I_vSOPTYPE in(2,5)) and (@I_vPYMTTYPE <> 6)) or

(@NewReceipt = 1))

begin

exec @iStatus = taGetPaymentNumber

@I_vDOCNUMBR output,

@iNxtPymntErrState output

select @iError = @@error

if ((@iStatus <> 0) or (@iNxtPymntErrState <> 0) or (@I_vDOCNUMBR = '') or (@I_vDOCNUMBR is NULL) or (@iError <> 0))

begin

select @O_iErrorState = 38

It first looks at the SOPTYPE value and if it is 2,3,5 or 6, will then go through the script showing here, ending with it looking at, if the Status is not 0 or the NxtPymntErrState is not 0 or the DOCNUMBR is blank or NULL, it'll return this error message.

Hopefully this will help resolve this error message.

Thanks

Quick Links

Leaderboard