Insert excerpt
Software Version: 2023.06.30 and newer
Table of Contents | ||
---|---|---|
|
Page Header
...
[Address ID] - [City], [State] - [Customer Name] ([Customer ID]).
The lookup contains the list of all Customer Address IDs. If changed, the details below will be updated to reflect the new Address ID.
Database Fields: ERPx_ARCustomer.Address.AddressID, ERPx_ARCustomer.Address.City, ERPx_ARCustomer.Address.State, ERPx_ARCustomer.CustomerID, ERPx_ARCustomer.CustomerDescription
...
Database Fields: ERPx_ARCustomer.CustomerID + ERPx_ARCustomer.CustomerDescription
Properties Tab
...
Database Field: ERPx_ARCustomer.CustomerID
...
Database Field: ERPx_ARCustomer.CustomerName
...
Database Field: ERPx_ARCustomer.StatementName
...
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' records in the Customer Class master file.
Database Fields: ERPx_ARCustomerClass.ClassDescription, ERPx_ARCustomer.CustomerClassSK
...
The lookup contains a blank value, the current assigned value, and a list of all the 'Attribute Classes' with an 'Attribute Type' of "Customer Attribute Class".
Database Field: ERPx_ARCustomer.AttributeClassSK
...
A single select lookup to identify the prefered method for getting the Sales Invoice to the Customer. This defaults to "Print" and is required. If missing the message "Customer Processing Failed: ([CustomerID]): Invoice Delivery Method is required." will be displayed on Save.
The lookup the following options:
- Both
Database Field: ERPx_ARCustomer.InvoiceDeliveryMethodEN
...
This is a single-select lookup to assign the default 'Checkbook' that will be used for Payment Receipts received from the customer. This default from the Checkbook assigned to the Customer Class but can be edited. This is required and if missing the message "Customer Processing Failed: ([CustomerID]): Checkbook is required." will be displayed on Save.
Database Fields: ERPx_MFCheckbook.CheckbookID, ERPx_ARCustomer.CheckbookSK
...
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Company Currencies.
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_MFDataEntityCompanyCurrency.CurrencySK, ERPx_ARCustomer.CurrencyID
...
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Payment Terms.
Database Fields: ERPx_MFPaymentTerms.PaymentTermName, ERPx_ARCustomer.PaymentTermSK
...
This field is not used.
Database Field: ERPx_ARCustomer.DiscountGracePeriod
...
This field is not used.
Database Field: ERPx_ARCustomer.DueDateGracePeriod
...
A Yes/No lookup to identify whether or not the customer has visibly to all Item codes in the Item Master. This defaults to "Yes" but can be changed to "No".
- If "Yes" any item from the Item Master can be sold to the Customer.
- If "No" only the Items included on the Item Set(s) assigned to the Customer or Customer Address 'Catalog Tab' can be sold to the Customer.
Database Field: ERPx_ARCustomer.HasFullItemAccess
...
A single select lookup to specify where 'Favorite' items are stored. This defaults from the "Default Item Favorites Level" Sales Preference but can be change to any one of the following values:
- Address: Favorites are auto assigned and managed at the Address level. If set to "Address" the Favorites Tab on the Customer Record View will be disabled and will be enabled on the Address Record View.
- Customer: Favorites are auto assigned and managed at the Customer level and shared across all the Customer Addresses for the Customer. If set to "Customer" the Favorites Tab on the Address Record View will be disabled and will be enabled on the Customer Record View.
- None: Favorites will not be auto assigned, nor can they be manually assigned. The Favorites Tab on both the Customer and Customer Address Record Views will be disabled.
...
Database Field: ERPx_ARCustomer.DueDateGracePeriod
...
A single select lookup to identify if, and how, Credit Limits are established for the Customer. This defaults from the Customer Class, is required and is always editable. If missing, the message "([CustomerID]): Credit Limit Option is required." will be displayed on Save.
This property works in conjunction with 'Credit Amount' property on this page and with the "When credit limits are exceeded" Sales Preference. Click /wiki/spaces/HELP/pages/2684911629 for additional information on managing Credit Limits.
The options include:
- No Credit: The Customer does not have any credit and the 'Credit Amount' property is set to 0.00 and will be disabled.
- Specific Amount: The Customer has a set Credit Limit that will be specified in the 'Credit Amount' property.
- Unlimited Credit: The Customer has unlimited credit (i.e., Credit Limits are not managed for the Customer), and the 'Credit Amount' property is set to 0.00 and will be disabled.
Database Field: ERPx_ARCustomer.CreditLimitOptionEN
...
A textbox to identify the Credit Amount for the Customer. This defaults from the Customer Class and must be >=0. If missing, it will be set to 0.00 on Save. If a negative amount is entered the message "([CustomerID]): Credit Amount must be greater than or equal to zero." will be displayed on Save.
Database Field: ERPx_ARCustomer.CreditLimitAmount
...
This field is not used.
Database Field: ERPx_ARCustomer.FinanceChargeOptionEN
...
This field is not used.
Database Field: ERPx_ARCustomer.FinanceChargeAmount
...
Database Field: ERPx_ARCustomer.AvgDaysToPay
...
A single select lookup to assign the Tax Class to the customer. This defaults to blank for new records, is not required and is always editable.
Tax Classes are used to calculate sales tax on Quick Sales transactions.
...
Database Fields: ERPx_MFTaxClass.TaxClassSK, ERPx_ARCustomer.TaxClassSK
This lookup contains a blank value, the current assigned value, and a list of all the 'Active' Tax Class records.
...
This field is not used.
Database Field: ERPx_ARCustomer.TradeDiscountMethodEN
...
This field is not used.
Database Field: ERPx_ARCustomer.TradeDiscount
...
A single select lookup to identify the Parent Customer. This is not required and is always editable. The lookup contains a blank value, the current assigned value, and the list of all 'Active' Customers.
This is informational only.
Database Field: ERPx_ARCustomer.ParentCustomerSK
...
- If set to 'Yes' then new Quick Sale and Sales Orders cannot be entered for the Customer but Payments Receipts can still be taken.
- If set to 'No' then the record is not on hold and can be freely used.
Database Field: ERPx_ARCustomer.IsOnHold
...
A multi select lookup to assign one or more Certifications to the Customer. This is not required and is always editable. Certifications assigned to a customer will default onto new Sales Orders where they can be used, edited, or removed.
Database Fields: ERPx_IMCertification.Certification, ERPx_ARCustomerCertification.CertificationSK, ERPx_ARCustomer.CustomerSK
...
A single select lookup to identify the Address where payments from this customer should be sent. This is not required, and always editable.
...
Database Field: ERPx_ARCustomer.RemitToAddressSK
...
- If set to 'Yes' then the record is "Inactive" and will not be included in lookups for transactions or other master files.
- If set to 'No' then the record is "Active" and can be freely used. This field is always editable.
Only Customers with no open transactions/ balances can be set to Inactive, otherwise the message "[Customer Name] ([CustomerID]) has a balance, has unapplied transactions, or is on an open transaction and cannot be saved as Inactive." will be displayed on Save.
Database Field: ERPx_ARCustomer.IsInactive
...
The purpose of the Customer Address Record View is to add, edit, and remove Customer Address records. From here, users can add, edit, remove, and activate/inactivate these records. Insert excerpt Def - Customer Address ID Def - Customer Address ID nopanel true
Software Version: 2023.06.30 and newer
Table of Contents | ||
---|---|---|
|
Page Header
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||
Grid Layouts |
| ||||||||
Help |
| ||||||||
New |
| ||||||||
Notes |
| ||||||||
Save |
| ||||||||
Fields | Description | ||||||||
Address |
[Address ID] - [City], [State] - [Customer Name] ([Customer ID]). The lookup contains the list of all Customer Address IDs. If changed, the details below will be updated to reflect the new Address ID. Database Fields: ERPx_ARCustomer.Address.AddressID, ERPx_ARCustomer.Address.City, ERPx_ARCustomer.Address.State, ERPx_ARCustomer.CustomerID, ERPx_ARCustomer.CustomerDescription | ||||||||
Customer |
Database Fields: ERPx_ARCustomer.CustomerID + ERPx_ARCustomer.CustomerDescription |
Properties Tab
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||
Fields | Description |
Properties |
| ||||||||
Value |
| ||||||||
Group: ID and Descriptions | |||||||||
Address Name |
|
|
Addresses Tab
This tab shows the list of all Address records that belong to the customer.
This is a text box to assign/edit the value for the Address Name that applies to the Address ID. This defaults from the Customer Name entered on the Properties tab but can be overwritten and must be <=150 characters. This is required and if missing the message "Customer Processing Failed: ([CustomerID]): Address Name is required." will be displayed on Save. This is always editable. Database Field: ERPx_ARCustomerAddress.AddressName | |||||||||
Address ID |
Database Field: ERPx_ARCustomerAddress.AddressID | ||||||||
Group: Address | |||||||||
Address Type |
Database Field: ERPx_ARCustomerAddress.AddressTypeEN | ||||||||
Address 1 |
Database Field: ERPx_ARCustomerAddress.AddressLine1 | ||||||||
Address 2 |
|
value for the Address ID. This defaults to blank and is not required. If entered, |
it must |
be <=75 characters. This |
is always editable. Database Field: ERPx_ARCustomerAddress.AddressLine2 | |||||||||
Address 3 |
|
<=75 characters. This is always editable. Database Field: ERPx_ARCustomerAddress.AddressLine3 | |||||||||
City |
Database Field: ERPx_ARCustomerAddress. |
City |
State |
|
|
|
|
|
'State' value for the Address ID. This defaults to |
blank and is |
not required. If entered, it must be <= |
30 characters. This |
is always editable. Database Field: ERPx_ARCustomerAddress. |
State |
Zip |
|
|
|
the Address ID. This defaults |
to blank and is not required. If entered, it must be <= |
15 characters. This is always editable. Database Field: |
ERPx_ARCustomerAddress. |
Zip |
Country |
|
|
|
|
Database Field: |
ERPx_ARCustomerAddress. |
Country |
Phone |
|
|
|
Phone' value for the Address ID. This defaults to blank and is not required. If entered, it must be <= |
25 characters. This is always editable. Database Field: ERPx_ARCustomerAddress. |
Phone1 |
Fax |
|
|
|
email' value for the Address ID. This defaults to blank and is not required. If entered, it must be <= |
25 characters. This is always editable. Database Field: ERPx_ARCustomerAddress. |
Fax | |||||||||
Database Field: ERPx_ARCustomerAddress.Email |
Group: Configuration | |||||
Attribute Class |
|
|
|
a single-select lookup that defaults to blank |
, is not required |
, and is always editable. Once assigned, the Attributes belonging to the Attribute Class will be visible and editable on the Attributes Tab. This is always editable. The lookup contains a blank value, the current assigned value, and a list of all the 'Attribute Classes' with an 'Attribute Type' of "Customer Address Attribute Class". Database Field: |
ERPx_ARCustomerAddress. |
AttributeClassSK | |
Sales Order Site | A single select lookup to identify the default ' |
Site' for the Customer Address. This defaults to blank, is not required, and is always editable. If assigned, this will default on new Sales Order transactions (but can be overwritten). The lookup contains a blank value, the current assigned value, and the list of all 'Active' |
|
|
Database Field: |
ERPx_ARCustomerAddress. |
A single select lookup to identify how access to sales items are established for the Address ID. This defaults to "Inherit Item access from Customer" but is always editable. The available options include:
- Allow access to all Items: Any item from the Item Master can be sold to the Customer Adddress.
- Inherit Item access from Customer: The rules for the Address are controlled by the "Full Item Access" property on the Customer Record View.
- Limit access to only assigned Item Sets: Only the Items included on the Item Set(s) assigned on the Customer Address 'Catalog Tab' can be sold to the Customer.
Database Field: ERPx_ARCustomerAddress.ARItemAccessOptionEN
SiteSK | |||||
Sales Order Carrier | A single select lookup to identify the default 'Carrier' for the Customer Address. This defaults to blank, is not required, and is always editable. If assigned, this will default on new Sales Order transactions (but can be overwritten). The lookup contains a blank value, the current assigned value, and the list of all 'Active' Carriers.
|
|
|
Database Field: ERPx_ARCustomerAddress.CarrierSK | ||
Salesperson - Outside | A single select lookup to identify a default 'Outside Salesperson' for the Customer Address. This defaults to blank |
, is not required, and is always editable. If |
assigned, this will default on new Sales Order transactions (but can be overwritten). The lookup contains a blank value, the current assigned value, and the list of all 'Active' Outside Salespersons.
Database Field: ERPx_ARCustomerAddress. |
SalespersonSK | |||||||||
Salesperson - Inside | A single select lookup to identify a default 'Inside Salesperson' for the Customer Address. This defaults to blank, is not required, and is always editable. If assigned, this will default on new Sales Order transactions (but can be overwritten). The lookup contains a blank value, the current assigned value, and the list of all 'Active' Inside Salespersons.
Database Field: ERPx_ARCustomerAddress.InsideSalespersonSK |
Item Access | A single select lookup to identify |
Database Field: ERPx_ARCustomerAddress.SalespersonSK
how access to sales items are established for the Address ID. This defaults to "Inherit Item access from Customer" but is always editable. The available options include:
Database Field: ERPx_ARCustomerAddress.ARItemAccessOptionEN | |||||
Tax Class | This field is not currently used, it is managed at the Customer level. A single select lookup to assign the Tax Class to the Customer Address. This defaults to blank for new records, is not required and is always editable. Tax Classes are used to calculate sales tax on Quick Sales transactions.
|
|
Database Field: ERPx_ARCustomerAddress. |
TaxClassSK |
This field is not used.
Database Field: ERPx_ARCustomerAddress.SOFreightProgramsEN
Freight Terms | A single select lookup to identify the default ' |
Freight Terms' for the Customer Address. This defaults to blank, is not required, and is always editable. If assigned, this will default on new Sales Order transactions (but can be overwritten). The lookup contains a blank value, the current assigned value, and the list of all 'Active' |
|
|
Database Field: ERPx_SOFreightTerms.FreightTermName, ERPx_ARCustomerAddress.SOFreightTermsEN | ||||
Sales Order Freight Programs | This field is not used. Database Field: ERPx_ARCustomerAddress. |
SOFreightProgramsEN |
Attributes Tab
Toolbar Icons | Description | |
---|---|---|
Excel |
|
Database Field: ERPx_ARCustomerAddress.State
This field is not currently used, it is managed at the Customer level.
A single select lookup to assign the Tax Class to the Customer Address. This defaults to blank for new records, is not required and is always editable.
Tax Classes are used to calculate sales tax on Quick Sales transactions.
Database Field: ERPx_ARCustomerAddress.TaxClassSK
| |||||||||
Fields | Description | ||||||||
Attribute |
| ||||||||
Available |
| ||||||||
Value |
|
Contacts Tab
This tab shows the list of all Contacts that belong to the customer address.
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||
Fields | Description | ||||||||
Contact Type |
Database Field: ERPx_ARCustomerContact.ContactTypeSK | ||||||||
Database Field: ERPx_ARCustomerContact.Email | |||||||||
Fax |
Database Field: ERPx_ARCustomerContact.Fax | ||||||||
Name |
Database Field: ERPx_ARCustomerContact.Name | ||||||||
Note |
Database Field: ERPx_ARCustomerContact.Note | ||||||||
Phone |
Database Field: ERPx_ARCustomerContact.Phone |
...
This tab shows the list of all Sales Programs that are applicable to the customer address. This grid is informational only, it is not editable.
...
This tab shows the list of Item Sets, containing the list of Items, that the Customer customer address has rights to purchase.
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||
Excel |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Item Set |
|
...
This tab shows the Favorite Items belonging to the customer address.
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||
Excel |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
# Substitute Items | A hyperlink that displays the count of the substitute items assigned to the Customer Favorite Item. This defaults to the text 'Add' and shows the count once one or more substitute items have been assigned. Clicking on the hyperlink opens the 'Assign Substitute Items' page. | ||||||||
Customer Item Description | A textbox that identifies the Item Description the customer uses to describe the Item. This defaults to blank, is not required, is always editable, and duplicates are allowed. If entered it must be <= 105 characters. This can be used to overwrite the Item Description displayed on Sales Invoices for the Customer. Database Field: ERPx_ARCustomerFavorite.CustomerItemDescription | ||||||||
Customer Item ID | A textbox that identifies the Item ID the customer uses to describe the Item. This defaults to blank, is not required, is always editable, and duplicates are allowed. If entered it must be <= 50 characters. This can be used to overwrite the Item Description displayed on Sales Invoices for the Customer. Database Field: ERPx_ARCustomerFavorite.CustomerItemID | ||||||||
Item |
Database Field: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription, ERPx_ARCustomerFavorite.ItemSK, | ||||||||
Price UOM |
Database Field: ERPx_IMUOM.UOMID, ERPx_ARCustomerFavorite.PriceUOMSK | ||||||||
Seq. | A textbox that identifies the sequence the Favorite items will be displayed. This defaults to the next number based on the count of favorites for the Customer. This can only be edited by using Drag & Drop to move Favorite Items. Database Field: ERPx_ARCustomerFavorite.LineItemSort | ||||||||
Unit UOM |
Database Field: ERPx_IMUOM.UOMID, ERPx_ARCustomerFavorite.UnitsUOMSK | ||||||||
Weight UOM |
Database Field: ERPx_IMUOM.UOMID, ERPx_ARCustomerFavorite.WeightUOMSK |
...
This tab shows the list of Price Lists the Customer customer address is assigned to. They are listed in the sequence they are evaluated. Nothing within the grid is editable except the sequence the price lists are shown. The sequence can be changed using drag & drop.
...