unixtown 12/21/2015 3:32:20 PM

Using eConnect to insert an entry into IV00101


 I am experimenting with using eConnect XML to insert / update inventory items. So far my tests have lead me to construct the following message.

<?xml version="1.0" encoding="utf-8"?>
            <ITEMDESC>Test SKU</ITEMDESC>

However this message fails with the following cryptic error:

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'IVSCRVIX', table 'TTS.dbo.IV00101'; column does not allow nulls. INSERT fails.
The statement has been terminated.

 Is this un-documented column mapped to an XML element?What does it normally hold?

 Am I missing any elements or structure in the above XML message?



Version: GP 2013
Section: .NET Development, Dynamics GP, eConnect, Visual Studio Tools for Dynamics GP, Web Services

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