Restricted Customer Commodities (SURC.SU23)

The Restricted Customer Commodities (ibis_surc.su23) view allows you to restrict a product line and product group (commodity) for specific customers. You must have the e-Commerce module activated, in order to set up commodity restrictions as these restrictions apply only to your e-Commerce web site. Customers with commodity restrictions cannot add the products associated with the restricted commodities to their shopping carts.

There is a relationship between restricted commodities (surc.su23) and e-Commerce Contact Reference Entry (ibis_ec31/Customer Accounts):

• The commodity restriction/customer relationship is set up in this view (surc.su23).

• In EC31/Customer Accounts, a relationship between the contact and the account (customer) is set up. A contact can be associated with multiple accounts. For each contact/account record, there is a Restricted Products Apply flag.

• In order for the commodity restrictions to apply to the contact, the Restricted Products Apply flag in EC31 must be set.

Note: You cannot edit the company, customer code, product line, product line description, product group or product group description information on either the Search Criteria/Grid page or on the Details page. If a record was created in error or the commodity restriction has changed for the customer, you must delete the record and create a new one.

The following list defines every field available in the customer restricted commodities (surc) table in alphabetical order:

• Commodity - displays the product line/product group codes as the commodity code. This field cannot be edited.

• Company - the company field is available when you create a new customer restriction commodity record. The company defaults to the company assigned to your user id in the Session Parameters view. You can change the default company during the customer commodity restriction creation process only. Once the customer commodity restriction record is created, the company to which the record is associated displays in the General section (at the top of the view).

• Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Customer - enter or select from the look up the customer code for which the commodity restriction is being created. This field is validated against the Customers (ibis_sucu) table. This field is only available when you create new commodity restriction records. Once the record is created, the customer to which the commodity restriction is associated displays in the General section (at the top of the view).

• Customer Selectable - this field is currently available for future custom use. You can also use this field for 'self defined' purposes. Select Yes or No from the drop list.

• Modification Counter - this field is not maintainable. The date and time the record was last modified.

• Modified By - this field is not maintainable. The user or system process that last modified the record.

• Modified On - this field is not maintainable. The date on which the record was last modified.

• Product Group - enter or select from the look up a product group to which the restriction applies. This field is validated against the Customers (ibis_sucu) table. This field is only available when you create new commodity restriction records. Once the record is created, the product group to which the commodity restriction is associated displays in the General section (at the top of the view).

• Product Line - enter or select from the look up a product line to which the restriction applies. This field is validated against the Product Lines (ibis_icc1.im09) table. This field is validated against the Customers (ibis_sucu) table. This field is only available when you create new commodity restriction records. Once the record is created, the product line to which the commodity restriction is associated displays in the General section (at the top of the view).

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.