Keeping in Touch
Getting the Most from Your Sage MAS 90 / 200 Investment 
November 2008, Issue 12
Newsletter Contents
Bank Transactions and Security
Customer and Inventory Analysis
Multiple Companies, Visual Integrator, General Ledger
Join Our Mailing List!
Quick Links
 
 
Current Course Calendar 
 
Introduction to Crystal Reports - Mon & Tue, Nov 24 & 25
 
Crystal Reports (v10) Refresher - Wed, Nov 26
 
Click here for more information 
Greetings!
Welcome to our new and improved newsletter.  From time to time, our clients challenge us with new requests where creative solutions or third party enhancements are required.  This newsletter includes a few of these -- perhaps you might need something like this, too.  We look forward to your feedback.
 
Bank Transactions and Security 

We have 3 separate solutions to help you gain efficiencies in your bank reconciliation and vendor payments processes.

Ability to download a list of cleared cheques from the bank and import this into Sage MAS 90.  Any differences between the bank file and the data in the Bank Rec module are highlighted as differences.  This is a great utility to make the cheque clearing process more streamlined.

Ability to send a list of cheques issued to your bank so that fraud can be virtually eliminated.  If a cheque is issued for payment that does not match the details sent to your bank, the payment is rejected.  This service is called Positive Pay and is available from most major financial institutions.

Ability to send payments to your supplier by EFT.  This is a very cost effective solution.  Details of the EFT payments made are emailed to your supplier through Business Alerts.

Click here for additional information on any of these solutions. 

 

Customer and Inventory Analysis
Perhaps you've upgraded recently and noticed that your historical customer and vendor analysis summary information is not correct.  Or, you've merged customers together and the customer analysis information does not reflect the totals for all the customers that were merged together.  We have a utility available that will recalculate the customer and vendor analysis information based on AR and AP history.  For additional information, please click here.
 
If you have changed your inventory reporting periods from a fiscal year to a calendar year, you will have noticed that the period by period information is no longer accurate.  We have a utility available that will recalculate this for you based on your AR invoice history.  This enhancement is 15% off until November 15.  For additional information on product pricing and features, please click here.
 
Multiple Companies, Visual Integrator, General Ledger
Consolidated reporting - one of our customers has many company codes within Sage MAS 90 and they needed to create a consolidated AR Aged Invoice Report for the bank.  Crystal Reports alone could not do this, so we created an Access database that consolidates the necessary data files from each company code and then a Crystal Report can be designed based on this.  The great thing about this project is that the data files being consolidated can include any MAS data file (AR invoice history, Inventory items, AP open invoices, etc).  The utility was written with a specific purpose in mind, but it can be used in virtually any MAS reporting situation.  For additional information, please click here.
 
Ability to account for intercompany transactions automatically.  For example, while posting an AP invoice in ABC company, you want to be able to post the expense to XYZ company and have the intercompany accounts on both sides recorded automatically.  DSD Business Systems has written this utility; we have a few clients using this and they love it!  Click here for additional information.  This enhancement is 15% off until November 15.
 
After a Visual Integrator (import) job has run, the source file can be renamed to a different file name so that it is not re-imported.  Click here for additional information.
 
After a Visual Integrator (import) job has run, the summary results of the job (number of records read, number of record imported, number of records failed, etc) can be emailed to the system administrator.  Click here for additional information.
 
Ability to edit a General Ledger posted transaction.  For example, after a journal entry has been posted, it is discovered that the amount, account, date, or description was incorrect.  Wouldn't it be cool if you could edit the transaction, rather than reversing it and re-entering it?  This utility also works well if you experience out of balance postings.  DSD Business Systems has written a great utility for this.  Click here for additional information.   This enhancement is 15% off until November 15.
 
 
We look forward to your feedback and your ideas for future issues of our newsletter.  Please let us know how we can help you Get the Most from Your Sage MAS 90 / 200 Investment.
 
Sincerely,
 
    Shabnam and Robert