M9-PO-1158 Square Foot Calculation with Custom Office UDFs

From BlythecoDev Wiki

Jump to: navigation, search



This Extended Solution to the Purchase Order module creates a Square Foot calculation in Purchase Order Entry using Custom Office UDFs.

The Custom Office module must be installed and enabled for this Extended Solution to function.


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 Purchase 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.

PO-1158 Setup Options
Figure 1

Answer the following prompts:

P/O LINE CUSTOM OFFICE UDF FOR LENGTH: Enter a Purchase Order Detail Custom Office Numeric UDF for Length.
P/O LINE CUSTOM OFFICE UDF FOR NUMBER OF PIECES: Enter a Purchase Order Detail Custom Office Numeric UDF for Number of Pieces.

You should not add the above two UDFs to the Purchase Order Line Entry Grid via Customizer.

I/M CATEGORY CODE FOR WIDTH: Enter the I/M Category Code which will hold the Width in feet.

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


During Purchase Order Line Entry, prior to entry of the Quantity Ordered field, the line item UDFs will appear in a pop up (Figure 2). Enter the Length in Feet, and the Number of Pieces. As you exit the pop-up window, the program will perform a calculation to arrive at the Quantity Ordered for the line: (Length * Width * Number of Pieces). The program returns control to the Quantity Ordered field, which may be edited.

PO-1158 Square Foot Calculation
Figure 2

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