OCT
05

Field Level Security in Dynamics GP

Many companies have a need to grant Dynamics GP users access to a window, but not all functionality within that window.  For example, many clients will want users to be able to input invoices, but not post them individually.  Instead, they will force users to save invoice transactions to a batch such that a manager can review the source documents and post.  An easy way to achieve this is through Field Level Security which allows the Dynamics GP admin to restrict user access to singular buttons within a window (such as the Post button).

To configure Field Level Security, navigate to Microsoft Dynamics GP > Tools > Setup > System > Field Level Security

This will open up the Field Level Security window.  Within the window, select Add to create a new restriction.

[caption id="attachment_1442" align="aligncenter" width="300"] Field Level Security window[/caption]

This will open the Field Security Maintenance window wherein one defines a the window and field to restrict.  Within this window, enter an ID and Description for the restriction.  Then select the Product Name, Form Name, Window Name & Field Name using the look-ups within the window.

Continue reading
  14903 Hits
SEP
13

Source Document / Batch ID Naming in Dynamics GP

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

When a user posts an individual transaction in GP, that transaction will likely display in the Financial Series Post, saved to a batch with an odd, automated ID.  These IDs are auto-created by Dynamics GP & are based on the source document / originating module from which the transaction was posted.  Generally, the first 2-3 characters of the these Batch IDs are based on the module, with 3 or so more characters to identify the transaction type.  this is or course followed by a numeric counter.

If one reviews the Source Document listing in GP, that will generally tell them what all the abbreviations represent.  For those more technical, source documents can be found in SY00900 in the database.

Below, I have listed a number of the more common prefixes to an automated Batch ID and have noted the module which they represent.

 

Continue reading
  17649 Hits
AUG
31

Support Plans

WebSan Support plans are available for purchase online using PayPal and all major credit cards.  Enable your team to get the cost-effective support it needs.  Get started now!

 

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite 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.

 

 

Continue reading
  8499 Hits
SEP
21

Learn Dynamics GP on YouTube

Check out our YouTube page for great Dynamics GP Training videos and other informative tips!

 

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Winner.  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.

  7982 Hits
AUG
27

Online Dynamics GP Training

Want to learn more about Dynamics GP, enroll in one of our WebSan University courses.  Course are instructor lead, contain certification tests & all students receive a certification of completion.

Our next course in August 29th from 1 - 5 pm.

 

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite 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.

  9880 Hits
SEP
02

Credit Card use in our Time and Expense Management System

Our Time and Expense Management System offered by WebSan Solutions Inc. allows the employee to easily include and process any expenses that he or she may incur on a company credit card, along with any expenses that were not processed through the company credit card.

This feature is great for the finance department, as they don’t need to do any additional work on their end to process the expense, or to make sure that the appropriate amounts get paid to the employee and the credit card issuer.  All that work is done by the employee who incurred the expense.

When an employee is set up with a company credit card, all he or she needs to do when entering in an expense, is to select the option in the drop down box that is provided and the system automatically sets up payments in Microsoft Dynamics GP to be paid to the credit card vendor for the marked entries.

By: Matt Locke, Application Developer, WebSan Solutions Inc. a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Finalist.

Continue reading
  8955 Hits
AUG
02

Why Doesn't my GL Match my Sub-Ledger?

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Many times, usually around month-end, I will get a call from a client that has a mis-match between their sub-ledger balance & their General Ledger.  The first thing I will ask them is whether or not all batches in their Financial Series Post are posted.  You can see from the screenshot below that GP will automatically create a number of batches in the Financial module after transactions have been posted in the Sales or Purchasing modules.  Company configurations can vary, however, in general, a transaction posted individually in a subsidiary ledger will have to also be verified & posted in the Financial Series Post before it will affect the GL.  Most transactions that are saved in the Financial Series Post have already affect the appropriate sub-ledger but NOT the General Ledger.

I advise clients to clear out all entries in the Financial Series Post daily to ensure accurate reporting and to be able to deal with any issues as they arise.

