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* 

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.