M9-SO-1051 Salesperson Commission by Product Line - Item Number

From BlythecoDev Wiki

Jump to: navigation, search



This Extended Solution adds a new entry screen to A/R Salesperson Maintenance for entering Salesperson Commission by Product Line or by Item Number.

The Inventory Setup option ‘Calculate Commission by Inventory Item’ must be checked and all Inventory Items eligible for SO-1051 commission must have their Commission Method set to something other than ‘None’.


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-1051 Setup Options

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


Salesperson Maintenance
Salesperson Maintenance has been modified with a ‘Comm…’ button (Figure 2). Click this button to access Commission Percentage Entry (Figure 2) where you can create multiple records per Salesperson by item number or by product line. For each record specify the commission method, the base rate and the base commission in the same manner as you would in the Inventory masterfile for the item.

SO-1051 Salesperson Maintenance

A lookup into the existing records in the file is available (Figure 3) via the button located next to the Item Number lookup.

The Percent of Cost Commission Method uses the Last Cost in Inventory Maintenance.

SO-1051 Commission By Sprsn-Prod-Item

Sales Journal Update
During the Sales Order commission calculation process, the following hierarchy will be employed:

1. Salesperson Commission by Item Number will take precedence over Salesperson Commission by Product Line
2. Salesperson Commission by Product Line will take precedence over standard Inventory Item commission calculation.

If no applicable record is found in A/R Commission by Salesperson/Prod/Item file, then the standard commission calculation will resume.

Crystal Reports and the ODBC Dictionary

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

SO-1051 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-07 release:

  • Upgraded 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.


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