Microsoft Dynamics GP (Archived)

Integration Manager Error - "The Transaction Qty passed in is <> to what was passed into the taIVTransactionSerialInsert proc or the taIVTransactionLotInsert proc"

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (0)

Janeece Moreland 270 on at

Like (0)

Report

RE: Integration Manager Error - "The Transaction Qty passed in is <> to what was passed into the taIVTransactionSerialInsert proc or the taIVTransactionLotInsert proc"

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Integration Manager Error - "The Transaction Qty passed in is <> to what was passed into the taIVTransactionSerialInsert proc or the taIVTransactionLotInsert proc"

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.