Sage 100 – Hidden Utilities

Here is a list of useful Sage 100 Hidden Utilities you should be aware of. You can run these utility programs by navigating to the Sage 100 Menu Bar, clicking File>Run, and typing in the program name.

ARWAR4

ARWAR4 is the AR Clear Open Invoice Payments Today flag utility. The ARWAR4 utility is available in version 4.10 only if program fix AR4008-T is installed (or Service Pack 1).

1. Within Sage 100 click File > Run and typing ARWAR4.
2. Click ‘Yes’ at the prompt. This changes the ‘Payments Today’ field in AR4 to match the data in AR9 and ARA (Case Receipt data entry files).

 APWRVD

Sage 100 4.10 and prior: APWRVD is the AP 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 AP 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. Use APZR00 for Sage MAS 90 3.23 Character versions and UNIX.

For Sage 100 4.20+: this utility has been moved to the AP Utilities Menu – “Remove Voided Checks”.

GLWSJA

GLWSJA is the Purge GL Update/Report in Process Flag utility. When a GL Register is updated, or a GL 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 GL updates or report printing. This utility clears this flag. This utility is available in MAS 90 3.23. Note: An alternate method is to use DFDM to clear the flag in SY0CTL.SOA. The record has the key [ABCRPTTxx]r [ABCUPDTxx], where ABC is the company code and Txx is the Terminal ID.

4.0 or later:

1. Rerun Workstation Setup. For more information, see How to install Workstation Setup for Sage 100.
2. If the error persists, have all users exit Sage 100, and reboot the workstation and server (if necessary).

GLWSKA

GLWSKA is the Clear Check Printing Flag Utility. When AP 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 100 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.

3.71 and Prior the message is “Other Check Printing in Progress”

4.00 and later the message is “Bank Code In Use”

GLZMSU

GLZMSU is used to move “actual” Beginning Balances and/or period balances 1 through 13 from one year to another year currently defined in Fiscal Year Maintenance. GLZMSU can also set the “actual” Beginning Balances and/or period balances 1 through 13 to zero for any defined fiscal year. Detailed instructions and GLZMSU worksheets can be found on the MAS Technical Reference and Support Guide CD. Contact Sage 100 technical support or your Reseller prior to running the utility, and be sure to make a backup of your GL files.

IMWIM5

The IMWIM5 utility (Sage MAS 90 3.70) uses the Item Warehouse Detail File (IM2) and the Inventory Transaction Detail File (IM5) in its calculation to determine the correct Quantity on Hand Dollar Amount Beginning Balance in the Beginning Balances file (IMW) and Beginning Average Cost in the Item Warehouse Detail file (IM2). Additionally, the utility recalculates the Quantity on Hand Beginning Balance in the Beginning Balances file (IMW) and updates this value, if necessary. A report is printed if the prior value in the Quantity on Hand Beginning Balance does not equal the calculated Quantity on Hand Beginning Balance.

The IMW file is a key component of the IM Trial Balance Report, and this utility should be run immediately after closing Inventory (if inventory is not closed in a timely manner) to correct the IM Trial Balance Report.

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

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 (3.71 and prior) data files within Sage MAS 90, creating a Test Company using your own data, or other purposes.

SVFCPY

SVFCPY is a wizard which allows you to copy standard forms from one company code to another company code. Note: Crystal forms are not copied. This does not affect the SVDATA utility.

ESC Serves as a toggle switch to enable or disable two completely separate functions.

The primary function of the *ESC command is to turn SAGE 100 error trapping on or off. After selecting Run from the File menu, typing the command, and clicking OK, type Yes at the “ERROR TRAPPING IS CURRENTLY SET TO (Y/N). DO YOU WANT TO CHANGE IT?” prompt. If error trapping has been disabled, it can be enabled by running the *ESC command again or by exiting, then entering SAGE 100.

Error trapping is automatically turned on each time SAGE 100 is started. For additional information on

this function, refer to Error Trapping in the TRSG Advanced Features.

The secondary function of the *ESC command is to enable or disable screen customizations made

through the SAGE 100 Custom Office module.

This can be very helpful when diagnosing errors that occur on customized screens. By turning the customizations on and off, you will be able to determine if the error is related to the screen customizations. If the screen customizations have been disabled, they can be enabled by running the *ESC command again or by exiting, then entering SAGE 100. Screen customizations are automatically turned on each time SAGE 100 is started.

SWUPCS

This standard old Sage MAS 90 Utility allows you to easily convert selected data/files to all Uppercase (e.g., Customers, Ship-To Addresses, Vendors, Purchase Addresses). And you can choose to update all Address Fields or just the City. (Maybe you forgot about the “Return City Names in ALL CAPS” setting in L/M > Company Maintenance.)

This is a permanent change that affects all companies and cannot be reversed. Make a full backup before proceeding.