Hello,
I am trying to do an Inventory Transaction with a Multi-Entity company and am getting the following error:
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Sql procedure error codes returned:
 
Error Number = 1581 Stored Procedure= taIVTransactionLineInsert Error Description = The Transaction Qty passed in is <> to what was passed into the taIVTransactionSerialInsert proc or the taIVTransactionLotInsert proc
Node Identifier Parameters: taIVTransactionLineInsert
IVDOCNBR = ADJ00000000000001
IVDOCTYP = 1
ITEMNMBR = 57894-030-01
Related Error Code Parameters for Node : taIVTransactionLineInsert
TRXQTY = 1.000000000000000
Can anyone point me in the right direction. This company is multi-entity with a script added to the integration, and the items do have serial numbers.
Thanks,
Collin
*This post is locked for comments
I know this is a little late but I wanted to post this for others. I received this error also. I tried creating my own line sequence number but that did not work.
As soon as I grouped by Serial the import worked.
Sorry, it appears the screen captures were to large to post. Here is the error:
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Sql procedure error codes returned:
Error Number = 1581 Stored Procedure= taIVTransactionLineInsert Error Description = The Transaction Qty passed in is <> to what was passed into the taIVTransactionSerialInsert proc or the taIVTransactionLotInsert proc
Node Identifier Parameters: taIVTransactionLineInsert
IVDOCNBR = ADJ00000000000001
IVDOCTYP = 1
ITEMNMBR = 57894-030-01
Related Error Code Parameters for Node : taIVTransactionLineInsert
TRXQTY = 1.000000000000000
Thanks.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156