Skip to content


Cannot insert the value NULL into column EXTDCOST table TEST.dbo.IV10001; column does not allow nulls

Charles asked 2 years ago
The client is using GP 10 with SmartConnect 
We tested an inventory transaction map but are receiving the above mentioned error. We have the Qty field mapped. We tried mapping the Unit Cost field and not mapping the Unit Cost field but still get the error. 
I tested this in GP 2018 with SmartConnect and, without the Unit Cost mapped, are able to import data. 
Does anybody know if there is something about GP version 10? (They are upgrading soon but not immediately.) 
Thank you

If you would like to submit an answer or comment, please sign in to the eOne portal.