About Services Tools Blog Contact us

Stock and Purchase Reports

Live reports of current stock and of products due on purchase orders, with an accounts code and a spreadsheet download of the same columns.

  • Reporting Dashboards
  • Trade supply
  • Dashboard feature
  • Bespoke
  • Hybrid
  • 2026

The problem

Someone checked stock and incoming purchase orders in Brightpearl by hand. The reports needed a live view and a file to download. Lines under a threshold were easy to miss, and purchase documents needed a nominal code so the figures landed in the right accounts bucket.

What it does

A stock report lists current quantities and highlights lines under a threshold. A second report lists products due on open purchase orders with the expected date. You can set an accounts code on those documents. A spreadsheet download has the same columns as the screen.

Outcomes

  • Lines under the threshold show in amber on the live report.
  • Due-in dates sit beside the stock view.
  • The accounts code is saved on the document.
  • The spreadsheet has the same columns as the screen.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Stock on hand

Lines
6
Live quantities
Under reorder point
2
Amber until the count is raised
Reorder rule
On hand
Compared with the point on the line
Counter stock Amber is under the threshold
MaterialCodeOn handReorderStatus
15 mm copper tube, 3 mCT-15-38624OK
22 mm copper elbowCE-22720Under
15 mm isolating valveIV-155416OK
Twin and earth cable, 2.5 mmTE-25412Under
15 mm push-fit couplerPF-1514040OK
110 mm soil pipe, 3 mSP-1102310OK

Due on open orders

Open lines
3
Expected this month
Units due
264
Elbows, cable and pipe
Nominal missing
1
Set a code before the file is posted
Purchase documents
DocumentLineQtyExpectedNominal
PO-4418 22 mm copper elbow Calder Tube 200 16 Oct 2026
On the document
PO-4422 Twin and earth, 2.5 mm Mere Cable 40 22 Oct 2026
PO-4430 110 mm soil pipe Humber Plastics 24 29 Oct 2026
On the document

How it works

  1. Open the stock tab and highlight lines under the threshold.
  2. Open the due-in tab for products on open purchase orders.
  3. Set an accounts code on a due-in line.
  4. Download the visible tab as a spreadsheet.
  5. Keep later changes in the saved report setup.

Pipeline

flowchart LR
  Stock["Stock quantities"] --> Low["Under threshold"]
  Po["Open orders"] --> Due["Due in"]
  Nominal["Nominal code"] --> Due
  Low --> Csv["CSV"]
  Due --> Csv