Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager Er...
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) ShareShare
ReportReport
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

  • Janeece Moreland Profile Picture
    Janeece Moreland 270 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

Under review

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

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans