Skip to main content
Unanswered

eConnect not recognizing correct values update SOPLINE update

editSubscribe (0) ShareShare
ReportReport
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.