We’re excited to announce that the latest information is now available on our new site, the Ginesys One Wiki!. Visit the site for up-to-date resources and insights. We look forward to continuing to support you there!
We’re excited to announce that the latest information is now available on our new site, the Ginesys One Wiki!. Visit the site for up-to-date resources and insights. We look forward to continuing to support you there!
#Stock Validity (Expiry) Ageing Analysis#
- Aparajita Basu Roy
Report Name | #Stock Validity (Expiry) Ageing Analysis# | ||
|---|---|---|---|
Report Location | Inventory\Status\Stock Expiry | ||
Report Type | Register | ||
Report Description | "This Report will display expiry analisys of stock. This Report will consider items which is expiry managed only and Stock details would be showing based on report run time. Note : Performance will impact for large data volume." | ||
Report Objective | The objective of this report is to see Item stock age for Expiry managed item only based on selection of parameter while running the report. It will help user to manage or plan for Expired and Near Expired Items. | ||
Target Audience | Inventory Manager, Operation Manager, Warehouse Manager | ||
Selections | Name | Selection type | Objective |
Show Expired : | Single | User can select as True, if user wants to see Expired Item Stock. Else user can select as False | |
Near Expiry Slab 1 (In Days) : | Single | User need to select Near Expiry Days to see Ageing based on 0 to Slab 1 | |
Near Expiry Slab 2 (In Days) : | Single | User need to select Near Expiry Days to see Ageing based on Slab 1 to Slab 2 | |
Near Expiry Slab 3 (In Days) : | Single | User need to select Near Expiry Days to see Ageing based on Slab 2 to Slab 3 | |
Near Expiry Slab 4 (In Days) : | Single | User need to select Near Expiry Days to see Ageing based on Slab 3 to Slab 4 | |
Show Barcode : | Single | If user select ‘Yes’ then it will show Barcode in the report | |
Show Category 1 : | Single | If user select ‘Yes’ then it will show Category 1 in the report | |
Show Category 2 : | Single | If user select ‘Yes’ then it will show Category 2 in the report | |
Show Category 3 : | Single | If user select ‘Yes’ then it will show Category 3 in the report | |
Show Category 4 : | Single | If user select ‘Yes’ then it will show Category 4 in the report | |
Show Category 5 : | Single | If user select ‘Yes’ then it will show Category 5 in the report | |
Show Category 6 : | Single | If user select ‘Yes’ then it will show Category 6 in the report | |
Report Level : | Single | User can select Report Level based on the following selections: A). Batch | |
Owner Site.SHORT_CODE : | Multiple | User can select, selected Site Name from this filter option | |
Stock Point (LOCNAME) | Multiple | User can select, selected Stock Point Name from this filter option | |
Item.Division : | Multiple | User can select, selected Division from this filter option | |
Item.Section : | Multiple | User can select, selected Section from this filter option | |
Item.Department : | Multiple | User can select, selected Department from this filter option | |
Item.Barcode : | Multiple | User can select, selected barcode from this filter option | |
BATCH_SERIAL_NO : | Multiple | User can select, selected Batch/Serial No from this filter option | |
Dependencies | NA | ||
Alternative reports to validate | NA | ||
Sample Output | 
| ||