Microsoft Dynamics SL vs. OpenAir PSA vs. Viewpoint Spectrum

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

This product is well suited for an organization that is focused on client services, project delivery, time tracking, expense reporting, and revenue recognition. From a pure project management perspective, this product is not as feature rich as say Microsoft Project Server. For organizations that are looking for detailed complex project plan and resource management (along with resource leveling, etc.), this is probably not the best suited product

Incentivized

The Installation team is amazing. They provide clear guidance at the beginning of the process regarding what is expected and what needs to be done. The implementation manager follows up monthly with you to make sure you are on track and if you need additional help. They are very helpful and responsive in resolving issues.

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

• Netsuite OpenAir PSA is highly configurable and has a large ecosystem of assets to work with.
• Tasks are easily designed to automate processes in your business workflow.
• OpenAir is designed in such a way that it can communicate and receive information from external systems without having to re-engineer your systems to make them work if you are following standard business practice.

Incentivized

• Job Costing - Viewpoint Spectrum handles job costing per project, per work order, per site, and gives us an up to date analysis of the project.
• HR - helps to keep all of the training certifications and HR incidents in a consistent and manageable order for all Managers to use.

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

• Compared to QuickArrow, setting up reports to reflect the data accurately seemed to require a bit more consultant time and collaboration. Getting the numbers correct is essential, so budget extra time for this iniative. We also learned that certain calculations can not be displayed in the executive dashboards. Ask these questions upfront to ensure your dashboards are complete for your needs (again, working backwards in the preparation stages).
• Compared to QuickArrow, NetSuite OpenAir PSA falls short in the resource management capabilities. UI, flexibility, and scheduling options all could be improved. This is on their roadmap, timeline yet to be defined. Scheduling is vitally important to our company and this is THE area where we feel is the applications weakest. However, the application does provide everything critical to scheduling and provided the elements we needed in order to be successful. We altered our scheduling process accordingly.
• During our System Administration 3 day online training, when a question was asked about detailed functionality, sometimes the trainer would share..."Yes, OpenAir has a configuration for that. Just inquire with your consultant and they can flip that flag in your instance." The responsibility for obtaining these special application configurations was placed on the System Admin [in training] to ask and to take notes. If your company needs the application to work a certain way, speak up and ask your OA consultant. There seems to be MANY flags that can be flipped in the background to allow for the system to meet your needs. My complaint is that these are not published, rather made available if one inquires.
• OpenAir is able to generate invoices directly and we strongly encourage using this feature to keep everything housed under one application. However, this did not work for our organization and we leveraged a financial integration. A bit of a pioneer integrating with Softrax -- the integration works well, however is quite fragile. We do receive appropriate support when needed, but would prefer the integration to be a bit more stable. We recommend integrating with their stated supported financial systems, as staying the course will likely net a more stable integration.

• Support isn't readily available. You can submit a ticket and wait days before it's picked up. Even critical issues (system outages) can wait an hour or two before someone responds.
• Large companies will feel limited. This product wasn't designed to handle large amounts of data, and performance seems to slow when there are more than 80 concurrent users.
• The new developments are limited. HR Management is less robust than a third-party product specializing in HR Management. Viewpoint Analytics is nowhere near as robust as Power BI or Tableau.

Incentivized

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

It all depends. We are still looking at moving our consultants to Oracle PAC, in order to get our financial systems in line (we use Oracle Financials currently). We are feeling a lot of pain with integration and segmented systems.

Ultimately,it depends on how much pain is felt there. OpenAir has given us a path to follow on from QuickArrow. I foresee either moving onto Oracle PAC by end of calendar, or staying on OpenAir.

OpenAir to Oracle integration is not easy. From a reporting and process perspective, there’s been pain from being in different systems

The product is working for us and the cost to implement a new system does not warrant the expense.

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

In this day and age I should not have to read a manual to understand a product. It should be intuitive to administrate and perform basic tasks. It feels like a ton of intelligence was poured into making OpenAir feature rich but no where near as much attention was given to the user experience.

Incentivized

There's a little bit of a learning curve, but once you've been working in the system for a while, it becomes second nature. I would say that out of all of the other software that I've personally used, Spectrum has been the easiest one to pick up and learn quickly

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

The system up time was reliable and that was never anything we ever had any concerns/issues with.

I've never seen Spectrum down

The performance was acceptable. If you had a very large data set you were working with it might take a little longer, but within reason.

For the most part the product is very reliable. Since we are hosted we sometimes have connectivity issues but I would say that is more our ISP than Spectrum.

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

As an admin, I've had more contact with OA support than most. I've found their response to tickets typically timely and helpful, however many of the responses to tickets are "we will file an enhancement request" and then I never hear about it again. So not terrible, but not a very fulfilling experience.

Incentivized

The support has recently changed. Last year, you could call in and get an immediate response. Now that doesn't seem possible unless you have an urgent situation with access to the software, payroll or payables. I have found that using chat or e-mail works nicely for the most part, but sometimes I feel it would be easier if someone from support would jump on our site and take a first-hand look rather than going back and forth

Incentivized

Very knowledgeable and able to articulate how other customers configured the solution to meet their needs as well as the best practices they recommended.

We did a 3 day online remote course back in April. NetSuite prefers training to occur before migration. We went over the functionality of tool and three months later we migrated. Personally, I didn’t find it that beneficial. Certain parts of it were beneficial as they applied to me – talked a lot about invoicing capabilities that didn’t apply to me. They also have knowledge base / e-learning assets, but I haven’t referred to them

Our trainer was excellent and navigated the time zone differences expertly. She gave us test assignments to complete and was available for questions at any time.

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

It went fine. Everything came over the way we wanted. In addition to migrating the current projects we wanted to migrate historical data – did that seamlessly. The finished product looked pretty good – just needed to tweak – and they helped us with that

My only insight would be to take time in your implementation and training process; ours was six weeks from start to finish.

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

OpenAir accurately reflects changes in real-time as well as lends itself to see where a draw is at, when payment is expected and what percentage of the contract has been billed or approved to date. This helps with project billing and tracking as well as cash flow. Quickbooks lacks the ability to show progress draws, approved changes, and pending changes on a given project where OpenAir excels.

Incentivized

I have previously used Sage Masterbuilder, another construction industry software. This has been a number of years ago. The company I am working for already had Spectrum and have been using it for as long as it has been around when it was known as Forefront. Based on conversations I've had with the personnel that were here at the time of purchase, Spectrum clicked off all the boxes they were looking for.

Incentivized

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

Incentivized

Once the system is setup, it's easy to manage and maintain.

You can grant user specific access which is nice. Project managers do not need all the same modules as Accounting. But Accounting does need access to PM modules as well

• 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 covers our requirements for time tracking and project/resource management better than the previous solution we used.
• Project managers are happier having this tool for their job and also because it is running on the cloud as opposed to running on-prem.
• It doesn't help in any way improving the "chasing" of the people that don't submit their time-sheets in time. This one stayed the same as before.

Incentivized

• [In my opinion,] it takes at LEAST twice as long to do our jobs now.
• [I feel like] we are paranoid about something not being printed correctly because of [what I believe are] buggy text fields.
• [In my experience,] we still have to refer to a physical file cabinet with paper, even though a main point of switching was to go paperless.
• [In our experience,] screens can now be "locked", so we can't see something if our coworker is also looking at it.
• [I believe that] the financial hit our company took from this switch was astronomical. [In my opinion:] Beware!