Keeping in Touch
Getting the Most from Your Sage 100 Investment 
Jan 2013, Issue 56
Newsletter Contents
Quotes to Ponder
Quarterly Webinar
Tax Change - Quebec Sales Tax
Faster Reports? Consider MWDataMerge
Sage 100 2013 (or MAS 90 / 200 v5.0)
Interesting Custom Office Projects
Join Our Mailing List!
Quick Links

 

 

 
 
Dear ,

Happy New Year!  We hope this newsletter finds you rested after the holidays and ready to tackle life with zest!  Thank you to one of our subscribers who emailed to check in on us -- we missed two months of newsletters and she was concerned for us!

This newsletter, Keeping in Touch, is our way of keeping you up to date with relevant news about your Sage 100 (formerly MAS 90 / 200) software and also what's happening at Munjal White.

We're always looking for ways to improve, so if you have any suggestions for newsletter topics, tips, or other ways that we can improve our service level, click here to let us know.
 
 
Quotes to Ponder

We will open the book.  Its pages are blank.  We are going to put words on them ourselves.  The book is called Opportunity and its first chapter is New Year's Day.

Edith Lovejoy Pierce

 

Cheers to a new year and another chance for us to get it right. 

Oprah Winfrey  

 

 

Quarterly Webinar

Your support agreement with Munjal White entitles you to attend our quarterly webinar series at no additional cost.  We encourage you to take advantage of these webinars.

 

The next topic is Month End Reconciliations.  Attend this webinar to see what you can do!   Click here to learn more and to register for this webinar scheduled for Tuesday, January 29th, at 10:00am.  In addition to reviewing what reports/accounts should be reconciled, we'll also discuss how to troubleshoot when there are problems.  
Tax Change - Quebec Sales Tax
As of January 1, 2013, the QST will be calculated on the selling price not including GST.  However, to ensure the total taxes payable remain the same, the QST rate will be increased to 9.975%.  For additional information, review the details on the Revenu Quebec website.

If your Sage 100 system has been set up to calculate QST, you should
  • remove the checkbox for Tax on Tax in the Sales Tax Code Maintenance screen for GST (make a note of the Tax Class to the right of the Tax on Tax field) (for example, let's say the tax class is TT) 
  • in the Sales Tax Code Maintenance screen for QST, delete the tax class (in the bottom portion of the screen) that you noted in the GST Sales Tax Code Maintenance screen (tax class TT in this example) 
  • in the Sales Tax Code Maintenance screen for QST, update the tax rate to be 9.975% for all tax classes that remain 

Consult your accountant if you have questions about how this change will affect your business. 

If you need assistance updating the QST setup in your system, please submit a support case by clicking here and we'll get back to you.

 

 

Faster Reports?  Consider MWDataMerge 

Many of our customers rely on reports to manage their business effectively.  One of the common complaints that we hear is that reports can run very slowly on large Sage 100 datasets.  For some customers, upgrading/moving to Sage 100 Premium (MAS 200 SQL) is the right answer.  For other customers, moving to Sage 100 Premium is not possible because of the version they are running or because they have modules or enhancements that are not compatible with the SQL version of Sage 100.

For customers who cannot move to the SQL version of Sage 100, we have developed a solution called MWDataMerge.  MWDataMerge was originally designed to consolidate many companies into the same database so that a single report could be run which would include data from 20+ Sage 100 company codes.  We have extended the functionality of MWDataMerge to store data on a SQL server.  SQL Server and Crystal Reports play very well together.  One of our customers had a report that took 45 minutes to run; the report now takes less than 3 minutes when using our MWDataMerge solution.

If you're interested in more information on MWDataMerge and how it can improve the speed of your reports, click here and we'll get in touch with you.

On a side note, are you interested in upgrading to the SQL version of Sage 100?  If so, click here to send us an email and we'll get in touch with you to discuss a migration plan.  

 

Sage 100 2013 (or MAS 90 / 200 v5.0)  

If your maintenance agreement with Sage is current, you should have received information from Sage about downloading the Sage 100 2013 software from the customer portal.  Sage 100 2013 (also known as version 5) was made available near the end of December.  We are recommending that our clients wait before upgrading to this version.  The software has gone through extensive Beta testing; however, we always recommend that our customers wait a few months before upgrading to a new version  We'll have more information in our February newsletter about the features in this latest software release from Sage.  


 

Interesting Custom Office Projects  

Each month, we get requests from our clients to add additional functionality to Sage 100.  Solutions to these requests are most often done through the Custom Office module.  Each month we will highlight a few of these requests.  These solutions have improved accuracy and saved time for our clients. 
  • Each time a new customer or vendor is added, can the tax schedule default to HST (this was done by creating a script)
  • Ensure that a customer orders a product in a case quantity (for example, we stock a product in each, but need to sell in multiples of 12 (12 per case)) (this was done by creating a script)
  • Show the lead time for each purchase order receipt on the Transactions tab of the Item Maintenance screen (lead time is the number of days between PO date and Receipt date)  (this was done by creating a script) 
  • Change a Sales Order from order type Standard to order type Quote (this was done by creating a script)

Click here to let us know if you'd like to discuss any ideas you might have about how scripting or other Custom Office changes can help your business.

 


We look forward to your feedback and your ideas for future issues of our newsletter.  If you would like to contribute an article or suggest an article or support tip to a future newsletter, we'd love to have your contribution.  Please let us know how we can help you Get the Most from Your Sage 100 Investment.

 

Sincerely,

 

    Shabnam and Robert