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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Creating a new invento...
Microsoft Dynamics GP (Archived)

Creating a new inventory location using econnect

(0) ShareShare
ReportReport
Posted on by sstyer65 105

I'm having to perform some inventory transfers in econnect on a regular basis.

I'm using the

IVInventoryTransferType xml to do this.   But, if an item doesn't already have that location assigned to it... it gives me 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

What Xml do I need to use, to create the location for that item #, before doing the transfer?

from the iv00102 table, that works for this item

item                           locncode

000009780321691231BU       ECAMPUS
000009780321691231BU       FBA
000009780321691231BU      LEX2FBA

*This post is locked for comments

I have the same question (0)
  • Tim Wappat Profile Picture
    Tim Wappat 5,713 on at

    To assign items to the site using eConnect, obviously may be assigned to multiple sites, hence array.

    Replace values into [] - this is min required.

      IVInventoryItemSiteType = new IVInventoryItemSiteType[]

     

                   {

                       new IVInventoryItemSiteType()

                       {

                               taItemSite_Items = new taItemSite_ItemsTaItemSite[]

                               {

                                   new taItemSite_ItemsTaItemSite()

                                   {

                                       ITEMNMBR= [itemsku],

                                       LOCNCODE="[location]",

                                       PRIMVNDR= [Supplier],

                                   }

                               }

                       }

                   }

  • sstyer65 Profile Picture
    sstyer65 105 on at

    I've tried to do one, and I get

    11.0.0.0
    System.Messaging
    System.InvalidOperationException: Property Label was not retrieved when receiving the message. Ensure that the PropertyFilter is set correctly.
    at System.Messaging.Message.get_Label()
    at Microsoft.Dynamics.GP.eConnect.Incoming.eConnect_Incoming.Send_To_Deadletter(MessageQueue q, Message m, Exception Exp)

    not sure If I have the xml correct

    we don't have our primvndr set

    i had been looking for some kind of example of the xml for this

    <?xml version="1.0"?>
    <eConnect>
         <IVInventoryItemSiteType>
              <taItemSite_Items>
                   <taItemSite>
                          <ITEMNMBR>000009780393073720BU</ITEMNMBR>
                          <LOCNCODE>LEX2FBA</LOCNCODE>
                          <PRIMVNDR></PRIMVNDR>
                    </taItemSite>
               </taItemSite_Items>
         </IVInventoryItemSiteType>
    </eConnect>

  • Tim Wappat Profile Picture
    Tim Wappat 5,713 on at

    I think that is configuration of your message q - create a corresponding 'deadletter' queue.

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans