Dramatically increase the accuracy and speed of reordering by reviewing historic demand, and future commitments.
- Review historic demand, and future commitments
- Select or modify the suggested reorder quantity for some or all products
- Works with existing Min/Max and economic order quantity settings
- Filter to reorder for a single supplier (e.g. ensure the container's always full)
- Try what-if scenarios and save the results to work on later
- Get funky and create “Reorder Strategies” that include complex calculations (e.g. to predict seasonal variations)
- Choose to restock one location from surplus stock at another location (requires the 010026 Inventory Location Transfers App)
- Number of Months Cover – type in the number of months of stock you want to have on hand at any time. This is used to determine what the suggested reorder quantity should be.
- Number of Months Demand History to Display – type in the number of months of demand history you want to display in the reorder workbench.
- Number of Months to Calculate Demand History – type in the number of months historical demand you want to use for calculating the Average Sales. This is only use if the Reorder method is set to Average Sales.
- Show Weight and Volume Information – tick this box to have weight and volume displayed in the reorder workbench. This will show both unit values and extended value – multiplied by
- Reorder Quantity.
Default Reorder Quantity
- The workbench has columns for both Suggested Reorder and Reorder Quantity – the Reorder Quantity is what will be used on any generated purchase orders.
- Choose whether the Reorder Quantity should default to Suggested (system recommendation based on calculations and criteria specified), Suggested (Rounded to Economic Order Qty) or Zero – in which case the user will have to type a quantity next to all items they are wanting to order.
Default Reorder Method
- The workbench will default to the selected method which is used to calculate the Suggested Reorder Quantity.
- Average Sales – This method uses the “Number of Months Cover” and “Number of Months to Calculate Demand History” parameters to suggest reorder quantities.
- Min/Max – This method uses Minimum and Maximum stock quantities per location setup on each stock item. A reorder quantity will be suggested for all items to bring them up to their Maximum.
- Required Only – The workbench will only suggest a reorder for items that have negative available.
- Include stock items with no suggested reorder – In the workbench if you select by analysis code, ticking this option will result in all stock items for that analysis code being displayed even if you have plenty of stock.
- Include Indent Stock Items - Indent items will be included in the workbench if they match other selection criteria. If Indent items are always linked to a Sales Order you would not want to include in the Reorder Workbench.
- Include Forward Orders – If selected then forward orders will be included in the demand calculation.
- Include Hold and Do not commit in Backorder – If selected then the calculation of demand will include any quantities on forward order even if the stock is not committed.
- Include Backorders – If selected the calculation of demand will include all backorders – this is recommended.
- Default All Locations – If selected the workbench will default to calculating the reorder across all locations. If each location is responsible for their own reordering then do not select this option.
- Show UDFs – If selected then the table in the reorder workbench will include a column for all user defined fields specified against stock items.
- Default PO Details Location to users default – if ticked the reorder workbench will default in the Default Location from the Purchase Order button and Defaults tab of User Maintenance specified for the user running the workbench.
1 Review Hide Reviews Show Reviews
This app was revolutionary for our business. We now have much tighter control over our reordering, and our sales have increased because of better stock management.