Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect Error
Microsoft Dynamics GP (Archived)

eConnect Error

(0) ShareShare
ReportReport
Posted on by allbrown 65

Hi,

I get the following error when voiding a cash receipt via eConnect:

Msg 2627, Level 14, State 1, Procedure taRMUnapplyTransaction, Line 1
Violation of PRIMARY KEY constraint 'PKCM20100'. Cannot insert duplicate key in object 'dbo.CM20100'. The duplicate key value is (52072.00000, 1).
The statement has been terminated.

I'm using GP2010 and I can void the transaction directly from the GP without any errors.  However the eConnect stored procedure is returning an error.  Has anyone else experienced this issue before?

Any help appreciated

 

*This post is locked for comments

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: eConnect Error

    Hi There, 

    I am getting same error ! Are you able to resolve this issue? 

    Your earliest reply is highly appreciable.

    Thanks much
    Sandip

  • allbrown Profile Picture
    allbrown 65 on at
    Re: eConnect Error

    Good idea but the schema will not help me in this case.  I'm using a utility called SmartConnect that uses the eConnect stored procs so I have to get it working from the stored procs.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: eConnect Error

    Got it. Instead of directly using StoreProc did you try to use eConnect Sechma and see if you get error or not?Here is link : msdn.microsoft.com/.../bb625310.aspx

    Thanks

    Sandip

  • Verified answer
    allbrown Profile Picture
    allbrown 65 on at
    Re: eConnect Error

    Thanks for your quick response Sandip.

    I'm actually voiding a Cash Receipt so I'm not getting the Next Cash Receipt Number.  The system has to unapply cash receipt while voiding.  Error occurs when I try to pass the parameters directly for the stored proc (below)

    EXEC @SPReturnCode = dbo.taRMVoidTransaction

    @I_vCUSTNMBR = 'XXX'

    ,@I_vDOCNUMBR = 'PYMNT0000128922'

    ,@I_vVOIDSTTS = 1

    ,@I_vRMDTYPAL = 9

    ,@I_vVOIDDATE = '05/03/2012'

    ,@I_vGLPOSTDT = '05/03/2012'

    ,@O_iErrorState = @O_iErrorState OUTPUT

    ,@oErrString = @oErrString OUTPUT

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    Re: eConnect Error

    How you provide your Next Cash Receipt Number? I think thats problem your supplying duplicate Receipt Number? Please check event viwer for more help.

    THanks

    Sandip

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans