AromaERP

A self-hosted ERP for a perfume manufacturer. It runs on their own Windows server and serves every device on the office network, with no internet connection needed.

Sector
Perfume manufacturing
Status
In development
Runs on
Client's own server
Internet
Not required
AromaERP · Product tourReal screens, demo data

01The problem

Formulas, batch records and billing were kept in separate files, and the owner wanted production data to stay inside the building, off the internet.

  1. 01

    Formulas in files

    Formula versions were copied between sheets, so the batch floor could work from an old version without anyone noticing.

  2. 02

    Lots used out of order

    Material was picked by whatever was nearest, not by expiry, so older lots aged on the shelf.

  3. 03

    Billing retyped

    GST invoices were typed up again from batch records, which is slow and where errors creep in.

02What we built

Formula to invoice, on their own network.

The formula drives the batch, the batch drives the lot pick, and the released batch drafts its own GST invoice.

AromaERP · FormulasReal screen, demo data
2.1Versioned, costed formulasReal screen

Every product has a formula with ingredient costs. Editing it creates a new version, so past batches keep the one they were made with.

AromaERP · ProductionReal screen, demo data
2.2Production ordersReal screen

Each order shows its product, batch, supervisor, material cost and status, from planned to completed.

AromaERP · Quality controlReal screen, demo data
2.3Quality before saleReal screen

Finished batches cannot be sold until approved here. Rejected materials are quarantined and kept out of production.

AromaERP · InventoryReal screen, demo data
2.4Lots, locations and expiryReal screen

Stock by lot and rack, with expiry dates and expired lots flagged before they are used.

03How it works

One chain, no retyping.

01

Formula

Versioned, with every component and its share.

02

Batch

Planned from one formula version and a size.

03

Lot pick

Lots suggested in expiry order and scanned.

04

Quality

Tested, then released or held for retest.

05

Invoice

GST invoice drafted from the released batch.

04From the client

05Scope

Modules
Formulas, batches, FEFO lots, quality control, barcodes, GST billing
Runs on
The client's Windows server, reached from every device on the office network
Internet
Not required to run
Status
In development
03/04Next projectInstrumentationMeasurement software for government researchOpen case