Cannot Insert The value NULL Into Column ‘BASEUOFM’ issue in GP2010

MGD King's Thoughts

Getting What's Inside My Head Out
 

About The King

The King of MGD!A lot of people ask me what does MGD King mean? Well, it was a nickname given to me because I used to drink large quantities of Miller Genuine Draft. Someone mentioned to me that I was the King of MGD, and so it stuck.

Twitterverse

Note: For Customization and Configuration, CheckOut Recent Tweets Documentation

Cannot Insert The value NULL Into Column ‘BASEUOFM’ issue in GP2010

by MGD King May 11, 2011 9:52 AM

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!

Add comment