Archive for the ‘Microsoft Dynamics GP’ Category

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

5 Reasons to upgrade to Microsoft Dynamics GP 2010

Thursday, November 10th, 2011

Each time I write a blog about Microsoft Dynamics GP I become more familiar with the features and benefits that they offer. After reading information about it, I was asking myself “If I already have financial accounting software, why would I switch?” So that’s why I’m writing this blog for those who asked the same question as me. There are about 50 reasons why you should upgrade, but I’m only listing five. These are five reasons to upgrade to Microsoft Dynamics GP:

1. Better Analytics Option:

With Microsoft Dynamics GP you would have the option of targeting your onlookers with specific data with access to about 100 Microsoft SQL server reporting services.

2. Quick Access to insight you need:

Your employees can customize their KPI’s and dashboards. It would now be easier to work with the information you need based on your position.

3. Integration with Excel:

Create analysis by using report builder. You can use lots of data sources to build from more than 200 Microsoft Excel reports.

4. Increase Relationships:

Enhance your relationship with clients and vendors by using instant messaging that Dynamics GP 2010 offers you with you also can hold live meetings with video and audio.

5. Track data with mini applications:

Create business applications without the annoyance of writing new codes and there’s no hassle of looking for information spread throughout multiple sources.

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

Evaluation Tools

Wednesday, November 9th, 2011

In 1983, Quaker Oats purchased Gatorade, transforming it from a multi-million dollar business into a multi-billion dollar business.  Fast forward a decade & Quaker decided that another drink manufacturer was primed for the same growth.  This time, Quaker eyed a takeover of Snapple, a popular fruit beverage.  After paying a large ransom for the Snapple business, Quaker did not see the returns it had forecast.  The Snapple brand fizzled as Quaker resources were washed down the drain.  Eventually, the Snapple brand was sold at a $1.4 billion loss to Quaker.

What went right with Gatorade that went so wrong with Snapple?

The measurement tools that Quaker used to evaluate Gatorade were both accurate & appropriate.  However, in the decade that past, these same evaluation tools were not updated.  Quaker applied the same methods & metrics to the Snapple brand that they did to the Gatorade brand.  However, in the decade that had passed, these tools were no longer the most appropriate.

Evaluation mechanisms are constantly being updated.  What works today might leave you behind tomorrow.  Quaker found this out first hand.  If companies want to continue to thrive, they must be constantly tweaking & evaluating the tools they use to evaluate their business.

Microsoft Dynamics GP leverages ever evolving Microsoft technologies in order to provide the best reporting options possible.  Users can access reports in many different formats.  Business Alerts can send automated emails to any staf member when exception criteria are met or at specific intervals.  Emails can be configured to include attachments, including lists of applicable information.  Users can have similar automated Reminders open on their screens when specified criteria have been met.  This allows for fast & automated management by exception.

To Do lists & Check List force users to complete tasks periodically in a structured way.  Meaning, no longer are workflows undocumented or dependent on a single employee.  If an employee leaves the organization, those same tasks must still be completed.

Standard reporting is available in paper format as would be expected.  Users can further use inquiries to research linked transactions if auditing information.  The same information can be exported to Excel or Word at the click of a button through a Smartlist.  These can all have filters applied to them to restrict the information that is displayed.  However, where Dynamics GP takes things a step further is SRS Reporting.  Smartlists can live on the server in the form of an Excel Report.  These can contain, charts, graphs, lists or whatever one’s heart desires.  These reports are linked to the server & the Dynamics GP database through Excel, meaning information is constantly changing on them automatically as data is entered into Dynamics.  And the best feature is that those who wish to view these reports do no require a Dynamics GP user license as they are not actually logging into GP.  The same premise applies to SRS (or SQL Reporting Services) Reports.  These are built through regular SQL statements & can include filters, etc, just like any SQL query would have.  Data can be displayed in many different formats & again, do not require a license to view.

