Top 10 Tips and Tricks for Microsoft Dynamics GP

Andrew King, Managing Director at WebSan Solutions shares 10 different tips and tricks about Microsoft Dynamics GP. Watch the following video to learn more:

 

WebSan Solutions offers an online (SaaS) hosted-enterprise business software solution, leveraging the vast capabilities of Microsoft Dynamics GP. For more information, please contact us.

Doriana Kote, Marketing Assistant, WebSan Solutions Inc., a Channel Elite Awards Finalist for 2013

  8420 Hits

Data Security in the Cloud

The most arguable myth about cloud ERP solutions refers to organizational data not being as secured as in an on-premise solution. In fact, SaaS security and privacy of data has proved to be customers’ biggest concern.

The top 4 most important issues about data security in the cloud are:

1. Your data storage location

This issue is related to the physical location of the data. When it comes to cloud ERP vendors, their data centers are housed in multimillion dollar facilities and have a 24/7 security all year long. After all, most cloud providers are actually better with physical security than an onsite solution vendor because they don’t have a lot of staff hanging around the facility. Thus, they are able to control physical access to various parts of the office space.

2. Who has access to your data and when

Continue reading
  8645 Hits

5 Useful SQL Features for Microsoft Dynamics GP

When organizing your business’ data and sorting through multiple categories and headings, it’s easy to get overwhelmed with the time-consuming process. Structured Query Language (SQL) used in Microsoft Dynamics GP serves to retrieve information from databases through the use of basic statements and clauses. Here are some SQL features that can help you sort through data quickly in Microsoft Dynamics GP:

  • Select clause – Allows you to pull and read data from the database. Often using the Select * format, this statement enables the user to select data from columns and tables such as a list of customers.
  • Where clause – Used to filter your list based on a certain condition, such as to specify a customer’s country or location.
  • Alias syntax – Enables the user to rename a database table or a column in a table. This function becomes especially useful when there are multiple tables in a query or when column names are long and not easily readable.
  • Join clause – Helps to combine and add more columns in your data. The join clause is often used to combine fields from two tables by using values that are common to each. 
  • Group by clause – Allows you to compress, consolidate and summarize data. This clause is used together with aggregate functions to group a result set into one or more columns.

To learn more about SQL queries and common functions in Microsoft Dynamics GP, register for our online course! 

Register for SQL 100 course in WebSan University

 

Linz Tan, Web Marketing Assistant, WebSan Solutions Inc. a 2014 Ontario Business Achievement Award Winner for Service Excellence.

  7518 Hits

WebSan Solutions Offers Dynamics GP On Any Tablet Device

WebSan Solutions, the largest Canadian Cloud Dynamics partner, offers users the ability to access Dynamics GP on a tablet. Customers now have an alternative way to access and create accounting transactions, without having to log in through their desktop computers.

“We see this as a natural extension of our Cloud Dynamics offerings. No other partner has made the commitment that WebSan has to provide this much flexibility to our customers,” says Andrew King, Managing Director of WebSan Solutions.

As long as there’s an active Internet connection, users would be able to use all of the capabilities of Dynamics GP, which also includes exporting SmartLists to Microsoft Excel with ease. WebSan’s Cloud Dynamics GP solution  allows users to quickly and securely access Dynamics on-the-go using Android, iOS and Windows devices.

An element that makes Dynamics GP on a tablet even more valuable is the feature that lets users print and email documents (i.e. Invoices) on the fly.

The ability to provide access to critical financial information to executives on devices other than a computer is important to a business. Get the insight you need to manage your business and improve the decision-making process by making it portable. 

Continue reading
  7385 Hits

Are you really considering Total Cost of Ownership (TCO) when evaluating Software as a Service (SaaS)?

These days, everyone is throwing around buzz words like “Software as a Service” or “Hosted” or “Cloud”, but how do I really go about calculating the total cost of the solution and whether to choose “the Cloud” or on-premise (traditional) solutions?

There are a number of cost figures to include :

1.       License fee

2.       License fee for upgrades

3.       Maintenance costs

Continue reading
  7388 Hits

Cut down on IT spending by using Software as a service

