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

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.

There's a lot of debate out there on forums regarding hosted ERP solutions.

Obviously, much success has been had with Software as a Service (SaaS) in the CRM (Customer Relationship Management) space, but CRM really isn't "mission critical." If a company chooses to outsource mission critical applications, such as shipping software, WMS, or manufacturing software, then what will happen if the company loses their internet connection?

There are many pros to going with a fully hosted solution over an on-premise solution. They include, but are not limited to:

• The initial cost for the ERP solution is usually significantly less than an on-premise solution.
• Total cost of ownership (TCO) over time can still be less than on-premise, depending on the outsource provider and their capabilities
• The initial implementation time line can also be accelerated by hosting because much of the underlying configuration infrastructure can be shared, therefore consulting time is minimized
• Internal IT support staff is not required for a hosted solution
• The hosting provider takes care of system updates, patches, regression testing, etc.

The one advantage on-premise solutions have over hosted is that they are indeed, on the premises of the client. They don't go down unless your business does, and then, you've got bigger fish to fry.

That being said, if you could combine the benefits of on-premise with the benefits of hosted, in a hybrid solution, then you would have the best of both worlds.

Look for a solution that offers to have your mission critical applications on site, like:

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!

In the first volume of this series, we discussed one of the key advantages a well-designed warehouse management system (WMS) delivers – visibility of inventory. For volume two we will touch upon the direct correlations between an effective WMS and increased customer service.

By implementing the appropriate WMS solution to fit your warehousing needs, you are telling your customers through your actions that, “Hey, we really do care that you get your product on time and in an accurate fashion”. It’s one thing to promise your customers that you can do something for them and another to keep that promise.

The simple concept of customer service is very often confused and misplaced in a world full of fancy gadgets and new-age business theories. At the end of the day, just make them happy; it’s really all they ask for.

A WMS increases customer service directly through:

• Improved warehouse organization
  • Efficient usage of warehouse space means lower storage and overhead costs. This translates into a competitive advantage you can leverage to provide more attractive pricing to customers

• A return system that actually works
  • An ineffective return merchandise authorization (RMA) program is as frustrating to customers as misleading promotional deals. A returns processing applet is typically integrated in a well-designed WMS

• Better inventory accuracy
  • If a customer needs to order a product and your website says that it’s available then you should be making sure this is true. A WMS increases inventory visibility, which reduces the number of stock-out confusions
  • By forecasting inventory trends, buyers can determine when a demand spike for certain products will arise and make appropriate purchases to support it

• Faster order cycle times
  • A WMS is not only software – it is a complete integrated system that works with your ERP system. RF devices can be incorporated to increase order-fill rates. Shipping stations can be established with shipping partners for automation and shipment management

Vernon Johnson is a warehouse management specialist at WebSan Solutions Inc. He can be reached at 416-499-1235.

Whether its aiding an aging workforce or assisting a disabled employee, there are a wide variety of cost effective products in the market today that can help employees become more efficient in the workplace.  Many of these technologies will also allow employers to take advantage of resource pools they once were unable to profit from.

Our analysis of assistive technologies focuses on two of the leading impairments faced by workers today, visual difficulties & dexterity impairments.  Those with either of these impairments can take advantage of many technologies discussed.  For example, Speech Recognition Software is a great tool for those living with either difficulty.  Furthermore, many of these technologies can be used to aid those with learning difficulties or simply assist those not living with any impairment.

Aides for Visual Impairments

Among adult computer users in the United States, more than 1 in 4 (27%) have a vision difficulty.  This large percentage of the population can take advantage numerous technologies to aid in everyday tasks.

• ·Screen Enlargers – Working like a magnifying glass, these enlarge a portion of the screen as the user moves their focus. Many allow the user to further zoom in & out on a specific area of the screen as well.
• ·Screen Readers – These programs used to verbalize, or "speak," everything on the screen including names & descriptions of control buttons, menus, text, and punctuation.
• ·Braille Displays - Provide a tactile output of Braille letters such that users can read with their fingers.
• ·Speech Recognition Systems - Allow users to enter data & give commands using their voice rather than a mouse or keyboard.

Aides for Dexterity Impairments

Among adult computer users in the United States, 1 in 4 (26%) have a dexterity impairment.  Technologies used to assist this portion of the population can also aid those with other disabilities, such as the Speech Recognition software mentioned above.

Next time you are printing Sales invoices, try this time-saving alternative:

Select Options > Quick Print, or simply CTRL + Q on your keyboard

