Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

Posts Tagged ‘tricks’

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

Ten Quick Tips and Features for Everyday Microsoft Dynamics GP Users

There are numerous features that even everyday Microsoft Dynamics GP users may overlook. We’ve compiled ten tips and features for Microsoft Dynamics GP that you may benefit from. Copy Settings You can save time when creating new user records by copying homepage roles, content, and settings from one user to another Different Menu Views Are […]

continue reading...

Microsoft Dynamics BI Blog #1 – BI Analysis Cubes Differentiate ERP Analysis

As Football/Hockey season is kicking off—let’s kick-off the Turnkey Technologies BI Blog Series! Business intelligence turns information into action through data gathering, analysis, monitoring, and forecasting to identify opportunities, minimize risk, and improve management insight. This BI definition above reminds us of an often-seen GEICO TV commercial, “Everybody Knows That”. Like many worthwhile endeavors requiring […]

continue reading...

Tips & Tricks: Incrementing a Number with Padded Zeros in SQL

Incrementing an integer in SQL is easy; all you have to do is + 1 to the value. However, incrementing a number that has padded zeros is a little trickier, since it is probably a string value and not a number. Luckily with some type conversions, it becomes just as easy as incrementing an integer. […]

continue reading...