M9-AR-1054 Automatic Credit Hold Utility

From BlythecoDev Wiki

Jump to: navigation, search



This Extended Solution to the Accounts Receivable module allows you to set a customer's Credit Hold flag by printing the Aged Invoice Report. A customer will be flagged as on Credit Hold if they either exceeded their credit limit or have an A/R account balance greater than zero on or before the Credit Hold Aging Cutoff Date. The Credit Hold flag will be unchecked for all of the other customers that appear on the report.

Additional functionality exists with SO-1328: Hold Flags for Sales Order and Custom Office installed and enabled.


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 Accounts Receivable 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.

AR-1054-Auto Credit Hold Utility
Figure 1

Answer the following prompts:

CREDIT HOLD AGING CUTOFF IN DAYS: Define a number of days. The Credit Hold Aging Cutoff Date is calculated by subtracting the number of days defined here from the workstation’s system date.
DEFAULT ANSWER TO SET CREDIT HOLD FLAG BY: Enter the default answer for the prompt ‘Set Credit Hold By’ for the Accounts Receivable Aged Invoice Report: Credit Hold Aging Cutoff Date, Over Credit Limit, Both (see Operations).


The Accounts Receivable Aged Invoice Report has been modified with a new drop list button, ‘Credit’ (Figure 2) which provides access to the prompt ‘Set Credit Hold By’ (Figure 3). The value for ‘Set Credit Hold By’ defaults to what was specified in Setup.

AR-1054 Accounts Receivable Aged Invoice Report
Figure 2

Automatic Credit Hold
Figure 3

When the Aging Option to Print, in the Options panel, is set to ‘All Open Invoices’ the Set Credit Hold By options will produce the following results:

If you select ‘Credit Hold Aging Cutoff Date’, any customer with an A/R account balance greater than zero on or before the Credit Hold Aging Cutoff Date (depending upon the aging method) will have the credit hold flag set to Yes. Only invoices which met the selection criteria for the A/R Aged Invoice Report will be tested against the Credit Hold Aging Cutoff Date.

If you select ‘Over Credit Limit’, customers with Accounts Receivable balances greater than their credit limits will have their credit hold flags set to Yes.

If you select ‘Both’, then the customer’s credit flag will be set to Yes if either his or her A/R balance is greater than zero on or before the ‘cutoff’ date, or he or she has exceeded his or her credit limit.

If you select ‘Credit Hold Off’, then all customers’ credit hold flags are set to ‘N’ regardless of their A/R balance or the ‘cutoff’ date.

The Customer’s Credit Hold flag will never be checked under the following circumstances:

  • when checking against the Credit Hold Aging Cutoff Date and the Customer is Balance Forward
  • when checking against the credit limit for a customer that has his or her credit limit set to zero (i.e., no credit limit).

If you have SO-1328, Hold Flags For Sales Orders, installed and enabled, when the customer’s credit hold flag is set to unchecked, the SO Header UDFs for ‘Terms Hold’ and ‘Credit Hold’ specified in the setup of SO-1328 will also be set to unchecked for this customer.

Helpful Hints

  • The ‘age’ of an invoice is determined by the answer to the standard MAS 90 MAS 200 A/R Setup question, ‘Do You Want To Age Invoices From The Invoice Date Or Due Date?’

What’s New

With the 10-04-07 release:

  • Added integration with SO-1328

With the 08-21-06 release:

  • Converted 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