Please visit our COVID-19 Resources page for useful payroll and reference information. During this time, when many companies are forced to telework, AccountEdge Hosted may be a good option. Host your company file to be accessed remotely from any device, for as long as you need. You can go back to your regular setup when you no longer need remote accessibility. If you’d like to discuss that or any other teleworking solution with a product specialist, please call 800.322.6962. Be safe.

  • Section: Inventory
  • Last updated: July 26, 2019, 12:45 p.m.

Insufficient Quantity on Hand - Cost Cannot be Calculated

Background

If you have the preference to "Allow the Sale of Items with Insufficient On-hand Quantities" turned on Setup > Preferences > Inventory screen you can receive a message when attempting to create a sale that will take the inventory under zero and no cost for the item is set (never purchased and no standard cost).

Insufficient Quantity Message

The message you will receive is:

To enter an estimated cost, click the Item Information button and enter an amount in the Standard Cost field.

To use $0.00 as the estimated cost, click the Use $0.00 Cost button.

The cost entered in either of these ways will be automatically adjusted if, when you purchase the item, the actual purchase price is different from the cost on the sale. The difference will be recorded as an inventory adjustment.

What This Means for You

The above dialog is displayed in an alert box when you enter a sale for an item that has "I Buy This Item" selected in the items's Profile but the Standard Cost or Last Cost is not set.

The statement, "the cost...will be automatically adjusted" means a Cost of Sales cannot be determined at this time. It will be calculated after a purchase, if the "actual purchase price is different from the cost on the sale."