Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

There are a number of recorded issues with Microsoft Dynamics GP 10.0 and 2010 when attempting to reference VBA code on 64-bit machines. Both Office 2010 and Crystal Reporting are known culprits in causing this issue to occur, as their installations update some system registry keys for VBA 6 incorrectly. Office 2010 references VB7, thus it should not be affecting keys it does not require. Registry Keys are used by the system as container objects, similar to folders, that can store values or further keys. If the value of a registry key is changed without the knowledge of an application that references its value, problems can arise. This would be the case for the VBA 6 file not being found.

I recently had a client of whom we were aiding implement an on-premise installation of GP and needed to deploy the software, along with any customized forms and reports we had designed, to a dozen workstations. After completing the deployment steps without any issue on the first three workstations, it was not until the forth that the system administrator eventually encountered the “File not found: VBA6.dll” error. The error can occur either on login to GP or when accessing custom VBA code through ‘Modifier’, if installed. Upon discussion, I was told that both Office 2010 and Crystal Reporting resided on the machine (Crystal was later removed, however the effects its installation has on registry keys can remain even after its removal).

To resolve the issue, there are two steps that need to be confirmed and/or completed to allow GP to properly reference the system dll:

(NOTE: Making changes to system registry keys is only advisable for advanced users, as incorrectly performing any steps can corrupt the system if care is not taken. Contact your system administrator for help.)
1. Ensure that Dynamics GP is not running.

If you have ever created any customized reports from within Microsoft Dynamics GP, then you are quite aware of how reporting can be a useful tool in extracting the exact information needed to increase your productivity and make effective business decisions. While there are a number of different reporting methods that can be utilized (such as SQL Server Reporting Services (SSRS), SmartLists, and Word Templates), the most popular and basis for reporting within GP is Report Writer.

While exceptionally powerful, Report Writer is not the easiest application to operate without prior knowledge or experience. However, the following is a trick that one can use to have Report Writer work for you.

A few weeks ago, a client had requested a Purchase Order form for a new company that they had just recently added to GP. The formatting of the PO form was to resemble that of an existing company, the only difference being a change in logo in the top-left corner of the report. Should be easy. However, Report Writer will only allow two versions of the same type of report: either the original GP standard or the modified version. When a report is 'modified', it will print in place of the standard version of the report. Although there are both 'Copy' and 'Duplicate' options when choosing a report to customize in Report Writer, these secondary versions of the report will only be accessible through (Reports → Customized) within GP and cannot be printed or displayed, for example, from the 'Purchase Order Entry' window.

Luckily, the Purchase Order form has two documents types: the Blank form or Other form. This way, both companies can utilize their own type of purchase order form. However, if the client requests the POP Purchase Order Other Form to be a copy of the POP Purchase Order Blank Form, the latter having numerous formatting changes and functions created; the replication of this report can be a lengthy process. There must be a better way, right? Well, there is.

Through the (Microsoft Dynamics GP → Tools → Customize → Customization Maintenance) menu, you can export a package file of the report you wish to copy. Package files are XML formatted and contain all the modifications and fields used on the report. Due to their text-based nature, these files can be manipulated within a simple text editing program, such as Notepad, without ever having to access Report Writer itself. After exporting the POP Purchase Order Blank Form as a package file (the form we would like to replicate) we can open the file and copy all text between the Report “POP Purchase Order Blank Form” line and the closing </Component>line.

There are several different elements that need to be well thought-out in order to receive a good ERP quote. Enterprise Resource Planning by definition is a system that integrates information across a company using services such as: finance/accounting, manufacturing, sales, customer relationship management (CRM) and more. You want to make sure that you get a quote that’s in your budget, but you don’t want to sacrifice the essentials to stay within your budget either. Make some room in your budget for fluctuation and negotiation to ensure that you get the best quote.

Modules

There are a number of modules that are offered in an ERP system, it’s up to you to choose which ones best fit your company. For example if you are a consulting company maybe you only need CRM, Finance and the Sales module. Save money on modules that you don’t need and get the one’s that you do need. You have the option of getting standard or advanced modules. Advanced modules offer more variety of features but are usually used for larger businesses. There needs to be research done to explore what particular capabilities you need.