We all know that the economy is not in the best shape. Some companies are forced to downsize due to insufficient revenue in these times. Anywhere that they can cut cost is a benefit to them, that’s why many companies are now deciding to use Saas (Software as a service). Just because a company may be downsizing doesn’t mean their data and files do, so they still need software to store their information. The great aspect about Saas is that instead of spending money on hardware, installation and maintenance you have the advantages of having your company records, data and information web based.

If you can save money in you IT spending and still have the advantages of data being backed up, disaster recovery and long term record retention, wouldn’t you do it? But maybe you’re a smaller company and your IT department consists of only you. Then you should get your core business applications hosted in the “Cloud”. You still have access to everything in your database; the only difference is that it’s through the internet. Now you might ask, “What kind of software would be a good choice to leverage as a hosted solution?”

Microsoft Dynamics GP online accounting software gives companies the flexibility to customize the software based on their needs and requirements. It’s one of the most capable and sophisticated business accounting solutions for small to medium business, now available in the Cloud. No need to install software on users’ laptops or worry about keeping the system updated with the latest patch.

Investing in Online Dynamics GP is a good investment in your business; it puts your finance department on the same wavelength with other department and keeps your general ledgers, payables and receivables, budgeting, collections management highly organized.

For more information about Microsoft Dynamics GP click here

Continue reading
  7479 Hits

Who said Corporate Training has to be Boring

Wouldn't you like to look sharper than your competitors? Then training is what makes your employees stay within your company or stand out from those at another.

Corporate training is an extremely valuable resource because it gives your employees a sense of empowerment. Once you invest in programs to help them enhance their skills and boost their knowledge they will feel better about working for your company. In turn, this fact will improve company retention rates and is an excellent motivational tool.

WebSan University is taking corporate training to a whole new level by offering live, instructor - led online courses. For more information on WebSan University and our upcoming course Microsoft Dynamics GP General Ledger, visit our website or contact us here.

Doriana Kote, Marketing Assistant, WebSan Solutions Inc., a Channel Elite Awards Finalist for 2013

  8118 Hits

Why is Enterprise Software so important for Small to Medium Businesses?

I encounter prospective Clients every day who ask me: why?

  • Why do I need a new system?
  • Why do I need to invest in new software?
  • Why WebSan?

I cannot come up with "one-size-fits all" answer for everyone, but what I can tell you is the following:

  • Companies that leverage Enterprise software to run their business see a significant improvement in their financial performance. This can manifest itself operationally in many ways, but typically it's a reduction in outstanding Receivables, growth in operating margin and lower overhead resources in the Finance and administration departments.
  • According to a recent Aberdeen© report, best in class companies saw:
    • 22% reduction in operating costs
    • 20% reduction in administrative costs
    • 17% reduction in inventory
    • 19% improvement in complete and on-time delivery

Organizations are always looking to be more competitive and reduce costs. A solid investment in technology with the right Partner can make all the difference in the world.

WebSan Solutions Inc. is a Microsoft Dynamics Certified Partner specializing in MS Dynamics GP and Hosted MS Dynamics GP. Dynamics is a top-rated Enterprise software system that has over 40,000 installs in North America.

Contact us for inquiries.

  6506 Hits

WebSan University Online Training is Here

WebSan University officially opened its doors to the public and takes WebSan Solutions webinars to a whole new level. The program consists of a series of extensive Microsoft Dynamics GP courses, from Bank Reconciliation to Project Accounting and is making its debut on July 25th, 2013 with its first course “Microsoft Dynamics GP Orientation”. In this introductory course new users will learn the basic principles of navigating and personalizing important areas of Dynamics GP as well as posting and integrating with other applications.

Why Online Training?

  • Immediate, cost- effective and easily affordable
  • Corporations save between 50-70% due to elimination of travel expenses according to Training Magazine
  • ROI to the Max - Affordable online training can be up to 93% cheaper than classroom training
  • Multimedia content, including dynamic video and graphics to efficiently illustrate key concepts
  • A new, easy and interactive way to learn.
  • Focus on the practical application of new approaches and tools
  • Contains applied work assignments that put learning into action
  • Ability to answer questions live

For more information on WebSan University Online Training and our upcoming courses, visit our website or contact us here.

Doriana Kote, Marketing Assistant, WebSan Solutions Inc.

  8163 Hits

What you gain from Business Intelligence (BI) in Microsoft GP

