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.