Call us today: (866) 4-WEBSAN (932726)

Archive for the ‘WebSan Blog’ Category

SSRS Reports in Dynamics GP

Wednesday, December 21st, 2011

For some of the more technical Microsoft Dynamics GP users, you may want a little more control and customization when reporting on your GP data.  SmartLists provide a fairly quick and dynamic option to custom reporting, but they may not be visually satisfying.  On the other hand, integrating BI360 with GP will allow you create very clean and organized reports in an Excel-like environment, but won’t give you that rudimentary control that your technical mind may crave.  If you’re looking for some sort of middle ground between these two options, take a look at SQL Server Reporting Services (SSRS) for Dynamics GP.

The key to creating effective SSRS reports is having a good knowledge of SQL – or at the very least, a fairly strong knowledge of databases.  This is what scares away some users, but for those that have this type of background, SSRS Reports could be your salvation in the pursuit of both visually appealing and fully customizable reports.

While SSRS Reports can be easily viewed within Dynamics GP, they are created in Microsoft Report Builder – a separate software program that is offered for free by Microsoft.  Using Report Builder allows you to take a custom SQL query that you have created (either from scratch or by using Report Builder’s intuitive Query Designer) and turn it into an appealing report.  With the ability to easily create tables, charts, and even visual scales/gauges, you can turn a simple list of data into a work of art!

If you have SSRS Reports deployed in your GP environment, you can view them by going into any series and selecting the “Reporting Services Reports” item in the Navigation Pane.

SSRS Reports in Dynamics GP

SSRS Reports in Dynamics GP

By: Rahim Jiwani, Application Specialist, WebSan Solutions Inc.

The Pros and Cons of Online Accounting Software

Thursday, December 1st, 2011

Buying accounting software is a big decision you have to make when the time is right for your company. It’s a harder decision, especially when you’re a small business owner and you don’t have much skill in accounting. Some people might wonder if online accounting software is for them. What I’m going to do is point out the pros and cons of inquiring online accounting software. Hopefully some of these pros and cons will give you an idea if it’s for you or not, make sure you do your research and find the right accounting software for you.

The Pros of using online accounting software:

  • Some software’s are very straightforward to use even though you don’t have much financial knowledge. Their job is to help especially small business owners with the necessary tools to operate their business.
  • It’s easy to make updates because it can be done automatically.
  • You can check up on your financials everywhere and anywhere you are, because of the fact that all of your finances are online.
  • The software company has online support just in case you need a question to ask, or if you have a concern that needs to be looked into, so you never overwhelmed with software that you don’t understand how to use it.
  • Accounting software’s have mechanisms to back up your data so if there’s a problem with your account at least nothing has happen to your data.

The Cons of using online accounting software:

  • There’s still the risk of hackers getting in the software systems, it is only a slim chance because these software have a lot of security protection. But there’s always a possibility.
  • Make sure you have an up-to-date internet connection because if your computer is really slow running, well so will be your accounting software.
  • Mobility is a good thing about online accounting software but be careful if you ever have to log in a public computer or even a friends computer make sure you log off properly because you don’t want just anyone looking at that information.

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

Two cloud based services offered by Microsoft Dynamics GP

Wednesday, November 23rd, 2011

A while back Microsoft offered two new cloud based services that can be very beneficial to your company if you are already in the cloud or if you’re planning on moving to the cloud.

Microsoft has announced the first two accounting offerings for Dynamics GP 10.0 and GP 2010. Payment services and commerce services are the new two new services that are cloud based. Payment services has credit and debit card that is processed from Dynamics GP. Payment services works with: VISA, MasterCard, Discover Card, American Express and PayPal. The good part about it that there will be the same existing data entry screen and you don’t have to install or integrate new software and your customer benefits from this service because they have more options to make payments.

A commerce service has item catalog functions also with integration to Dynamics GP, using the same tool used to connect Dynamics CRM to Dynamics GP. This service is to support a business to consumer website it also allows you to extend your sales reach.  The great benefit about commerce service is that you can expand your sales across different channels and enabling online shopping therefore using another resource to increase your sales.

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

What is Microsoft FRx?

Friday, November 18th, 2011

I’ve recently seen “FRx” come up when I’m doing searches on Google. I do a lot of searches with things that have to do with Microsoft Dynamics GP. I’ve become very curious about what FRx is and why does it keep appearing when I’m searching for different things. I’ve found a good definition of what FRx is and how it’s used in Microsoft Dynamics on the Find Accounting Software website. In this blog I’m going to do a simple summary of what FRx is.

Microsoft FRx is a reporting application that gives a company complete control of the reporting process which ultimately saves you money on Information Technology support. This application is best utilize by mid-size companies, it has interfaces for more than 50 industry leading financial accounting software systems. It also offers Microsoft Integration Designer 2.0 which allows Microsoft FRx 6.7 to be used with a general ledger package. This application is great for various skills and positions in the accounting field because FRx creates valuable and precise financial reports.

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

