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.
Prerequisite:
Table of Contents
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 DEAR 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. 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.