Target System Technology, Inc.
MAS 90 Tips

 


MAS 90 Helpful Hints
Do YOU have a creative tip for using MAS 90?

Have you got a time saver? A solution to that annoying little transaction or reconciliation problem?

E-mail your tip to Tom Rogers and maybe we will post it here for all to see.

By e-mailing your tip to us you consent to its use on our website or other materials.

SELECTING MULTIPLE NON-CONSECUTIVE ACCOUNTS WHEN PRINTING GENERAL LEDGER REPORTS

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


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


BANK RECONCILIATION

Ever had your bank reconciliation work out perfectly, but when you compare to your general ledger you find that the general ledger indicates a different balance?

The following tips can help you keep them in sync.

1. Never post to a bank account which is linked to bank reconciliation with a general journal entry. General journal entry will not create a corresponding entry in the bank reconcilation module. If you must enter through general ledger (instead of payables or receivables), use transaction journal entry and a source journal that is linked to the bank reconciliation. This will create an entry in the bank reconciliation module.

2. Be careful when using manual check entry to enter checks that the check dates and your posting dates are in the same month (if your check date is 01/25/02, be sure that your posting date when you update is also in January 2002). Failure to do so will result in the check showing in January 2002 in the bank reconciliation module, but possibly in February 2002 in the general ledger.

3. If you accidentally make the error noted in #2 use the advance look up engine to review the check date and transaction (posting) dates in accounts payable to look for inconsistencies. To do this:

a. Goto A/P | Main | Payment History Inquiry
b. Select the bank account you wish to review
c. Click on the look up for check number.
d. Click on the Custom button. Click on the Next button.


e. Add the Transaction Date field to the lookup.

f. Click Finish.

g. Do a lookup and look for non-matching check and transaction dates (notice the second to last line in the screen shot below).



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

This web site is owned by Target System Technology, Inc. Target System Technology, Inc. is independent from Best Software and is not authorized to make any statement, representation or warranties or grant any license or permission on behalf of Best Software regarding and Best Software product, service or Web site content. Certain materials made available on or through this web site are owned by Best Software and cannot be used without Best Software's prior written permission.

Back to Home Page
Back to MAS-90 Page