Error: The value for column 'itCost' in table 'items' is DBNull.


This error message will occur if the ITEM you are selling does not have a cost associated to it.

First Steps to Resolve Error Message

• To verify and correct the missing cost for a Special Order:

  1. Go into Inventory > Items > Find - then lookup the item. 
  2.   Once located, double click to open the item record and input a cost.

• To verify and correct the missing cost for the Item on a sale line:

  1. In your POS, select the MORE button on the item's sale line.
  2. Click ITEM DETAILS to bring up the item record for this item, and then input a cost on the item.

Once you have corrected the missing cost, please proceed with the sale or pickup you were attempting at the time the error message occurred.

Further Assistance for Error Message

If you are still seeing this SAME error message after following the steps outlined above, please contact The Edge Support Team at support@ajsllc.com for further assistance. You may also email directly from the Edge Error message by clicking on the Email button.

Please include a detailed description of sale or special order pickup being processed, including the steps you were taking at the time this error message occurred. Also make note if the error message has changed after following these steps, and if so, please email in the NEW error message with details.

In addition to these details, please also include the version of Edge you are running, which can be found at the bottom left hand side of the main Edge screen.

Updated on Fri, 18 Dec 2020 by Angela Chiaravalle

Glad we could be helpful. Thanks for the feedback.

Sorry we couldn't be helpful. Your feedback will help us improve this article.

How helpful was this page?