Viewing Product Availability

DEAR allows the user to view the availability of their products, including what has been allocated to sales and work orders. 

In case the stock is currently on order, DEAR informs users of the expected delivery date of the ordered stock. Customers can then decide whether to back order (see Back Orders for more information) or opt for an alternative if the incoming stock is not expected to be available soon enough.


To view the Product Availability page, navigate to Inventory > Availability.

As with the Inventory > Products screen, you can filter the report, customise the columns, use the search option, print product labels and export the report.

NOTE: There is a separate Product Availability Report that can be generated from the DEAR Reports module. The information displayed in that report is essentially the same as that found on the Product Availability page. For more information, see Product Availability Report.

The information on the Product Availability page is presented in the table below. See Calculation of Available, On Hand and Allocated Stock quantity for more detail about how these values are calculated. 

Category of the product
Name of the product
LocationLocation(s) where the product is stocked
BinBin(s) where the product is stocked
Batch/Serial #Batch or serial number of the product
Expiry DateExpiry date of the product
Stock ValueValue of the product stock
On HandQuantity of items in stock
AvailableQuantity of items available for allocation. Computed as the difference between items On Hand and Allocated.
On OrderQuantity of items with authorised purchase orders that have not yet been received
AllocatedQuantity of items allocated to the sales order (after the sales order is authorised and before the item is shipped)
Next DeliveryExpected delivery date of the ordered product, regardless of whether the product is in stock or not. The displayed date follows the selected Date Format option in General Settings.

NOTE: For stock that has been ordered but not yet received, the date displayed in the Next Delivery column is taken from the Required By date on the Purchase or Transfer Order. If the Required By date is blank, the delivery date remains blank. For stock that has not been ordered, N/A is displayed in the Next Delivery column.

Available and On Hand quantities can be verified during purchases using the Verify an Order function on the purchase order screen. This will compare PO quantities to your inventory stock. 


If you sell products in multiple set quantities, (e.g. a single apple and a 6-pack), you can set up Additional Units of Measure to automatically handle conversions. When larger packs are purchased, they are automatically disassembled into the smallest or base unit. For 6 apples, the product availability screen will show 6 singles on hand but one 6-pack and 6 singles available for sale.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.