Do you have a suggestion for an improvement to Dynamics GP. Let Microsoft know via Microsoft Connect:
Adam MacIntosh is a Senior Project & Account Manager with WebSan Solutions Inc.
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.
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.
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.
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!
Sarah Purdy discusses Modified Dictionary Upgrades:
Chris Bulson discusses Version Checks & Upgrades:
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%.
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!
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) softwareto 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.
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!