Microsoft Dynamics SL is one of the ERP products in the Dynamics family.
This product was acquired from Solomon 2000.
The product is typically used by SMBs, particularly in project-based businesses (e.g. construction). It has strong accounting and project management capabilities.
N/A
MySQL
Score8.4 out of 10
N/A
MySQL is a popular open-source relational and embedded database, now owned by Oracle.
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We have never contacted MySQL enterprise support team for any issues related to MySQL. This is because we have been using primarily the MySQL Server community edition and have been using the MySQL support forums for any questions and practical guidance that we needed before and during the technical implementations. Overall, the support community has been very helpful and allowed us to make the most out of the community edition.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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!
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