Number of Users

The number of user’s plays an important role when determining the price. It is important to have a firm estimate of the amount of user’s that you need. Plan in advance to avoid unanticipated cost and to get a more accurate quote.

Implementing a new ERP Software is a time for new learning experiences and challenges. There are some common mistakes that you want to avoid when implementing ERP software, remember this list so you can become a hero and not a victim of poor planning.

Mistake 1: Not selecting the right vendor

Browsing through a vendor’s website can’t determine if they are right for you. Call the company and speak with someone, this gives you the chance to ask questions about the company and their services. Don’t forget to ask for references so you can hear more than one opinion of the vendor.

Mistake 2: Not taking advantage of all the features that you are paying for!

For any kind of service you pay for, be mindful of what’s included. If you are unaware of a feature that you have but never use, just ask!

Still wondering what choosing Microsoft Dynamics GP ultimately means for your business? Our clients who have adopted Dynamics GP often mention terms such as Value Added, Productivity, Familiarity and Innovation within days of implementation and it’s easy to see why.

Exceptional customer experiences begin with the people who make your business possible. By providing these very people with the right tools to boost their productivity and in turn increase their value added activities, they will ultimately help your organization to achieve your goals and generate maximum return. These very tools are found in Microsoft Dynamics GP. Reducing administrative overhead and the redundant tasks costing your business daily only begin to describe the advantages your business will experience. Dynamics GP will justify your existing technology investments with its seamless integration capabilities and will help to streamline your business processes with a fast, easy configuration that doesn’t require writing any new code.

Who’s going to help you make this important transition in your business life cycle you ask? WebSan Solutions Inc. will help support your transformed business processes using Dynamics GP by providing you with exceptional support and training wherever and whenever  you need it. We work hard to understand your business and provide you with support solutions to once again ensure your business is optimizing its functional capabilities.

Contact WebSan Solutions Inc at This email address is being protected from spambots. You need JavaScript enabled to view it. to hear more about how your business can benefit from Microsoft Dynamics GP.

Praveen Parameshwaran is a Dynamics GP Support Specialist capable of assisting companies with a wide variety of business challenges.

Accounting staff must always ensure that the general ledger and the sub-ledgers are in balance at all times.  Often, our support team will be asked to assist when they aren’t in balance.  When this occurs, we generally run the Reconcile to GL routine in GP in order to determine the cause.

Dynamics GP 2013 includes a new feature to help reconcile the Bank & Inventory sub-ledgers to one’s General Ledger.  This functionality previously existed for Accounts Receivable and Accounts Payable sub-ledgers.  Further the Reconcile to GL window now includes both the General Ledger and Sub-ledger balances on it for quick review.  The additional sub-ledgers for reconcile will help ensure customers have a quick and easy way of ensuring their records are accurate.

Adam MacIntosh is a Senior Project Implementation Manager at WebSan Solutions Inc, a Microsoft Dynamics GP Silver Partner & 2012 Microsoft Impact Awards Finalist.  Adam can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 213.

The long awaited Microsoft Dynamics GP 2013 was recently released right before the holiday season.  The latest version has a number of new features which we have previously discussed in this blog, the most important of which is greater flexibility in terms of deployment.  Also included is RapidStart Services, a tool designed to speed up implementations while lowering project risk.

Contact WebSan Solutions Inc today at This email address is being protected from spambots. You need JavaScript enabled to view it. to learn more about Microsoft Dynamics 2013.

Adam MacIntosh is a Senior Project Manager at WebSan Solutions Inc, a Microsoft Dynamics GP Partner offering implementation & support services for large & small firms in a variety of industries.

The release is almost here! Business is growing and so is technology so look no further! Microsoft Dynamics GP is committed to helping you do this by delivering a widespread vision and solution for your business. In part 1 of this blog I will be talking about 3 features that you can look forward to in the upcoming release.

Take command of your business

