MILabs
Integrations

Inventory forecast report for Brightpearl

How an inventory forecast report can read Brightpearl stock and sales exports to show cover in days and flag lines for reorder.

Updated 2026-09-24

Inventory forecast report with Brightpearl

Much of a buyer's week goes on one question: how long the stock already on hand will last. In a Brightpearl account, the answer sits in several places at once, with receipts in one report, sales in another and the buyer's own sheet filling the gap. An inventory forecast report for this pair pulls those figures together and works out cover for each product line, meaning the number of days current quantity lasts at the recent sales pace. Receipts and returns feed the calculation, so a missed goods-in entry or a run of returns will shift that line's estimate and should be checked first. The weekly output is a short list of reorder dates, suggested quantities and flagged lines, sent by email to the buyer or owner. Brightpearl remains the source of record, and the report only reads from it, so a person decides every order.

How it works

  1. Confirm which Brightpearl reports or API fields hold sales, receipts, returns and stock on hand for the account, since fields vary with how modules are set up.

  2. Set up a named Brightpearl user with read access to those records, so the build sees no more than that user can see.

  3. Pull the weekly export or connected data into a working table, where each product code carries its stock, sales pace and receipt history.

  4. Calculate cover in days for each line, compare it with the reorder threshold the owner agrees, and mark lines below it or above a set level.

  5. Send the summary by email with each figure traced to its source, and keep the buyer responsible for raising any purchase order in Brightpearl.

good questions, straight answers

Frequently asked questions

What happens if Brightpearl changes?
The report reads from Brightpearl's exports or API, so a change to a field name, export layout or report setting can break the calculation. Each build keeps a list of the fields it depends on, which makes changes quicker to check. Module or permission changes are reviewed with the account owner first. If an access method is withdrawn, the connection moves to a route agreed with the business.
Who owns an inventory forecast report built around Brightpearl?
The business owns the report, its calculation rules and the figures it produces. MILabs builds and documents the connection, the threshold logic and the summary, then hands over a written note on how each figure is worked out. Brightpearl access stays with the named user the account owner creates, and that user can be removed at any time. Any working file kept outside the platform sits in the business's own accounts.
How does an inventory forecast report hand work to a person in Brightpearl?
The report does not raise purchase orders itself. Each week it sends a summary with reorder dates, suggested quantities and flagged lines. The buyer checks each flag against supplier terms and current stock in Brightpearl, then creates or amends the order by hand. Notes on any overridden line are kept with the summary, so the reason is on record.
Can an inventory forecast report work with Brightpearl data exports?
Yes, a weekly file of sales, receipts, returns and stock levels, exported from the account, can feed the report without a live connection. The export needs consistent product codes and dates, because the calculation matches lines across files. If the export layout changes, the report needs a short update before its next run. Export-based setups suit accounts that prefer no live access, and they can move to a connection later.
What should I back up in Brightpearl first?
Before the report is set up, export the stock levels, purchase orders, sales history, receipts and returns for the period you plan to test against. Keep the product code list with those files and store them outside the platform, in a folder the business controls. Record the report settings and any user permissions in use. These copies let a forecast be checked against what happened and give a clean reference.
let's make something happen

Custom development: how we can help

Choose how you want to work on this with MILabs. Both options start with an enquiry.

Discovery is free, no obligation from the first chat.

Let us build it for you

We build it and look after it.

Build it yourself, we'll help

You build it with our direction, teaching and a weekly check-in.