Lot Expiry Report

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.

Prerequisites

Managing Cin7 Core Reports

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

Input:

Lot expires on	Allow user to select a date. Lots expiring before this date will be shown.
Layout	Set to the Default layout. Allows selection of saved layouts, if any.
Save Layout As	Allows saving of a layout for potential future use.
Reset Layout	Resets 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 Cin7 Core Reports - Filtering Reports for more detailed information about using filters.

Output:

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
SKU	Product SKU.
Product	The name of the product.
Location	Location name.
Bin	Bin where stock is located within Location.
Batch #	Batch or Serial number to expire.
Expiry Date	Batch expiry date.
Tags	Comma-separated product tags.
Category	Product category.
Brand	Product brand.
Family	Product family name.
Unit	Product unit of measure.
Year	Year of expiry date.
Quarter	Quarter of expiry date.
Month	Month of expiry date.
Product Additional Attribute 1-10	Values of product additional attributes.
Data Headers
Quantity On Hand	Current quantity on hand on the batch.

FAQs

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. 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 Cin7 Core support.

Lot Expiry Report

Prerequisites

Input:

Output:

FAQs

Was this article helpful?