Product Administration Change Product Category Report overview

Product > Administration > ICA Reports > ICACC

Function acronym: ICACC

Use this report to update entire product category groups or partial product category groups.

Caution: 
Because this report updates many records, it is a time-consuming process. Do not run this report during normal business hours. If you cancel the report before it is complete, a partial update may occur. A partial update corrupts files that cannot be repaired by any standard system function. You cannot restart the report to complete the process.

Depending on the ranges and options that you specify, the report can update these records:

  • SA Table Code Value Setup
  • Product General Ledger Distribution Setup
  • SM Setup Extended Product Category by Customer Totals
  • SM Setup Product Category by Totals and by Vendor
  • Sales orders
  • Purchase orders
  • Bid preparation orders
  • Pricing and rebate records
  • Warehouse transfers
  • Supplier Link
  • Kit production work orders

The Product Setup records are changed regardless of the options that you select. Non-stock product records and non-stock build-on-demand kit component records are also changed. If you choose options that do not make changes to existing records, enter the changes manually.

PD Setup Automatic Pricing records (character version only) and product categories on the SM Sales Analysis Report list screen are changed unconditionally. They are included on the report with separate totals. Product Catalog Setup records are not changed with this function because those records are not company specific.

If you post by product category and on hand balances for a product changed, a manual journal entry is required to keep General Ledger in balance.

This table shows the messages that can be included on the report:

Error Cause/Corrective Action
Old Product Category Does Not Exist In System Table - SASTT A product category that is included in Old Product Category range must be set up in SA Table Code Value Setup. Processing does not occur.
New Product Category Does Not Exist In System Table - SASTT A product category that is included in New Product Category range must be set up in SA Table Code Value Setup. Processing does not occur.
New Product Category Already Exists In System Table - SASTT A product category that is included New Product Category range already exists in SA Table Code Value Setup. Set the Change Existing SASTT Record? option to No.
New Product Category Is The Same As Old Category The new product category and old product category are the same. Specify different categories and rerun the report.
Cannot Use Range of Products If Converting SASTT, ICSEG, SMSP, or SMSEP Records

You specified a range of products and specified Yes for these options:

  • Change Existing SASTT Records?
  • Change Existing ICSEG Records?
  • Change Existing SMSP/SMSVP Records?
  • Change Existing SMSEP Records?

Set the options to No and rerun the report.

Each Transfer Includes Two Product Category Fields. Therefore, Records Changed May Not Match Open Transfers On File If you specified Yes for the Change Existing Orders? (OE, PO, WT, BP) option, the message is included as a warning.
If SMSP records were not changed, please note that all category analysis files will represent category sales prior to this change If you specified No for the Change Existing SMSP/SMVSP Records option, sales records previous to this change will not reflect sales in new category. Update SMSP Totals manually.
If SMSEP records were not change, please note that all category analysis files will represent category sales prior to this change If you specified No for the Change Existing SMSEP Records option, sales records previous to this change will not reflect sales in new category. Update SMSEP Customer Totals manually.
If ICSEG records were not changed, please remember to set up any ICSEG records that may be required to support the new category If you specified No for the Change Existing ICSEG Records option to No, update the records manually.