Dynamics Virtual Summit November 22nd, 2022 @ 11:00 AM – 4:30 PM EST This Virtual Conference will highlight the future of the Microsoft Dynamics Ecosystem and how it solves today's business challenges. Sessions Include: The Future of Business Central for SMBs Microsoft 365 Ecosystem - Recession Proof Your Business Business Central Wave Releas...
Microsoft Dynamics GP is a powerful accounting system with enhanced report design capabilities that will certainly improve your decision making processes. Microsoft Office and Microsoft Dynamics GP offer what is known as Office Data Connection (ODC), a method to integrate both systems and allow users to view Dynamics GP data in an Excel worksheet. This means, you can view your Microsoft Dynamics GP data in your MS Excel and have it refreshable at any time.
Not only are there more than 200 out of the box Excel reports included in the core system but also users can design and customize Excel reports to meet the individual needs of their businesses. These reports retrieve data from the Dynamics GP SQL database, thus offering real time reporting.
Furthermore, you do not have to be a user in Microsoft Dynamics GP to have the ability to view the Excel reports that come with the system. By using Windows Authentication and setting appropriate permissions for security, anyone in your company will be able to see these reports.
Finally, the default Excel Reports in Dynamics GP are created from the existing SmartList favourites. They are basically Excel files that can be tailored to the user’s needs and provide you with the familiar look and environment of Microsoft Office Excel. In addition, if you need extra customized Excel reports for your business, you can use the Excel Report Builder that comes with the SmartList Builder, though you will have to get a separate license for it.
If you want to learn more about Excel Reporting in Dynamics GP, join our free webinar on February 19, at 11 am EST and find out how to create powerful and easy to read reports.
As 2013 comes to a close, we are all considering our New Year’s Resolutions to make 2014 the best year ever. This is a great opportunity to consider last minute adjustments for fine-tuning your business. Remember to follow all the recommended year-end procedures so that all associated systems are ready for the challenges of the New Year.
Another thing to verify as part of the year-end closing process is the company’s backup procedures. Many organizations have poor or non-existent backup procedures. If there is a hardware failure, the organization may not have a secure offsite copy of its business data to ensure things can pick back up quickly. WebSan provides top cloud security with our Hosted Dynamics GP solution, maintained in our state-of-the-art SAS 70 certified data centre located in Toronto
If you want to learn more about year-end procedures in Microsoft Dynamics GP, join our webinar on Thursday, December 19th, at 11:00 am EST and learn how to successfully close your books.
We help you make it a success every year!
Doriana Kote, Marketing Assistant, WebSan Solutions Inc., a Channel Elite Awards Winner for 2013
WebSan Solutions is featured again in the Globe and Mail Challenge Revisited column, where experts provide advice to help small and medium – sized companies overcome key issues. This time WebSan, is showcasing the challenge of clients failing to stick to their testing and training schedules.
Andrew King, Managing Director of WebSan Solutions Inc., explains how he had a problem that was spiralling out of control. “How do I manage a positive client relationship while enforcing my contractual terms?” he wondered last spring.
Check out the full article here: http://www.theglobeandmail.com/report-on-business/small-business/sb-growth/the-challenge/what-happens-when-customers-are-naughty-not-nice/article16003601/
Doriana Kote, Marketing Assistant, WebSan Solutions Inc., a Channel Elite Awards Winner for 2013
WebSan Solutions Inc. has won silver in the Best Small Business Solution category for this year’s CDN Channel Elite Awards. http://www.computerdealernews.com/channel-elite-awards/winners
This award honors the partner that has created the most innovative and problem-solving hardware, networking, cloud or software-based solution for an organization or department with up to 100 seats or less using the solution.
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.
Congratulations WebSan Solutions! Well done team!
In recent news, there has been an uproar amongst US companies regarding the NSA Prism Program.
It’s been said that the US government had direct access to data stored on servers of well-known companies; this news was leaked by whistle-blower Edward Snowden.
"The PRISM disclosures are damaging, and I think I'm prepared to speculate extremely damaging to commercial firms that have offered cloud and related kinds of services, and that do or would benefit from efficient cross-border data flows," says Philip Verveer, the former U.S. coordinator for international communications and information policy at the State Department.
With that being said, we at WebSan Solutions believe that everyone should have a right to have secure data.
WebSan Solutions Inc. has a SAS70/SSAE16 certified data centre, located in Toronto Canada. We can assure our customers our its data center operations meet the higher level of quality. Independent auditors review WebSan's processes, policies, and procedures and validate our security, availability, and operating integrity.
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
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:
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:
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.
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.
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!
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.
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.
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.
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:
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.
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.
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!
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
You can view the recorded webinar and other Microsoft Dynamics GP training videos at our YouTube Channel.
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:
© Copyright 2023 WebSan Solutions Inc.WEBSAN is a trademark of WebSan Solutions Inc. Registered in Canada and other countries.
