The Reorder Report is a key tool in Brahmin Solutions that provides a comprehensive view of your product inventory, including availability and associated default suppliers. This report is specifically designed to help you identify products with low stock levels, enabling timely replenishment to maintain optimal inventory.
Key Features of the Reorder Report:
Visibility of Product Availability: The report lists all your products, displaying current stock levels to ensure you have up-to-date information on your inventory.
Default Supplier Information: Each product entry includes the default supplier, making it easier to manage orders and relationships with your vendors.
Identification of Low Stock Items: You can quickly see which products are running low, allowing you to prioritize restocking efforts.
Detailed Stock Information: For each product, the report shows the current quantity on hand, quantities allocated for sales or manufacturing, and quantities already on order.
Automated Reorder Recommendations: Based on the available amount, which is calculated from the current stock, allocated, and ordered quantities, the report suggests reorder amounts to ensure you are never out of stock.
The Reorder Report is designed to be one of the most powerful tools in the Brahmin Solutions suite. It offers critical insights into your inventory management processes and facilitates efficient stock replenishment.
Step 1: Access the Reorder Report
To view the Reorder Report:
Navigate to the "Purchases" section in the main menu.
Select "Reorder Report" from the dropdown options.
Step 2: Utilizing the Reorder Report
Understanding Filters:
The Reorder Report offers a range of filters to help you refine the data according to your specific needs. Each filter is designed to provide targeted insights, making it easier to manage your inventory effectively.
Warehouse: This filter initially automatically displays the default warehouse. However, you can select other warehouses to view their specific inventory levels.
Vendor: Use this filter to view products associated with a specific vendor.
SKU: This allows you to search and view data based on the SKU of the items.
Product: Filter the report by item names to find specific products quickly.
Primary Vendor: This filter isolates the products supplied by vendors marked as primary vendors.
Non-Primary Vendor: Use this to view products from vendors that are not marked as primary.
These filters ensure that you can customize the display of your inventory data, focusing on what's most crucial for your stock management and replenishment needs.
Column Descriptions
Warehouse: Identifies the specific warehouse by name.
Product: Shows the name of the product.
SKU (Stock Keeping Unit): Lists the unique identifier for the specific product.
Vendor: Names the supplier or vendor of the product.
Expected Date: Indicates the anticipated date of receiving the product based on the vendor’s lead time.
Reorder Qty: Calculates the total number of items needed to refill stock to the maximum level after dropping below the minimum. This is determined by the formula: Maximum Stock - Available Stock - Stock On Order - Stock On Assembly.
Min (Minimum Stock Alert Level): The threshold value that triggers a stock replenishment alert.
Max (Maximum Stock Level): The upper limit of stock to be maintained in the warehouse.
On Hand: The quantity of product currently available in the warehouse.
Allocated: The amount of inventory reserved for fulfilling existing sales and manufacturing orders.
Available: The quantity of product available for sale, calculated as On Hand - Allocated.
Step 3: Filtering, Running Reports, and Reordering Stock
Apply Filters and Run Report:
Set your desired filters according to the parameters you need.
Execute the report to review your current stock levels.
Select Stock for Reordering:
Identify and select the stock items that need to be reordered due to low quantities.
Generate Purchase Order (PO):
Click on "Generate PO" to initiate the creation of a purchase order.
Brahmin Solutions automatically consolidates low-stock items from the same vendors into a single purchase order, streamlining the procurement process.