DX CASE STUDY

CASE-003 MD SYSTEM

From quotation to shipment and invoicing — every process in one database

An in-house production and sales management system covering both our die division and stamping division.

In use since 2011 (current version "MD SYSTEM 3": since 2026)
Built with: PHP, MySQL, JavaScript

MD SYSTEM

This is a summary of the case study. Full details are available on the Japanese page.

Challenges

We run two very different businesses: high-mix precision die making and high-volume stamping of automotive connector parts. Information was split by department and by document, making it hard to see the whole picture.

Data scattered on paper and Excel

Order, purchasing, production and shipping records were kept in separate ledgers and spreadsheets.

Slow lot tracing

Tracing which material was used, and who produced and inspected a lot, meant cross-checking several records.

Figures a month late

Orders, output and divisional profit were only known after month-end totals.

Double entry into accounting

Sales and inventory data were re-entered by hand into the accounting software.

Our Approach: Building the business flow into the system

MD SYSTEM connects the whole flow — quotation, order, purchasing and materials, production planning, production results, shipping inspection, packing and shipping, invoicing and accounting — with a single set of data. Information entered at one step carries over to the next, so nothing is entered twice.

It is organized into three areas — Die, Stamping and Administration — with more than 70 screens, and runs in a web browser on office PCs as well as tablets and smartphones on the floor.

Since 2011

Started as an in-house order and purchasing system for the die division, replacing spreadsheets.

Expanded step by step

Extended to stamping production, inspection and shipping, then to sales, accounting and stocktaking, in response to requests from the floor.

2026: MD SYSTEM 3

A full redesign with smartphone/tablet support, stronger security, a management dashboard, a machining scheduler and AI business-card scanning.

Key Features

Management dashboard

Monthly orders and results for dies and stamping, and divisional profit trends in charts.

Lot traceability

Trace material, production time, operator and inspection results from a product lot on one screen.

Machining scheduler

Gantt-chart scheduling of die plate machining by machine, including unattended night operation.

Accounting integration

Sales and inventory data exported in a format the accounting software can import.

AI business-card scanning

Photograph a card and generative AI fills in the company, name and contact details.

Approval flow & audit log

Orders above a set amount require approval, and every change is logged.

MD SYSTEM is not packaged software — we design and build it ourselves. Improvement requests from the floor are implemented in-house, sometimes by the next day. We evolve the system to fit our work and our people, not the other way round.

15 years
of in-house development

Results

Faster management decisions

Orders, output and divisional profit are visible in real time, without waiting for month-end.

Stronger quality assurance

Lot information is linked from material to shipment, giving the traceability required for automotive parts.

No more double entry

Data entered on the floor flows through to accounting, reducing clerical work and transcription errors.

Shared, up-to-date information

Anyone can check the latest status on the same screen without asking the person in charge.

TECHNOLOGY

PHP 8MySQLJavaScriptHTML5 / CSS3REST APIGenerative AI (OCR)