WebSan Solutions Inc. a Toronto-based Dynamics GP Partner is now a regular contributor on ERPSoftwareBlog.

Come check out our recent posts!

The foundations of ERP are found in manufacturing resource planning, traditionally used by companies which produced tangible goods in factories. The adoption of ERP and MRP systems was initially quite slow – management were content with the status quo and saw no reason to change what seemed to be working. However, the recession experienced in the late 1980s and early 1990s forced many companies to make a choice: Either find new ways of operating more efficiently and effectively, or go under. This created a massive boom in the ERP market, which lead to massive changes in the ways in which fundamental business operations were conducted, and those organizations that made it through the recession came out stronger.

North America is no longer the goods-producing collection of nations it once was and is instead dominated by service industries. However, many of the same problems that existed in manufacturing organizations twenty years ago still exist in these businesses: Lack of integration, inability to respond and take advantage of environmental change, time and money wasted on data entry and redundancies, and so on. Much like the recession twenty years ago, the economic downturn caused by the subprime mortgage crisis has forced many modern companies to find new ways of performing more effectively and efficiently.

This is the time to get ahead of the competition, and Microsoft Dynamics GP is the perfect solution for organizations looking for more than simple accounting and reporting features without high maintenance costs and complexity.

The Item Resource Planning, Site Resource Planning & MRP Order Detail windows have all been updated to incorporate a ‘Move Out’ fence.  The new logic allows for rules that determine if & when to suggest moving or canceling a purchase order or manufacturing order.  A Move Out is suggested when an item’s Projected Available Balance will be greater than the item’s Order UP To Level.

As GP calculates an item's Projected Available Balance for a specific time period, MRP will include supply order moves & cancel suggestions that impact the quantities occurring in that time period.

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-499-1235 ext. 213.

The Service Management module now allows for processing of Kit Items.  When a kit item is entered in the Service Parts window, the kit's components are added automatically to the Service Line table; although, they can be deleted if necessary.  Note: the quantity ordered cannot be partially allocated.  Through the Service Management module, POs can now be created for kit component items on a service call.

Kits can also be entered in Returns Management, Preventative Maintenance, on Contract Lines, or on the Parts line for Depot Management Work Orders.

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-4991235 ext. 213.

Field Services now allow the use of non-inventoried items.  Service Calls or POs can be entered for non-inventoried items representing labour, expenses or misc charges.  Preventative Maintenance events can even include non-inventoried items.  Contract Administration, Returns Management & Depot Management all now allow the use of non-inventoried items.

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-499-1235 ext. 213.

Users of US Payroll in Dynamics GP will love the new integration points from other modules within Dynamics GP.

One such integration point is with the Field Services module.  Direct & indirect labour postings that create Payroll transactions can be made in Service Call Management & Depot Management.  This integration allows for Payroll to captures the cost from the employee's pay code into the labor record in Field Service.

A Post to Payroll check box has been added to the Work Type Maintenance & Depot Station Maintenance windows that when selected, enters the value from the window's corresponding Pay Code field, representing an hourly pay code.

Service calls can now be escalated to additional managerial levels. The Service Type Escalation window has been modified to include a new Manager Level field.  When a call is escalated, an e-mail to the technician's manager is sent.  This can now be sent to two additional levels of management directly above the technician's manager. One can specify the number of levels to e-mail, including:

• The manager of the technician on the service call
• The manager's manager
• The manager of the manager's manager

The Service Call Escalation window also now supports multiple technicians for each call.

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-499-1235 ext. 213.

[caption id="attachment_254" align="aligncenter" width="748" caption="HST Tool-Kit"][/caption]

Did you know Directors of corporations can be held personally liable for un-remitted HST!?!

Be ready for the new HST!  Contact WebSan now to take advantage of our HST Cut-Over Tool-Kit.

Over our many years of experience with Microsoft Dynamics GP, we have developed a proven implementation methodology for companies both large & small.  Get the job done right the first time!  Let us help you with HST upgrades:

• Update company-wide sales & purchasing tax options
• Set tax settings for specific grouping of customers or vendors
• Ensure appropriate sales items are taxable or not

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-499-1235 ext. 213.

GP 2010 is coming soon!  Over the next while we will be previewing some of the new features.

Also, join us during our upcoming webinar featuring the top 10 new features.

GP 2010 will bring additional reporting printing capabilities.  Users can now take advantage of Word report templates as an alternative to using the native Report Writer.  Out-of-the-box there will be 22 templates available for use with endless possibilities on user customized reports.

GP 2010 will also feature added capabilities with Excel reports & pivot tables ... hum

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-499-1235 ext. 213.

When making payments in GP 2010, users will be given additional restriction possibilities in Select Checks window.  New restrictions can be place on the following fields:

• Vendor IDs
• Vendor names
• Class IDs
• payment priorities
• voucher numbers
• document numbers
• due date\discount date cutoffs
• document currency

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-499-1235 ext. 213.

