TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Microsoft Dynamics SL

    Score5.1 out of 10
    N/AMicrosoft 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

    OnPlan

    Score10 out of 10
    N/ASpreadsheets are widely used for planning because of their flexibility and familiarity. With OnPlan, users get access to visualization capabilities, integrations, and collaboration features, in a solution designed to give the run-of-the-mill spreadsheet model more power. OnPlan integrates with dozens of data sources, including Netsuite, Quickbooks, Salesforce, ADP, and also existing spreadsheets – allowing the user to make important business decisions leveraging a single source of…N/A
    Pricing
    Microsoft Dynamics SLOnPlan
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Microsoft Dynamics SLOnPlan
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Features
    Microsoft Dynamics SLOnPlan
    Payroll Management
    Comparison of Payroll Management features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    8.5
    2 Ratings
    12% above category average
    OnPlan
    -
    Ratings
    Pay calculation9.62 Ratings00 Ratings
    Direct deposit files9.01 Ratings00 Ratings
    Customization
    Comparison of Customization features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    6.0
    6 Ratings
    23% below category average
    OnPlan
    -
    Ratings
    API for custom integration6.06 Ratings00 Ratings
    Plug-ins6.04 Ratings00 Ratings
    Security
    Comparison of Security features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    8.7
    10 Ratings
    3% above category average
    OnPlan
    -
    Ratings
    Single sign-on capability7.49 Ratings00 Ratings
    Role-based user permissions10.09 Ratings00 Ratings
    Reporting & Analytics
    Comparison of Reporting & Analytics features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    8.0
    10 Ratings
    6% above category average
    OnPlan
    -
    Ratings
    Dashboards8.06 Ratings00 Ratings
    Standard reports8.010 Ratings00 Ratings
    Custom reports8.010 Ratings00 Ratings
    General Ledger and Configurable Accounting
    Comparison of General Ledger and Configurable Accounting features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    7.1
    11 Ratings
    8% below category average
    OnPlan
    -
    Ratings
    Accounts payable6.011 Ratings00 Ratings
    Accounts receivable6.08 Ratings00 Ratings
    Global Financial Support6.02 Ratings00 Ratings
    Primary and Secondary Ledgers6.63 Ratings00 Ratings
    Journals and Reconciliations3.04 Ratings00 Ratings
    Configurable Accounting8.03 Ratings00 Ratings
    Standardized Processes6.03 Ratings00 Ratings
    Inventory Management
    Comparison of Inventory Management features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    5.7
    6 Ratings
    33% below category average
    OnPlan
    -
    Ratings
    Inventory tracking5.06 Ratings00 Ratings
    Location management6.03 Ratings00 Ratings
    Order Management
    Comparison of Order Management features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    6.2
    4 Ratings
    25% below category average
    OnPlan
    -
    Ratings
    Pricing6.03 Ratings00 Ratings
    Order entry3.04 Ratings00 Ratings
    Credit card processing7.02 Ratings00 Ratings
    Cost of goods sold7.03 Ratings00 Ratings
    Subledger and Financial Process
    Comparison of Subledger and Financial Process features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    5.7
    4 Ratings
    28% below category average
    OnPlan
    -
    Ratings
    Billing Management6.02 Ratings00 Ratings
    Cash and Asset Management7.33 Ratings00 Ratings
    Travel & Expense Management5.01 Ratings00 Ratings
    Budgetary Control & Encumbrance Accounting6.32 Ratings00 Ratings
    Period Close6.04 Ratings00 Ratings
    Project Financial Management
    Comparison of Project Financial Management features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    4.7
    3 Ratings
    47% below category average
    OnPlan
    -
    Ratings
    Budgeting and Forecasting7.33 Ratings00 Ratings
    Project Costing6.33 Ratings00 Ratings
    Cost Capture2.12 Ratings00 Ratings
    Capital Project Management8.01 Ratings00 Ratings
    Project Revenue Recognition2.01 Ratings00 Ratings
    Grants Management
    Comparison of Grants Management features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    6.3
    1 Ratings
    18% below category average
    OnPlan
    -
    Ratings
    Award Lifecycle Management6.01 Ratings00 Ratings
    Manufacturing
    Comparison of Manufacturing features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    6.0
    1 Ratings
    22% below category average
    OnPlan
    -
    Ratings
    Production Management6.01 Ratings00 Ratings
    Supply Chain
    Comparison of Supply Chain features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    6.0
    1 Ratings
    20% below category average
    OnPlan
    -
    Ratings
    Inventory Planning6.01 Ratings00 Ratings
    BI Standard Reporting
    Comparison of BI Standard Reporting features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    8.7
    1 Ratings
    14% above category average
    Pixel Perfect reports00 Ratings8.01 Ratings
    Customizable dashboards00 Ratings10.01 Ratings
    Report Formatting Templates00 Ratings8.01 Ratings
    Ad-hoc Reporting
    Comparison of Ad-hoc Reporting features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    9.3
    1 Ratings
    18% above category average
    Drill-down analysis00 Ratings10.01 Ratings
    Formatting capabilities00 Ratings10.01 Ratings
    Report sharing and collaboration00 Ratings8.01 Ratings
    Report Output and Scheduling
    Comparison of Report Output and Scheduling features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    9.0
    1 Ratings
    13% above category average
    Publish to PDF00 Ratings10.01 Ratings
    Report Versioning00 Ratings8.01 Ratings
    Data Discovery and Visualization
    Comparison of Data Discovery and Visualization features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    8.0
    1 Ratings
    8% above category average
    Pre-built visualization formats (heatmaps, scatter plots etc.)00 Ratings8.01 Ratings
    Access Control and Security
    Comparison of Access Control and Security features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    10.0
    1 Ratings
    18% above category average
    Multi-User Support (named login)00 Ratings10.01 Ratings
    Mobile Capabilities
    Comparison of Mobile Capabilities features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    10.0
    1 Ratings
    31% above category average
    Responsive Design for Web Access00 Ratings10.01 Ratings
    Budgeting, Planning, and Forecasting
    Comparison of Budgeting, Planning, and Forecasting features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    9.2
    1 Ratings
    13% above category average
    Long-term financial planning00 Ratings10.01 Ratings
    Financial budgeting00 Ratings10.01 Ratings
    Forecasting00 Ratings10.01 Ratings
    Scenario modeling00 Ratings8.01 Ratings
    Management reporting00 Ratings8.01 Ratings
    Financial Reporting and Compliance
    Comparison of Financial Reporting and Compliance features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    8.5
    1 Ratings
    5% above category average
    Financial Statement Reporting00 Ratings10.01 Ratings
    Management Reporting00 Ratings8.01 Ratings
    Excel-based Reporting00 Ratings8.01 Ratings
    Automated board and financial reporting00 Ratings8.01 Ratings
    Analytics and Reporting
    Comparison of Analytics and Reporting features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    10.0
    1 Ratings
    28% above category average
    Personalized dashboards00 Ratings10.01 Ratings
    Cost and profitability analysis00 Ratings10.01 Ratings
    Key Performance Indicator setting00 Ratings10.01 Ratings
    Integration
    Comparison of Integration features of Microsoft Dynamics SL and OnPlan
    Feature
    Microsoft Dynamics SL
    -
    Ratings
    OnPlan
    10.0
    1 Ratings
    21% above category average
    Flat file integration00 Ratings10.01 Ratings
    Excel data integration00 Ratings10.01 Ratings
    Direct links to 3rd-party data sources00 Ratings10.01 Ratings
    Best Alternatives
    Microsoft Dynamics SLOnPlan
    Small Businesses
    Zoho One
    Score9.2 out of 10
    No answers on this topic
    Medium-sized Companies
    Zoho One
    Score9.2 out of 10
    IBM Planning Analytics
    Score8.5 out of 10
    Enterprises
    Microsoft Dynamics AX (discontinued)
    Score4.8 out of 10
    Oracle Fusion Cloud Enterprise Performance Management
    Score7.2 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Microsoft Dynamics SLOnPlan
    Likelihood to Recommend
    5.0
    (18 ratings)
    10.0
    (1 ratings)
    Likelihood to Renew
    5.4
    (8 ratings)
    -
    (0 ratings)
    Usability
    3.0
    (7 ratings)
    -
    (0 ratings)
    Availability
    9.9
    (2 ratings)
    -
    (0 ratings)
    Performance
    1.0
    (1 ratings)
    -
    (0 ratings)
    Support Rating
    9.5
    (4 ratings)
    -
    (0 ratings)
    Online Training
    1.0
    (1 ratings)
    -
    (0 ratings)
    Implementation Rating
    9.0
    (4 ratings)
    -
    (0 ratings)
    Product Scalability
    1.4
    (2 ratings)
    -
    (0 ratings)
    User Testimonials
    Microsoft Dynamics SLOnPlan
    Likelihood to Recommend
    Microsoft
    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
    Read full review
    OnPlan
    OnPlan is well suited for finance teams looking to maintain control of their corporate/financial models. Every model can be exported to Excel. In particular, for early-stage to mid-stage companies, OnPlan provides a powerful and inexpensive solution that allows for automation and customization. Another strong argument for OnPlan is their experienced CSM/IM team that helps to build the first model and acts as a sounding board with insights to improve the models. OnPlan might be less powerful for large organizations operating across multiple divisions, countries, and entities as this requires sophisticated consolidation processes and standardization, which might be difficult to maintain with OnPlan. Implementations depending on complexity can take longer due to the customization options and plethora of options to make models more accurate.
    Incentivized
    Read full review
    Pros
    Microsoft
    • 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
    Read full review
    OnPlan
    • Integration with QBO and SFDC
    • Integration with Google sheets and presentations
    • User friendly and polished UE
    • Easy Excel like syntax for modelling
    • Flexibility to create custom formulas
    • User roles and permissions
    • Handling of fiscal year vs. calendar as well as switching between monthly/quarterly views
    Incentivized
    Read full review
    Cons
    Microsoft
    • 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
    Read full review
    OnPlan
    • Chart library or templates to quickly create polished Google charts
    • More collaboration features for comments and questions to team members
    Incentivized
    Read full review
    Likelihood to Renew
    Microsoft
    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
    Read full review
    OnPlan
    No answers on this topic
    Usability
    Microsoft
    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
    Read full review
    OnPlan
    No answers on this topic
    Reliability and Availability
    Microsoft
    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
    Read full review
    OnPlan
    No answers on this topic
    Support Rating
    Microsoft
    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
    Read full review
    OnPlan
    No answers on this topic
    Implementation Rating
    Microsoft
    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
    Read full review
    OnPlan
    No answers on this topic
    Alternatives Considered
    Microsoft
    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
    Read full review
    OnPlan
    OnPlan provided the best tradeoff for customization, integrations, affordability, user controls, and maintenance/control of the financial model.
    Incentivized
    Read full review
    Scalability
    Microsoft
    Since the backbone of the database is MS SQLServer, the database can be easily scaled.
    Incentivized
    Read full review
    OnPlan
    No answers on this topic
    Return on Investment
    Microsoft
    • 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
    Read full review
    OnPlan
    • More cost control
    • More accurate forecasts / reducing of forecasting errors
    • More accurate accounting close / detection of erroneous GL entries
    • Time savings to update financial model / forecasts
    • Time savings to create BvA reports
    Incentivized
    Read full review
    ScreenShots

    OnPlan Screenshots

    Screenshot of Get started fast – import your Excel or Google Sheets financial model.Screenshot of No need to learn a new system — OnPlan uses the Excel formulas and syntax you love.Screenshot of Generate scenarios and drill into variances. Create new what-if scenarios in seconds, and visualize variances with one click.