This report shows how long products stay in stock by time intervals.



Input:

Following are input for this report



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:

Following are the output fields of the report



SKU

 Product SKU.

Product

 The name of the product.

Batch #

 Batch or Serial Number.

Expiry Date

 Expiry Date of the batch.

0-30 Days

 Quantity purchased 30 or less days ago.

30-60 Days

 Quantity purchased less than 60 days ago but more than 30 days ago.

60-90 Days

 Quantity purchased less than 90 days ago but more than 60 days ago.

90-120 Days

 Quantity purchased less than 120 days ago but more than 90 days ago.

120-150 Days

 Quantity purchased less than 150 days ago but more than 120 days ago.

150-180 Days

 Quantity purchased less than 180 days ago but more than 150 days ago.

Above 180 Days

 Quantity purchased more than 180 days ago.

Tags

 Comma-separated product tags.

Category

 Product category.

Brand

 Product brand.

Family

 Product family name.

Location

 Location name.

Bin

 Bin where stock is located within Location.

Unit

 Product unit of measure.

Product Additional Attribute 1-10

 Values of product additional attributes.