Responsive Maintenance Company working for Social Landlords - Integrated Purchasing, Stock Control and Job Contol

We began working with this firm in 1995. Since then they have grown systems across multiple sites through several years of expansion.

They recently consolidated their systems with a move to new a head office whilst retaining a satellite depot.

Features

• Over 400 active operatives
• 60 back office staff, including purchasing department and stock
• Full job control system handling 12,000 maintenance jobs each month
• Purchasing system processing 3000 orders a month
• Stock system supporting multiple stock locations including van stocks
• Interfaces with external clients for automatic importing of jobs
• Interfaces completion to client systems for KPI reporting
• Interfaces charging and certified values between client systems to speed up the payment process
• Parts used on jobs automatically interfaced to stores system for restock
• Parts issued from stores automatically costed against jobs to give immediate profitability
• Multi-site system with redundancy and backups at both main locations for almost immediate disaster recovery
• Secure off-site backups for added durability
• Full access to all data from historical systems

Configuration Details

• Database: Firebird SQL
• Database size: 6.1GB
• Primary Server Current continuous uptime: 310 days [since installation]
• Number of records in largest table: 3,165,827
• Primary Server Processor: Core2 2.13GHz Dual-code
• Primary Server Memory: 4GB
• Primary Server HDD: 3x320GB configured as Raid1