Importing Manufacturers Item Numbers
Tracy asked 6 years ago
I am trying to import the Manufacturers Item Number field in the Manufacturers Item Number Maintenance window from the Item Purchasing Options Maintenance window. I see the field available in the Vendor Item mapping. However, after I run the map, this field is not updated. How can I get this updated ?
Thanks
Thanks
Answers
Patrick Roth Staff answered 6 years ago
Tracy,
Interesting.
The MFG Item Number you see on the Item Vendors integration goes to the IV00103 table (The Item Vendor Master table). There is a column in that table that it goes to.
Yes it looks like the window you reference also has a MFG Item Number – but that data is stored in the IV00115 table and as far as I know it isn’t available in eConnect anywhere.
If you want to write data to that table as well, you would have to write your own proc from scratch or use a tool like eOne Node Builder to do the same. And then you could integrate to that data.
Or – just use an “after document success” SQL task and insert it directly into the table via TSQL code.
patrick
Interesting.
The MFG Item Number you see on the Item Vendors integration goes to the IV00103 table (The Item Vendor Master table). There is a column in that table that it goes to.
Yes it looks like the window you reference also has a MFG Item Number – but that data is stored in the IV00115 table and as far as I know it isn’t available in eConnect anywhere.
If you want to write data to that table as well, you would have to write your own proc from scratch or use a tool like eOne Node Builder to do the same. And then you could integrate to that data.
Or – just use an “after document success” SQL task and insert it directly into the table via TSQL code.
patrick