Working in a lab environment with Microsoft Dynamics GP2010 and I came across an issue when selecting the “Item” list in Inventory. I was getting the following error:

Cannot insert the value NULL into column ‘BASEUOFM’, table ‘tempdb.dbo.##xxxxxx’; column does not allow nulls. INSERT fails.

Restarting the database server didn’t resolve it because I was hoping that clearing out the temp database tables would clear it and I was going crazy trying to find the answer! With a little help from this thread what I found was empty fields in the UOMSCHDL column in the IV00101 table. The following SQL script identifies the empty fields.

select ITEMNMBR, UOMSCHDL from IV00101
order by UOMSCHDL

The following script fixes the empty fields found in the above script.

UPDATE IV00101 SET UOMSCHDL='E' WHERE ITEMNMBR = 'ITEM NUMBER WITH EMPTY UOMSCHDL FIELD'

Now I can view items without error! Not sure how the field became empty. Check Links could possibly be the culprit but I’m not sure. So if you ever come across that error maybe this will fix it! Good luck!