You’re offline. This is a read only version of the page.
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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,151
Super User 2024 Season 2
#2
Martin Dráb
229,963
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (