Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Under review by Community Managers

Under review

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

eConnect not updating quantities on SOPLINES

Posted on by 75,730

I have an eConnect import that updates quantities on sales order lines. It works perfectly provided the line was not partially shipped. If there was a partial shipment I get this message.In this case the original order quantity was 20 and 2 were shipped. It is now time to ship the rest. Now along comes the import and the doc type is order, quantity is set to 18 which should be updating QTYTOIVC and QTYTBAOR is set to the original order quantity minus the sum of quantity shipped plus the quantity previously invoiced (20-(18+2) = 0). You can see in error message below that QUANTITY does get set to 18 but it says QTYTBAOR is not being passed down. That is not true. I am setting the value of sopline.QTYTBAOR to 0. Any suggestions as to what I am missing? UpdateIfExists is set to 1.

eConnectException: Sql procedure error codes returned:

Error Number = 4777  Stored Procedure= taSopLineIvcInsert  Error Description = Quantities can not exceed total quantity plus quantity already transferred
Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = WEB000885464
SOPTYPE = 2
LNITMSEQ = 65536
Related Error Code Parameters for Node : taSopLineIvcInsert
UpdateIfExists = 1
QTYCANCE = Note: This parameter was not passed in, no value for the parameter will be returned.
QUANTITY = 18.00000
QTYTBAOR = Note: This parameter was not passed in, no value for the parameter will be returned.
QUOTEQTYTOINV = Note: This parameter was not passed in, no value for the parameter will be returned.
TOTALQTY = Note: This parameter was not passed in, no value for the parameter will be returned.

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans