Ratnesh Upadhyay created OFBIZ-10974:
----------------------------------------
Summary: 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
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)