The evaluation tools offered by Microsoft are beyond comparison & constantly evolving.  those utilizing Dynamics GP are always in the know & won’t be left behind.

Pie Chart

Adam MacIntosh is the Senior Project Manager with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems. You can contact Adam at Adam.MacIntosh@WebSan.com or at 416-499-1235 ext. 213.


Clearing up Confusion around Word Templates in Microsoft Dynamics GP

Tuesday, November 1st, 2011

The arrival of Word templates in Microsoft Dynamics GP 2010 was welcomed by many GP users who were tired of trying to create documents in Report Writer. Unfortunately, Word templates do not replace Report Writer. In fact, Word templates are built on Report Writer documents. Despite this, there are still a number of clear advantages to Word templates.

Word templates are much easier to work with when it comes to design. Many users are at least familiar enough with Word to modify tables, headers and footers to create clean layouts. Word is also much more robust than Report Writer in the design department. Fonts, images, colour, and shading can quickly and easily be modified or added to GP documents. With customized documents, users can skip attempting to fiddle with layouts in Report Writer. Instead, the XML behind custom documents can be imported into a Word template, and the layout and design can be set there.

Another advantage to Word templates comes in their deployment. Report Writer documents are stored locally, and if other workstations need access to these documents, shared folders need to be set up, and the DYNAMICS.SET file needs to be modified to point to the shared location. Every time a new workstation is created, the SET file needs to be modified. When using Word templates, the documents are stored centrally within the back-end database so that all users have access at all times.  This can speed up and simplify the deployment of a Dynamics GP instance. It also works fantastic in a hosted solution.

By: Tom Ross, Application Specialist, WebSan Solutions Inc.

A fool-proof method in order to prevent ERP implementation failures

Friday, October 21st, 2011

If your company wants to implement a new ERP solution and you’re looking for the right partner, are you going to pick the first one that offers you the price you want? I would compare it to being blindfolded, and told to walk in the street, are you really surprised you got hit by a car? It’s your responsibility to conduct research on the organization that you’re doing business with because you could be a victim of unrealistic expectations and inaccurate estimations.

Vendors, who are in it to urgently to make a sale, will tend to tell you that their software can be done in a quick manner, with an affordable price with little to no risk. Hearing that is a company could possibly have you sold on that idea, but if it sounds to go to be true it probably is. Next thing you know by the end of the project, your tens of thousands dollars over budget and your expected launch date keeps being pushed back.

Would you go to the doctors and get prescribed a prescription, without getting a checkup first? That’s basically what a diagnostic is, letting you know that you have a cold and then giving you medicine to cure your cold.  It lets you get familiarize with the company that you’re doing business with, they will also discuss your needs and goal so they and yourself  have a clear understanding of what will be done. You also want to ensure that you know where your money is going to and how long it will take to implement everything. You might think that you’ll save on money not doing a diagnostic but on the contrary, it will cost you in the long run especially if a vendor and/or system integrators don’t know enough about your project and are just in it for the win.

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.

Now is the best time to switch to Microsoft Dynamics GP

Friday, October 7th, 2011

With all the features Microsoft Dynamics GP has I don’t see why you wouldn’t switch. It’s easy to learn and use, and it keeps important information from falling in the cracks. But you might say “I don’t want to reeducate my employees, it would take long for them to be retrained.” I can understand why that would be a problem. But Microsoft Dynamics GP helps you reduce training time because it works similar to software solutions you already have, like Outlook, Word and Excel. Most users only need to learn the navigation required of them to complete the task they are assigned.

Do you know that 81% of people are more likely to complete successful business process flows in one single application? Dynamics GP is designed to give users a one stop shop for all the access that they need on a daily basis with reminders, quick links and KPI’s. It ultimately helps prevent small problems from becoming big problems and it allows you to focus on important tasks. To describe Microsoft Dynamics GP in one sentence would be: “Keeping it simple but giving you everything you need.” That’s why now is the time to switch your business solutions to Microsoft Dynamics GP.

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