Midstream Integrations

Open-source tools for Business Central

The scripts and extensions behind our client work, published so anyone can use, inspect and improve them. Free to use, with help available when you want it.

Follow on GitHub

Projects

Each repository includes setup instructions, a license file and a ready-to-install release. Every Business Central app uses its own object range and the MID prefix, so any combination installs side by side.

Business Central apps

  • bc-card-statement-ocr

    Card statements become coded, receipted purchase invoices. Managers attach receipts and G/L coding from an email link, and approve vendor invoices with an optional second approver. How it works.

    Needs: BC 25+ and the OCR server (self-hosted or hosted by us)

    AL

  • bc-scheduled-report-emailer

    Email any report, standard or custom, as PDF, Excel or Word on a Job Queue schedule. Save the report's filters once; set recipients, subject and body per entry.

    Needs: BC 25+

    AL

  • bc-inventory-threshold-alerts

    One email when an item drops below its minimum, per item, location and variant. Alerts once per dip and re-arms when stock recovers.

    Needs: BC 25+

    AL

  • bc-production-machines

    A machine register by location with a maintenance, QA and safety log, attachments, and the machine on every released production order.

    Needs: BC 25+ Premium

    AL

  • bc-reporting-pack

    A G/L entries audit view with created and modified by as real user names, plus queries for outstanding warehouse receipts and received-not-invoiced lines.

    Needs: BC 25+

    AL

For Insight Works Dynamic Ship users

  • bc-dynamicship-bol-commodity

    Commodity lines built from what's on each license plate, NMFC and freight class, and the pro number as a barcode on the Bill of Lading.

    Needs: Insight Works Dynamic Ship

    AL

  • bc-dynamicship-productivity-pack

    Sales order and customer PO on the Package Worksheet, a "Ready for QA" email routed per location, customer columns on Warehouse Shipments, and third-party BOL fields.

    Needs: Insight Works Dynamic Ship

    AL

Integration and infrastructure tools

  • wirewatch

    A traffic dashboard for a Raspberry Pi or Ubuntu box plugged into your switch's mirror port: every device and destination, alerts for traffic outside your country, and a live world map. See how it works.

    Python

Card Statement OCR, from PDF to approved invoice

Our flagship app takes the retyping out of company credit cards. The people who know what each charge was for do the coding, without a Business Central license.

  1. Upload the statement

    Accounts payable uploads the card statement PDF to a purchase invoice. OCR reads it and lists the cardholders on it.

  2. The manager codes each charge

    The manager gets an email link to a web portal, uploads each receipt, enters the G/L account and dimensions, and presses Submit.

  3. Business Central builds the invoice

    One line per charge, every receipt attached, mismatches flagged as comments, and the requisition form stamped as approved.

Hosting and setup Read the code

Use it yourself

Clone the repository, follow the README and run it. If you have a question or find a bug, open an issue on GitHub.

Or have us set it up

We can install, configure and tailor any of these tools for your Business Central tenant and servers, then support them over time.

Ask about setup

Why open source?

You should be able to see exactly what software does before it touches your financial data. Open code also means no lock-in: if we part ways, everything keeps working.

Contribute

Pull requests are welcome. If you've solved a Business Central problem others have too, we'd like to hear about it.