Stock taking is used to ensure that stock levels in Brightpearl are an accurate representation of what items are physically available in the warehouse.
Brightpearl provides all the information required for performing a stock take and all the filters needed to carry out a rolling stock take.
Getting a stock take list
To perform a stock take the following information will need to be extracted from Brightpearl for each SKU:
- The quantity in stock at the relevant warehouse and warehouse location
- Products not currently in stock at that warehouse, but which are handled at that warehouse
The product list can be used to get a list of products and the current in stock value at a particular warehouse. Once the report is filtered by the warehouse the default location of each item will also be displayed and exported. If stock for the same SKU may be stored in multiple locations (multiple concurrent location management) and you wish to include this level of detail the inventory detail report can be used instead. Since the inventory detail report only shows currently in-stock products, any out of stock items will need to be taken from the product list.
Where some products are only handled at specific warehouses, items which appear out of stock since they have a zero stock level may need to be ignored on the stock take. It may be possible to filter these products out from the stock taking list if default locations are configured for everything else - items with no default location will display as 0.0.0.0. If desired, a location reference can be created specifically for the purpose of flagging a product as not stocked at a warehouse. Alternatively custom fields can be used to flag items in a way which allows them to be filtered effectively.
Do I have to stop work during a stock take?
Once the product list of current in stock inventory has been exported you should aim not do anything which may affect this figure, such as:
- Receiving items on purchase orders
- Shipping goods-out notes
- Anything which does not directly affect the "in stock" figure can still be worked on, such as:
- Allocating inventory to orders
- Fulfilling orders to goods-out notes
- Printing goods-out notes
- Picking items ready for packing - but remember that picking inventory will remove it from its usual location which may make counting them more difficult.