M9-SO-1119 General Ledger Account Number Override by Code

From BlythecoDev Wiki

Jump to: navigation, search



This Extended Solution allows you to maintain a list of Override Codes which can be applied at a document level or a line level to change the Cost of Goods Sold and Sales Accounts.

This Extended Solution requires Custom Office to be installed.


Before installing any Extended 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.

Extended Solutions Control Center

Installing any Extended Solution will add an Extended 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
  • Extended 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 Extended Solution.


Upon completion of software installation, you will need to access Extended Solutions Setup from the Sales Order Setup 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.

SO-1119 Setup Options
Figure 1

Answer the following prompt:

OVERRIDE CODE BY: Select ‘Line UDF’ if you wish to specify an Override Code by line. Select ‘Header UDF’ if you wish to specify an Override Code by Order/Invoice.
G/L ACCOUNT OVERRIDE CODE UDF: Specify the string-type, uppercase Custom Office UDF to use for the Override Code. If you specified ‘Line UDF’ above then this will need to be a SO Sales Order Detail UDF. If you specified ‘Header UDF’ above then this will need to be a SO Header UDF. The UDF can be up to 10 characters long. If you want this processing in S/O Invoice Entry as well, then you will need to have setup a UDF of the same name for the corresponding SO Invoice UDF table.

To add lookup and validation capabilities to your UDF, in Custom Office User Defined Field Maintenance - Validation tab, check the User Defined Table radio button and select the SO_GLAccountOverride_001 table in the drop down box (Figure 2). You can do so before enabling this Extended Solution.

SO-1119 SO Invoice Header: Edit Field
Figure 2

The following Task has been added:

• ‘G/L Account Override Maintenance’, can be found under the Sales Order Setup Menu.

Users who are authorized to run any of the above should be granted permissions for the prospective tasks and security events. Please review your security setup in Role Maintenance and make appropriate changes.

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


G/L Account Number Override Maintenance
This option has been added to the Sales Order Setup menu (Figure 3). When accessed, you will be prompted to define your Override Codes, a corresponding Description as well as the Cost of Goods Sold and Sales accounts which will be used in conjunction with this Code.

The Override Code in the G/L Account Override table is 10 characters long. If you setup a UDF that is shorter than 10 characters, you should not set up override codes that exceed the length of your UDF.

SO-1119 GL Account Number Override
Figure 3

A listing is available for printing by clicking the printer button (Figure 4).

SO-1119 View GL Override Code Listing
Figure 4

Sales Order or Sales Invoice Entry
If you specified to override by a line UDF, then as a valid Override Code is entered in the specified UDF, the COGS and Sales accounts will be overridden with the account numbers associated with that Code. If the Override Code UDF is left blank, then no changes will be made to the default accounts.

If you specified to override by a header UDF, then as a valid Override Code is entered, the COGS and Sales accounts on all lines will be refreshed. All lines added after an Override Code has been defined will use the Override Code’s accounts. If an existing Override Code is blanked out, no refresh will occur.

The features of this Extended Solution are not available in Shipping Data Entry.

ODBC Dictionary

The files listed below have been added or changed in the ODBC Dictionaries by this Extended Solution for Crystal Reports purposes.
SO-1119 ODBC Dictionary

Be aware that the ODBC Dictionaries may contain other files and data fields that will be unavailable without their corresponding Extended Solutions installed.

What’s New

With the 02-21-06 release:

  • Converted to Business Framework
  • Converted the UDFs from SO-1014 or SO-1113 to Custom Office

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.


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