[jira] [Commented] (OFBIZ-10974) Stock Watch List Report

["Pierre Smits (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OFBIZ-10974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16827541#comment-16827541 ] 

Pierre Smits commented on OFBIZ-10974:
--------------------------------------

Hi [~swash78],

I feel confident that this new feature would  enhance the appeal of OFBiz. However, this can be a quite complex improvement. We're not only a complex filtering matrix (based on info provided in the description, but may also filtering on date? or facility?) Would this not involve quite heavy aggregations (calculations) on the server each time a request is submitted to the server?


Also,I am wondering whether this should be a feature in the facility app (based on transactional data solely and native OFBiz code) or whether it would better be suited in the BI/Birt plugin, with
 * a daily scheduled service (in off-business hours) that aggregates the inventory movements of the previous day;
 * a portal page with the search and find screen widgets (with maybe even a chart?), that enables adopters to decide dynamically where they want to have the page shown: in either the order, sfa or product component...

> Stock Watch List Report
> -----------------------
>
>                 Key: OFBIZ-10974
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-10974
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: product
>    Affects Versions: Trunk
>            Reporter: Ratnesh Upadhyay
>            Priority: Major
>
> Add the Stock Watch List report to track the availability of items and assortment. So that sales manager can keep a watch on current stock and sales performance of all the product lines and can get their current inventory status like Available, Low, Out of Stock and when the inbound shipment is planned to receive. This information can help merchandiser to analyse differentiation in fast moving and slow moving items.      
> Report should have following filters : 
>  * User should be able to filter the report by availability status like Available, Highly Available, Low, Out of Stock items.
>  * User should be able filter the products by category.
>  * User should be able to choose all or any of these filters to generate the report.
> Report Matrix should be-
> lets say we have to product X in category Y in system that have multiple variants like product-X has following size variants XS, S, M, L, XL in RED colour.. And it also have same size variants in BLUE colour..then resultant report should be like this..
> ||Product Name||XXS||XS||S||M||L||XL||
> ||Product-X (RED)||A||A+||L
> <incoming shipment Date>||O||A||A||
> ||Product-X (BLUE)||L||A||A+||A||O||L
> <incoming shipment Date>||
>  
> Availability Codes: 
> *(A) - Available*  _i.e_. product has more number of quantity then safety stock.
> *(A+) - Highly Available* _i.e_ product has more number of quantities than max limit. 
> *(L) - Low* _i.e._ product has less quantity than safety stock.
> *(O) - Out of Stock*  _i.e_ product is not in stock.
>  
> Tagging [~swash78]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)