No null values in the Quantity committed in store level

Asked By 30 points N/A Posted on -
qa-featured

Hi, I have just started having this problem in two of our shops and I was wandering if anyone else has had the same problem.  It is an error concerning the 401 worksheet.  There is a timeout followed by this message.

Error-2147217873 – Cannot insert the value Null into column "Quantitycommitted…”, .

There are no null values in the Quantity committed in store level & itemdynamic in HQ

SHARE
Answered By 567105 points N/A #138767

No null values in the Quantity committed in store level

qa-featured

I think you should do a thorough check on the worksheet specifically on the QuantityCommitted column. The NULL value mentioned in the error message means a blank or no value was declared or that there are no values inserted under the column QuantityCommitted of the worksheet.

If you are sure that this column doesn’t have any null values, meaning all fields of this column were completely filled then check again if any of these fields contain a “space” either before or after the inserted value.

Maybe the column doesn’t allow inserting a “space” or spaces in the value it contains.

You may also try checking your computer for any possible errors. Use a disk utility application to check the system. For a much thorough diagnostics test on your system, use disk utility applications like Norton Utilities, PC Tools Performance Toolkit, or Norton SystemWorks.

You may also try checking your machine for possible virus infection that is possibly affecting the functionality of your programs.

Login/Register to Answer

Related Questions