Microsoft Dynamics SL vs. QAD Adaptive ERP vs. Sparkrock

For a small to mid-size business, MS Dynamics SL is effective. We are capable of managing our finances with a very low risk of error. We have worked with MS Dynamics for almost 15 years and have more than doubled the size of our business in that time with very few issues from the program. We have exponentially increased our revenue and reporting demands and have found SL to be very dependable and stable. The program does have the occasional glitch and those are sometimes outside of the realm of expertise of our IT department. SL support is excellent, but their timeliness is not as urgent as ours.

Incentivized

If you're setting up operations where you have to manage manufacturing builds from raw components to finished goods, I would recommend QAD. It's nice to have subassemblies part numbers for your builds and enter in the number of accepted quantities and rejects. QAD is very helpful if you have a lot of parts floating around. I would not buy QAD if you only have to manage less than ~20 parts... just use Excel.

Incentivized

For all companies that want to improve the performance of their employees and increase productivity, this software helps all daily business tasks to be executed on time efficiently and smoothly. A very useful program that's why we don't stop using it.

Incentivized

• Provides flexibility for complex project based cost accounting
• Strong and flexible allocation processer for cost allocations, markups, and pricing
• A "Flexible Billing" module under the project controller series that allows for multiple billing formats ranging from fixed price schedule of values, T&M or Cost Plus, and scheduled billing.
• Flexible reporting with options using Crystal Reports, SSRS, a Quick Query tool, and ability to tie into MS Office tools such as MS Access and MS Excel
• Tight integration with Financials, but also the ability to integrate with modules such as Sales Order, Inventory, and Field Service
• Customization abilities ranging from a VBA (visual basic for application) foundation to allow customizing existing forms to the ability to use the SDK (Software Development Kit) to build more complex customizations that integrate with Dynamics SL.

Incentivized

• The QAD Enterprise application is great, we only started using this application a few years ago. The Master Scheduling Workbench has been a great improvement to our daily operations.
• The Web-based QAD Supplier Portal has also been implemented recently in our company and has been a huge help to our purchasing and materials department.
• The QAD support that we receive has helped our company grow and is a major asset in upcoming projects.

Incentivized

• Data collection - the system is robust and we can tailor it to collect the information we need.
• Easily configurable - the system is easy to configure to meet our specific business needs.
• Reporting and data extraction - the system allows for easy access to information that helps inform business decisions.

• Reporting in the Project module is lacking functionality. I understand that most companies have specific needs when it comes to tracking project information but the standard reports are not good.
• I would recommend a product like Management Reporter that is for Projects only. Project Reporter should allow users to pull in all Project related data into reports.
• Fixing suspended batches. Obviously all of us users have experienced this mess. SL knows what needs to be corrected and there could be some step by step fixes in a separate repair module to do the steps we do in Query Analyzer.

Incentivized

• The layout is old fashion. Can be more modern.
• QAD Adaptive ERP has alot of functions that can be overwhelming to new users

Incentivized

• Many of the improvements are being met with each upgrade. Altus Dynamics has an idea portal that customers can add ideas to and vote on other customer ideas. This means that most issues that come up are resolved with each new upgrade.

Unfortunately, Dynamics' lack of ability to smoothly integrate with our CRM system is causing us to look at other solutions. The efficiencies that we gain by using Dynamics for our day to day accounting are lost in the constant headaches of getting sales quotes to import properly into the system for invoicing. Another major issue for us has been budgeting and reporting. We currently do all of our budgeting and board reporting in Excel, which is too time consuming and inefficient, especially when a system as robust as Dynamics should easily be able to handle this relatively simple task.

Incentivized

The cost / benefit of changing to a different ERP will create a high cost and low benefit that's why I believe that we'll continue renewing QAD for a long time.

Incentivized

We are already scheduled for our upgrade to NAV 2016 beginning in May 2016.

I rate it a 10 because we have removed the fields we don't need so users can really crank the data into the system. The software was designed for the professional services firm in mind but does a tremendous job for construction firms and "blended" companies that are both distribution firms but project centric as well. Perhaps they drop ship inventory to a project where their employees or subs need to work on a project for example.

Incentivized

Easy to use, zero or minimum cost to maintain the database (DBA etc) , no issue with OS ( Linux), stable database

Incentivized

Complete workflow management to keep up to date and orderly the daily activities of employees. Allows for seamless cash flow, invoicing, general ledger, payroll, and inventory.

Incentivized

We have had only one unplanned outage for 2 hours in the last 30 months. We shut down for 30 min to 1 hour once a month, but that is for Microsoft OS updates to the servers. Being a 24/7 world wide operation, the reliability is really important. We do get an 8 hour window on the weekend that we can be down for a short period to install Microsoft Dynamics SL updates, but we do not have many of those. On our last version upgrade, we shut the users out at 9:30 am and were fully operational in less than 6 hours. The upgrade was New SQL server, New SL server and 2 new Citrix servers.

Incentivized

Support is only used when needed, so unfortunately ,they get all the odd issues. It's a difficult business, but Microsoft and our firm do a great job of meeting customer needs. We get routine feedback that our support services are very good.

Incentivized

I haven't contacted support for QAD yet.

Incentivized

Complete tracking of employee performance, hours worked, attendance and absences, vacations, and overtime.

Incentivized

Just to let it take its course. The implementation for me once I became a part of my former organization was pretty seamless. Just get to know the basics and call the support team to ask questions if you need help on an issue, should they arise. They are ready, willing, and able to help!

Incentivized

Of the comparable mid-range ERP systems, Dynamics SL competes at the lower end based on price, but also above the high-end based on flexibility, data, and reporting. Being able to stay with the same core accounting from a $100 million dollar company to a $3 billion dollar company shows the range of capabilities.

Incentivized

QAD is very easy to use once it's set up. It's basically an Excel sheet that can handle a lot more data points and faster. It's nice that you can dump the data stored in QAD to a CSV file and analyze in Excel. Careful narrow down the data searches to a limited number of points or Excel will crash. QAD is much easier to set up than Arena and SAP. And the numbering systems you can create in QAD is more customizable.

Incentivized

• Real-time data that is available at our fingertips
• Flexibility of the system to address changing needs over time
• Elimination of the huge administrative burdens that we were experiencing as a result of the previous system due to lack of integration

Since the backbone of the database is MS SQLServer, the database can be easily scaled.

Incentivized

• More time is spent on manipulating reports which can and should be automated.
• Lack of electronic invoicing process and other green technology features creates more cost on printing and storage costs.
• The lack of a user friendly interface requires more training and a bigger learning curve for staff.

Incentivized

• It help us to reduce the inventories (FG and RAW)
• It reduce the time to adjust to the constantly changing international customs laws

Incentivized

• As a technician it's hard for me to say what effect the ROI has had on our organization, however our finance team seems satisfied on it. We look forward to deploying the staff dashboards for better financial tracking throughout our whole organization.