Sage MAS 90 | Sage MAS 200| Sage MAS 500| Sage CRM SalesLogix | DSD

Sage MAS 90 and Sage MAS 200 Technical Tips from DSD Business Systems

****JavaScript based drop down DHTML menu created by Dan Smith. (DSD Inc. - http://www.dsdinc.com)****

MAS 90 & 200 Tech Tips General Tech Tips Hidden Utilites Identifying MAS 90 CD Roms Copying Company Data MAS90 3.71 PDF Manuals Recovering Disk Space Year End Closing Procedures E-mailing and Invoice or Order Creating a Custom Look-up Are you ready for 4.0? Business Insights Wizard Tape Backup Strategy Windows SP2 for 3.71 & 4.0 FRX Desktop - Custom Financials Share Point Required on Server How to copy a company in 4.0 Accounts Payable Tips Payments &: Wire Transfers Reversing an AP Check 1099 Printing for Year 2003 E-mailing an Order or Invoice Accounts Receivable Tips Bank Transfers Sales Tax Calculation Utility Balance Forward Issue Customer Sales Summary by Year Report Top 15 Customer Rank Report Refunding Sales Tax Customizing Lookups in 4.0 Apply a Credit Memo to an Invoice Processing Customer Deposits E-mailing an Order or Invoice General Ledger Tips Balancing Inventory to the GL Finding G/L Problems & Preparing for 4.0 Out of Balance in 4.0 Trial Balance Recording Bank Transfers with Transaction Journal Entry Batch Processing in G/L 4.0 Inventory Tips Inventory Transaction Types Purchase Order Tips How to Clear Backorderd PO's Managing the PO Clearing Account Payroll Tips Voiding a Direct Deposit Check Arizona State Income Tax Min. $5.00/Month Workaround Updating Federal 941 Form for Year 2003 2003 Payroll Year-End Procedures W-2 Processing W2 Printing for Year 2003 Sales Order Tips Credit Memo with a Credit Card Processing Customer Deposits Crystal Reports Tax Tips Using Form DE-4 to adjust CA State Income Tax Withholding 1099 Printing for Year 2003 W2 Printing for Year 2003 2003 Payroll Year-End Procedures W-2 Processing MAS 90 4.0 Tech Tips Are you Ready for 4.0? Solving Client Server Firewall Issues Finding G/L Problems & Preparing for 4.0 Out of Balance in 4.0 Trial Balance Windows XP SP2 Support for 4.0 Recording Bank Transfers with Transaction Journal Entry Batch Processing in G/L 4.0 How to Copy a Company in 4.0 DSD Services Training MAS 90 & MAS 200 MAS 500 SalesLogix On Site Training Crystal Reports IT & Network Services Internet Services Professional Services Consulting Implementation Support Custom Programming

Sage MAS 90 & Sage MAS 200 General Tech Tips

DSD Sage MAS 90 Tech Tip 1 - Hidden Utilities

Here is a list of useful Sage MAS 90 “hidden” utilities you should be aware of. These utility programs are run from the Sage MAS 90 Menu Bar, File/Run, and typing in the program name.

APWRVD is the A/P Purge Void Checks utility. This program is used to purge a large range Void check records, which were created incorrectly. Generally, you would run the program when you attempt to Reverse an A/P Check, but get the message that the check has been voided. Running this utility program allows you to delete the Void Check, so the actual check can be reversed.

GLWSJA is the Purge G/L Update/Report in Process Flag utility. When a G/L register is updated, or a G/L report is run, a flag in set in the SY0CTL.SOA System Control File. If the process does not complete normally, this flag is left in place, preventing G/L updates or report printing. This utility clears this flag.

GLWSKA is the Clear Check Printing Flag Utility. When A/P Manual Check Printing, standard Check Printing, or Payroll Check Printing is started, a flag is set on the Bank Code to prevent another check printing program from being run, at the same time, for the same Bank Code. If the Check Print program terminates abnormally, this flag is left on the Bank Code. This utility is used to clear this flag, so check printing can be resumed. In older Sage MAS 90 systems, the procedure was to use Data File Display & Maintenance, and edit GLWccc(60,1) for the Bank Code record, and blank out the check printing flag.

IMZBL1 is the Inventory Quantity On Hand Balancing Utility. This utility program is used to compare and report discrepancies between the Warehouse Detail (IM2) file and Cost Detail (IM3 cost tier) file for FIFO, LIFO, LOT or Serial valuation items. This character-based program will allow you to fix FIFO or LIFO items. Lot and Serial items must be fixed on a case-by-case basis using transactions or the FIX hidden feature.

PRZDRR For those of you with Payroll, PRZDRR is used to edit the Form 941, if some of the data fields printed on the report need to be corrected.

SVDATA is the windows version of the old character based SUDATA. The Copy Data Files to New Company utility program is used to make a duplicate copy of one company’s application data files into another company code. This utility is useful for making a backup of your Sage MAS 90 data files within Sage MAS 90, creating a Test Company using your own data, or other purposes.

Sage Software, the Sage Software logos, and the Sage Software product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other trademarks are property of their respective owners.