How to Remove Zero Quantity Cost Tiers from Inventory in Sage 100


How to Remove Zero Quantity Cost Tiers from Inventory in Sage 100


Backup Warning

Use caution when working with the below product functionality. (Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst. 


  1. Open Inventory Management, Utilities menu, Remove Zero Quantity Costing Tiers
  2. Enter the desired data in the Remove Costing Tiers with Zero Quantities Dated on or Before field
    • The last date of the current period is the default date
    • This removes any existing zero quantity tiers that are not posted to a future period

Note: Beginning with version 5.10.6 , a new column, Tier Value, was added to the Negative Tier Report, Costing Tiers with a non-zero Tier Value on the Negative Tier Report or Inventory Value on the Valuation Report will not be removed by running this utility. See Related Resources. The Remove Zero Costing Tiers was changed to look at the both the Quantity and the Value so that the tier is not removed unless both the quantity and value are zero. This is to prevent removal of stranded values as a result of mistakes made in modifying the cost on prior transactions. 

Caution: It is highly recommended that this procedure be performed in a test company code first where the desired results can be viewed. Record removes during this processed cannot be recovered.