Supplier order based on sales (en) » History » Revision 3
Revision 2 (Remina Neagu, 2021-12-06 16:13) → Revision 3/4 (Remina Neagu, 2021-12-06 16:14)
h1. Supplier order based on sales (en) *Inventar → Supplier orders based on sales → Generate new supplier order* 1. # Select supplier (mandatory). 2. # Select categories and manufactures for supplier products (can be empty). You can set for each estimated fluctuation. 3. # Select excluded product status from order (Offline). 4. # Add general fluctuation for order (max fluctuation is used for the product if it is set for product categories or for manufacturer) 5. # Select date interval for sales analysis 6. # Select days for order. *Algorithm* 1.Select supplier products that were ordered between the selected dates. 2.Filter products by categories and manufacturers (if they are set). For each products: → Calculate average ordered quantity / day (avg) i) Find days when product was in stock. ii) For each days calculate ordered product quantity from shop and from external orders. → Calculate available stock (product stock in warehouse - reserved stock). → Add quantity from another supplier orders to available stock. *Quantity for order = avg * days - available stock + minimum stock* → Add fluctuation.