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) / Procedure or function ...
Microsoft Dynamics GP (Archived)

Procedure or function 'taSopLineIvcInsert' expects parameter '@I_vITEMNMBR', which was not supplied.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Im trying to Export an 850 for a new customer into out EDI Highjump Transaction Manager system. We have Microsoft Dynamics GP but with this customer I need to export them into our "old" platform, Great Plains Framework. When I export this into our system Im getting this error:

Procedure or function 'taSopLineIvcInsert' expects parameter '@I_vITEMNMBR', which was not supplied.

My EDI team NOR the new customer's EDI team seems to know what is going on and everyone is saying its someone else's issues. In the meantime I have a customer that is waiting on product because I can't seem to find an "IT" person that whats to take ownership of this. 

*This post is locked for comments

  • Lucas Miller Profile Picture
    Lucas Miller on at
    RE: Procedure or function 'taSopLineIvcInsert' expects parameter '@I_vITEMNMBR', which was not supplied.

    Lynn,

    I have worked with people using Salespad in the past, so I know that application's stored procedures contain a version of the Dynamics GP eConnect logic.  Here's the GP data check that determines if eConnect will return the "Inventory item does not exist" error message:

    if ((@I_vNONINVEN = 0) and (not exists(select 1 from IV00101 (nolock) where ITEMNMBR = @I_vITEMNMBR))

    and (not exists(select 1 from SOP60300 (nolock) where CUSTITEMNMBR = @I_vITEMNMBR and CUSTNMBR = @I_vCUSTNMBR)))

    To break this down it first checks if you've specified if this is a non-inventoried item.  It then checks if the item you've passed in to @I_VITEMNMBR does not exist in the Item Master (IV00101).  Finally, it checks if the Item Number and Customer Number combination you've passed doesn't exist in the SOP60300.  If all three of those statements are true this error condition will be given.

    I'm not sure if Salespad can output an XML or SQL statement it's sending to the database for troubleshooting purposes, but that would be an easy way to see that you're passing valid data.  If that is not possible with this tool I would recommend capturing a SQL Server Profiler trace when you submit the document from Salespad to see what the SQL calls look like.  Much of the activity will likely be encrypted, but you should be able to see the parameters being passed to the line and header procedures to verify the Item Number that is being used.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Procedure or function 'taSopLineIvcInsert' expects parameter '@I_vITEMNMBR', which was not supplied.

    Thanks for the feedback Lucas. I am getting ready to leave so I will start back up with this in the morning. I will get you more info but basically we have an PO (850 EDI document) in our Transaction Manager, we use High Jump TrueCommerce EDI Solutions to export into my GP/ SalesPad. We really use Sales Pad as the interface because it is more user friendly. Ive sent the item up in teh Item Set up table inside High Jump TrueCommerce EDI Solutions and now the new error I'm getting is saying:

    "Inventory item does not exist"  

    But all the items listed on the customers PO is in our GP system.

  • Lucas Miller Profile Picture
    Lucas Miller on at
    RE: Procedure or function 'taSopLineIvcInsert' expects parameter '@I_vITEMNMBR', which was not supplied.

    Lynn,

    This error indicates that you're using the eConnect functionality of Dynamics GP to interact with the data in the SQL database, or more specifically the taSopLineIvcInsert stored procedure.  This sproc is intended as part of the process of importing a transaction from an external source into Dynamics GP.  The @I_vITEMNMBR parameter is required for this particular procedure.

    It sounds like you're trying to get data out of Dynamics GP into another applications, so this type of eConnect procedure may not be your best bet.  We do have an eConnect feature called Requester that can work with Microsoft Message Queuing (MSMQ) and SQL table triggers to push XML-formatted data out of Dynamics GP to an Outgoing MSMQ queue to be picked up by external applications.

    Bottom line, if you could provide more details on what exactly you're using to perform this export or what you're hoping to accomplish I'm sure the community can find a solution for you.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,399 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans