Public

h1. Supplier order based on sales (en)

Inventar → Supplier orders based on sales → Generate new supplier order

Select supplier (mandatory).

Select categories and manufactures for supplier products (can be empty). You can set for each estimated fluctuation.

Select excluded product status from order (Offline).

Add general fluctuation for order (max  fluctuation is used for the product if it is set for product categories or for manufacturer)

Select date interval for sales analysis

Select days for order.

Algorithm 

Select supplier products that were ordered between the selected dates.

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.