Inventory
      Back to home
      1. Help Center
      2. General Documentation
      3. Inventory

      Inventory Reorder List Report

      The Inventory Reorder list within FreshByte is a feature that enables the user to quickly determine items and quantities that need to be reordered.

      Overview

      The Inventory Reorder list Report provides users a tool to quickly determine Inventory or supply items need to be reordered/purchased.  The report has extensive filtering options to provide each user the ability to customize the report criteria to easily identify user specific needs.
      The Quantity to order is calculated based on the criteria set by the user. The report can include Open POs, Packouts, and Sales Orders to allow the user to determine reordering needs.
      If the user selects Open Orders, the Quantity to Order is calculated as follows:
      Quantity on Hand – Open Sales Orders + Quantity on Purchase Orders = Total Available
      If the Total Available is below the Minimum Quantity set within Item Master, the Order Quantity will calculate based on the quantity needed to bring the Total Available Quantity up to the Required Quantity set in the Item Master.

      Required Set Up in Item Master

      The user must enter the minimum and maximum quantities in the Item Master for the Order Quantity to calculate properly.


      Inventory -> Item Master -> Misc.2 tab


      Enter the preferred quantities within each field as displayed below.

      Inv Reorder List 1

       Navigate to the Report 

       Inventory -> Inventory Reports -> Inventory Reorder List  

      Inv Reorder 2

      The Inventory Reorder List can also be accessed from the Purchases and Sales Reports Menus. Optional navigation steps are displayed below:

      Purchases -> Reports -> Inventory Reorder List

      Sales -> Reports (A-O) -> Inventory Reorder List

      Inv Re 3

      Selection Criteria

      There are a multitude options for the Inventory Reorder Report. Below is a detailed list of filter options:

      • Warehouse
      • Buyer
      • Vendors (and Priority One Vendors)
        • Items by their Priority One Vendors
        • Vendor Standard Items
        • All Vendor Specification items
        • Items by their Priority One Vendors – by Vendor Groups
        • Vendor Standard Items – by Vendor Groups
        • All Vendor Specification Items – by Vendor Groups
        • Vendor Currency/Country
      •  Item Selection Type  
        • Select Items
        • Item Types
        • Item Categories
        • Item Groups
      • Customer Selection Type
        • Customers
        • Corporations
        • Customer Groups
      • Print Options
        • All Items
        • Short/Over items Only – Total Available
        • Short Items – Items with Zero On-Hand Quantity
      • Grouping Options
        • No Grouping
        • Item Type
        • Priority One Vendor Name
        • Buyer, Priority One Vendor Name
        • Buyer, Item Category, Item Type
      • Order By Options
        • Item Code
        • Item Description

      In addition to the above filter options, the report can be limited to a specific date range for open Sales Orders and open Purchase Orders. This feature allows the user to include POs in transit. By selecting the option ‘Consider time in Sales Orders and Purchase Orders’, the user can include dates “UP TO” a specific date or only consider the “EXACT” date selected.

      Before calculating the report, the user may also select how the Average Inventory Movement will be displayed by filtering the following:

      • Do not Calculate Average Inventory Movement
      • Calculate Average Weekly Inventory Movement
        • Enter the From and To dates for the time period to be calculated
      • Calculate Average Daily Inventory Movement
        • Select the time-period to be calculated
      • Average calculations have two options:
        • Mathematical Average Calculation: This option uses the number of weeks or days in the selected time period and divides the total movement quantity to calculate the Weekly (or Daily) average.
        • Statistical Average Calculation – determines the number of weeks or days that the item was sold during the selected time period and then divides the total quantities by that calculation to get the Weekly (or Daily) average.

        Example:

        There are 26 weeks in the selected time-period, and the total movement quantity of the item, during that time-period, is 100. However, there were only 2 weeks during the 26 weeks that the item had any movement.

         The Mathematical Average Calculation -   100 / 26 = 3.85 

        Inv Re 4

        Inv Re 5

        The Statistical Average Calculation - 100 / 2 = 50

        Inv Re 6

        Inv Re 7

        Preview / Print / Export Options

         The user has three options to view this report: 

        • Preview on Screen
        • Print to Printer
        • Excel

          • Weekly (or Daily) Average – This is the average calculation as calculated and described above.
          • Quantity on Hand – The current on-hand quantity for the selected warehouse(s).
          • Open Sales – Includes the open Sales Orders up to the date entered. If the “Include Items used in Packouts” option is checked, open packout quantities will be included in the amount.
          • Quantity on Order – The Open Purchase Orders up to the date entered.
          • Total Available – The calculation of Quantity on Hand – Open Sales + Quantity on Order.
          • Minimum Quantity & Required Quantity – Based on the quantities as set up on the Item Master.
          • Order Quantity – The calculation of Required Quantity – Total Quantity.
        • Export to Excel. Some of the selections listed contain many fields. The user must export to Excel to view all details selected.