• Considerations When Getting a New Computer
• Sage 100 - Selecting Multiple Non-Consecutive Accounts When Printing General Ledger Reports
• Don't forget to install service updates
• Printing MICR checks
• Tips and Tricks for Bank Reconciliation
• Tips and Tricks for Purchase Order
• Clearing purchase clearing
  

Ever wanted to print that general ledger detail report for a couple of account that were not consecutive?  Maybe you wanted your fixed assets, accumulated depreciation, depreciation expense and gain or loss on disposal accounts.  So you ran the report 4 times.

Select the operand "Equal to" and then type in the account numbers that you want separated by commas.   Sorry, you can't use the look up if you have multiple accounts.

Back to Index

DON'T FORGET TO INSTALL PRODUCT UPDATES

Don't forget to install product updates when you install version upgrade. These updates include important patches and enhancements to the software between CD releases. Sage Support website.

You should periodically check for the latest service update in between upgrades as well.  If you have third party modifications,  do make sure that they are compatible with the lasted product update.

In addition,  make sure you back up your Sage 100 install before applying product updates just in case the unexpected happens.

Back to Index

PRINTING MICR CHECKS

Did you know you can print MICR checks from MAS 90? With the MICR checks capability you can use blank check stock and print multiple companies checks to the same stock and never have to worry about loading and unloading different checks.

What you need
1. Blank check stock
2. A laser printer
3. MICR toner cartridge for your laser printer
4. Adobe Font for MICR characters (less than $100)
5. Crystal Reports loaded on your workstation to do any modifications necessary to your check format

What to do:

1. Load the Adobe MICR font on the computer that will be used to print the checks.

2. Make sure that graphical checks are enabled in the module you wish to print from (AP / PR). This is usually in the setup options window on the last tab.

3. In bank code setup click on the MICR button. Enter all the requested information.



4. Be sure your laser printer has the MICR toner cartridge inserted.

5. Print!

6. Be sure to take a test check down to your bank and make sure that the MICR encoding is readable. The MICR readers are sensitive to the exact positioning of the MICR characters.


Back to Index

PURCHASES CLEARING

Ever been frustrated with trying to reconcile that purchases clearing account in your general ledger? If so, you know that the purchase orders module's purchases clearing report only gives you the detail as of right now. You can't go back and ask for what was in it on December 31 and your accountant wants to know what the balance consists of!

Wouldn't it be much nicer if there wasn't any balance in the general ledger account at the end of the month?

The purchases clearing account is really just accounts payable for which you have not received a bill yet. In other words you have done a receipt of goods but don't have the invoice. You have the goods and you owe your vendor something, you just don't know exactly what. When the bill finally comes in, you enter it in with receipt of invoice and the purchases clearing account zeros out.

Make sure that when you do a receipt of goods without an invoice, that when you later do the receipt of invoice that you post to the same G/L date as when you did the receipt of goods. The invoice should really be recorded at the date the goods were received, not when the invoice was received.

This should make the G/L balance of purchases clearing -0- at the end of a given month once all invoices have been entered.

Back to Index