This report shows all product batches with their expiry dates. Use this report to check how much quantity on hand you have of different product batch numbers and when they will expire.


Table of Contents

Data from this report can be exported in Excel, PDF or RTF format. 


Lot expires onAllow user to select a date. Lots expiring before this date will be shown. 
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets layout to the default layout or selected saved layout.

Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 


The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report. 

Data Headers
SKUProduct SKU.
ProductThe name of the product.
LocationLocation name.
BinBin where stock is located within Location.
Batch #Batch or Serial number to expire.
Expiry DateBatch expiry date.
TagsComma-separated product tags.
CategoryProduct category.
BrandProduct brand.
FamilyProduct family name.
UnitProduct unit of measure.
YearYear of expiry date.
QuarterQuarter of expiry date.
MonthMonth of expiry date.
Product Additional Attribute 1-10Values of product additional attributes.
Data Headers
Quantity On Hand
Current quantity on hand on the batch.


[back to top]

In the Lot Expiry report, the item ZMA17733 shows with available quantity on 3 locations although I have made credit note for all locations. When I go to Product availability, I can see that the products show in the On hand and Available column. 

This can happen when the unstock quantity is less than the Stock received quantity, therefore stock is still available from these orders. This can be corrected by performing an Inventory Write Off

Can I add cost of goods to the report to show value of the stock about to expire?

The Lot Expiry report currently shows the stock on hand quantity only and there is no option to add the cost. This can be added as a feature request to our forum so other users can vote on it, depending on the popularity we might consider it on our upcoming releases. As a workaround, you may utilise the Inventory Movement Details Report to combine to this report to include the Cost in for a certain batch/serial number using VLOOKUP.

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.