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

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.

2. We need to ensure that ‘VBA 6 Core components’ is installed on the workstation. This can be found in the following path: C:\Program Files (x86)\Common Files\microsoft shared\VBA\VBA6\VBE6.dll

If the file or path does not exist, then the VBA6 folder can be copied from another workstation that has it on their system. Otherwise, the VBA 6 Core Components will need to be downloaded and run on the machine to install the correct files. This can be accessed from: https://mbs2.microsoft.com/fileexchange/downloadfile.aspx?fileid=2208ac6f-d575-4f34-8b19-40340fe3d20c(the download will require either a CustomerSource or PartnerSource login). The file can be obtained through other means, but you need to ensure that the file is coming from a trusted site as dll files, along with any system files, can be dangerous to your system if they are not genuine.

3. Once the path and the dll file exist on the workstation, we will need to update a registry key to point to the new path:

a. Click on the Windows start button and in the search box, type: regedit and hit enter

b. This will open the Registry Editor window.

From here, you will need to navigate on the left side of the window to: HKEY_CLASSES_ROOT\TypeLib\{000204EF-0000-0000-C000-000000000046}\4.0\9\win32

and ensure the path for the key is set to: C:\Program Files (x86)\Common Files\microsoft shared\VBA\VBA6\VBE6.dll

Registry Editor

c. If the path specified above does not exist in the System Registry, then we will need to create a registry file to add the appropriate node.

i. Open ‘Notepad’ and copy the copy the following text into the blank document:
Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\TypeLib\{000204EF-0000-0000-C000-000000000046}\4.0]

@="Visual Basic For Applications"

[HKEY_CLASSES_ROOT\TypeLib\{000204EF-0000-0000-C000-000000000046}\4.0\9]

[HKEY_CLASSES_ROOT\TypeLib\{000204EF-0000-0000-C000-000000000046}\4.0\9\win32]

@="C:\\Program Files\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6.DLL"

[HKEY_CLASSES_ROOT\TypeLib\{000204EF-0000-0000-C000-000000000046}\4.0\FLAGS]

@="0"

[HKEY_CLASSES_ROOT\TypeLib\{000204EF-0000-0000-C000-000000000046}\4.0\HELPDIR]

@="C:\\Program Files\\Common Files\\Microsoft Shared\\VBA\\VBA6\\"

ii. Save the Document as a .reg file. Now, double-click on the registry file you just created and click ‘OK’ to add it to the system registry.

4. Start GP and enter your credentials. Now proceed to perform whatever task was notifying you of the error.

With the dll file in place and the path correctly pointing to the file, the error message should disappear. Hopefully, Business Objects, and especially Microsoft, ensure that their products do not affect any registry files that do not pertain to the particular application themselves.

Brandon Germaine is an Application Specialist at WebSan Solutions Inc, a Microsoft Dynamics GP Silver Partner & 2012 Microsoft Impact Awards Finalist. Brandon can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 219.

Published in WebSan Blog

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

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.

1

2

This can then be pasted into an exported POP Purchase Order Other Form package file, in the exact same location of the text document (between Report “POP Purchase Order Other Form” and the closing </Component>).

Once saved, the POP Purchase Order Other Form package file can be imported back into GP through the Customization Maintenance window. The only step remaining is to replace the logo in Report Writer with that of the new company. Simple.

When importing packages into GP, it is important that all users, other than yourself, are logged out as the package will not import correctly and problems can occur. Backing up existing packages files is always a good idea in the case that something goes awry. Access will also need to be granted to the users who wish to view or print the modified report.

Tricks like this one can save you a lot of time and stress when dealing with reporting in GP, and if a particular task appears as though it will take more work than warranted, then it is likely that there is an easier way of accomplishing it.

Brandon Germaine is an Application Specialist at WebSan Solutions Inc, a Microsoft Dynamics GP Silver Partner & 2012 Microsoft Impact Awards Finalist. Brandon can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 219.

Published in WebSan Blog

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.

Training and Customizations

Training can sometimes be overlooked when budgeting for an ERP solution. Even though training could be included in the ERP quote, keep in mind the degree of training they offer. If you know that your staff is going to need more training than what’s offered, suggest to the vendor that you need more training. If you want a feature that is not available but can be done as a customization then that could increase your budget as well.

Natalie Williams, Marketing Coordinator, WebSan Solutions Inc., a Canadian Certified Microsoft Partner

Published in WebSan Blog

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.

Published in Dynamics GP
Saturday, 05 January 2013 09:35

Microsoft Dynamics 2013 Released

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.

Microsoft Dynamics 2013

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.

Published in Dynamics GP
Monday, 23 July 2012 09:15

SmartList Builder Webinar

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.

Published in Uncategorized

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.

3.       Do you want to go towards cloud hosting or stay on premise?

Even though moving to the cloud would be less money and more current with what today’s businesses are doing, some people don’t feel comfortable choosing the cloud. But at least there are options to choose from.

4.       Can I afford this software?

Sometimes it takes money to make money. But if this decision will put you deep in debt then it’s not worth it. Be sure of the software you choose and thoroughly access the situation for the right budget.