[caption id="attachment_1323" align="aligncenter" width="300"] Financial Series Post[/caption]

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite 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.

  11978 Hits
AUG
07

New Installation Tip - Invoice Alert

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Dynamics GP allows users to enter invoices through a number of different methods.  When first accessing the invoicing windows in GP, users will often encounter a system alert warning them of the fact that they have multiple windows with which to enter the data.  Without intervention, this warning will always appear for users moving forward.

To get rid of this warning, run your GP Utilities (from your Start menu).  In the Additional Tasks window, select the ‘Remove SOP and Invoicing message’.  Proceed to uncheck ‘Warn in Sales Order Processing’ & ‘Warn in Invoicing’.  When complete, the warning will be gone forever.

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite 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.

  7103 Hits
AUG
11

Using Checklists in Dynamics GP

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

In October 2009 I wrote a blog about using Checklists in GP.  I find this blog is still useful today as I have clients wherein turnover has forced the need to document processes within the system.  Checklist are the perfect tool to allow these processes to be documented.  See my blog below:

 Lots of us make checklists for a variety of tasks from grocery shopping to complex projects.  Microsoft Dynamics GP offers built in checklists in the Routines section of every module that can help walk users through a diverse range of topics.

Once you have accessed the appropriate Checklists window, ensure the frequency is appropriate for the checklist you are about to create.  Click Add to create a link to a Microsoft Dynamics GP window.  Name the checklist item & select the appropriate in the Command (Dynamics GP window).  Once your list is complete, order the items appropriately by using the Up & Down buttons.  Now every time a user performs this particular task, all they are required to do is click the checklist item in order & populate the fields with new data.

Checklists are particularily beneficial when turnover is an issue or roles require extensive training.  Two tasks I recommend clients create checklists for are performing payroll & completing year-end.  Mistakes made performing either of these functions can have wide-reaching effects.  In my next blog, I will cover a few tasks that should be on your year-end checklist.

Continue reading
  11956 Hits
AUG
17

Careers @ WebSan

Join our growing & diverse team at WebSan.  We have a number of positions currently available & offer a wide range of benefits.

See our Careers page for more information.

 

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite 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.

 

Continue reading
  7761 Hits
AUG
15

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

  7664 Hits
AUG
19

Project Accounting Billing and Revenue Recognition

Project Accounting connects project activities with company financials and provides extensive reporting capabilities. Watch the following video to learn about invoicing, posting costs from Purchasing as well as timesheets and revenue recognition:

WebSan Solutions offers an online (SaaS) hosted-enterprise business software solution, leveraging the vast capabilities of Microsoft Dynamics GP. If you are interested in GP Project Accounting, please contact us for more information.

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

  6859 Hits
JUL
08

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.

  7642 Hits
JUN
07

Reasons why SMBs should Move to the Clouds

Business owners have many decisions that they have to make. From hiring employees to how the business should operate. Choosing the most efficient technology is not always priority number one. With the rise of software-as-a-service (SaaS), business owners have taken advantage of what SaaS has to offer. If you are still on the fence about switching to a cloud-based solution, make sure you take the following reasons into consideration.

The software is affordable

Business owners sometimes don’t have the extra funds to deploy a new system. The cloud is a fantastic solution because it’s less expensive than any on-premise system. You pay a lower subscription and maintenance cost and don’t require additional software and infrastructure.  For instance, Cloud hosted Dynamics GP is a robust, cost-effective business software that could meet your business needs.

Do you wonder how much it  would cost? Try our three step quote generator for instant results!

You can get started right away

Continue reading
  7297 Hits
JUN
04

Manitoba PST Update

Effective July 1, 2013, the Manitoba government is increasing the PST rate from 7% to 8%.

After this cutoff date, GP users will have to change the tax setup prior to inputting any Manitoba AR / AP invoices.  This change can be completed by navigating to Administration > Setup > Company Tax Details.  Then, select the appropriate tax detail (generally you will have one for Sales and one for Purchasing) and update the Percentage field from 7% to 8%.

[caption id="attachment_1229" align="aligncenter" width="300" caption="Tax Setup"][/caption]

