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


Posts Tagged ‘SQL database’

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...

Distributors Can Track The Lifetime of a Serial Number in Dynamics GP with SalesPad Quick Reports

Microsoft Dynamics GP with SalesPad works especially well for distribution companies that have inventory with serial or lot numbers. There are many standard reports for tracking these items, but what if you want to go deeper?  For example, what if you want one report that shows you the full lifetime of a serial number? You […]

continue reading...