M9-BR-1002 Multiple Company Bank Reconciliation
From BlythecoDev Wiki
Contents |
Synopsis
This Extended Solution modifies reconciliation to consolidate like records across multiple company codes into a single entry in the company code in which the Extended Solution is enabled. Checks will always be consolidated. Check consolidation criteria are: same check number, date, type and source module. Deposits and adjustments can be consolidated, or left as individual records. Criteria for consolidation of deposits and adjustments are same adjustment type and date.
The records will be cleared from the source companies as the consolidation is performed.
Installation
Before installing any Extended Solution, please verify that the version level referenced on your installation file is the same version level as your 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 MAS 90 MAS 200 platform.
Extended Solutions Control Center
Installing any Extended Solution will add an Extended Solutions Control Center to the MAS 90 MAS 200 Library Master Utilities menu. When you open the Control Center, the following options will be available:
-
- Merge Installation Files
- Extended Solutions Setup options
Custom Office
If you customize your MAS 90 MAS 200, then you must run the Update Utility every time you install this Extended Solution.
Setup
Upon completion of software installation, you will need to access Extended Solutions Setup from the Bank Reconciliation Main menu. Select this part number, and the Setup screen for this Extended Solution will appear (Figure 1). Check the ‘Enable Extended Solution’ box to activate this Extended Solution.
CONSOLIDATE DEPOSITS AND ADJUSTMENTS: Check this box to consolidate deposit and adjustment transactions. If unchecked, each company’s deposits and adjustments will be written as individual records.
Extended Solutions will be added to the Bank Reconciliation Main menu as a Setup Option task. Please review your security setup in Role Maintenance and make appropriate changes
Operation
Bank Reconciliation, Bank Code Maintenance
Bank Code Maintenance has been modified with a Merge button (Figure 2). Clicking this button will present you with the Multi Company Merge Options (Figure 3).
Clear Existing Records Before Merge Check this box to delete all existing records for this company code bank code prior to performing the consolidation. This would be checked if the company code under which you are performing the consolidation is not used to process any banking activities. Leave it unchecked to merge the incoming records with the existing records.
Company Codes To Merge Enter an unlimited number of company codes to be included, clicking the Add button after each entry or click the Select All button to include all company codes. (You will not be able to enter the company code in which you are performing the merge). Only company codes which
-
- have Bank Reconciliation installed
- do not have BR-1002 enabled
- the user code has the assigned task of ‘Reconcile Bank’
will be available. Company codes can be deleted individually from the list via the Delete button, or all can be removed via the Clear button.
When the company code list has been compiled, click the Proceed button. Records in the selected company codes for this bank code will be merged with existing records. Checks will be consolidated for all transactions with the same check number, check date, check type and source module.
If you checked ‘Consolidate Deposits and Adjustments’ in setup, the merge processing will consolidate all like deposit and adjustment transactions from the other company codes for this Bank Code. Deposits and adjustments will be consolidated by date.
Reconcile Bank
A Source Company column has been added to both tabs of Reconcile Bank. It will contain the Company Code from the first record consolidated. It will be blank if the record existed only in the current company code. Figure 4 is an example from the Checks tab and Figure 5 of the Deposits/Adjustments tab.
What’s New
With the 1/20/2006 release:
-
- Added a new setup option ‘Consolidate Deposits and Adjustments’ to the setup screen.
- Restrict the company codes for merging to the company code’s for which the User has the assigned Task of ‘Reconcile Bank’.
- Updated to Business Framework.
Upgrades and Compatibility
The installation CD is labeled with the version of the MAS 90 MAS 200 module for which this Extended Solution was prepared. This Extended 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 Extended Solution must be upgraded as well. Your MAS 90 MAS 200 dealer can supply this upgrade.
Documentation
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.
Acknowledgments
Copyright © 2010 Blytheco, LLC. MAS 90 and MAS 200 are registered trademarks of Sage Software, Inc.
Revision Note: 4.4
