Product Availability Report

This 'report' takes you to the Product Availability page. 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.


See Viewing Product Availability for detailed information. 


NOTE: The Product Availability Report will only show SKUs that have had movements or transactions (authorised sale/purchase order, stock adjustment, etc.) or an initial stock quantity. Out of stock products with no movements will not appear, even if Show only non-zero quantities is unticked. To see products that do not yet have any movements, try the Stock Level Report which will indicate All SKUs Listed.


Prerequisite


Table of Contents


The following table shows the inputs for the report.


RefreshWhen clicked, refreshes the report with the latest DEAR information. 
ExportWhen clicked, exports the report data to Excel.
PrintWhen clicked, prints labels for selected products.

 


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. 


COLUMNDESCRIPTION
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. If this and the Expiry Date columns are hidden from the page, the Available column shows consolidated info for all locations.
Expiry Date*Expiry date of the product. If this and the Batch/Serial # columns are hidden from the page, the Available column shows consolidated info for all locations.
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.
BrandProduct Brand
FamilyProduct Family name 
Unit
Product unit of measure
Stock LocatorStock Locator for product
Price Tier 1Tier 1 Price
Price Tier 2Tier 2 Price
Price Tier 3Tier 3 Price
StatusProduct Status (ACTIVE or DEPRECATED)
On-Hand VolumeQuantity on Hand x H X L X W dimensions. If dimensions have not been entered for a product, this value will show as 0.
Unit CostUnit Cost of the product based on the purchase price, COGS and any landed costs


Headings can be added to or removed from the Product Availability table to change the view by using the Settings icon in the corner of the page. You can also sort the table view by ascending or descending values of each heading by hovering over the heading name. Return layout to default by selecting Reset Layout.


FAQs

[back to top]


I sell items in multiple set quantities (e.g. single product and six-pack). How is this shown in Product Availability?

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.


I sell both finished goods and components. If the components are in stock, is the finished good shown as available?

Yes, finished good availability will be estimated per the amount of its components in stock. Only assembled finished goods will appear as On Hand, however Available will estimate both assembled finished goods and finished goods which could be assembled from in stock components. NOTE: The finished good will not show as available, even with components in stock, if it does not have any movements or transactions associated with it. 


Is it possible to see the total quantity of a serial tracked item, rather than seeing individual serial numbers? 

If the costing method is selected as Serial/Batch, the products will be shown the availability according to the unique Serial/Batch number. You can hide the Serial/Batch and Expiry Date columns to view total SKU availability. 


I am wondering if there is a better way to view these when using bins? We have stock in various locations within consignment, so use bins. But because the sale order only lets me select consignment location (not the bin) when I look at stock availability sometimes there are multiples and it's confusing and not strictly accurate. Is there a better way to lay this out?

You can add the Bin heading to the product availability layout by using the Settings icon in the corner of the page as shown in the image below.


We did several 'New Stocktake' additions on April 30. They have been completed. When we go to the 'Availability' most of the items that we entered quantity for show a zero quantity.

This can happen because products have been zero-d out during stocktake. You can void this stocktake to put back the Qty back to inventory. Also, keep in mind when doing a stocktake, if no changes on the available Qty it should be entered in the Stocktake Quantity again so that it will not 0 out the items. If it is not possible to void the stocktake, perform a stock adjustment to put back the correct quantity. 



Can we get the date of the purchase order for on order stock to show on the product availability screen?

To see purchase order date by purchase order you can use the Purchase Order Details Report. Purchase order date is not currently an available feature on the Product Availability screen, but this can be requested as a feature on our forum and considered for future development releases. 


Is it possible to see the total quantity of a serial tracked item, rather than seeing individual serial numbers? 

If the costing method is selected as Serial/Batch, the products will be shown the availability according to the unique Serial/Batch number. You can hide the Serial/Batch and Expiry Date columns to view total SKU availability. 


How can I see the value of inventory at a certain date?

Try the Inventory Summary Report, which shows Stock on Hand for the end of the reporting period. 


Why is the number of available products different between Availability and Stock Transfer?

Products with an authorised sale order will no longer be marked as available on the Product Availability report, however, are still available to be transferred between warehouses using Stock Transfer. When Pick is authorised, the product will no longer be available for Stock Transfer.



Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

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