This report shows all product batches due to expire on specified date.
Input:
Following are input for this report
Lot expire before |
Allow user to select a date i.e. Expiry date |
Update |
Update button which refresh report results |
Apply Filter |
This button show option to set filter on fields used in report |
Export |
This button will allow user to export report data in Excel, PDF or RTF format |
Output:
After setting inputs described above, when you press update button, report will refresh as per inputs, there are following output field available for this report
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. |
Quantity On Hand |
Current quantity on hand on the batch. |
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. |