Solutions

Three kinds of work, one data layer underneath.

Most of what we do falls into integration, reporting or operational applications. In practice they depend on each other, so we usually build them on the same foundation.

01 — Integration

ERP and data integration

For when the information you need exists, but is spread across systems that don't talk to each other.

Typical situations

  • Sales are in the e-commerce platform or marketplaces, costs and accounting in the ERP.
  • Two companies in the group run separate ERP systems, and consolidation is done by hand.
  • Reports pull directly from the ERP and slow it down, or break when it changes.

What we do

  • Design a central database with a structure you can keep building on.
  • Set up scheduled synchronisation from each source, with reconciliation checks against the source.
  • Leave the ERP unchanged, and use read-only access wherever possible.
  • Document the schema so your own team can query it.

Systems we have worked with include JD Edwards, Logo, IdeaSoft, Amazon and Walmart marketplace APIs, Microsoft SQL Server and PostgreSQL.

02 — Reporting

Management, financial and commercial reporting

For when management needs one version of the numbers, and the people preparing them need their time back.

Typical situations

  • Monthly reports are assembled in spreadsheets and arrive late.
  • Sales, finance and operations each define margin or stock differently.
  • Group or multi-currency figures need to be consolidated before anyone can read them.

What we do

  • Agree the key definitions once, and use them in every report.
  • Build Power BI models and reports around how management reads the business.
  • Financial views: consolidated P&L, budget against actual, margin and cost breakdowns.
  • Convert foreign currency at the rate of the transaction date, not today's rate.
  • Look after the reports afterwards: changes, new requests and refresh problems.

03 — Applications

Operational and business applications

For the people who run the daily work and need to act on something today, not read a summary next month.

Typical situations

  • Shipment or stock planning lives in a spreadsheet that one person understands.
  • Production, laboratory or maintenance records are kept on paper or in scattered files.
  • Master data and mappings are fixed by hand every time a report breaks.

What we do

  • Build focused screens for entry, follow-up, planning and approval, limited to what each team needs.
  • Use the same data as management reporting, so both sides see the same numbers.
  • Add role-based access and keep the database open and documented.
  • Run the application on your infrastructure or host it for you.

Next step

Not sure which of these fits?

Describe the problem in your own words. We'll tell you honestly whether it's something we should take on.