Skip to Main Content
Return to Navigation

Using Quick Customer Create Functionality

This section provides an overview of quick customer create functionality and discusses how to:

Pages Used for Quick Customer Create Functionality

Page Name

Definition Name

Navigation

Usage

Customer Search

QUICK_CUST_SRCH

select Customers, then select Customer Information, then select Quick Customer Create, then select Customer Search

Search for customers or enter new customers. Determine factors such as contacts' correct customers or which customer addresses to use. Quick Customer Create updates the Contact/Customer tables.

Customer Summary

QUICK_CUST_SUMMARY

Click the Search button on the Customer Search page.

View customer and contact search results, and select the correct matches.

Customer Summary Detail

QUICK_CUST_DTL

Click the View details for selected customer(s) link on the Customer Summary page.

View additional customer information, navigate to transactions, and update contact and customer information. The system applies customer and contact information to the transactions automatically.

Contact User Profile Display

QUICK_CUST_USR_DSP

Click the View User link on the Customer Summary - Detail page.

View contacts' user profile information. This page is read-only.

Create New Customer/Contact

QUICK_CUST_CREATE

Click the Create New Customer/Contact link on the Customer Search page, Customer Summary page, or Customer Summary - Detail page.

Enter new customers' information.

Contact User Profile

QUICK_CUST_USER

Click Add User on the Customer Create page.

Enter contacts' user information to enable them to access self-service transactions.

Contact Credit Card Info

QUICK_CUST_CRCARD

Click Add Credit Card Information on the Customer Create page.

Enter contacts' credit card information.

Understanding Quick Customer Create Functionality

Quick Customer Create enables the customer service representative (CSR) to determine if a customer exists in the system and to enter the minimum number of fields for an order if the customer is new.

Search Logic for Quick Customer Create

The search functionality does not use a wildcard percentage from the beginning of the search. The search logic is not case sensitive and uses and in the search logic (instead of or) when you enter multiple search criteria. The search functionality also uses a like operator for all nonprompt search fields and a = operator for all prompt fields. For example, if you enter USA as the country and Broadway as the Address1, then all addresses with a country of USA and an address line one of Broadway appear in the search results.

To improve search results:

  • Add indexes on the most commonly used fields on which you search.

  • Modify the call to the function resolve_wildcard so that they can perform an exact search or a like search.

  • Modify the call to the function resolve_wildcard so that if the search does not need an UPPER, they should remove it.

    For example, if you are searching for the city Paris and you also type the city in the same way, the call to the function resolve_wildcard should not UPPER the city name.

Entering New Customers and Contacts

The CSR can enter a new customer and contact from the Customer Search page or from the Customer Summary page if the search returned no results or if the customer is new. The new customer can have only one contact, customer, and address and must have the same sold to, bill to, and ship to information. When entering the new customer, select a setID and a template customer, which, selected from all customers in the setID, populates the additional fields in the customer tables that are not entered on the Create New Customer/Contact page.

This table list the fields that the template customer updates when using Quick Customer Create. You can set up additional fields from the Maintaining Customer and Maintaining Contact menus.

What Is Created

What Is Updated

Contact only

  • CONTACT.

  • CONTACT_PHN (only if phone information is provided).

  • PSOPRDEFN (only if user is created).

  • PSOPRALIAS (only if user is created).

  • PSOPRCLS (only if user is created).

  • PSROLEUSER (only if user is created).

  • ROLEXLATOPR (only if user is created).

Customer only

  • CUSTOMER.

  • CUST_SOLDTO_OPT.

  • CUST_SHIPTO_OPT.

  • CUST_OPTION.

  • CUST_SHIPTO.

  • CUST_BILLTO.

  • PRODCTLG_CUST.

  • PROD_CUST_ALIAS.

  • CUST_TEAM.

  • PRODCTLG_PRDLST.

  • CUST_CGRP_LNK.

  • CUST_CREDIT.

  • CUST_CRSPD.

Contact and Customer

  • CONTACT.

  • CONTACT_PHN (only if phone information is provided).

  • CONTACT_CUST.

  • CONTACT_CARD (only if credit card information is provided).

  • CUST_CNTCT_SEQ.

  • CUST_CONTACT.

  • CUST_CNTCT_PHN (only if phone information is provided).

  • CUST_CNTCT_CARD (only if credit card information is provided).

  • PSOPRDEFN (only if user is created).

  • PSOPRALIAS (only if user is created).

  • PSOPRCLS (only if user is created).

  • PSROLEUSER (only if user is created).

  • ROLEXLATOPR (only if user is created).

  • CUSTOMER.

  • CUST_SOLDTO_OPT.

  • CUST_SHIPTO_OPT.

  • CUST_OPTION.

  • CUST_SHIPTO.

  • CUST_BILLTO.

  • PRODCTLG_CUST.

  • PROD_CUST_ALIAS.

  • CUST_TEAM.

  • PRODCTLG_PRDLST.

  • CUST_CGRP_LNK.

  • CUST_CREDIT.

  • CUST_CRSPD.

The template customer never updates these tables:

  • CUST_INDIRECT

  • CUST_BROKER

  • CUST_NOTE

  • CUST_NOTE_DOC

  • CUST_NOTE_KEYWD

  • CUST_CRSPD_REM

  • CUST_EXEMPT

  • CUST_EXEMPT_DTL

  • CUST_HIERARCHY

  • CUST_ID_NBRS

  • CUST_PM_CHANNEL

  • CUST_SIC_CODES

  • CUST_REGN_TYPE

  • CUST_VAT_EXCPTN

  • CUST_VAT_REG

Customer Search Page

Use the Customer Search page (QUICK_CUST_SRCH) to search for customers or enter new customers.

Determine factors such as contacts' correct customers or which customer addresses to use. Quick Customer Create updates the Contact/Customer tables.

These user-defined fields are associated with the customer. The address fields are dependent on the country selection.

Note: Use the % wildcard to search for partial strings.

Customer Summary Page

Use the Customer Summary page (QUICK_CUST_SUMMARY) to view customer and contact search results, and select the correct matches.

Customer Summary Detail Page

Use the Customer Summary Detail page (QUICK_CUST_DTL) to view additional customer information, navigate to transactions, and update contact and customer information.

The system applies customer and contact information to the transactions automatically.

Contact Information

Customer Information

Create New Customer/Contact Page

Use the Create New Customer/Contact page (QUICK_CUST_CREATE) to enter new customers' information.

Note: A new customer can have only one contact and address, and they must have the same sold to, ship to, and bill to address.

Enter Contact Information

Enter Customer Information

Contact User Profile Page

Use the Contact User Profile page (QUICK_CUST_USER) to enter contacts' user information to enable them to access self-service transactions.

Logon Information

Permission Lists

Contact Roles

Note: CSRs should be authorized to run the Component Interfaces (USER_MAINT and CUSTOMER_CONTACT) so that the appropriate tables are updated when the contact and user are created using Quick Customer Create. The ID Type CNT must be marked as Enabled on the User Profile Types page so that the customer information can be saved.

Note: Contacts established to access express order entry must also have user preferences established for sales orders under Setup Financials/Supply Chain, Common Definitions, User Preferences, Define User Preferences, Orders - Sales.