SA Administrator Inactive Product Removal Report overview

System Administrator > Administration > SAA Reports > SAAIP

Function acronym: SAAIP

Use this report to inactivate inactive products and then remove the product records and any attached records. Run this report at least once a year.

This report generates an exception report that includes this information:

  • The number of products that were inactive before the report was run
  • The number of products with no activity
  • The number of product records that are inactivated
  • The number of product records that were deleted from the database
  • The total number of exceptions that were encountered

You can run the SA Administrator Inactive Product Removal Report to review the records that qualify for deletion before you delete them. To run the report for review, select these values on the report:

  • Specify No for the Delete Inactive Products? option.
  • Specify Yes for the Inactivate the Non-Active Products? option.

When you run the report to delete the records, select Yes for both options.

Caution: 
The system administrator or someone familiar with product records should run this report. A security level of 5 is required to make deletions. We recommend that you review the records before deleting them.

Product records are not inactivated or deleted if sales order entry or warehouse transfer ties exist.