Versions Compared

Version Old Version 5 New Version 6
Changes made by

Janice Dannenberg

Tom Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Every Customer can have multiple Address ID's (but a minimum of one) associated to them. The Addresses ID stores data pertaining to the physical location, phone, email, and payment information. This list view shows all the Address ID's for all the Customer accounts. The purpose of this page is to add, edit, remove, and activate/inactive these records.

(lightbulb) This list view also contains columns for each Attribute that is set up for the 'Customer Addresses' attribute type. Customer Address attributes are automatically included in the default view. However, because these attributes are user defined, they are not included in the help documentation.

Software Version: 2019.09.03 and newer

...

ID

A hyperlink that shows the value of the ‘Address ID' property on the Customer Address record. Clicking on the link opens the record view for the selected Customer Address. This defaults to blank for new records and is required. If not assigned, the message "Request 1 (#MISSING#): Address ID is required." will be displayed on Save. This field is always editable from the record view.

The Address ID is used as a short description and identifier of the Customer Address account Line 1 Line 2AddressLine3The Address Type specific to the customer address a single select load on demand lookup and is not assigned This field is always editable record view.  Address Types identify whether the Address is a 'Billing' address, 'Shipping' address, 'Both' billing and shipping, or 'Inactive'. This field is a single select load on demand lookup field always editable from the ‘Addresses’ tab of a record view  field is a single select load on demand lookup and . This field the record view. If field is a single select load on demand lookup and . This field the record view If    field a single select load on demand lookup and is . This field the record view If field a single select load on demand lookup and is . This field the record view. If
Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV
Delete - LV
nopaneltrue
Excel
Insert excerpt
Excel - Global (old)LV
Excel - Global (old)LV
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
New
Insert excerpt
New - Global
New - Global
nopaneltrue
FieldsDescription
CheckboxUsed to select one or more records for delete or mass update.
Address 1

The 'Address 1' property of the Address ID. This is not required and is always editable from the Address Record View or the Customer Record View - Addresses Tab.

Linked Database Field: ERPx_ARCustomerAddress.AddressIDAddressLine1

Address 2

The 'Address Line 12' property of the Address ID that is assigned. This field  This is not required and is always editable from the Address Record View or the Customer Record View - Addresses Tab.

Linked Database Field: ERPx_ARCustomerAddress.AddressLine1AddressLine2

Address 3

The 'Address Line 2' property of the Address ID that is assigned. This field  This is not required and is always editable from the Address Record View or the Customer Record View - Addresses Tab. 

Linked Database Field: ERPx_ARCustomerAddress.AddressLine2AddressLine3

Address Line 3The 'Address Line 3' property of the Address ID that is assigned. This field is not required and is always editable from the Record View. ID

A hyperlink that shows the value of the ‘Address ID' property on the Customer Address record. Clicking on the link opens the record view for the selected Customer Address. This defaults to blank for new records and is required. If not assigned, the message "Request 1 (#MISSING#): Address ID is required." will be displayed on Save. This field is always editable from the record view.

Address IDs must be unique by Customer but can be repeated across Customers. For example all Customers can have an Address ID of MAIN but only one Address for a given Customer can be "MAIN".

The Address ID is used as a short description and identifier of the Customer Address account.

Linked Database Field: ERPx_ARCustomerAddress.

AddressID

Address Name

The ‘Address Name' property on the Customer Address record. This defaults to blank for new records and is required. If not assigned, the message "Request 1 (#MISSING#): Address Name is required." will be displayed on Save. This field is always editable from the record viewAddress Record View or the Customer Record View - Addresses Tab.

The Address Name is used as a long description/name of the Customer Address.

Linked Database Field: ERPx_ARCustomerAddress.AddressName

Address Type

Identifies whether the Address ID is a Billing, Shipping, Both (same for both billing & shipping), or Inactive Address. This field is

required. If

