Skip to content

Weighbridge Integration and Automated Invoicing for Quarries

Building materials group, UK and Ireland

In short

How can quarry weighbridge tickets turn into invoices without re-keying?

At a quarry every load is weighed, but the weight often stops at the gate. When tickets are keyed in again for invoicing, bills go out late, mistakes slip in and stock figures lag behind what has left the site. We linked the weighbridge to invoicing and to a live view of reserves.

At a glance

  • Weighbridge ticket to draft invoice in one flow
  • Live stock and reserve view by parcel
  • Approval request when a parcel runs low

The client

The client is a building materials group producing aggregates, cement, asphalt and ready-mixed concrete in the UK and Ireland. Weighbridges at site gates record each load in and out.

What it was costing them

  • Re-keying: weighbridge tickets typed into the finance system add time and errors.
  • Late invoices: billing waits for someone to collect and match tickets.
  • Stale stock figures: reserves are known some time after the material has left.
  • Approval delays: approval to excavate another parcel starts late when a parcel runs low.

What we built

We built one flow from weighbridge to invoice, with stock and reserves updated on every load.

  • No re-keying: each weighbridge ticket reaches Dataverse as a delivery record, through the weighbridge system's export or API.
  • Right customer, right price: the delivery is matched to the order, and the price comes from a maintained price list.
  • Invoices without waiting: Power Automate prepares a draft invoice from the delivered quantity and sends it for approval.
  • Live stock position: every load reduces the stock of its product and the reserve of its parcel.
  • Early warning on reserves: when a parcel falls under a set level, an approval to excavate an alternate parcel goes to the right manager.
  • Exceptions only: tickets with no matching order go to a queue for a person.

Results

  • Result: invoices are drafted on the day of delivery, as ticket data is already in the flow.
  • Result: re-keying falls away for matched orders, leaving only exceptions.

The risk most teams miss

The weighbridge system is the hard part. Each vendor exposes data differently, and tickets arrive late, twice or with a mistyped customer. We used unique ticket numbers to block duplicates, an exceptions queue, and a parallel run with current invoicing before switching.

What we would add today

Improvements we would add on top of what is live.

  • Use AI Builder document processing or Azure Document Intelligence to read paper tickets at sites with no digital export.
  • Apply Dataverse row security so each site sees only its own loads and stock.
  • Keep stock history in a Fabric lakehouse to forecast when each parcel will be exhausted.
  • Store weighbridge and finance credentials in Azure Key Vault, with a service principal for the flows.

Technology

Dataverse, Power Automate, Power Apps (model-driven), Power BI, custom connector to the weighbridge system, finance system connector.

Tell us which weighbridge system you run and how invoices are raised today, and we will tell you where the manual steps can go.

Products and capabilities

  • Power Automate
  • Dataverse
  • Power BI
  • weighbridge integration
  • automated invoicing
  • stock monitoring

Related use cases

Finance

Have a Microsoft project in mind?

Tell us what you need built, fixed or supported. A senior consultant replies within one business day.