Microsoft Dynamics Partners providing comparisons and opinions to professionals in the ERP/Accounting software selection process since 2009


Posts Tagged ‘Database’

Webinar: Speed Up Your Dynamics GP System – April 24th, 2018

Tuesday, April 24, 2018 11:00 AM – Noon (CST) Register Here! Are monthly maintenance tasks like running reconcile, taking hours, or worse, days? Maybe it is time to take a look at the size of your database. We will go over some of the in-house Administration things you can do within Dynamics GP – routines, […]

continue reading...

Creating Microsoft Excel Connections to SQL databases

Microsoft Excel can be a powerful tool to evaluate SQL data.  In Excel, a connection can be created to directly link to a particular database filtered according to your requirements.   This connection must be validated by a SQL login to ensure the contents of your databases remain secure. The connection can be refreshed to update […]

continue reading...

MASS Update System Indicator in Microsoft Dynamics NAV

Recently, I refreshed a client test database with a copy of their live database in Microsoft Dynamics NAV so they could test some functionality and do training.  One of the issues that they ran into right away was that it became confusing for them to know which database and company they were accessing.   “What […]

continue reading...

Have You Outgrown Your ERP or Are You Just Ready For an Upgrade?

ERP Packages are constantly being enhanced with better functionality, more flexibility, and focus on efficiency with each new product version. Also, many accounting software developers integrate user-requested changes into later version releases.   It is possible for a company to outgrow their current accounting package. Businesses grow, requirements change, and ultimately, an ERP package is not […]

continue reading...