A CEO plays one of the most important roles in a business and has a tremendous amount of responsibility. So some people may say, “I would never want to be a CEO, it’s just too much”. But I say, “If you increase your business intelligence using Microsoft GP, it is a breeze.” Now you’ll have more knowledge to:

Make better business decisions

  • You don’t have to solely rely on advisors, consultants and employees because you have educated yourself about what’s been going on in the company.

Use a tool you are already familiar with to reduce operational costs

  • With more than 200+ built in Excel reports it is easier to observe changes in the company and react to market conditions rapidly.

Achieve your budget and forecast targets more consistently

  • Productivity improves because budgeting will be more accurate and planning will be more organized.

Be notified about key changes in your business rapidly

Continue reading
  7394 Hits

US Court Announces That Cloud Companies In The EU Should Hand Over Their Data

The US Court announced recently that all European Hosting Providers are obliged to hand over ALL their data to the US government. According to US Magistrates court judge James C. Francis, internet and cloud companies must turn over all information to US government agencies on demand, regardless of where the data is held.

This means that even if you use a European Provider to host your services, the law might still apply to your case if the provider's data centers are located in the USA. You can read the full article here.

After the NSA revelations and their surveillance activities, this announcement adds an an additional concern for those companies in the European Union that consider working with a US hosting provider or anyone in their country that utilizes US data centers.

The good news is that Canada is not affected by this announcement and you can securely choose a Canadian cloud hosting provider, without worrying about leaking your confidential information.

WebSan Solutions can help you by offering Dynamics GP Hosting Services through our Partner Program. Also, if you are a Microsoft Partner and only offer Dynamics GP on-premise, we can help you serve new clients efficiently. Plus, WebSan offers you peace of mind by hosting your data securely in our SAS70/SSAE16 certified data centre in Toronto, Canada.

Continue reading
  8133 Hits

Avoid Disaster in the Cloud

Disaster recovery is often neglected until an actual disaster occurs.  A number of people assume it will never happen to them.  We don’t drive cars without insurance, so why compute without a disaster recovery plan?

Well enter the cloud with hosted Microsoft Dynamics GP

Access to files & reports when you want them.  Take the worry out of disaster recovery.  Accessing your ERP over the net has never been more secure, convenient or faster.  When you enter the cloud with WebSan, we ensure the highest level of disaster recovery.  We have redundancy upon redundancy to protect your data.  From protection against power failures to floods to fire.

Never worry again about a service disruption.

Adam MacIntosh, Senior Project Manager

  10769 Hits

Enter the Cloud - Stay on Top of Your Business

Cloud computing is the latest & greatest innovation in the technology industry & for good reason.  I previously discussed how cloud computing takes the worry out of disaster recovery.  Another way cloud computer helps take strain off executive shoulders is that it helps your company avoid service disruptions often associated with service updates.  Imagine never worrying about having to upgrade your software.  Imagine it was just done for you, with no downtime, disruptions or worry.  That is what the cloud offers.  At WebSan, we offer hosted Microsoft Dynamics GP for a number of client, taking care of necessary service packs, system updates & necessary maintenance that comes along with owning an ERP system.  By taking advantage of Saas Dynamics GP (or software as a service), customers can stay focused on their core competencies.  Hosted solutions allow clients to scale up or down as the market dictates without & overhead burden often associated with on-premise solutions.  Lastly, they don’t have to worry about having a full-time IT resource to help with issues where one might not be required.

WebSan is a Microsoft Partner offering hosted Dynamics GP to clients big & small.

Adam MacIntosh, Senior Project Manager

  7466 Hits

Big Data and Business Intelligence (BI)

Nowadays business professionals have access to a vast variety of technologies and sources of information. Big data is growing fast as organizations devote technology resources to tapping the terabytes of data flowing into their organizations and externally in social media. Thus, a major challenge has come up recently: how to leverage Big Data analytics and improve business performance by using current Business Intelligence (BI) practices?

The current thinking around big data and business intelligence tends to be built around a very simplistic model. You acquire lots of data, in all kind of formats, from a myriad of sources, apply some business intelligence and get your answer to the above question. However, executives thinking that a big data dive is all they need to exploit conclusions are mistaken. While big data might be getting ahead of itself in enterprise promises, you need to think about the skills you have in your company and develop the relevant data skills to adapt to this new model. At the same time, BI kills the need to develop, administer and analyze this huge amount of corporate data. Therefore, big data and BI can be integrated within the business context for better, faster decision making.

