Creating a set of product cross-reference records for a customer

When you create a set, specify a customer number as selection criteria. Product cross-reference records for products in warehouses that are associated with the customer are extracted, based on the customer that is specified on Product Warehouse Description Setup records.

  1. Select System Administrator > Administration > Mass Maintenance.
  2. Click Create.
  3. Specify this information:
    Set Name
    Specify a unique alpha-numeric value to identify the set.
    Table Name
    Select ICSEC-Product Cross Reference.
    Record Limit

    Specify a value to limit the number of records to extract. Leave the default value to extract up to 100,000 records.

    Note: If more than 100,000 records are available for extraction, a warning is included on the SA Mass Maintenance Utility Report. You can create another set to extract the additional records.
  4. Click Next.
  5. In the Beginning Value and Ending Value fields for the custno field name, specify the number of the Storeroom customer.
  6. Click Next.
  7. Select all of the extraction columns, and then click Select/Deselect.
    The check boxes in the Selected columns are selected.
  8. Click Next.
  9. Select a value in the Create Tab Delimited Output File field to create a tab-delimited file. If you select Send To Email, specify the email address.
  10. Specify printing information for the SA Mass Maintenance Utility Report.
  11. Click Finish.
  12. Save the file to a local directory for editing.