6 things you need to consider before you begin your ERP implementation: Part 2

Wednesday, November 16th, 2011

If you haven’t read part one of this blog please click the link to get caught up!

If checklist one through three gets a check mark, you’re on the right track to avoiding as little problems as possible. Number four on the list is something that you must be responsible for because, you can’t blame all ERP implementation failures on the other company. Sometimes when a partner gets a client and there ready to kick start there plan, the clients give them all their “baggage” to fix and then leave. They eventually come back at the end, near the go-live date and say things like “Are we ready to go live yet?” Have you tested the system? Nope. Has your staff gotten trained? Nope. Then the answer to your question is nope. You don’t want to be that kind of client. Therefore make sure the implementation goes in steps or phases, and make sure to have regular follow ups on the progress that has taken place.

Be motivated! Sometimes implementations take a while to finish, you might checking off each suggestion on the list but when you come to number five you realize that what’s your lacking in. You need to be upbeat about this whole process, I’m not saying jump up and down and scream for joy that you are getting new accounting software. But at least have a good attitude towards the implementation; I say this because getting something new isn’t always a good thing. You have to retrain your staff; get familiarized with a new system and implement it to your company. That can be a bothersome to someone resulting in them giving you a hard time. As the client, be positive and have a good outlook on this new system, which could ultimately better your performance in the long run.

Last but not least number six on the checklist is to plan for everything and anything that could happen. Once one to five is checked off, be aware about number six. Even though you have everything planned to a T anything could happen from employees’ issues to company changes. Just be prepared for whatever can happen because even though you might be well prepared when it comes to the implementation there’s always a chance of a problem that could occur. You can’t predict and prevent everything but give yourself a fighting chance if a problem arises.

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

Shortcuts to Customize Your Microsoft Dynamics GP Home Page

Tuesday, November 15th, 2011

If you are a frequent user of Microsoft Dynamics GP, chances are you use a select few windows much more often than others.  If this is the case, you may find it helpful to have shortcuts to these key windows directly on your home page.  These shortcuts can be added in several different ways:

  1. Quick Links – Arguably the most popular method is to add the window to the Quick Links pane of your home page.  To do this, hover over the Quick Links pane, select the pencil icon that appears in the top right corner of the pane, and click the Add button to add new links.  Don’t forget to refresh your home page if the new link does not appear right away.
  2. Navigation Pane – To add a shortcut to your navigation pane, open the window that you want to link to, select File, and select Add to Shortcuts.  A link to that window will now be added to your navigation pane when you are on your home page.
  3. Toolbar – To view the toolbar for a particular series, right-click the blue menu bar at the top of the Dynamics GP screen and select the desired series so that a checkmark appears next to it.  To customize which icons are on the toolbar, right-click the blue menu bar again, select Customize…, choose the appropriate series from the drop-down menu, and click Add to add a new icon to the toolbar.

Shortcuts to Customize Your Microsoft Dynamics GP Screen

By: Rahim Jiwani, Application Specialist, WebSan Solutions Inc.

6 things you need to consider before you begin your ERP implementation: Part 1

Monday, November 14th, 2011

I was reading on an article called “Six Basics of preventing pain in our ERP implementation” and I thought to myself, why are all these problems with ERP implementation occurring in the first place? It’s happening more than normal and I think I know why, Companies are not doing enough research therefore they choose the wrong partner and software. Here I have a checklist of six rules you should consider before saying yes and signing the dotted line.

Really research thoroughly about which partner would be the right partner for you and which software would be the right software for you. Even if you have ten companies and have to narrow it to one then do that. If you’re searching on Google “accounting software” there are millions of results that come up, I know that can be overwhelming but don’t choose only the top three results. Some people think that the top three results are the best results, but that’s completely untrue. Google doesn’t rank you higher based on your product or services quality, they rank based on search engine optimization, keywords and links. But that’s another blog; basically what I’m saying is take your time to do your homework.

When you find the right partner and software, make it clear on what you expect from your partner. Have a one on one sit down with the company you will be working with, there needs to be impeccable communication between both companies. Make sure you listen to their expectations and make sure they listen to your expectations, because if one person’s not listening the project is bound to go wrong. Even if you have to take notes, you need and they need to fully understand the expectations of the project. That’s to prevent sentences like: “I never said that”, “But I thought you said…”, “I told you that, remember?” Also it’s good to get everything in a tight sealed contract so you can also avoid those phrases.

So once you’ve found the right partner and you found the right accounting software and there’s clear understanding amongst both companies, make sure they don’t go anywhere. Sounds weird enough, but I’m not joking, whoever is in charge of your project make sure they stay in charge of the project. The reason this is on the list is to prevent your partner from doing a 180 on you. If you have one project manager that is in charge of the project, if there’s any hiccups in the implementation you can go straight to that person to address the problem. If there’s no one particular in charge of the plan, you’re only going to get the run around when a problem occurs because no one’s in charge. Another reason it’s on the list is because if the company switches the manager, you would have to communicate every single detail about the project all over again hoping that they can comprehend it  and execute it all in a short matter of time.

