Go to top

Work Order Management System by FMDBSolutions


The client is a large Oil servicing company based in Massachusetts, USA


This system is a mini ERP that connects inventory and assets to Work Orders.

Project Description

There are five aspects to this project::

  1. Work Order Management Manages all their Work Orders information and able to add Receipts, Inventory, Assets and Time sheet.

  2. Assets Management – Manages all asset information and its history.

  3. Inventory Management – Manages all asset information and its history.

  4. Technician Management – Manages all their technicians and ability to set the technician to active or inactive.

  5. Offline Database Technician can download and upload their work orders from Server database to local database.

Technical Highlights:

Integration with other systems:

1.Barcode Scan using Pic2shop

2.Sage (Import and Export)

Plugins and Special Features

Following are the plugins and special features of the project:

  • Server-side Scheduled scripts to Import records from Sage and exporting records to sage.
  • Offline Database with sync Process.

  • Barcode Generation

Team Size – 1 TL + 2 TM + 1 Tester


  1. Desktop

  1. iPad (offline + sync)

Development Platform – FileMaker Server 14

Deployment Platform:

FM Server 14 – Windows Server 2012 R2 Standard Intel(R) Xeon(R) CPU E5-2609 0 @ 2.40GHz 2.40GHz (2 Processors) 15.6 GB RAM, 64-bit Operating System

# of Users :

  1. Desktop – 15

  2. iPad – 40

Skills Used:
FileMaker 14
Barcode Integration
FileMaker Development
FileMaker GO
FileMaker Offline
Lubrication company
Work Order Management