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

Uncategorized (48)

Monday, 11 June 2012 09:15

SQL Reporting Webinar

Written by

On May 29th WebSan held a SQL Reporting Services Webinar. We discussed the ability to export reports to any other formats like Word, Excel, PDF etc. and we toured of the most popular SQL Reports. To be kept up to date latest webinars, send us a message or e-mail us at This email address is being protected from spambots. You need JavaScript enabled to view it.

You can view the recorded webinar and other Microsoft Dynamics GP training videos at our YouTube Channel.

Join us for our upcoming June webinars!

-          Move from QuickBooks to Microsoft Dynamics GP on June 21 @ 2:00 p.m. EST

-          10 Tricks in 30 minutes – The Top 10 Features of Dynamics  GP You’re Not Using and Should Be! On June 19 @ 11:00 a.m. EST

Thursday, 21 June 2012 10:40

WebSan Continues Growth

Written by

WebSan has continued its growth by expanding its office facilities.  We have recently taken over additional office space, doubling our office size.  We are also expanding our workforce.  If you have the proper blend of technical capabilities & a knack for business, applying to one of our openings at the link below:

http://www.websan.com/about/careers/

Monday, 25 June 2012 04:45

Still Time to Apply ...

Written by

We are still accepting resumes for our Application Specialist position.  Hurry & forward your resume before its too late!

http://www.websan.com/about/careers

We are accepting applications from recent university graduates as well as current GP users looking to broaden their knowledge.  Work for a young & vibrant company in uptown Toronto!

Monday, 23 July 2012 09:15

SmartList Builder Webinar

Written by

On July 19th WebSan held a SmartList Builder Webinar. We discussed how to link tables and calculate fields, create defaults for more user-friendly environment and create summary SmartLists. To be kept up to date with our latest webinars, send us a message or e-mail us at This email address is being protected from spambots. You need JavaScript enabled to view it.

You can view the recorded webinar and other Microsoft Dynamics GP training videos at our YouTube Channel.

Monday, 11 February 2013 09:30

Microsoft adds Skype to its CRM application

Written by

Since Microsoft has released an update to its Dynamics CRM Online software, they decided to add a new capability to its system. Skype is a service that allows back and forth communication with people by voice and video using a microphone and a webcam, and instant messaging over the Internet.

Users could make Skype calls when using Dynamics CRM. Microsoft has said that this new feature will "Guide sales and service professionals through predefined lead, opportunity and case-management processes."

But users aren’t forced to use the Skype application. You have the option of “opting in or out” of this new feature. Microsoft understands that their users might prefer to use the Outlook interface instead.

Microsoft has also stated that this new update includes support for Firefox, Chrome Browsers on Windows PC and Safari on Macs. The update also includes more integration with Bing Maps that will create addresses and other information about prospects and leads. In mid-2013, Microsoft is preparing to run a mobile version of CRM on Windows 8 and iPad devices.

Microsoft is moving in the right direction integrating customer relationship management with social media. This is a great way to stay connected and to maintain relationships, whether it’s a B2B or B2C relationship.

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

 

Monday, 01 April 2013 07:07

SSRS PHP Tips and Tricks Default parameters

Written by

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Have you ever wanted to share a report between several different people or companies, but wanted the report to only display data for that specific person or company?  This can be tricky with a multi company or multi person database.  However there is an easy way to do this, and it's not coping and pasting the report for each company/user.

There are 2 steps to do this.

The first step is easy.  When creating the SRS report, create a person or company parameter, just a normal text field parameter.  This will be the parameter be used to set which specific person/company the report will be for.  It would probably be a good idea to use a different naming convention for this parameter, to specify that it as a default parameter, like default_user.  Then finish creating the report and onto the next step!

The second step is to change your code where you set/send the report parameters to the SSRSPHP library.  All you have to do is check if the parameter name is equal to one of the default parameters and hide the parameter from the user when setting the parameter.  Then when the report is being submitted, all you have to do is set the parameter before sending it to the SSRSPHP library to retrieve the report.

The code to do this would look something like this:

ssrs

Now the user won't be able to change or even see the parameter.  This is pretty good, but if we want to add more default parameters this isn't a very elegant solution.  Instead we can put all the default parameters into an array and check if the default parameter exists in the array.  This way in order to add more parameters, all we have to do is change an array

The code to do this would look something like this:

ssrs 1

To the user it will seem like nothing has happened, but we have effectively limited the user to see the report data that we want them to see without having to create separate reports for each company or person.

By: Dustin Yee, Application Developer, , WebSan Solutions Inc., a Canadian Certified Microsoft Partner

Wednesday, 24 April 2013 05:15

ExtJS 4 Keeping Store Loads to a Minimum

Written by

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

When creating a user interface, you always want it to feel smooth and fast as you can, and any time that the user is left waiting on the system decreases the appearance of how fast your system is. Delays on web applications can be caused from things such as processing lots of data, to constantly requesting new data from the server. It’s the latter case that I’m going to look at today and show a method that can reduce the amount of times you request data from the server.

For a working example, say we have a registration screen that is asking for the user’s country and province/state that they live in. Both fields could be simple text boxes, but it’s a little bit nicer if you provide combo boxes that give the user a list of options to choose from.

You probably want the list of provinces/states that you show to be dynamic based upon what country they select. So your province/state combo box will likely have an event listener that looks like this:

matt blog 1

Above is a simple listener that listens for when the combo box expands (when the user opens the combo box to view the choices), and when it does that, it gets what the country combo box is set to, sets it as a parameter, and then retrieves the list of provinces/states from the server based on the selected country.

So if they select a country, and then open the combo box for the province/state, it will load up the list properly. The problem is that if they open the combo box for the province/state again, it will request the list from the server again, even if the country selection hasn’t changed.

There are two fairly simple ways that we can prevent that second server request.

The first is to check and see if the country has changed before we reload the province/state store:

matt blog 2

This way, if the country hasn’t changed from when we last got the list of provinces/states, then we just use our current list of provinces/states as it’s the same data that the server would have given us.

By: Matt Locke, Application Developer, WebSan Solutions Inc., a Canadian Certified Microsoft Partner