Contact us today: (866) 4-WEBSAN (932726) Support

Microsoft Dynamics GP

Microsoft Dynamics GP (70)

Have you seen us on the Microsoft Solution Profiler?

Click here.

WebSan is one of the few companies in North America that offers a hosted Dynamics GP solution. It reduces your total cost of ownership vs. an on-premise solution.

Check out our web page regarding hosted Dynamics GP for more information.

Tuesday, 12 January 2010 12:26

Microsoft Dynamics GP newbie – First Contact

Written by

As the newest member to the Dynamics GP Consulting practice at WebSan, it is my responsibility as a junior analyst to learn how the system works through Microsoft E-Learning and actual hands-on practice in QA environments. My goal with my blog entries is to take you through my learning process with the system. It is my intention to provide any new users or potential future users of the system an objective view of how I perceive and adapt to Dynamics GP.

Coming from a systems background with experience in ERP and warehouse management systems, the first thing that came to mind when interacting with Dynamics GP initially was how easy it was on the eyes. This is an attribute that many software developers neglect because they fail to think like a user. I personally believe that more appealing GUI’s are successful than their bland counterparts in the efficiency department. Nobody likes monochrome work environments.

I’ve also found the navigation to be very intuitive. I have been able to get where I need to go in my basic training exercises in usage and configuration. The help menu has been doing a great job covering any questions I had. Any challenging issues I have definitely had to inquire a senior analyst. Although the software has an accounting backbone and I don’t come from an accounting background, I did not have much difficulty accomplishing basic tasks such as setting up GL accounts or running reports.

I am currently working through the configuration of a new WebSan client on Dynamics GP. My next blog entry will describe my experience with it, including any challenges and lessons learned. Stay tuned!

Steven Lu
This email address is being protected from spambots. You need JavaScript enabled to view it.
416-499-1235 x.209

The Setup Checklist in Microsoft Dynamics GP is a great little tool to guide you in the configuration of a new client on the system because it provides a systematic and efficient list of tasks for a complete deployment. I found the tool to be excellent in ensuring the proper setup tasks were completed in the right order because many latter and complex tasks such as in modules such as Sales and Project are dependent on initial setup such as GL account creation and Currencies to be finished first.

When opening up the checklist using the path Microsoft Dynamics GP -> Tools -> Setup -> Setup Checklist, you will find a nifty Setup Guide that pops up right beside the Checklist. I found this to be very helpful in the explanation of the task at hand and how to find more information in the related links below the task description. Here is the Guide that appears when configuring System Security:

As you can see, after the brief task description follows a list of more information that the user can click to further learn about the task and its relationship and effect on various other functions. Since System Security is related to users directly, you would find links for personal security and security roles in links. I noted in my first entry that the Help menu does a superb job of providing necessary information when stuck on a task and it continues to be as I am continuing with my configuration duties.

One complaint that I do have so far is the inability to maximize every single setup window when doing configuration. Usually the first window in a path can be easily maximized (i.e. Account Maintenance) but say if you wanted to Lookup the accounts, the results list must be manually enlarged instead of using the window maximize button. Although a small complaint, I believe that one-click window maximization should be found on every drilldown window in the system for added convenience.

My next issue will cover the concept and handiness of Smartlists and how they can help you with your production in Dynamics GP. I will be sure to provide an example of a custom one and the type of data that can be derived from it.

Steven Lu
This email address is being protected from spambots. You need JavaScript enabled to view it.
416-499-1235 x.209

Tuesday, 26 January 2010 14:17

Microsoft Dynamics GP newbie: SmartList

Written by

As promised from my last entry, I will be discussing SmartList functionality this time – how to use them to your advantage and how to build/modify your own.

SmartList in a nutshell is a powerful means of accessing your Dynamics GP data in simple to read form for reporting and analysis. They can be found right in the Microsoft Dynamics GP dropdown menu. There are predefined SmartLists for all modules, which means there is one for everybody. Examples of a few that come with the system are PA Cost Categories found in the Project Accounting folder and Open Purchase Orders, which is located in the Purchasing folder. Using a SmartList is as simple as clicking on the SmartList icon in the desired module. After the data is generated, you could then export to Excel for further data manipulation. There is also an option to export to Word if required.

