You’re offline. This is a read only version of the page.
Announcements
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
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.
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.
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.
#1
André Arnaud de Cal...
294,120
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