Have access to Dynamics GP virtually everywhere. There will be a new web client so you can use and contribute to Dynamics GP anywhere, anytime. The business analyzer dashboard helps you gain access to key performance indicators, reports and important information.

What’s new about business intelligence is it now offers both full service and self-service users have more of an “out-of-the-box” Microsoft SQL Server Reporting Services and Microsoft Excel Reports.

Drive efficiency up while you drive costs down.

WebSan Solutions Inc. announced that it has been selected as a finalist in the ERP Partner of the Year category for the 2012 Microsoft Partner Network IMPACT Awards. The tenth annual IMPACT Awards recognize excellence within the Microsoft technology partner community in Canada.

 “This year, we celebrate the 10th Anniversary of the IMPACT Awards, which recognizes the outstanding achievements of Canadian Technology Partners, such as WebSan Solutions Inc.,” said Mark Dodds, Vice-President of Small Business, Midmarket Solutions & Partners, Microsoft Canada Inc.  “Microsoft depends on our Partners now more than ever before as we enter a new era of cloud-based computing. Our partnership is pivotal to growth and success and we look forward to celebrating the commitments of our Partners this year at the IMPACT Awards gala.”

WebSan was chosen as a finalist in the ERP Partner of the Year for its Dynamics GP implementation of an Electronic Bank Reconciliation solution for Cash 4 You, a Canadian Retail Financial Services provider.

“We are pleased to receive this recognition for our efforts. We always focus on delivering tremendous value to our Clients through the implementation of the Microsoft suite of products, including Cloud and On-Premise Dynamics GP, CRM and Office”, states Andrew King, Managing Director.

WebSan, along with other technology partner winners and finalists in each of the award categories, will be honored at an awards ceremony at the new Four Seasons Hotel located in Yorkville, Toronto on November 13, 2012.

WebSan Solutions Inc. has been named a 2012 Impact Award Finalist for ERP Partner of the Year!

"We're thrilled with the recognition of our contributions to our Clients' successes and our position as the leading Canadian Hosted Dynamics GP Partner." stated Andrew King, Managing Director.

Here's a complete list of the 2012 Impact Award Finalists.

We'll find out November 13 if we won or not!

Stay tuned!

Employees can work from home, the office or on the beach. Because of the IT cloud movement you no longer have to be confined to your desk. That doesn’t mean that less work gets done, it just means you have more of a flexible environment to work from. This can make you more efficient and manage your time better because you now have options. Generation Y is all about “multi-tasking” and being technology driven.  So it’s only logical to have employees enter their time and expense via internet/remotely.

According to Forrester Research , as of 2011, about 34 million people work from their residence occasionally. Forrester Research also predicts that the number of people who work remotely will nearly double -- to approximately 63 million people -- by the year 2016.With that said, the modern day time and expense management needs to keep up with this growing movement.

A benefit from an employee’s perspective is being worry-free about forgetting to enter an expense or time worked. If you come home and realized you forgot to enter your time, you can now go on the internet and enter it right away. Being able to enter your time or expenses as they occur increases accuracy.

A benefit from an employer’s view is that work can get done regardless of where their employee is. It’s now easier to capture your employees’ time and expenses. No more paper!

We recently attended the CDN Channel Elite Awards Gala, and even though we didn’t win, were a top finalist. CDN Canada’s number one IT channel publication recognizes Canadian solution providers in ten categories. WebSan Solutions Inc. was nominated for “Best Small Business Solution”. This award honours partners that have created the most innovative and problem solving hardware, networking, cloud or software-based solution for an organization or department with up to 100 seats or less using the solution. “The Channel Elite Award program demonstrates that Canada has a growing number of talented, innovative Solutions Providers that are capable of delivering solutions that help businesses of all sizes.” said Paolo Del Nibletto, editor of CDN.

We are very honoured to be nominated. Being recognized for our talents in this industry drives us to work harder and to continue to keep our customers satisfied.

CDN recognizes IT Solution Providers for their innovation, leadership and commitment to creating value for their customers.