If the standard SmartLists do not satisfy all of your analysis purposes, there is an add-on tool called SmartList Builder that allows you to customize the standard SmartLists as well as create your own to query a customized set of information. If available, the tool can be found in Micrsoft Dynamics GP-> Tools-> SmartList Builder->SmartList Builder. SmartList Builder allows you to link up to 32 tables in the system and configure your own column headings to suit your reporting needs. I will go through the steps of creating a new SmartList for my own purposes: Contract ID with Project ID and Project Name. To begin, name your SmartList and choose the Product that the data will come from. Project details are found in Project Accounting so that was the product I selected.

To start adding tables, simply click on the “+” symbol on the left panel and select “Microsoft Dynamics GP Table”. From there, you can choose and/or link up to 32 tables of your choosing to incorporate your desired set of data. There will be some research to be done in order to link the right combination of tables for your own purposes. The information I need is found in the PA Contract Master File and PA Project Master Files so I need to first add the PA Contract table and then link the Project Master table based on a common field (Contract ID):

I can then select the fields I require to be displayed in my dataset:

Just save the SmartList and it will be good to go in the SmartList window!

You can also choose to further filter your dataset using the Search button on the SmartList menu:

I hope this helped! My next blog entry will cover the Report Modifier feature in GP!

Steven Lu
This email address is being protected from spambots. You need JavaScript enabled to view it.
416-499-1235 x. 209

Thursday, 06 May 2010 06:16

GP 2010 - Payments

Written by

When making payments in GP 2010, users will be given additional restriction possibilities in Select Checks window.  New restrictions can be place on the following fields:

  • Vendor IDs
  • Vendor names
  • Class IDs
  • payment priorities
  • voucher numbers
  • document numbers
  • due date\discount date cutoffs
  • document currency

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-499-1235 ext. 213.

Tuesday, 10 May 2011 11:57

Microsoft Dynamics GP 2010 R2 Released!

Written by

Microsoft Dynamics GP 2010 R2 was recently released earlier than expected on April 27th with rave reviews since the product launch.

The updated GP 2010 R2 expands upon the Microsoft Dynamics GP 2010 solution with key themes of Enhancing Insight, Making It Easier and Extending Connections.

Overall highlights of GP 2010 R2 include:

  • Industry leading business intelligence with enhancements to SQL Reports, Word Templates, and Email
  • Release of Business Analyzer – a tool that helps enhance business decisions by viewing Dynamic GP reports and extends the reach of ERP to everyone within the organization
  • Additional 50 features added to overall platform to build on advancement and use

Let us show you how we can help your organization implement the right Dynamics GP solution.

Wednesday, 11 May 2011 13:00

Rising Gas Prices and Microsoft Dynamics GP

Written by

For those who drive, we’re all experiencing the same phenomenon of a lighter wallet. Reading and listening to news reports of rising gas prices has everyone in a cringe. Spending more money than what we’re use to isn’t everyone’s cup of tea, especially not mine. This poses a question for alternatives. There are lists of possibilities but one does seem like an effective solution, Public Transit. Why? It’s affordable and it’s just as efficient by getting me to work. I know you’re asking how does this relate to Microsoft Dynamics GP. Think about it this way. Your company is spending more money on antiquated systems that can’t keep up with  business or on multiple disparate systems which both have the effects similar to ‘spending more than you should’. You need a solution and that’s where Microsoft Dynamics GP comes in. Think of it as your company’s ‘Public Transit’ that can help your business do more with less. It incorporates all functions such as HR, Accounting, Sales and more, which adds to productivity. It’s a familiar interface, and gives you the power of choice in deployment, purchase and use.

Here’s a list of why you should chose Microsoft Dynamics GP for your company:

-         Affordability: One system that does it all

-         Great Fit: Easily integrates into your existing systems

-         Improve Productivity: Connect information across your entire organization

-         Rapid Innovation: Updates help improve your company system

The combination of the flexibility to adapt to your business needs and an affordable price makes Microsoft Dynamics GP the best choice.

Let us show you how we can help your organization implement the right Dynamics GP solution.