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

Friday, 26 July 2013 12:00

Have a Dynamics GP Suggestion?

Do you have a suggestion for an improvement to Dynamics GP.  Let Microsoft know via Microsoft Connect:

connect.microsoft.com/default.aspx

Adam MacIntosh is  a Senior Project & Account Manager with WebSan Solutions Inc.

Published in Microsoft Dynamics GP
Tuesday, 23 July 2013 06:40

Upgrade to Dynamics GP2013

Want to upgrade to Dynamics GP2013 and enjoy all the new system benefits, call WebSan!  We are experienced with Microsoft Dynamics GP2013 upgrades and can help guide you in order to avoid typical pitfalls.  Microsoft is currently supporting Dynamics GP 2010 and 2013.  All users on older versions should look to upgrade immediately to ensure they are supported.

 

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 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 Microsoft Dynamics GP
Wednesday, 17 July 2013 06:06

Upgrade Dynamics GP at No Cost!

The Microsoft Dynamics GP Professional Services Tools Library (PSTL) is a group of tools that allow users to improve system capabilities & increase productivity.  Users generally have access to these at no cost but do not take advantage of them.

Within the Finance module, one can Modify Accounts, Fiscal Periods, or Fixed Assets, allowing end users to convert historical records to new records, maintaining the necessary history & without corrupting your database.  Within the Purchasing module, users are able to update / convert vendor records, similar to the above.  Further, users have the ability to set minimum values for payabales cheques or combine cheques where necessary.  Similar updates are available throughout the system, allowing updates to master data records such as salespeople, territories, customers, employees, inventory, etc while maintaining the proper history.  One key feature many users like is the ability to unapply receivables documents, opening them back up for one to enter transactions against.

Ask us about how you can get free access to this wonderful tool today.

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 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 Microsoft Dynamics GP
Wednesday, 10 July 2013 09:30

Tracking Vacation Time Off

Despite the weather conditions this week, summer is approaching its peak and while employees are taking their vacation leave time, many organizations find it difficult to capture time off. Managers are responsible for maintaining the accuracy of accrued vacation leave records and they also need to ensure that time is reported accurately in accordance with the respected policies regarding vacation leave.

So what if employees could request time-off via the internet and managers could approve these requests and view their department’s work schedules online? It is obvious that a time tracking software reduces the time required versus manual options and the savings accelerate quickly. Additionally, the costs of archiving paper documents will vanish.

WebSan Solutions offers a robust, out of the box Time and Expense Management System that keeps track of your employee’s time and expenses easily. Moreover, its unique project management features will monitor your projects and your costs efficiently.

For more information on our web-based Time & Expense Management System, register for our free webinar on July 11th, at 11:00 am EST or contact us here.

Doriana Kote, Marketing Assistant, WebSan Solutions Inc., a Microsoft Dynamics Silver Partner

Published in TEX Portal

Yesterday’s rainfall was the most rain in Toronto’s recorded history. Toronto is still recovering from an unprecedented rainstorm that shattered records and paralyzed the city. Yesterday’s storm dropped more rain in two hours than the city usually receives in the month of July. More than 300,000 residents were without power.

However, WebSan’s Microsoft Dynamics GP hosted environment was up and running full speed. We experienced no issues throughout the storm and our backup generating system was on standby when needed. Our SAS70/SSAE16 certified data centre was not affected by the severe weather; it was business as usual for all our clients. You always have access to your data, through our secure network, in our SAS70/SSAE16 certified data centre!

Published in WebSan Blog
Wednesday, 05 June 2013 15:15

Dynamics 2013 Upgrade Useful Information

Hi All

I discovered a couple excellent blog post from two fellow Dynamics community members that I wanted to share.  Both relate to upgrading to GP2013.  At this time, there are still a number of known issues with GP2013 even though Service Pack 1 has been released.  If you are looking to upgrade to GP2013, please contact me via This email address is being protected from spambots. You need JavaScript enabled to view it. or 416 499 1235 ext 213.  In the mean time, I encourage you to review the blog posts below.

Sarah Purdy discusses Modified Dictionary Upgrades:

https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/04/11/modified-dictionary-upgrade.aspx

Chris Bulson discusses Version Checks & Upgrades:

https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/04/04/version-checks-amp-upgrades-lt-draft-gt.aspx

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
Tuesday, 04 June 2013 18:09

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"]Tax Setup[/caption]

If you have any questions, please feel free to contact our support team at This email address is being protected from spambots. You need JavaScript enabled to view it.

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

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Incrementing an integer in SQL is easy; all you have to do is + 1 to the value. However, incrementing a number that has padded zeros is a little trickier, since it is probably a string value and not a number. Luckily with some type conversions, it becomes just as easy as incrementing an integer.

First thing you want to do is to get the length of the string, so you know how many padded zeros to add. You can do this by using the LEN function:

1. SELECT @Length = LEN(RTRIM(LTRIM(@Num)))

It is also a good idea to trim the value just in case there are extra spaces.

Next we can increment the number.  Now we can't just do a + 1 to the value since it’s a string and doing a + 1 to a string would just concatenate the 1 to the end of the string.  So let’s convert the string to an integer:

2. SET @tempNum = CONVERT(INT, @Num) + 1

Nice, now we have incremented the number. Now all we have to do is add those zeros back in and we're done.  To do this, we first convert the number back to a string.  Then we concatenate a bunch of zeros to the front of the number.

Last, using the RIGHT function we set the length of the string back to the original length, using the length we got earlier, so that we have the appropriate number of leading zeros.  Here's how it looks:

3. SET @nextNum = CONVERT(VARCHAR(21), @tempNum)

SET @nextNum = RIGHT('000000000000000000000' + @nextNum, @Length)

There you have your incremented number!

By: Dustin Yee, Application Developer, WebSan Solutions Inc., a Microsoft Dynamics Silver Partner and a CDN top 100 solution provider for 2012.

Published in Uncategorized

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.

Using Enterprise resource planning (ERP) solutions, such as Microsoft Dynamics GP, will make it easier for you to capture important data and turn it into actionable insight. It goes without saying that this solution is user-friendly and easy to learn, like other commonly used Microsoft products. MS Dynamics GP will help you collect and manage data related to accounting, finance, human resources, supply chain and other core business functions. Moreover, if you incorporate customer relationship management (CRM) software to your business, you can add customer data, e-commerce, and social media statistics.

The data collected in Dynamics GP and CRM software solutions can identify top-selling products, what time of the day or year products sell most or least and who is buying your products. Companies can use this comprehensive analysis of data to increase productivity and thus, maximize their profitability.

WebSan Solutions offers a hosted-enterprise business software solution, leveraging the vast capabilities of Microsoft Dynamics GP. We help our customers focus on growing their business and serving their customers, while avoiding the time and costs requirements associated with maintaining an on-premise system.

Doriana Kote, Marketing Assistant, WebSan Solutions Inc., a Microsoft Dynamics Silver Partner and a CDN top 100 solution provider for 2012.

Published in Uncategorized
Monday, 20 May 2013 12:00

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!

Values per Week

For more information about WebSan's TEX Portal or Dynamics GP services, please contact Adam via This email address is being protected from spambots. You need JavaScript enabled to view it..

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.

Published in Microsoft Dynamics GP