WebSan Solutions Inc. has been named a finalist in the Best Small Business Solution category for this year’s CDN Channel Elite Awards. http://www.itbusiness.ca/cea/home.html

This award honors the partner that has created the most innovative and problem solving hardware, networking, cloud or software-based solution for an organization or department with up to 100 seats or less using the solution.

CDN’s Channel Elite Awards recognizes IT Solution Providers for their innovation, leadership and commitment to creating value for their customers.

As a finalist, we will be judged by a panel of CIO or IT director level executives. Category winners will be chosen based on the following criteria:

Innovation - originality in the application of the IT solution to the business problem

On July 19th WebSan held a SmartList Builder Webinar. We discussed how to link tables and calculate fields, create defaults for more user-friendly environment and create summary SmartLists. To be kept up to date with our latest webinars, send us a message or e-mail us at This email address is being protected from spambots. You need JavaScript enabled to view it.

You can view the recorded webinar and other Microsoft Dynamics GP training videos at our YouTube Channel.

If you are thinking of starting a new business, or getting a new software system, what company do you choose? How do you know that the company that you decide to go with fulfills your needs? It’s time that you do your own research and be in charge of your business financial system. Here are some questions that you should ask before you make a decision:

1.       Will the accounting software grow with your business?

You want to make sure that you don’t outgrow your system. It’s better to get a system that has the capacity to grow with your business.

2.       Can access be restricted for some users?

Having the power to monitor who uses particular functions is very important to a company. Having control is very important for senior level employees to keep certain information confidential and private.

Recently I had the opportunity to interview Jon Rivers. In this interview he discusses his book, current projects and his views on user problems.

In a short summary what do you describe your job is?

I am currently the Channel Partner Manager at Data Masons Software an EDI ISV solution provider who helps to solve the EDI needs of clients who are running Dynamics GP, AX or NAV. When I am not helping the partners I am managing all of our Social Media outlets if that be our Blog, Twitter or LinkedIn accounts.

You can also find me presenting at Dynamics-focused conferences, educational forums and Web events, including the annual GPUG Summit, AXUG Summit, NAVUG Forum, Microsoft Convergence and numerous regional user groups.

How long have you’ve been in the Microsoft Dynamics GP Industry?

Happy Canada Day!

For those enjoying a little R&R today, imagine this was your every day!  To get achieve that, you would need to start building some automation into your business processes.  The first step you can take is by ensuring your reporting is easily & readily available.

Homepage Metrics offer out-of-the-box reporting that covers all GP modules.  There exists an extensive list of potential reports one can use.  These are automatically integrated to ones Homepage for easy & quick viewing.

Try adding some Metrics to your Homepage today by selecting the pencil icon / edit button on the Metrics heading.

We are still accepting resumes for our Application Specialist position.  Hurry & forward your resume before its too late!

http://www.websan.com/about/careers

We are accepting applications from recent university graduates as well as current GP users looking to broaden their knowledge.  Work for a young & vibrant company in uptown Toronto!

WebSan has continued its growth by expanding its office facilities.  We have recently taken over additional office space, doubling our office size.  We are also expanding our workforce.  If you have the proper blend of technical capabilities & a knack for business, applying to one of our openings at the link below:

http://www.websan.com/about/careers/

An Enterprise Resource Planning (ERP) Consultant is either a contract employee or an employee that’s part of a company that is hired to do either of the following: implement, upgrade or support an ERP system.

The main function of the ERP consultant is to help organizations move to ERP software. A successful ERP consultant is able to adjust to a client business process, to determine where ERP systems would be most useful.

ERP Consultants relevant fields of study are information technology, business information systems or management information systems. You have the option of letting a consultant help out with the full implementation of an ERP project, from matching your business requirements with the right software to managing change within the organization as a result of the software.

You know you have a good consultant when he/she is capable of communicating with users at all levels of the organization.

If you are looking for an ERP Consultant, contact WebSan Solutions Inc. we've got the experience and expertise you need to help lead you in the right direction. We ensure your new integrated ERP system will meet all your management, reporting, financial and accounting needs while also helping you to streamline processes and improve your overall business.