News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Unable to sync the Ord...

Finance | Project Operations, Human Resources, ...

Suggested answer

Unable to sync the Order from Ecommerce to GP

(0) Share

Report

Report

Posted on by P@van

50

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: Unable to sync the Order from Ecommerce to 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

9,

1,

@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

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 601 Most Valuable Professional

#2

Abhilash Warrier 416

#3

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans