Skip to content
+1-888-319-3663

COMMUNITY FORUM

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

Charles asked 1 year ago
The client is using GP 10 with SmartConnect 10.15.0.51. 
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 20.18.1.11 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.