ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pierre Smits (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-10974) Stock Watch List Report
Date Sat, 27 Apr 2019 10:06:00 GMT

    [ 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,
 * 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

View raw message