Skip to main content

Notifications

Announcements

No record found.

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

eConnect SOP Error Modified quantity can not be less then the quantity already transferred

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I have an existing eConnect integration for SOP documents and have come across a new situation where the error message is not making sense so I am curious if anyone can provide some insight.

If I integrate a SOP Invoice with a negative quantity the document is accepted into GP succesfully.

However, if I try to update this invoice with the exact same values I receive  this eConnect error:

2262 - taSopLineIvcInsert  -  Modified quantity can not be less then the quantity already transferred .

If I open the invoice in the GP interface, it will let me save it successfully.

If I delete the negative quantity line and re-add it through eConnect it works fine. However trying to update these negative quantity lines always fails with this error.

Perhaps I am missing something, any help is appreciated.

Thanks in advance

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: eConnect SOP Error Modified quantity can not be less then the quantity already transferred

    Hi,

    That is what I was thinking and have already taken steps as you suggested to work around it.

    My work around seems to be correct based on the posting of the documents, etc.

    Just wanted to see if others had run into this as well.

    Thanks for the confirmation and assistance.

  • KevinD Profile Picture
    KevinD 215 on at
    Re: eConnect SOP Error Modified quantity can not be less then the quantity already transferred

    Sounds to me like it's a bug in eConnect if you can do it in the window.  The more and more you write integrations using eConnect, you will see things that you can do in the window, but eConnect won't let you.  Short of decrypting the stored procedure and following the logic of the SQL proc, you could put some SQL logic in the taSopLineIvcInsertPre stored procedure that basically updates the quantity ahead of time with an update statement  That taSopLineIvcInsert  is just a stored procedure in the background that is throwing this error at some point in the code, that error you see is just a number from the eConnect error code table that is getting thrown).  As a general rule, if  I can confirm that this really is how the system should be working, then I have no problem tricking eConnect to work the way it should.  But be careful and make sure you know what you are doing.  This one might just be failing because of flipping signs since I feel like the SOP line tables generally expect positive numbers; even returns are positive, just a different doc type.  It just might not have been taken in consideration when writing that proc.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans