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

 
 

Posts Tagged ‘sql’

Data Warehouse Benefits

Having a direct view of your company’s performance enables strategic decisions.  Having access to a clear view of your company’s performance to start with can be an immense struggle for many companies.  As the grand picture of a company’s performance includes various data types, accurately gathering and uploading data into a single location can be […]

continue reading...

TIP Sheet – Deleting a Dynamics GP User ID

How to Delete a Microsoft Dynamics GP User ID   Ever go into Dynamics GP to delete an active or inactive User ID and get the “Deleting the Login failed for an unknown reason.  Contact your SQL Server administrator for assistance” error?   Not very descriptive.  So you go back in figuring you forgot to: […]

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

Microsoft Dynamics CRM and Salesforce Forecasting and Analyses

If your business has a sales and marketing team, and your business wants to show your customers that they are top priority, a customer relationship management (CRM) software is probably a good thing to invest in. If you are not familiar with CRM, let me give you an overview of it, as well as examples […]

continue reading...

5 Useful SQL Features for Microsoft Dynamics GP

View our free webinars   Read more about Hosted Dynamics GP   Download a FREE Demo When organizing your business’ data and sorting through multiple categories and headings, it’s easy to get overwhelmed with the time-consuming process. Structured Query Language (SQL) used in Microsoft Dynamics GP serves to retrieve information from databases through the use of basic […]

continue reading...

12 Questions To Determine the Cost of Your Dynamics GP Upgrade

The topic, how much does a Dynamics GP Upgrade cost, is very popular. Ever since we posted our article giving an estimate of our Dynamics GP upgrade costs and tips to save money on Dynamics GP upgrades we have had quite a few companies calling to ask us for Dynamics GP upgrade quotes. Even if […]

continue reading...

Kick-Start Your Data Warehousing

Many of the projects that I’ve been working on over the last 12 months have evolved integrating data into a data warehouse. Specifically, companies are looking to import more data from other systems to do various types of analysis. Data integration is nothing new, companies have been doing it for a long time, but usually […]

continue reading...

Using SSAS (SQL Server Analysis Services) Data Mining to Automate Marketing Analysis.

Any good analysis depends on creating a customer profile with good data.  For data to be good it will need to be cleansed, meaning when you look up State in your customer database table that MD is always the entry for Maryland.  The collecting and cleansing of the data is the hard part or where […]

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

TSA Set Up Roll Down Bug

A client recently asked us if it was ok to change the TSA setting on a deduction code that had history. Two of our seasoned Payroll consultants both said "no", and that if there is history no change can be made in GP to deduction codes with history. The client changed the TSA flag with their […]

continue reading...