M9-PR-1118 Multi Company Combined Direct Deposit File

From BlythecoDev Wiki

Jump to: navigation, search



This Custom Solution to the standard MAS 90 MAS 200 Payroll module adds a Combined Direct Deposit File Generation utility to the Direct Deposit menu.

Sage Software’s Direct Deposit Interface must be installed and enabled for this Custom Solution to function.


Before installing any Custom Solution, please verify that the version level referenced on your installation file is the same version level as your Sage 100 (MAS 90 MAS 200) installation. (For more information please call (800) 425-9843). It is recommended to have a complete and tested backup prior to installing any application on your Sage 100 (MAS 90 MAS 200) platform.

Custom Solutions Control Center

Installing any Custom Solution will add an Custom Solutions Control Center to the Sage 100 (MAS 90 MAS 200) Library Master Utilities menu. When you open the Control Center, the following options will be available:

  • Merge Installation Files
  • Custom Solutions Setup options

Custom Office

If you customize your Sage 100 (MAS 90 MAS 200), then you must run the Update Utility every time you install this Custom Solution.


Once the disk is installed, you will need to access the Payroll options screen. After the standard MAS 90 MAS 200 option screens have been displayed, a Setup screen for this Custom Solution will appear. Check the ‘Enable Custom Solution’ box to activate this Custom Solution (Figure 1).

PR-1118 Setup Options

Answer the following prompts:

FILE PREFIX: Enter a three-character file prefix.
COMBINED FILE LOCATION: Enter a location to place the combined file.
BANK CODE FOR COMBINED FILE: Enter the Bank Code to be used for the 1 and 9 records in the combined file.

You should visit this Setup screen after each upgrade or reinstallation of this Custom Solution.


This Custom Solution adds a Combined Direct Deposit File Generation utility to the Direct Deposit menu (Figure 2).

PR-1118 Combined Direct Deposit File Generation

Select one of the following options in the Batches to Be Combined drop box:

Only Batches Never Combined
Only Batches Previously Combined
All Batches

‘Effective Date’ and ‘Created Date’ will always be available. ‘Combined Date’ will only be available if ‘Only Batches Previously Combined’ or ‘All Batches’ have been selected.

This program will read the SY0ACH file that was created by the Direct Deposit Interface and use this file to combine all specified .ACH files from the selection screen into one file. Each .ACH file will be read, and any records that are not types 5, 6 or 8 will be discarded. A new 1 and 9 record will be created. The 1 record will use all of the financial institution information from the Bank Code specified in Setup (i.e., Routing Number, Destination, Origin, etc.). The 9 record will total all values of the combined batches and will also use any financial institution information necessary from the Bank Code specified in Setup. As combining takes place, a ‘Combined Date’ will be added to SY0ACH; if there is a previously existing date, it will be overwritten.

The file will be named with the three-character File Prefix from Setup + YYMMDDHHMMSS+ ".ACH" and placed in the directory specified in Setup.

What’s New

With the 09/28/08 release:

• Modified to work with the standard Payroll Direct Deposit Interface

Upgrades and Compatibility

The installation CD is labeled with the version of the MAS 90 MAS 200 module for which this Custom Solution was prepared. This Custom Solution will check its compatibility with the appropriate MAS 90 MAS 200 modules and will be disabled if an incompatibility is found. If you upgrade your MAS 90 MAS 200 modules, this Custom Solution must be upgraded as well. Your MAS 90 MAS 200 dealer can supply this upgrade.


Only changes made by Blytheco, LLC to the standard operation of Sage Software, Inc. MAS 90 MAS 200 have been documented in this manual. Operations not documented in this manual are standard procedures of MAS 90 MAS 200 processing. Standard MAS 90 MAS 200 processes, data entry screens, inquiry screens, reports, updates, etc., have not been changed unless addressed in this document.

Parts of this document may refer to the Specific Purpose Rule. When referenced, the described feature was developed for a specific client to its specifications and may not conform to generally accepted MAS 90 MAS 200 standards and procedures. These features may or may not benefit you in your application of MAS 90 MAS 200.


Copyright © 2010 Blytheco, LLC. MAS 90 and MAS 200 are registered trademarks of Sage Software, Inc.

Revision Note: 4.4

Personal tools
MediaWiki Appliance - Powered by TurnKey Linux