The inventory detail report is located under Products > Inventory detail.
This report shows you your current inventory levels, across all warehouses, broken down by products and batches, along with their unit, landed and total cost prices and their locations.
When inventory is received into the system, the collection of individual units received at the same time is called a batch.
For example, say you have a purchase order containing 12 units of Product A, 12 units of Product B and 12 units of Product C.
If you then receive in 4 units of Product A and 3 units of product B in one go, those 7 units comprise a batch.
On the inventory detail report, inventory is displayed by batch.
This means one product may appear several times on the inventory detail report, once per batch which still contains in stock items.
Deleting a batch
If all of the items in a batch are still on hand, you will see a red 'X' appear next to the batch items in the inventory detail report:
Clicking the X will bring up a modal window asking if you want to proceed with deleting a batch. Clicking OK will remove all of the stock received in on that batch.
This is useful if a purchase order has been received accidentally - instead of having to unreceive stock line by line, the whole batch can be deleted in one click.
Amending the price of a batch
You can edit the price of a batch once it's been received by hovering over the batch and clicking the pencil next to the 'Price' column:
This will open a modal window asking what the new price should be, which account to post the correction to and a reason for the change:
Going through this process removes the inventory at the old price and re-enters it at the new price.
Reading the report
Every row on the inventory detail report corresponds to
- in stock units of a product...
- ... received at the same time...
- ... into the same location...
- ... for the same price.
The report lists the following:
- the date the batch was received
- the location of the inventory
- the the product's inventory levels
- the unit cost, landed cost (if using landed costs) and total cost
The figure at the bottom of the report is the sum of the values of the items displayed on screen - to get the total value of all inventory, you will need to ensure all products are displayed on screen, or export the report.
Filtering the report
There are a number of different filters on the inventory detail report which can be used to identify particular products, view historical data, or toggle which warehouses to report on.
Finding specific products
The Inventory detail report can be filtered by the following product attributes to enable you to look up a subset of products:
- Product ID
- Product type
It is also possible to filter by warehouse, to view the value of inventory in one specific warehouse, or even by aisle, bay, shelf or bin to view the inventory in a specific location in that warehouse.
You can also filter by the purchase order number, to view inventory brought in on a single purchase order, in the "PO Ref" field.
Tip: You can use the PO Ref field to search for items received in on sales credits too!
Filtering by date
The inventory detail report will show items which are in stock at the time it is viewed. However, you can filter the report to a historic date to view the quantities and values of items in stock on that date (up to the end of that day).
Note: The quantities displayed will be the in stock quantities. It is not possible to view historical allocations.
Inventory in transit
If you have any inventory that is currently ‘in transit’ (for example, any quarantined inventory), then it’s possible to include this in your inventory detail report.
Simply click ‘Show filter’ and then select the ‘Display inventory in transit’ checkbox before filtering the report.
Note: The ‘in transit’ figure represents the number of items in transit at the destination warehouse (the warehouse that the stock is due to be received into).
Filter first setting
The inventory detail report is a filter first report, so it can be configured to always display the filter first before loading the report. This can be useful if you have a large product catalog.
Landed costs on the inventory detail report
If you are using the landed costs module in Brightpearl, your inventory detail report will include a separate column to display the landed costs applied to each unit.
Why is there is there an asterisk next to the inventory value?
When the same SKU is added onto a purchase order using multiple rows (instead of a single row with the total quantity, e.g. if some units are being received in at a different price), it is possible to allocate different landed costs to each row.
Once the items have been received into stock, the total inventory value for the SKU in the batch can be seen on the inventory detail report and inventory audit trail.
Since there are two different landed cost values to be shown on a single report line, the average landed cost will be calculated and displayed. When this happens an asterisk will be shown.
In this example, the SKU was received into stock on the purchase order with different landed costs:
The SKU gets combined on the inventory detail report, so an average cost is used to display a single landed cost: