Automatic Order - Schedule Regular Supplier Orders using Stock Reorder

Automatic Order - Schedule Regular Supplier Orders using Stock Reorder

New to Retailer 3.4.2 , you can setup specific suppliers to automatically create supplier orders for products using the Stock Reorder-desired levels process (also known as min max quantities), or forecasting the order quantities based on sales records.

When Automatic Ordering is enabled, and properly setup, Retailer will generate supplier orders for the relevant products at the frequency that is specified, ready to be sent out.
The supplier stock items must first be setup with reorder quantities, if not using the Forecast method. The Forecast method uses sales data.
Info
For more information on how to setup Reorder Quantities, click HERE. Only the setup is required, and the Reorder Report section is not applicable here.

Setup Automatic Order

  1. From the main screen of Retailer, click on the Stock button, or Stock Maintenance in the top menu.
  2. Click on Suppliers and Departments, and then the AutoOrder tab.
  3. The screen should be prefilled with all the suppliers currently in the system, with their names in the Supply column.
  4. In the 'Schedule Type', choose the appropriate frequency from the following:
    1. Daily = Generates supplier order every day, every 24 hours from the first time an order is created this way.
    2. Weekly = Generates supplier order every week from the first time an order is created this way.
    3. Fortnightly = Generates supplier order every 2 weeks from the first time an order is created this way.
    4. Monthly = Generates supplier order every month, about every 30 days from the first time an order is created this way.
    5. Yearly = Generates supplier order every year, on the same date as the first time an order is create this way.

  5. In the 'Order Type', choose the type of supplier order to create:
    1. New = This will create a new Pending supplier order each time
    2. Add to Existing = This will add the ordered items to an Existing Pending supplier order, if one exists. Otherwise, a new Pending supplier order is created.

  6. In 'Qty Derived From', choose a method of calculating reorder quantities:
    1. Reorder Qty =Generates reorder quantity based on desired levels only, ignoring any other supplier orders
    2. Reorder Qty - Pending = Generates reorder quantity based on desired levels, and subtracting quantities already on Pending supplier orders
    3. Reorder Qty - Sent = Generates reorder quantity based on desired levels, and subtracting quantities already on Sent supplier orders
    4. Reorder Qty - Pending/Sent = Generates reorder quantity based on desired levels, and subtracting quantities already on Pending and Sent supplier orders
    5. Forecast = Generates reorder quantity based on sales record for the item, and what is estimated to be needed
  7. In 'Next Run', you can click to select the date that the system next creates a supplier order. The schedule will then create subsequent automatic orders from this date. The time cannot be selected and will be automatically set by the system to a valid future time.
    IdeaThe first order will generate about an hour from when the Auto Order is first activated. You can change the date and set it to today, to see an order created within an hour. This will reset the automatic schedule and continue subsequent orders from today.
  8. In 'Active', tick the box to enable automatic ordering for that supplier, using the settings currently in the grid.
  9. (Only used for Forecast ordering) In 'Forecast Week', enter the number of weeks to forecast for.
    E.g. Forecast Week 1 will predict the order quantities for the next 1 week from now.
  10. (Only used for Forecast ordering) In 'Forecast Weeks Period', enter the number of weeks to look back at sales.
    E.g. Forecast Weeks Period 2 will look back at the last two weeks of sales, to calculate forecast numbers.
  11. Click the Green tick in the bottom left, just under the grid, to save all current settings. The Next Run column will indicate when the supplier orders will be next created.
The supplier orders will be automatically created/added after this, and a notification will appear in the Notification button (speech bubble) at the top of the main Retailer screen, and the POS screen.
The notification can be clicked on to open the supplier order in the Orders Maintenance screen.

Troubleshooting Automatic Supplier Orders

If your Automatic Supplier Orders are not generating:
  1. If 'Qty Derived From' is set to a Reorder Qty type, make sure the 'Desired Quantity to have on hand' and 'Reorder this item when its stock level gets down to' settings are both set in the Stock Screen → Reorder tab. See Set Up Desired Quantities for Stock Items
  2. If 'Qty Derived From' is set to Forecast type, make sure the item has sold in the previous number of weeks set in 'Forecast Weeks Period'
  3. Check the Tower Events service is running by following the steps below
  4. Contact Tower Support to investigate

Check Tower Events Service

  1. On the Main/Server computer, double click the 'RetailerV3 Backup' icon (Blue R)
  2. On the left hand side, Click on Settings (1)Database Settings (2)
  3. At the top of the page, 'This is the Server' (3) should be ticked. If it is not ticked, you are not on the Main computer. Try a different computer.
  4. On the left hand side, click 'Services' (4)
  5. In the list of Services look for 'TowerEvents'
  6. Check the Status column. The status should read 'Service Running'
  7. If not, click the 'Start' button next to 'TowerEvents'
    • Related Articles

    • Orders Report (Orders Maintenance)

      The Orders Maintenance screen is where supplier orders are usually managed, and there is a report that can be run on the orders in the system. This report will display details of each supplier order, and details of the stock on the orders. Generating ...
    • Stock History - Orders Maintenance

      When creating a supplier order, you can select an item and look up its sales history. If you need information on how to create and send a supplier order in Orders Maintenance, start by clicking HERE . Click on the item in the grid, and click Stock ...
    • Emailing Orders To Suppliers

      Retailer allows you to send your orders to suppliers by e-mail, eliminating the need to print them out. Configure E-mail Server Settings Before you can send e-mails to suppliers, e-mail server settings need to be configured in Retailer. For more ...
    • Importing a Spirit Publishing Stock File

      This is the advice for importing a Spirit Publishing stock file. The stock file is embedded in this article. Do not try this with another stock file. The stock file included with this article has been tested. We know it works. If you have products ...
    • Importing a Henderson Greetings Stock File

      This is the advice for importing the attached Henderson Greetings stock file. Do not try this with another stock file. The stock file included with this article has been tested. We know it works. If you have products from this supplier that are not ...