web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect Inventory Tra...
Microsoft Dynamics GP (Archived)

eConnect Inventory Transfer Integration

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I'm trying to update GP with inventory transfer requests from a POS system, via eConnect.  I have implemented the official eConnect schemas, so I known my message is structured correctly.  The message is quite straight forward and easy to map.  The error message suggests that the sites don't exist and that the Item Number is not associated with the site, but we have check to make sure it is.  The From location also has available inventory.

Error message

Error Number = 1373 Stored Procedure= taIVTransferLineInsert Error Description = The From Location Code/Site ID (TRXLOCTN) does not exist in Location/Site Setup - IV40700
Node Identifier Parameters: taIVTransferLineInsert
IVDOCNBR = POS_29
ITEMNMBR = 10001-00001-OS
TRXLOCTN = 31
TRNSTLOC = 30


Error Number = 1374 Stored Procedure= taIVTransferLineInsert Error Description = The To Location Code/Site ID (TRNSTLOC) does not exist in Location/Site Setup - IV40700
Node Identifier Parameters: taIVTransferLineInsert
IVDOCNBR = POS_29
ITEMNMBR = 10001-00001-OS
TRXLOCTN = 31
TRNSTLOC = 30


Error Number = 1375 Stored Procedure= taIVTransferLineInsert Error Description = The From Location Code/Site ID (TRXLOCTN) is not assigned to the Item Number (ITEMNMBR) passed in
Node Identifier Parameters: taIVTransferLineInsert
IVDOCNBR = POS_29
ITEMNMBR = 10001-00001-OS
TRXLOCTN = 31
TRNSTLOC = 30


Error Number = 1376 Stored Procedure= taIVTransferLineInsert Error Description = The To Location Code/Site ID (TRNSTLOC) is not assigned to the Item Number (ITEMNMBR) passed in
Node Identifier Parameters: taIVTransferLineInsert
IVDOCNBR = POS_29
ITEMNMBR = 10001-00001-OS
TRXLOCTN = 31
TRNSTLOC = 30


<taIVTransferLineInsert>
<IVDOCNBR>POS_29</IVDOCNBR>
<ITEMNMBR>10001-00001-OS</ITEMNMBR>
<LNSEQNBR>1</LNSEQNBR>
<TRXQTY>2</TRXQTY>
<UOFM>Ea</UOFM>
<TRXLOCTN>31</TRXLOCTN>
<TRNSTLOC>30</TRNSTLOC>
<TRFQTYTY>1</TRFQTYTY>
<TRTQTYTY>1</TRTQTYTY>
</taIVTransferLineInsert>

For reference here is the header node as well;

<taIVTransferHeaderInsert>

<BACHNUMB>Gastown_180808</BACHNUMB>

<IVDOCNBR>POS_29</IVDOCNBR>

<DOCDATE>2018-08-03</DOCDATE>

<POSTTOGL>0</POSTTOGL>

</taIVTransferHeaderInsert>

Originally I was just passing in the minimum number of fields and allowing the non-required fields to default, but I have since added these fields to ensure that these were not the cause.  The addition of these fields did not have any effect on the error message.

Any help would be much appreciated.

Thanks,

Martin

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: eConnect Inventory Transfer Integration

    This turned out to be a none issue.  The problem was the result of the connection string pointing to the wrong company.  So the error message was perfectly correct the sites do not excist in the specified company.

  • sstyer65 Profile Picture
    sstyer65 105 on at
    RE: eConnect Inventory Transfer Integration

    Is the above, the only things you put in the schema?

    I need to find out, how to do inventory transfers for a project I'm working on.

    we've used econnect for invoices... but, have never used the other schemas.   Could you post yours?   thanks

  • Community Member Profile Picture
    Community Member on at
    RE: eConnect Inventory Transfer Integration

    The full eConnect XML schemas are available on the computer you installed eConnect on.  On our computers the path is 'c:\Program Files (X86)\Microsoft Dynamics\eConnect 14.0\XML Sample Documents'. 

    Hope this helps,

    Martin

  • sstyer65 Profile Picture
    sstyer65 105 on at
    RE: eConnect Inventory Transfer Integration

    I tried something similar to what you did, as a test.

    I'm getting an error

    Error Number = 1376 Stored Procedure= taIVTransferLineInsert Error Description = The To Location Code/Site ID (TRNSTLOC) is not assigned to the Item Number (ITEMNMBR) passed in
    Node Identifier Parameters: taIVTransferLineInsert
    IVDOCNBR = FBA15DCL6W7S_4
    ITEMNMBR = 000009780205687930BU
    TRXLOCTN = ECAMPUS
    TRNSTLOC = LEX2FBA

    do you know if that item number has to be setup to access the to location?

    is there a way, to have this done inside the xml?

    here was the xml I was using.... any ideas?

    <taIVTransferLineInsert>
    <IVDOCNBR>FBA15DCL6W7S_1</IVDOCNBR>
    <ITEMNMBR>000009780321691231BU</ITEMNMBR>
    <LNSEQNBR>1</LNSEQNBR>
    <TRXQTY>2</TRXQTY>
    <UOFM>EA</UOFM>
    <TRXLOCTN>ECAMPUS</TRXLOCTN>
    <TRNSTLOC>LEX2FBA</TRNSTLOC>
    <TRFQTYTY>1</TRFQTYTY>
    <TRTQTYTY>1</TRTQTYTY>
    <IVIVINDX></IVIVINDX>
    <InventoryAccount></InventoryAccount>
    <IVIVOFIX></IVIVOFIX>
    <InventoryAccountOffSet></InventoryAccountOffSet>
    <USRDEFND1></USRDEFND1>
    <USRDEFND2></USRDEFND2>
    <USRDEFND3></USRDEFND3>
    <USRDEFND4></USRDEFND4>
    <USRDEFND5></USRDEFND5>
    </taIVTransferLineInsert>

    <taIVTransferHeaderInsert>
    <BACHNUMB>TEST10</BACHNUMB>
    <IVDOCNBR>FBA15DCL6W7S_1</IVDOCNBR>
    <DOCDATE>2018-10-25</DOCDATE>
    <POSTTOGL>1</POSTTOGL>
    <USRDEFND1></USRDEFND1>
    <USRDEFND2></USRDEFND2>
    <USRDEFND3></USRDEFND3>
    <USRDEFND4></USRDEFND4>
    <USRDEFND5></USRDEFND5>
    </taIVTransferHeaderInsert>

  • Merajuddin Profile Picture
    Merajuddin 5 on at
    RE: eConnect Inventory Transfer Integration

    Hi Dear, can your please provide me the C# code for econnect inventory transfer.

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 experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans