Low stock reorder
This function allows streamlined reordering of stock that is running low, ensuring no sales are lost due to an item being out of stock. Stock Reorder parameters can be set globally for each product or independently for each location of your organisation.
Users will need the Purchase - Stock Reorder permission in order to access the low stock reorder feature. See Introduction to users, Manage roles, and User permissions explained for how to set user permissions.
For more advanced control of stock levels which takes into account lead times from suppliers and sales demand, see Generate reorder suggestions.
Prerequisites
Set up Products (required)
Set up Suppliers (recommended)
Set up Locations (recommended)
Familiarity with Processing a Purchase (recommended)
Low stock reorder user permissions
Cin7 Core offers fine-grained control over user permissions by going to Settings → Users and Roles. See Introduction to users and Manage rolesand User permissions explained for help setting user permissions.
Users will need the Inventory → Products & Families permission to set up low stock reorder points. Users will need the Purchases → Reorder stock permission to view this module and create purchase orders for reorder items.
Setting Up Low Stock Reorder Points
For stock to be presented for reorder automatically, the low stock reorder points must be set up for each inventory item you wish to reorder. Low stock reorder points can be set up for total product numbers and also for the amount of product in each location.
To set up low stock reorder points:
Navigate to Inventory → Products.
Select the relevant product.
Enter a Minimum Before Reorder quantity and the Reorder Quantity.This sets up the low stock reorder point for total numbers of the product across your inventory.
Go to the Suppliers tab and click + or Add more items to add a supplier from the dropdown list for this product. You can choose as many suppliers as you wish for each product. At least one supplier must be added to the product for the low stock reorder function to work.
Click Save.
To set up low stock reorder points for a location:
Navigate to Inventory → Products.
Select the relevant product.
Go to the Reorder levels tab.
Click +Location.
Enter the Location, Minimum Before Reorder and Reorder Quantity.
Click Save.
Important! If you have multiple locations, the total reorder quantity will depend on the Minimum Before Reorder specified for system setting, which can be found under the Purchase Process Customisation section in Settings → General Settings, as shown in the screenshot below.
Turn on/off low stock reorder for a location
You can quickly turn on/off low stock reorder points for a location once they have been set up. To do this, go to Settings → Reference Books → Stock → Locations and Bins. On the Locations tab, select a location.
Check/uncheck the Allow to Reorder Stock Level box for that location.
Low Stock Reorder
A product will now be automatically shown in the Reorder Stock module once the quantity reaches the Minimum Before Reorder quantity.
To reorder stock:
Navigate to Purchase → Reorder.
Select a Supplier. This displays a list of available products for reorder. Alternatively, click Select All to select all products needing reorder.
Click the Products filter button to open up the filter window.
-
Products can be filtered by product family, tag, category, brand OR filtered to show a single product.
The condition for filter groups work is AND. This means that values selected in the filters are applied as AND. Inside the group the condition is OR
For example, if the filters Product Family: Long-sleeved Shirts, T-shirts, Tag: New, and Category: Menswear are selected, Products belonging to the long-sleeved shirts family AND t-shirts family with tag: new and category: menswear will be shown.
Select one or more products by checking the box next to it.
Click Reorder.
A new purchase order will be generated automatically for the reordered stock. Follow the link to go to the Purchase order. Check the purchase order to see if the details are all correct.
Authorize the order to be printed or emailed to the supplier to be fulfilled.
View product stock levels
The reports module has several reports which allow you to compare available stock, on order stock and minimum before reorder levels. Go to Reports → Inventory to view these reports.
Products Stock Level: Shows the current stock level of all active products in all locations. Use this report to see available, on-hand, allocated, on-order, reordered and minimum before reorder quantities. You can also check the stock on hand value and unit cost of products on the current date.
Products Reordering: Shows stock level details necessary for stock refill. Use this report so see available, on order, reorder and minimum before reorder quantities as well as purchase price for all active products.
Products Low on Stock Shows stock level details necessary for stock refill. Use this report so see available, on order, reorder and minimum before reorder quantities as well as purchase price for active products with stock levels below the minimum before reorder quantity.