This will print your invoices according to the settings in the Quick Print Setup screen (also under the Options menu).  Default can be created for:

· Orders
· Invoices
· Packing slips
· Picking tickets

Select a print Destination & number of copies to be printed.  Print options available for documents are:

In any window, users can select Help > About Microsoft Dynamics GP to determine what version they are using.  This is extremely useful when installing patches or making upgrades.  This information can even be critical when submitting a support request.

Hint:  From this window, one can select Options to determine what modules are registered.

Do you often find yourself canceling reports that automatically print after you have posted a document?  Or even changing the default destination of these reports?  Well, one can set the default destination of these reports or even stop them from printing all together.

Try entering  the Posting Setup screen (Microsfot Dynamics GP > Tools > Setup > Posting > Posting).  In this screen, you can select whether or not a specific report will print by selecting or de-selecting the checkbox in the Print column.  Also, one can specify destination for a report by making the appropriate selection in the Send To column.

See the attached screenshot below & save yourself all that extra clicking when you next post a transaction.

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.

FRx is the standard financial reporting tool utilized by most Microsoft Dynamics GP users for financial reporting.  FRx links directly into the general ledger to allow the creation of endless types of reports.  These report are then viewed in the FRx DrillDown Viewer.  Users I have spoken to in the past have expressed that they are more comfortable viewing reports in Excel.

To take your FRx financial report & export to excel:
1 - Generate the report
2 - In the DrillDown Viewer, select File > Export > Worksheet File > Formatted Excel
3 - Save the report to its desired location

This quick & easy trick should save you time & energy in attempting to convert your reports.

Have you seen us on the Microsoft Solution Profiler?

Click here.

WebSan is one of the few companies in North America that offers a hosted Dynamics GP solution. It reduces your total cost of ownership vs. an on-premise solution.

Check out our web page regarding hosted Dynamics GP for more information.

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.

There was a great article published on cpatechnologyadvisor.com late in 2007 that's worth showing here.

Here's the reprint :

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.

Lots of us make checklists for a variety of tasks from grocery shopping to complex projects.  Microsoft Dynamics GP offers built in checklists in the Routines section of every module that can help walk users through a diverse range of topics.

Once you have accessed the appropriate Checklists window, ensure the frequency is appropriate for the checklist you are about to create.  Click Add to create a link to a Microsoft Dynamics GP window.  Name the checklist item & select the appropriate in the Command (Dynamics GP window).  Once your list is complete, order the items appropriately by using the Up & Down buttons.  Now every time a user performs this particular task, all they are required to do is click the checklist item in order & populate the fields with new data.

Checklists are particularily beneficial when turnover is an issue or roles require extensive training.  Two tasks I recommend clients create checklists for are performing payroll & completing year-end.  Mistakes made performing either of these functions can have wide-reaching effects.  In my next blog, I will cover a few tasks that should be on your year-end checklist.

Following with the theme from my last blog, I will continue my discussion on correcting posted transactions.  Both Receivables & Payables documents can have certain information edited after they have been posted.  Documents can have the following four fields edited after they have been posted:

• Discount Date
• Due Date
• PO Number
• Description

To access these screens, select Edit Transaction Information under either Sales or Purchasing Transactions windows.  Select the appropriate vendor or customer document to edit & make the necessary changes.  This tool is handy for those that base collections, payment or other information on these details.  Just ensure only the appropriate parties have access to modify this data.

Normally, once an item is posted, it is in the system.  Posting is the be-all & end-all.  It is kind of like writing with pen.  And let’s just say, there is a reason they invented whiteout.

Dynamics GP does have an exception to the posting rule in the form of Correcting Entries.  The one caveat is that only open year General Ledger entries can be corrected.

To make a correcting entry, select Transactions > Financial > Transactions.  Click the Correct button.  Select an Action of:

Back Out a Journal Entry
Or
Back Out a Journal Entry and Create a Correcting Entry

Select the appropriate journal entry to correct using the lookup feature & select OK.  Remember, only general journal entries can be reversed.  Review the Batch ID in the lookup window to determine if an entry is a general journal entry.

Earlier this week, I talked about annoying configuration that can be found in Dynamics GP.  I tried to show that users don’t have to be annoyed because they are the ones that control what the system does.

A similar situation exists in Business Portal.  Recently, I was watching a client access Business Portal & every time they entered the system; they had to change the Company ID.  I explained to them that this is easily configurable in the system.

To set your default company, select the Welcome drop-down menu from the top right corner of the screen while in Business Portal.  Select My Business Portal Settings & adjust your default company as desired.