Keep in mind, though, big data can make or break a company. Integrating advanced analytics for big data with business intelligence systems is an important step toward gaining full return on investment. That is, BI systems and advanced analytics can be highly complementary; the latter ones can provide the deeper, exploratory perspective on the data, while BI systems provide a more structured user experience. In addition, BI systems’ richness in data visualization and reporting can be vital to making advanced analytics actionable.

The first step to understanding big data is collecting all of your data into powerful, integrated solutions. The second step is to identify correlations with your data to make improvements in your operations and find new opportunities. Microsoft Dynamics GP Business Intelligence (BI) module provides people with the insight they need to take quick action and pursue opportunities. What is more, using a single software solution, like Microsoft Dynamics GP, will make it easier for you to find and use the important business data you need to drive your business forward.  The more efficiently you use this data, the faster you can respond to new opportunities.

At the end of the day, while big data is a hot term, it doesn't mean much unless you can complement them with BI systems and expand their power. Thus, big data can be very helpful if you can wade through it to obtain meaning, i.e. they always have to make sense. It's not enough to gather accurate and timely data. Professionals need powerful and user friendly BI analysis tools to help them understand context and trends. You need to focus on evolving your BI approaches and integrate them with big data analytics to fuel faster and more accurate decision making. In this way, you will be able to gain a competitive advantage by understanding how big data can supplement the outcomes already achieved through “traditional” BI.

Continue reading
  10487 Hits

Enter the Cloud - Work from Anywhere

Tele-working or working from home is very common in today’s business world.  Staff at many companies have the ability to work from anywhere.  In fact, IBM has half its staff working from home, saving them valuable real estate, overhead & all that goes with having an office.  As a consultant, I am constantly traveling, but I am still able to stay in touch with the office through my Blackberry.  VPN’s allow many users to log into networks to access systems, emails, files, etc.

With cloud computing, the ability to work from anywhere is made even easier.  Through hosted Microsoft Dynamics GP, all staff need to access their ERP is an internet connection.  A CFO can easily review financial statements, in real time, from a Starbucks.  Imagine living out your days on a beach in the Caribbean, still able to complete necessary tasks.  With the invention of internet sticks that can plug into any USB, Operations Managers can carry a net-book or laptops with them & have the ability to complete sensitive tasks in an instant.  Sales staff no longer need a reserved desk at the office.  They can stay mobile, reaching more clients.  Even administrative staff could work remotely should the need arise as it did for many last summer with the G8 summit shutting down the core of Toronto.

WebSan Solutions is a Microsoft Partner offering Hosted Dynamics GP

Adam MacIntosh, Senior Project Manager

  9059 Hits

Frequently asked questions about the WebSan Cloud Dynamics GP Solution

I frequently receive questions from Clients regarding our Hosted Dynamics GP solution, so I thought I would publish our "FAQ" document on our blog for all to see. If you have additional questions, feel free to contact us and we can help you with any inquiry you may have.

Q: What is the cost of Hosted Dynamics GP?

A: You will need to contact us in order to discuss your requirements in a bit more detail so that we can provide you with a quote customized to your needs.

Q: Who owns the data?

A: The Client owns the data and WebSan Solutions owns the application as well as any customizations and/or enhancements made to it.

Q: Where is the data hosted?

Continue reading
  7293 Hits

Sales Order Processing in Dynamics GP

You can probably guess that GP Sales Order Processing is used to enter, print and post sales orders. But did you know that you can also enter quotes, invoices, back orders and returns individually or in batches?

Are you aware that Sales Order Processing in Dynamics GP allows you to transfer sales documents from one type to another? For example, when goods or services are delivered to a customer, you can transfer the order to an invoice. The price the customer will pay and your cost will be calculated automatically.

Here are a couple of points you need to keep in mind, before transferring a document:

  • Make sure there are actual quantities to transfer to an order, invoice, or back order
  • Verify that the appropriate transfer options are marked for the type ID in sales setup
  • Enter a batch ID for the document
  • Approve the document, if required

For more information about Sales Order Processing in Dynamics GP, join our webinar on November 14 and learn how to cut lead times and speed up your transactions.

Doriana Kote, Marketing Assistant, WebSan Solutions Inc., a Channel Elite Awards Winner for 2013

  9479 Hits