missing, the message “Request 1 (#MISSING#): Address Type is required” will be displayed on Save.

from the

Address Record View or the Customer Record View - Addresses Tab. Only addresses with an Address Type of 'Shipping' or 'Both' will be displayed on the 'Sales Order: Select Ship-to' page. 

Linked Database Field: ERPx_ARCustomerAddress.AddressTypeEN

Carrier

The default Carrier associated with the customer address

. This

is not required and is

editable from the Address Record View or the Customer Record View - Addresses Tab. If a Carrier is specified, it will default on new Sales Orders for this address. 

Linked Database Field: ERPx_ ARCustomerAddress.CarrierSK

City

The 'City' property of the customer address. This field Address ID. This is not required and is always editable from the Address Record View or the Customer Record View - Addresses Tab.

Linked Database Field: ERPx_ARCustomerAddress.City

Customer Class

The Customer Class assigned on the Customer record. This is

required field and can be updated from the Customer

Record View. 

Linked Database Field: ERPx_ARCustomer.CustomerClassSK

Customer ID

A hyperlink that identifies the Customer assigned to the Customer Address. Clicking on the link opens the record view for the selected Customer. Customer IDs must be unique by Customer but and can be repeated across Customer Address accounts. Each Customer Address must be associated with a Customer ID.edited from the Customer Record View.

Linked Database Field: ERPx_ARCustomerAddress.CustomerSK

Customer Name

The Customer Name associated to the customer address. This field is a single select load on demand lookup and is required. This defaults to blank for new records and is required. If not assignedmissing, the message "Customer is required." will be displayed on Save. This field is always editable from the record viewCustomer Record View.

Linked Database Field: ERPx_ARCustomer.CustomerName

Default Ship To

A Yes/No field to identify whether the customer address is the default address to be shipped to. This field is not required.

Where is this editable from?

Linked Database Field: ERPx_ARCustomerAddress.IsDefaultShipToAddress

Email

The 'Email specific to the customer address. This field ' property of the Address ID. This is not required and is always editable from the Address Record View or the Customer Record View - Addresses Tab.

Linked Database Field: ERPx_ARCustomerAddress.Email

Fax

The 'Fax Number ' property of the customer address. This field Address ID. This is not required and is always editable from the Address Record View or the Customer Record View - Addresses Tab. 

Linked Database Field: ERPx_ARCustomerAddress.Fax

Freight Terms

The Freight Term specific to the customer address. This

is not required

and is always editable from

the Address Record View or the Customer Record View - Addresses Tab. If a Freight Term is specified, it will default on new Sales Orders for this address. 

Linked Database Field: ERPx_ARCustomerAddress.SOFreightTermsEN

Inside Salesperson


The Inside Salesperson specific to customer address. This

is not required

and is always editable from

the Address Record View or the Customer Record View - Addresses Tab. 

This lookup contains a list of all the salespeople set up on the Salesperson List View where Type = ‘Inside Sales’.

 If an Inside Salesperson is specified, it will default on new Sales Orders for this address.

  

Linked Database Field: ERPx_ARCustomerAddress.InsideSalesPersonSK

Phone 1

The 'Phone number ' property of the customer addressAddress ID.  This This field is not required and is always editable from the Address Record View or the Customer Record View - Addresses Tab.

Linked Database Field: ERPx_ARCustomerAddress.Phone1

Salesperson

The Salesperson specific to customer address. This

is

not required

and is always editable from

the Address Record View or the Customer Record View - Addresses Tab. 

This lookup contains a list of all the salespeople set up on the Salesperson List View where Type = ‘Outside Sales’.

 If a Salesperson is specified, it will default on new Sales Orders for this address. 

Linked Database Field: ERPx_ARCustomerAddress.SalespersonSK

Site

The default Site specific to the customer address. This

is

not required

and is always editable from

the Address Record View or the Customer Record View - Addresses Tab. If a Site is specified, it will default on new Sales Orders for this address. 

Linked Database Field: ERPx_ARCustomerAddress.SiteSK

State

The 'State' property of the customer address. This field Address ID. This is not required and is always editable from the Address Record View or the Customer Record View - Addresses Tab.

Linked Database Field: ERPx_ARCustomerAddress.State

Zip

The 'Zip Code ' property of the customer address. This field Address ID. This is not required and is always editable from the Address Record View or the Customer Record View - Addresses Tab.

Linked Database Field: ERPx_ARCustomerAddress.Zip

...