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...Posts Tagged ‘SQL database’
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...