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
The service behind this work
Power Platform developmentThe service behind this work
Power BIMore on this industry
Manufacturing and distribution
Related use cases
FinanceActionable Power BI Reports with an Embedded Commenting App
Management reports need remarks wherever a number deviates, but Power BI's built-in comments cannot target a single value. Finance teams stitched answers together from Excel, PowerPoint, Word and Outlook before every report went out. We built a Power Apps app, embedded in the report, that lets people comment on a specific KPI or date and act on it from the same page.
Schools Division Integrated Planning in the Accountability Framework App
Each year, the schools division network of the client had to plan business, manpower and finances for all of its schools and centres, in separate spreadsheets that someone had to merge by hand. The cycle had a fixed calendar and a presidential review, so late or inconsistent plans cost real time. We added integrated planning to its existing Accountability Framework app.
- 30+
- schools on shared templates
- c. 90
- departments imported
Bank Reconciliation Proof of Concept for Oracle
Matching bank transactions to finance records by hand costs time every day and ties the process to the people who know the rules. The client was moving to a new Oracle system and asked how reconciliation could work on it. We ran a short proof of concept on its own data.
Have a Microsoft project in mind?
Tell us what you need built, fixed or supported. A senior consultant replies within one business day.