What do you like best about Spectrum?
As the Dir of IT, one of the most helpful areas is the ability to import data using their Data Exchange, which can save a great deal of time, which uses Excel, and they also have Import features for Material Management and Inventory.
Another great feature is creating your reports using Crystal Reports. If you are into SQL, you can also garner data that way as well, where I have modified data using SQL in their system that was imported incorrectly.
They have continued to develop their help features online, where you can direct new users.
We still use the on-prem version of the software, and by March of 2025, they will stop supporting the on-prem version and we will be required to move to the cloud.
I have had to participate within every department, mainly focusing on Accounting, HR, Job Cost and Material Management as the majority of my work. Those modules are all pretty solid and work very well, and I will get to some drawbacks on the other side.
They allow Multi-Companies. Review collected by and hosted on G2.com.
What do you dislike about Spectrum?
Data Exchange: They don't have enough formats for a program of this size. If they don't have one, they push their development team at a hefty price. We are a Heavy Highway Construction company, and our asphalt prices fluctuate on the price of oil, if you have special pricing for customers (which they have a section for that), but you have to modify all those prices by hand because they do not have a Data Exchange for Customer Special Pricing, which is perplexing that they wouldn't, as we have a large number of customers with special pricing based on their levels of qty. I believe, every table should have a data exchange and a modify for one-time import ones.
Not every field in the Data Exchange is error checked. If the data is wrong on some of the one-time imports, you have to use SQL to correct your mistake.
Crystal Reports: If you want to modify one of their reports, they use temp tables for almost every report, which does not lend itself to those of us who write Crystal Reports, as you can not always get to the raw data as they use temp tables to create raw data you cannot use, and you cannot always add other tables or parameters because the report may fail. It would have been better for them to use the base tables to make it easier for the companies to modify their reports. Many times I have to start from scratch to determine what data they used to create their temp table.
On-Prem vs Cloud: I know many industries are moving in that direction, though the cost savings they calculate for you don't equate to what we pay directly. Moving to the cloud will cost our company more as we still have servers and must maintain them, as well as backups. If is not like Spectrum is the only software our company uses.
Departments: One of the issues I have is the inconsistencies of the different screens from the different modules. They say this is due to different programmers working on different modules throughout the years, but they don't have a standard, which can be frustrating when you want to see what data you will need to enter, some screen populate (greyed out as it awaits you to enter the main piece of data) where other screens remain completely blank with only the entry for the main piece of data. The other drawback is the system is click happy. You have to click through some areas that you shouldn't need to click so many times to complete a task.
Inter-Company Billing and Sharing : The software is weak on procedures of sharing data and invoicing between companies. We have had to write Crystal Reports to create Data Exchange FIles to import Invoices from 1 company to another. All Equipment and Employees have to be entered in all companies they work in as opposed to our old software that these could be flagged as to which companies they could be accessed by. Review collected by and hosted on G2.com.