Factors to Consider When Choosing an ERP system

With the New Year fast approaching, your company has decided to adopt/upgrade to an enterprise resource planning (ERP) system. Congratulations! Making the decision to adopt/upgrade to an ERP system already puts you ahead of your competition.

An ERP system is a powerful tool that helps you efficiently analyze, interpret, and execute the core activities of each department of your business on a day-to-day basis. Companies who seek to adopt/upgrade to an ERP system do so in order to integrate the different programs they're using for different departments into one suite. An ERP system helps reduce costs because any previous delays or duplication of work is avoided. For example, a company may calculate their sales revenue using one type of software meanwhile using separate software to produce a financial report. An ERP system integrates the two actions whereby once the sales revenue is calculated, the ERP system uses the same information to produce a financial report. A benefit of having these separate processes integrated is that the same information flows from each department which results in less errors made, in addition to better business decisions made. Resources such as time and staff are reduced (not to mention the complexity) which boosts the company's bottom-line.

Other benefits and features of an ERP System include:
• Access to all the company's information across all departments in real-time
• Stronger customer relations through better access of customer information as part of your company's practices in customer relationship management (CRM)
• Improved controls at each stage of the supply chain
• Enhanced security with access to a single set of user settings to better protect your company's information
• Less training and implementation necessary because all staff are trained to use the same system

Consider the following when adopting/upgrading to an ERP system:

Costs & Benefits
• What is your budget?
• What is your firm looking to achieve?

Continue reading
  8633 Hits

Determining the Best Reporting Tool for the Job

There is no doubt that Microsoft Dynamics GP offers a wide variety of custom reporting methods that can enable anyone in your organization to get real-time reporting quickly and easily – whether it be SmartLists, Linked Excel Reports, SQL Server Reporting Services (SSRS), or Management Reporter (MR). As a report developer, typically it’s not too difficult to find the data that you need for a given reporting request – instead, sometimes the biggest challenge is just figuring out which reporting tool to use when creating the report.  I’ve found that there are a few key questions you can ask that can immediately narrow down your options for you.

Will non-GP users need access to this report?

If your answer is “Yes”, then SmartLists are automatically out of the question, as these can only be accessed from within GP.

Will users need to run this report for various scenarios?

If your answer is “Yes”, go with either SSRS or Management Reporter – these are the only 2 reporting methods that allow “parameters” that the user can play with before running the report.  These parameters make it easy for the user of the report to run it for a specific scenario that suits their needs.

Continue reading
  8001 Hits

Cloud Predictions for 2014

Cloud computing has become the rule and not the exception for applications in today’s business world. It is with no doubt the default IT platform and the reality is a lot of organizations use multiple cloud environments delivered within different platforms.

The challenge of managing these cloud environments in a consistent way has created the need for what is known as cloud brokerage. That is, a third-party, vendor-neutral business that serves as a single point of contact when working with multiple providers. Cloud service brokers help users benefit from best-in-class offerings from different providers, while keeping the back end simplified.

Another trend is to certify trustworthy cloud providers. Certified clouds will lead to better take up and wider use of different services with the assurance they bring. After the NSA revelations, there has been an increasing need for cloud security in the business world that can be reassured by cloud certifications. WebSan Solutions has already amplified the importance of security by maintaining its hosted Dynamics GP solution in its state-of-the-art Tier II SAS70/SSAE16 certified data centre located in Toronto, Canada.

Finally, cloud - based applications are gradually gaining ground against on-premise software. Taking into account there is a Google or IOS application for almost everything in today's business world, people can work on one device, either it is a desktop, tablet or mobile and then stop and pick up right where they left off on a different device in another location.

Doriana Kote, Web Marketing Coordinator, WebSan Solutions Inc., a Channel Elite Awards Winner for 2013

  9102 Hits
WebSan Solutions is a Gold Certified Microsoft Partner

Multi-Award Winning

Gold Microsoft Partner

Microsoft Partner of the Year

Dynamics 365 Business Central

Microsoft Canada Impact Award

Business Applications

Microsoft Inner Circle

Business Applications
WebSan is a Microsoft Solutions Partner

© Copyright 2024 WebSan Solutions Inc.WEBSAN is a trademark of WebSan Solutions Inc. Registered in Canada and other countries.