Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Hosea 3/2/2012 11:22:48 AM

Vendor Item Number (VNDITNUM) is not setup for this Item Number (ITEMNMBR)

I'm getting the error below when sending a PO via eConnect, GP2010.

The item is not set up for this vendor, but they don't want to. What I don't understand is that I can key this in the system without an issue...

 

Sql procedure error codes returned:

Error Number = 397 Stored Procedure= taPoLine Error Description = Vendor Item Number (VNDITNUM) is not setup for this Item Number (ITEMNMBR)
Node Identifier Parameters: taPoLine
PONUMBER = 25181-25173
VENDORID = OTTO BOCK
Related Error Code Parameters for Node : taPoLine
ITEMNMBR = SHIPPING
VNDITNUM = Note: This parameter was not passed in, no value for the parameter will be returned.


<taPoLine>
<PONUMBER>25181-25173</PONUMBER>
<VENDORID>OTTO BOCK </VENDORID>
<LOCNCODE>1000 </LOCNCODE>
<ITEMNMBR>SHIPPING</ITEMNMBR>
<QUANTITY>0</QUANTITY>
<ITEMDESC>SHIPPING</ITEMDESC>
<UOFM>EA</UOFM>
<ORD>7</ORD>
</taPoLine>

I tried setting the NONINVEN flag and got this:

Sql procedure error codes returned:

Error Number = 5466 Stored Procedure= taPoLine Error Description = Item exists as a inventoried item, NONINVEN cannot be set to 1
Node Identifier Parameters: taPoLine
PONUMBER = 25181-25173
VENDORID = OTTO BOCK
Related Error Code Parameters for Node : taPoLine
NONINVEN = 1
ITEMNMBR = SHIPPING


<taPoLine>
<PONUMBER>25181-25173</PONUMBER>
<VENDORID>OTTO BOCK </VENDORID>
<LOCNCODE>1000 </LOCNCODE>
<VNDITNUM>SHIPPING</VNDITNUM>
<ITEMNMBR>SHIPPING</ITEMNMBR>
<QUANTITY>0</QUANTITY>
<NONINVEN>1</NONINVEN>
<ITEMDESC>SHIPPING</ITEMDESC>
<UOFM>EA</UOFM>
<ORD>7</ORD>
</taPoLine>

Version: GP 2010
Section: eConnect








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables