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.
|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.