Tune in to part two and see the rest of the checklist!

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

5 tips for maintaining Microsoft Dynamics GP

Friday, November 11th, 2011

You finally have Microsoft Dynamics GP and now you are ready to explore the wonderful world of online accounting software which is good and all but while you’re having lots of fun using the different applications it provides, don’t forget that you have to maintain it! Here are five tips to help you maintain Microsoft Dynamics GP.

1. SQL Backup

Make sure you create SQL backups of every database on your server. It’s recommended that you performed full backups or you have the option of full backups with transactions log backups, but it’s ultimately your choice. You also need to back up Dynamics databases, Company (s) databases and Model database.

2. File Backup

SQL aren’t that only backups that you have to do, don’t forget the other multiple files that need backing up to. For example any folder that ends in dic, set or config and all the other folders including sub-folders. The <DATA> folder is included in the backup process as well as Dex.Ini that is located in the <DATA> folder for example OLEPath, OLEPathHR, Word Macro File etc.; I have one more suggestion, backup any files in the manuals of any add-on products.

3. Schedule your backups

Schedule backups for SQL and Files as needed. But remember the more backups you have the more chances that if information were to get lost it would be low. You should have automatic scheduling for backups. This is to ensure that backups are completed, don’t believe me? Check the transaction log because it keeps record of backups done.

4. Monitor your backup jobs

Keep track of the backups that are being done, even if you have write it down in your calendar. It’s just to make sure everything is going smoothly. A really good thing about Microsoft Dynamics GP is that you can program your SQL server to notify you if the backup fails.

5. Test your backups

Even though you can automatically schedule backups, once in a while test your backups just to make sure everything is getting backed up. A good way to test a SQL backup is to restore the backup to another server.

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

Reporting on Microsoft Dynamics GP

Friday, October 21st, 2011

A lesser-known method for reporting on your Microsoft Dynamics GP data is through Solver’s BI360.  BI360 is an Excel-based business intelligence tool that offers out-of-the-box integration with Dynamics GP for reporting, budgeting, and dashboards.  It offers several key benefits to users:

  • Familiar Environment – BI360 is an Excel add-on, which means all of your reporting is designed and displayed in the same Excel environment that you are already accustomed to.
  • Simple Design – No SQL knowledge is required to design your own report or budget in BI360.  It’s a simple drag-and-drop interface that allows almost anyone in your organization to develop customized and effective reports quickly.
  • Integration – BI360 automatically integrates with your Microsoft Dynamics GP environment and pulls data from GP in real-time when generating reports, so you never have to worry about synchronization.
  • Easy Distribution – not only does BI360 give you an easy and effective medium to design and view custom reports, but also allows you to easily distribute static versions of your reports to non-BI360 users.

In a nutshell, BI360 is a simple tool that provides powerful Dynamics GP reporting in a familiar environment – what more do you need?

By: Rahim Jiwani, Application Specialist, WebSan Solutions Inc.

Are IT projects really ticking time bombs?

Friday, September 30th, 2011

I recently read an article in the Toronto Star titled “IT projects are ticking time bombs.”

The article cited a study at Oxford University where they found that 17 percent of IT projects were so mismanaged that they had “average cost overruns of 200 per cent….”

After reading the article, I spent some time thinking about the IT projects I’ve been involved in over the years, from the large, multi-million dollar SAP projects to the smaller, 5-15 user Dynamics GP projects. I’ve had my share of smooth go-lives and my share of “rough” projects. One common theme with the projects that run smoothly is that an unbreakable link exists between the project team and their vision of what they’re working on and the overall business goals for the project.

It’s somewhat human nature, really. If we understand the “why” of what we’re doing, then the “what”, and “how” are easier to understand and “get behind.” I’ve seen projects with great potential and a really strong business case go off the rails because the executives didn’t effectively communicate to the project team what the real goal was. If the project team and leaders have “context” by which to understand the purpose behind the project, the odds of success rise dramatically.

There are obviously numerous other factors that affect the outcome of an IT project (which I’ve written about in the past), but I come back to executive involvement and leadership as the #1 factor in project success.

I’ve even seen “rough” projects continue off the rails for months and even years until a new executive comes on board in the company to “take charge” and rally the troops around fixing the problems that exist. In fact, it amazes me every time how rapidly the issues actually get resolved, once a strong leader puts their weight behind identifying the problems and assigning clear accountability for their resolution.

One of the things I look for when selling software to a new prospect is a strong leader. We even had a Client executive bring his entire team to our office this week just to “see the whites of our eyes” and have his team meet ours before moving forward with us. To me, that’s a sign of a strong leader who understands what it takes to deliver a successful IT project.

So perhaps some IT projects are ticking time bombs, but all bombs can be diffused by the right person with the right tools and attitude.

By Andrew King, Managing Director, WebSan Solutions Inc.