Cash receipts may now be entered as a negative currency value within GP 2010.  This will subsequently decrease the deposit amount of the cash receipt by the value entered in the Amount field.  Furthermore, the posted receipt will show up as a deposit with a negative amount.

The negative cash receipt can be applied similar to any regular cash receipt, except the outstanding amount of the invoice will increase, instead of decrease.  Users experiencing returns, bad debt or miscellaneous fee issues will undoubtedly love this new feature.

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-499-1235 ext. 213.

System Administrators will find setting up new users in GP 2010 much quicker.  User Security setting can now be copied from the security of another user.

In order to help reduce the likelihood of incorrectly assigning permissions, Administrators can filter security windows in order to view only the selected:

• Operations assigned to tasks
• Tasks assigned to roles
• Roles assigned to users

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at This email address is being protected from spambots. You need JavaScript enabled to view it. or at 416-499-1235 ext. 213.

In previous versions, users would be able to view the module's Navigation Pane regardless of whether it was used or not.

In GP 2010, Administrators control which Navigation Panes are available to users and which are not.  Unnecessary navigation buttons can be limited at the user or at the company company level.

Again, join WebSan in our upcoming GP 2010 Webinar!

PS ... For Analytical Accounting users, user security can now be assigned on-the-fly!  No more setting up segments & then waiting for approval to use them.

Want to access Microsoft Dynamics GP data on your mobile device?  Upgrade to Business Portal!

Through Business Portal, users can access data from Microsoft Dynamics GP without logging into the system.  Instead, the data lives on-line, making it accessible through mobile devices such as a Blackberry.  Simply configure your mobile device to access your company VPN & your off!  You don't have to be chained to that desk anymore!

As a Microsoft Dynamics GP implementer, I run into a number of issues that the everyday user never sees.  One such issue can occur when mass loading data, updating the system through the database (not recommended!) or just through normal business processes.  Errors happen!  Sometimes, the best intentions don’t go unpunished.

Why?  When data is entered in GP, multiple tables are populated with the data, not just one.  Everything is linked.  That’s the beauty of an ERP system.  But sometimes, wires cross & fixes are needed.

The Checklinks tool helps examine the links between related information, helping to restore any damaged data.

Even before problems arise, Checklinks can be used for general clean up.  Be sure to make a backup of your data prior to using the functionality, just to be safe.

I am constantly searching for ways to help my clients save money & improve performance.  Often the answer includes automating a particular process.  One of such process includes Emailing Customer Statements.  For clients with a large number of customers, the savings can be extensive.  Clients save on paper, ink, wear & tear on printers, envelopes, postage & most importantly, employee time.

Automating the customer statement process is very simple to setup.  First, enter the Customer Maintenance window & click Options.  Enter the email contact for the customer in the ‘To’ box in the bottom right corner of the screen & check the ‘Send Email Statements’ check box.  Now, when creating customer statements, check the ‘Send Email Customer Statements’ under the Email Options heading.

The return on users’ time investment will be realized after the first statement run.   So automate the process of sending customer statements & free up your time for more important tasks.

For more advanced FRx users, I thought I would cover some calculation formulas that are available for use in FRx.  Much of FRx is fairly self explainable & easily learned with a little exploration.  One topic I had a little trouble with when first learning the system was Calculation Formulas on Row Formats. 

Simple adding & subtracting are fairly self-explanatory.  Simple take the columns to add & place a plus sign between them.  For example, B + C. 

However, did you know FRx can perform complex calculations such as adding & multiplying all at once.  The formula (A+((B+C/2)+(C*.8)/2))+(F TO H) is a valid entry.

IF/THEN/ELSE Statements are another handy tool.  These allow one to build logic into the column.  For example, the formula "IF B>1000 THEN B ELSE C*2" translates to:

If the amount in column B is greater than 1000, place the value from column B in the CALC column. If the value is not greater than 1000, multiply the value in column C by 2 & place the result in the CALC column.

Year-End can be a hectic time for all & it is fast approaching.  In many instances, we are tired from or preparing for the holidays.  Everyone is out of their routine & sometimes, performing tasks they only think about once a year.  Here is a brief summary of performing year-end in any ERP system.

Prior to performing year-end tasks:
1 - Post all receivables, payables & financial transactions.  Future dated transactions should be held off if possible until after the year has closed.
2 - Perform a stock count, send out customer statements & complete all reconciliations
3 - Make any adjusting entries needed.
4 - Print necessary reports to maintain in the companies permanent records for audit trail purposes
5 - Make a backup of company database before starting the year-end processes.

Ensure all users are out of the system when performing year-end processes.  Additionally, users are often given the opportunity to purge obsolete records during the year-end processing.  One should consult company policy & ensure local law reporting laws are followed prior to deleting any records.  Once complete, it is good practice to close old fiscal periods from posting to prevent any accidental postings.

Here is a brief timeline I have put together to help users determine when to process Year-End closing routines.