Supplier order based on sales (en) » History » Revision 2
« Previous |
Revision 2/4
(diff)
| Next »
Remina Neagu, 2021-12-06 16:13
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.
Updated by Remina Neagu over 3 years ago · 2 revisions