Supplier order based on sales (en) » History » Revision 2
Revision 1 (Remina Neagu, 2021-12-06 16:11) → Revision 2/4 (Remina Neagu, 2021-12-06 16:13)
h1. Supplier order based on sales (en) *Inventar Inventar → Supplier orders based on sales → Generate new supplier order* 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* Algorithm 1.Select Select supplier products that were ordered between the selected dates. 2.Filter 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 Quantity for order = avg * days - available stock + minimum stock* stock → Add fluctuation.