5.       Ask for referrals from other business, clients and/or family.

If you don’t know where to start, ask around about the different accounting software people you know are using. Also, start to search on Google. If you have read this blog on our website then I just have given you an accounting software to look into, Microsoft Dynamics Great Plains.

By: Natalie Williams, Marketing Coordinator, WebSan Solutions Inc., a Canadian Certified Microsoft Partner

Published in WebSan Blog
Sunday, 01 July 2012 10:00

Homepage Metrics

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.

Picture

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.

Published in Dynamics GP

Move to the cloud or stay on premise? What do you choose? Some firms are very skeptical about moving to the cloud while others welcome it. If you are a company that thinks it’s time for a change, then using Hosted ERP System will be for you. Read the following list that I wrote about benefits of Hosted ERP System below:

  • Do you prefer to pay for what you use? Hosted Dynamics GP uses a subscription-based licensing model, where you pay for the number of user licenses.
  • Trying to keep your cost low? Licensing fees are very predictable and can be known in advance.
  • Looking to get a quick start on things? Hosted Dynamic GP guarantees faster deployment and implementation than choosing to be on premise.
  • Do you want to save energy costs?  You don’t have to have a server; you just need an internet connection.
  • Still want to be in control of your data and business? Don’t worry, you also have 24/7 access to your data. You have the options of adding and removing users if you choose.

Are you still undecided? If you want to learn more information about Hosted Dynamics GP, visit our website www.websan.com At WebSan Solutions Inc. we help you unlock your systems potential.

By: Natalie Williams, Marketing Coordinator, WebSan Solutions Inc., a Canadian Certified Microsoft Dynamics Partner

Published in WebSan Blog

I had the opportunity to interview Victoria Yudin, a Microsoft MVP (Most Valuable Professional) for Microsoft Dynamics GP and founder of Flexible Solutions Inc., as well as a well-known professional in the Dynamics GP community. I wanted to interview her to get an insider's insight on Dynamics GP - to find out her perspective on GP modules, Microsoft's partner channel, and what the future holds for Dynamics GP. As I'd hoped, her answers tell a lot about her success with the product and the direction of the GP ecosystem.

1.       What do you most love about your job? 

I love the feeling I get when I am able to help someone learn how to do something that saves them a lot of time or fix an issue they are having.  There is this tangible relief you can see (or hear if you’re on the phone), that is very gratifying.

2.       In 2010, you wrote the book “Microsoft GP 2010 Implementation” what were your inspirations for writing it? 

This may sound a bit corny, but Dynamics GP as well as the GP community were both inspirations for me.  Dynamics GP because I think it an amazing product and the community for being so dedicated and friendly.

3.       Was there anything that you found particularly challenging when you were writing your book?

 I don’t really consider myself a good writer, and as hard as it may be to believe, after all the writing I have done, I do not particularly enjoy writing.  The incredibly positive feedback I have received on my blog, as well as to my online GP community posts, have convinced me that writing is actually something I can do fairly well, but that is definitely a challenge I had to overcome while writing my book.  Finding quiet time to concentrate on writing was another challenge.  I did not take time off to write my book, so all the time had to be carved out around an already hectic schedule.  The staff at the Packt Publishing really helped with this by providing a schedule and guidelines while being flexible at the same time.

4.       Are there features or modules that you wish Microsoft Dynamics GP has but doesn’t have currently?

Of course, the short answer to this is “yes”.  I don’t know if it is ever possible to be 100% satisfied with any piece of software, there is always something more that can make it better, some feature that can save time or better address common requests.  One thing that comes to mind from a recent customer question is the ability to enter prepayments against Purchase Orders.  I believe that would add some nice functionality for a lot of users.

5.       How do you think the partner channel will have to change over the coming years?

I am concerned about the direction that the Dynamics GP partner channel has taken with all of the recent changes.  My belief is that the best way to address a mix of small and large customers is with a mix of small and large partners because a company like Microsoft simply cannot directly support a product like Dynamics GP without the help of the partner channel.  While I understand that at some level this is a revenue game and that decisions have to be made for all partners and customers as a whole, what I see is that smaller GP partner companies being systematically phased out or forced to merge with other companies to continue to do business.  This as a move in the wrong direction and if it continues, it would be a big loss to the Dynamics GP partner channel and community.  Hopefully, Microsoft will realize that a partner channel comprised of only large companies is not the right approach for a product like Dynamics GP and what may mean more revenue short term could easily translate into less customer satisfaction and thus less revenue long term. 

 6.       What do you think the future holds for Dynamics GP? 

I think that Dynamics GP as a product will continue to be a great solution for many businesses.  We’re seeing a lot of new functionalities talked about, especially with the web client announcement for the next version.  It will be exciting to see what the future brings. 

You can visit Victoria Yudin website here: http://victoriayudin.com/

Natalie Williams, Marketing Coordinator, WebSan Solutions Inc., a Canadian Certified Microsoft Dynamics Partner

Published in WebSan Blog