Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Sql procedure error codes returned: Error Number = 1340

Posted on by 170

Hi,

I am using smart connect to import 400 plus sales invoices in shot. I am adding few new AA codes and trying to test the import but I am getting this error.

"Sql procedure error codes returned: Error Number = 1340"

pastedimage1569361997468v1.png

Can somebody advise me how to get rid of this.

Thanks,

Ran

  • RE: Sql procedure error codes returned: Error Number = 1340

    Looking at the taRMDistribution procedure mentioned in the error screenshot, the error number of 1340 represents the following:

    if (@I_vACTNUMST <> '')
    begin
    select @I_vDSTINDX = 0
    select @I_vDSTINDX = ACTINDX from GL00105 (nolock) where ACTNUMST = @I_vACTNUMST
    if (@I_vDSTINDX = 0)
    begin
    select @O_iErrorState = 1340

    On the surface, it's looking at the account index (ACTINDX) value in the GL00105 table for the account number (ACTNUMST), then if the account index (ACTINDX) which is passed into the vDSTINDX variable is 0 (zero), then it throws error 1340.

    I looked for more information on this error and procedure but didn't find much more than this. I would look at the ACTINDX value in the GL00105 table for the account numbers (ACTNUMST) being used in the integration and/or for any ACTINDX values in the GL00105 that are 0 (zero) or not a valid account index number and if you find any, correct them to see if this resolves this eConnect error.

    You can also open a support case if you want a engineer to actively look at this error with you, otherwise I'll leave this forum open for anyone else that may've experienced this error message and have more information on it.

    Thank you,

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans