Microsoft Dynamics SL vs. Quantrix

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 find yourself in the ocean of traditional spreadsheets, overwhelmed by broken links, errors, model audit problems, hardwiring, etc. here is a lifebuoy for you. If you want to have full flexibility in your budgeting and forecasting in contrast to ERPs with rigid structures and one-size-fits-all concept. If you are small or medium size company and do not want to invest in costly enterprise solutions. If you need a fast implementation https://youtu.be/5W_q5Xhw5fg

• 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

• Building complex financial planning model availing of a multidimensional data structure coupled with a powerful formula language, with the immediacy and intuitiveness typical of spreadsheets
• Implement quickly model modifications (new products, new scenarios, new time periods) simply adding new "items" to "categories" (corresponding to dimensions in a multidimensional data model)
• Scale up models to very large datasets with very fast computation times
• Easily import data from text files, other Quantrix models and external databases via DataLink and DataNAV
• Save snapshots of tables computed in Quantrix to external databases via DataPush

Incentivized

• 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

• Hard to be critical of the Quantrix team as I know they strive to produce the best product possible. I suppose the next thing on my wish list would be the application of the new Solver functionality to be available in the Qloud.
• A big help for new users would be a good book on transitioning from Excel or other environment into Quantrix. I know first hand it can be difficult to transition when having to learn the program through a help guide, forums and tech support. I had a lot of trial and error in my journey to producing the desired models. On one hand it was a valuable method as it taught me a lot of what not to do, but I will admit it was not the most efficient way to do things.
• Would also love to see local user groups being formed at some point in the future. Quantrix puts on a fantastic conference once a year in beautiful Maine, but it is a big journey for someone in Southern California (and limited to one or two days a year). I would like to see some local chapters formed in different areas of the country so local Quantrix users can get together more often and collaborate (maybe a quarterly or semi-annual meetup?). Our Quantrix community is still relatively small and may be a difficult task for some areas, but is also the very reason why this would be great idea.

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

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

For a newbie it can be difficult until you get the hang of the system. Quantrix is a very logical system, once you understand its underlying ideas.

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

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

Overall, I was not part of the ultimate decision to purchase Quantrix. I terms of user-friendliess and robust reporting capabilities I do think Tableau has Quantrix outclassed. That being said, Quantrix does provide more in-depth analyses for our relevant data and provides better modeling for our forecasts out of the box. The accuracy of the tools output is also much better

Incentivized

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

• Capacity forecasting used to take hours to calculate with a ton of manual modifications. Quantrix has automated that so a model can be updated at any time with a click of a button
• The accuracy of the models is incredible. It took some tweaking to add in data scubbers, but now it runs almost flawlessly
• The confidence the management teams have in the output of the model is amazing. Before, people would question the output, have you rebuild it, and then compare. Now the report comes out and the output has high confidence.

Incentivized