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.
- Set up Products
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||Category of the product|
|Product||Name of the product|
|Location||Location(s) where the product is stocked|
|Bin||Bin(s) where the product is stocked|
|Batch/Serial #||Batch or serial number of the product|
|Expiry Date||Expiry date of the product|
|Stock Value||Value of the product stock|
|On Hand||Quantity of items in stock|
|Available||Quantity of items available for allocation. Computed as the difference between items On Hand and Allocated.|
|On Order||Quantity of items with authorised purchase orders that have not yet been received|
|Allocated||Quantity of items allocated to the sales order (after the sales order is authorised and before the item is shipped)|
|Next Delivery||Expected 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.