E1: 01: How To Enter Address Book Records In EnterpriseOne (P01012/P0100041/P0111/P0115)
(Doc ID 1511984.1)
Last updated on MARCH 12, 2021
JD Edwards EnterpriseOne Address Book - Version XE and later Information in this document applies to any platform.
Overview of Address Book Information
You use the JD Edwards Address Book system to maintain information about companies and people with whom you do business. The Address Book contains company names, contact names, addresses, phone numbers, notes, and other pertinent information, and is used by most other JD Edwards EnterpriseOne systems
The following tables are used by the Address Book Revisions program (P01012) to store and access address book information. Other Address Book programs also use some of these these tables:
Customer Master by Lines of Business (F03012)
Supplier Master (F0401)
Address Book Master (F0101)
Address Book - Who's Who (F0111)
Address Book - Phone Numbers (F0115)
Alternate Address (F01161)
Electronic Address (F01151)
Related Person (F01112)
Address by Date (F0116)
Address Organizational Structure (F0150)
Postal Code Tables (F0117 and F0118)
Before you can use other JD Edwards EnterpriseOne systems, you must enter address book information in the JD Edwards Address Book system for your customers, suppliers, and so on. Other JD Edwards EnterpriseOne systems retrieve up-to-date name and address information, based on the address book information that you enter. Use the Address Book Revisions (P01012) program to enter address book records. The system stores information for address book records in the Address Book Master table (F0101). You can also select to display other forms automatically when entering an address book record, such as the Supplier Master (P04012) or Customer Master (P03013) using the Address Book Revisions (P01012) processing options.
In addition to basic address information, you can enter an unlimited number of phone numbers for each address book record and specify whether the phone number is a business number, cellular number, fax number, and so on. Phone numbers are stored in the Address Book - Phone Numbers table (F0115).
To locate an address book record on the Work With Addresses form, you can enter a full or partial name, address number, and so on. If you use a partial name, you must include an * (asterisk) either in front of or at the end of the partial name. The program searches only for the first word in the address name. For example, if you have address book numbers for Corporate Center, Continental Services, and Services Continental and you search for *CO or CO*, the search results will include Corporate Center and Continental Services.
Duplicate Entry Validation
To alleviate the potential for duplicate records when you enter, revise, or upload address book records, you can activate duplicate record validation in the JD Edwards Address Book system. You specify whether you want the system to issue a warning or error message when it finds records with the same alpha name, city, and zip code combination or the same tax ID.
The Address Book MBF program (P0100041) has two processing options that specify whether to search for duplicate records:
Validate for Duplicate Data Entry - Identifies records with the same alpha name, city, and postal code. Records with abbreviations are not identified. For example, Saint Petersburg and St. Petersburg are not identified as duplicate records.
Validate for Duplicate Tax ID Entry - Identifies records with the same tax ID in the same country. Records with a blank tax ID are not identified. You can set either or both of these processing options to issue a warning or error message. The system allows you to accept entries with warning messages, but not with error messages.
For duplicate data entry validation, the system searches the Address Book Master (F0101) and Address by Date (F0116) tables for a matching alpha name, city, and zip code. For duplicate tax ID entry, the system searches the F0101 table for a matching tax ID and the F0116 table for a matching country.
Note: This functionality is only available as of release 8.10 and above.
Using Mobile Sales with Address Book
If you are using JD Edwards EnterpriseOne Sales Force Automation, you can enter and revise address book records for customers when you are disconnected from the JD Edwards EnterpriseOne system. JD Edwards EnterpriseOne Mobile Sales was created to support sales personnel who need to create and modify customer information or sales orders on their laptops when they are disconnected from the enterprise server. For example, a sales representative can enter or update order, customer, lead, or contact information on a plane, in a hotel room, or at a client site, and then synchronize the data entered when able to connect to the server. Data transfer is bidirectional, which means that during synchronization, the laptop both receives updated information from the server and sends new or modified information to the server.
This document is intended for users setting up and maintaining address book records in EnterpriseOne Address Book.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!