Is Your Made2Manage® ERP Keeping Up? The Ultimate Annual M2M Health Assessment Checklist

For small to mid-sized manufacturers, the ERP system is the operational heartbeat of the shop floor. It manages your bills of materials (BOMs), schedules production jobs, tracks inventory, calculates job costing, and keeps your financial ledgers balanced.

For many discreet and custom manufacturers, Made2Manage® (M2M) has been the workhorse driving these critical business processes. In many ways, the ERP system has become as critical as any machine on the shop floor. However, as supply chains evolve, customer demands become more complex, and business models shift, even a robust ERP like M2M can slowly degrade in performance and alignment.

Yet while companies routinely maintain equipment, audit inventory, and review financial performance, they often neglect the health of their ERP environment. Without routine maintenance, small inefficiencies stack up: data gets cluttered, workarounds replace standard workflows, and system performance slumps.

To ensure your system continues to drive profitability rather than friction, perform an annual M2M ERP Health Assessment. Use this comprehensive, multi-pillar checklist to conduct your operational tune-up.

1. System Performance & Infrastructure Check

Goal: Ensure system speed, data integrity, and server environment health.

Over time, database bloat, legacy logs, and aging hardware can turn routine queries into minute-long waiting games. Users gradually become accustomed to slower system response times and may stop reporting performance problems.

· [ ] Database Optimization & Indexing: Have SQL Server indexes been rebuilt and statistics updated regularly? Is the M2M database log file properly managed and truncated?

· [ ] Server Hardware & OS Compatibility: Is your hosting environment (on-premise or cloud) running supported operating systems and SQL versions? Are CPU, RAM, and disk space utilization levels within safe operating thresholds?

· [ ] Backup & Disaster Recovery (DR): Have you verified that automated database backups run daily? Crucially, when was the last time you performed a test restore to confirm your DR plan actually works?

· [ ] Module & Patch Updates: Are you running the latest stable update or service pack for your M2M version, ensuring critical bug fixes and tax table updates are applied?

Checklist Action: Compare current performance metrics against prior years. Trending analysis frequently reveals emerging problems before they affect operations.

2. Master Data Management & Data Hygiene

Goal: Eliminate "garbage in, garbage out" to restore trust in your reports.

Bad master data undermines scheduling, purchasing, and costing across the entire manufacturing plant. Even small inaccuracies can create scheduling challenges, purchasing errors, and distorted inventory valuations.

· [ ] Part Master Cleanup: Have inactive or obsolete part numbers been flagged or archived? Are lead times, safety stocks, and order quantities up to date?

· [ ] Bill of Materials (BOM) & Routing Accuracy: Are shop floor routings accurate to actual run times, work centers, and setup hours? Do BOM structures reflect true material usage?

· [ ] Customer & Vendor Master Audits: Are contact details, tax exempt certificates, default freight terms, and payment terms current?

· [ ] Work Center & Capacity Standards: Have machine rates, labor rates, and shift capacities been reviewed within the last 12 months to reflect modern labor costs and plant layout changes?

Checklist Action: Randomly audit 25 high-volume parts and compare ERP information against actual manufacturing practices. Verify routings, setup times, labor standards, and BOM structures.

3. Core Operational Workflow Audit

Goal: Ensure end-to-end operational processes align with M2M best practices.

A surprising number of ERP issues stem from process variation rather than software limitations. Workarounds are the silent killer of ERP ROI. Watch for warning signs including duplicate data entry, manual report manipulation, and excessive reliance on tribal knowledge.

· [ ] Quoting to Order Entry: Is customer quoting performed directly within M2M, or are custom spreadsheets taking over? Are quote-to-sales-order conversions seamless?

· [ ] Production Scheduling & Shop Floor Control: Is the shop floor dispatch list driven directly by M2M, or are supervisors managing production using whiteboard or Excel workarounds?

· [ ] Inventory Control & Physical Counts: Are cycle counts or annual physical inventory counts yielding acceptable accuracy rates (aim for >95%)? Are physical inventory adjustments being properly reconciled in the general ledger?

· [ ] Purchasing & MRP Utilization: Is Material Requirements Planning (MRP) being actively generated and trusted by buyers, or are raw materials purchased based on gut instinct?

Checklist Action: Interview representatives from each department and document the top three ERP frustrations they encounter daily. If multiple users have developed their own workaround for the same issue, that's often evidence of a process gap that should be addressed.

4. Financial & Costing Alignment

Goal: Validate job costing, margin visibility, and financial reconciliation.

Many manufacturers assume their costing structures remain accurate simply because transactions continue processing successfully. However, labor rates, overhead absorption methods, supplier costs, and production processes change over time. Accurate manufacturing accounting relies on tight integration between operational tracking and financial modules.

· [ ] Job Costing Reconciliations: Are job variance reports reviewed promptly upon job closing? Are WIP (Work in Process) balances matching physical realities on the shop floor?

· [ ] Standard vs. Actual Cost Verification: Have standard costs (material, labor, overhead) been updated to reflect recent inflationary spikes or supply chain adjustments?

· [ ] Subledger-to-GL Reconciliation: Do Accounts Receivable (AR), Accounts Payable (AP), and Inventory subledgers match the General Ledger cleanly at month-end close?

· [ ] Month-End Close Efficiency: How long does your month-end close take? (If it takes longer than 5 business days, workflow bottlenecking is likely present).

Checklist Action: Compare actual margins against estimated margins for representative products. Significant differences may indicate costing assumptions that no longer reflect reality.

5. User Access, Security & Training

Goal: Protect sensitive data while empowering staff with system knowledge.

Employee turnover often results in "knowledge loss," where new team members are only trained on bad habits passed down from predecessors.

· [ ] Role-Based Security Audits: Have user permissions been reviewed to ensure proper segregation of duties (e.g., separating AP creation from check printing)?

· [ ] Terminated User Offboarding: Are former employees promptly deactivated across M2M and connected SQL instances?

· [ ] Skills Gap Assessment: Have key power users identified areas where staff struggle or request repeat assistance? Is ongoing M2M training budgeted for new hires?

· [ ] Customization & Reporting Review: Are custom reports (SSR/Crystal Reports) and dashboards still relevant, accurate, and actively used by decision-makers?

Checklist Action: Conduct a role-based access review and remove unnecessary privileges. Many companies find users have accumulated permissions through years of incremental changes.

Turning Assessment into Action

Completing this health assessment checklist is step one; acting on the findings is where real business value is unlocked. The goal isn't to generate a lengthy report that gets filed away. It's to identify practical improvements that strengthen business performance over the next year.

1. Grade Your Findings: Mark each checklist item as Green (Optimal), Yellow (Needs Attention), or Red (Critical Issue).

2. Prioritize Quick Wins: Tackle high-impact, low-effort items first—such as running database reindexing scripts or deactivating legacy user accounts.

3. Develop a Remediation Plan: Group remaining yellow/red items into quarter-by-quarter projects (e.g., standard cost updates in Q1, MRP retraining in Q2).

The most successful ERP health assessments are not technical audits performed in isolation. They are cross-functional evaluations involving finance, operations, engineering, supply chain, customer service, and IT. Your Made2Manage® ERP system is designed to provide visibility, control, and efficiency across your manufacturing business. By conducting a structured annual health assessment, you protect your software investment, eliminate costly operational drag, and keep your business running lean and profitable.

Need Help Optimizing Your M2M ERP?

If your team lacks the internal SQL resources or time to conduct an M2M health check, consider partnering with Cincinnati Software Solutions, an experienced M2M consultant and managed service provider, to execute a comprehensive technical and functional audit.