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

Uncategorized (48)

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.

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.

Yesterday 13,000 cyclists headed out on the two major Toronto highways, Gardiner Expressway and Don Valley Parkway, in this year’s Becel Heart & Stroke Ride for Heart.

Despite the bad weather, this year the event raised a record of $5.5 million, which is $500,000 more than it did in 2012.

Here at WebSan Solutions Inc., we strongly believe in the value of community and we were thrilled to take part in the Ride for Heart and help towards funding more research that extends and saves lives.

We had a great time and we are proud that we contributed to the eradication of heart disease and stroke.

See you all again next year!

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

You may think that tracking time and expenses to optimize your team and satisfy your clients is an easy, routine task. The truth is that tracking staff’s timing and expenses is about making insight-driven decisions a key part of your business culture and day-to-day activities.

Usually, a new company will start small by tracking employees’ hours in an Excel spreadsheet or even in traditional, handwritten records. As your client portfolio grows and your team gets larger, your time management needs to change. Whether you are an accounting firm, an IT consulting company or a bank, there will come a point where you will need to better take advantage of your resources and track your revenue and costs.

A lot of times, people consider buying a time management system an unnecessary expense. In fact, the effectiveness of it in tracking, analyzing and reporting on employee’s timekeeping, outweighs its cost. Today’s software options focus on web hosted portals with reporting and time tracking features, as well as various options for recording expenses towards clients and projects. You can also bill an employee’s time at various rates depending on the client and the tasks to be performed.

Therefore, a time and expense management system helps you to better leverage your employee time and keep track of how you utilize your resources. As you build an historical database, the better you plan and manage, thus the more revenue you generate

WebSan Solutions offers a robust, out of the box Time & 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 Time & Expense Management System, register for our free webinar here or contact us at This email address is being protected from spambots. You need JavaScript enabled to view it.

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

Wednesday, 03 July 2013 15:46

WebSan is in the July Edition of Snap North York

Written by

On June 2nd 2013, WebSan Solutions took part in Becel’s 26th annual Ride for Heart. More than 13,000 cyclists rode their bikes across the Gardiner Expressway and Don Valley Parkway. The event raised a record of $5.5 million, which is $500,000 more than it did in 2012.

We are glad that we could make a positive impact in eradicating heart disease and stroke! It has been a proud moment for all the employees here at the office.

To view our photo and the July edition of Snap North York, click here: http://www.snapnorthyork.com/index.php?option=com_sngevents&id[]=520947

By: Natalie Williams, Marketing Coordinator, WebSan Solutions Inc.

Thursday, 04 July 2013 09:30

IRAPP DTAPP Funding for Small Business

Written by

Did you know you can receive up to $100K in government funding through IRAP Digital Technology Adoption Pilot Program(DTAPP)?

DTAPP is a component of the Government of Canada’s overall strategy to boost the productivity of small and medium – sized enterprises (SMEs) and improve Canada’s digital economy. The contribution acts a cost sharing mechanism and will be applicable to the expenses associated with the analysis, implementation and customization of new software or the direct labor and consulting components of implementing new digital technologies. If your proposal is accepted by the program, the government will also provide up to 80% of the payroll costs and 75% of the applicable sub-contractors fees for a project up to $100k contribution.

To be eligible for DTAPP services or funding, your firm must:

  • have 500 employees or less
  • be incorporated, for-profit and operate in Canada
  • be growth oriented
  • demonstrate plans to carry out a project designed to adopt digital technologies

WebSan Solutions Inc. will work with you and your company to find the best small-medium enterprise solution that will help your business grow and become more efficient. If you are considering implementing a new ERP project, contact us to learn more about the IRAP DTAPP funding opportunity.

Doriana Kote, Marketing Assistant, WebSan Solutions Inc.

Remember when you had to record your time on a spreadsheet? Then your boss had to approve it and send it to HR in order for you to get paid? Spreadsheets are still an important way to track information; however, tracking your time and expenses on a spreadsheet can become time-consuming and leaves room for more inaccuracy. WebSan Solutions has developed an add-on to eliminate spreadsheets in order to create efficiency within your organization.

The benefits of our system include:

  • Seamless integration with Dynamics GP database
  • Handle Canadian VAT (value added tax) and US taxes seamlessly
  • Track days off, holiday and vacation time
  • Internal reporting for timesheet status, expense reports, and history
  • Supports attaching receipts and documents to expense and timesheets
  • No need to use PDK to approve timesheets, ONE complete integrated solution
  • Full browser interoperability, so you can use your favorite browser and not just IE.

We fully integrate with Microsoft Dynamics GP, there are no firewall issues and our solution is 90% easier to setup and use! To find our more information about our Time and Expense Management System, contact us today!

Natalie Williams, Marketing Coordinator, WebSan Solutions Inc.