If you have any questions, please feel free to contact our support team at support@websan.com

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.

  6758 Hits
APR
23

WebSan Solutions makes CDN Top 100 Solution Provider of 2012 list

WebSan Solutions Inc., a cloud Microsoft Dynamics Certified Partner and IT consulting and solutions provider,  has been recognized as one of Canada’s top 100 Solution Providers in 2012 by Computer Dealer News (CDN). WebSan has over a decade of experience in Enterprise Software solutions, business and financial accounting software.

The list was announced April 16th, 2013 at the Top 100 Solution Providers Awards Gala. CDN is the voice of Canada's IT channel community for more than 25 years and defines an information technology solution provider as an organization that resells computer hardware, software or peripheral products along with providing IT related professional services, support services, consulting in a cloud or on-demand environment, on-premise fashion or as managed service.

“WebSan Solutions Inc. of Toronto makes the CDN Top 100 Solution Providers list this year and with that they join an exclusive club of the best technology minds in the country. WebSan really made a name for itself this year by offering cloud services based on Dynamics GP. They are part of a group of young and up-and-coming cloud specialists that CDN has noticed on the Top 100 list over the last few years,” said Paolo Del Nibletto, editor and associate publisher of CDN – Computer Dealer News, Canada’s No. 1 IT Channel Publication and Web site.

“We are very pleased to have made the list this year.” says Andrew King, Managing Director, WebSan Solutions Inc. “Our relentless focus on customer service and growth has enabled us to reach this milestone. More and more small to medium businesses our choosing our Cloud Dynamics GP Accounting solution for ease of use and cost every day.”

To view the list of the top 100 Solution Provider click here: http://www.computerdealernews.com/top-100-solution-providers/top-100

Continue reading
  6294 Hits
MAY
16

Time Off Requests

With the May Long Weekend just a couple days away, many friends and coworkers are taking time-off to be with family.  WebSan has recently release a new Time-Off Request module to our TEX (Time & Expense) Management System for Dynamics GP.

The Time-Off Request module is a new optional add-on allowing staff to request paid or unpaid leave for vacation, jury duty, etc.  Non-working days (typically weekends), holidays (i.e. Christmas, Easter) & time-off reasons are configurable by company.  Employees can then send requests to their manager for approval which automatically integrates into their time sheet submission.  A company-wide calendar is maintain for viewing & enhanced time-off reporting is now available with this added functionality.

[caption id="attachment_1159" align="aligncenter" width="300" caption="Time Off Calendar"][/caption]

For more information about WebSan's TEX Portal or Dynamics GP services, please contact Adam via adam.macintosh@websan.com.

Adam MacIntosh is a Senior Project & Account Manager with WebSan Solutions Inc.  A Microsoft Dynamics Silver Partner and a CDN top 100 solution provider for 2012.

  7755 Hits
MAY
20

Web Based Dynamics Reporting

Need access to your Dynamics GP data on the go?  Not able to manage your team while outside the office?  Access your Dynamics GP data from anywhere using the WebSan TEX Portal.  With two layers of security, staff can view GP Reports from anywhere they might be.  Now your staff can have access to the information they need, whenever they need it!

For more information about WebSan's TEX Portal or Dynamics GP services, please contact Adam via adam.macintosh@websan.com.

Adam MacIntosh is a Senior Project & Account Manager with WebSan Solutions Inc. A Microsoft Dynamics Silver Partner and a CDN top 100 solution provider for 2012.

  6882 Hits
MAY
21

Go from Great Pains to Great Plains with MS Dynamics GP

Today companies struggle with a volume of information that has the force of a tidal wave. You can either float or sink into that wave, depending on whether or not you can leverage the exponential growth of business data.

The current thinking around big data though, tends to be built around a very simplistic model. According to that, you acquire large amounts of data in lots of formats from various sources. Then apply some business intelligence into that mix and get your solution. However, this data has to make sense and be as simple as possible.

Continue reading
  6623 Hits
MAY
28

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
  10005 Hits

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

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