Case studies

What this looks like in a working business

Three pieces of work, described as they happened. Customers are not named on this page.

SCO OpenServer 5.0.6 · Informix

Six years of automated documents, then a staff portal

A UK business runs its ERP on SCO OpenServer 5.0.6 with an Informix database. The application does its job and nobody wants to replace it. What it could not do was produce a document anyone would want to receive, or answer a question without a printed report.

Documents

Since August 2019 the invoices and credit notes the system prints have been captured from the print queue, turned into branded PDFs and emailed to customers. Staff print exactly as they did before.

Portal

A web portal now sits on the same system for directors, accounts and office staff. It covers customer lookup, documents and statements, aged debtors, credit watch, lapsed customers, sales analysis, a finance overview with a cash-flow forecast, VAT return figures, stock valuation and purchase planning, all read live from the SCO database.

Result

Reports that used to be printed as documents of 50 to 200 pages are now live in the portal, filterable and exportable to Excel.

Document management    Web portals

Since August 2019
59,240 PDFs produced
Every working day
About 40 documents
Last 12 months
8,195 documents, all delivered by email
Kerridge ERP · Linux

Modern tooling around a legacy manufacturing system

Not every legacy system we work on is SCO. This business runs a Kerridge ERP, and wanted the same things: better documents, less retyping and management figures straight from the ledger.

Documents

Document management has been in daily use for several years, producing PDFs for two trading brands from the same system.

Getting data in

Bills of materials are loaded into the ERP from a spreadsheet instead of being keyed by hand, and works orders are issued and booked with a stock check before anything is committed.

Getting data out

The nominal ledger is extracted every night to a cloud database for management reporting. The full extract builds in under two seconds and loads in seven.

Modern tooling on legacy systems

Nightly ledger extract
Built in 1.8 seconds, loaded in 7
Documents
Two brands from one system
SCO OpenServer 5.0.5 · HP NetServer E60

A rescue from an HP NetServer E60

A business system on SCO OpenServer 5.0.5 was still running on an HP NetServer E60. The system was restored and brought back to life as a virtual machine.

We wrote this one up in full.

Read the rescue story    Virtualisation

From
OpenServer 5.0.5 on an HP NetServer E60
To
A virtual machine on current hardware
Next step

Tell us what the system is doing

A few lines is enough to start: the SCO release, what the system runs, and what you need. We will reply by email with what we would do next.

  • You deal with the people who do the work
  • No obligation, and no upgrade required before we will help
  • We tell you plainly if something is not worth doing

Send an enquiry

We reply by email. If a server is down, say so in the first line. You can also write to help@scoexpert.com.