Versions Compared

Version Old Version 25 New Version Current
Changes made by

Tom Williams

Tom Williams

Saved on

Key

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

Customers are entities you sell things to and the Customer List View shows the list of these accounts. Customers are used in Sale and Sales Programs.

Insert excerpt
Def - Customer
Def - Customer
nopaneltrue
 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 'Customers' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. Customer attributes are not included in the help documentation.

Software Version: 20192022.0906.0316 and newer

Table of Contents
typeflat

...

 This

Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV
Delete - LV
nopaneltrue
Excel
Insert excerpt
Excel - LV
Excel - 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

Checkbox

Currency

The 'Currency’ property on the Customer record. This defaults from the Customer Class on new records, but can be overwritten, and is required. If not assigned, the message "Customer Processing Failed: Request 1 ([CustomerID]): Currency is required." will be displayed on Save. This field is always editable from the record view.

The Currency assigned identifies the transaction currency used for the customer. If a Customer is assigned a Currency of "USD", all of their transactions are stated in "USD" and their payments must be received in "USD". Changing the assigned Currency is allowed but should not be done until all the open receivable transactions are fully applied.

This lookup contains a blank value, the current assigned value, and a list of all the Company Currencies.

Linked Database Field: ERPx_ARCustomer.CurrencyID

Insert excerpt
HELP:Def: CurrencyHELP:Def: Currency
nopaneltrue
Insert excerpt
Checkbox
Checkbox

Used to select one or more records for delete or mass update.

nopaneltrue
 

Avg Days to Pay

Insert excerpt
Average Days to Pay
Average Days to Pay
nopaneltrue
 This is required and never editable.  The value will be recalculated if the Sales "Number of Days for Average Days to Pay" preference value is updated.  

Database Field: ERPx_ARCustomer.AvgDaysToPay

Currency

Insert excerpt
Def - Currency
Def - Currency
nopaneltrue
 This is required and is always editable from the Customer the Customer Record  View but should not be done until all the open receivable transactions are fully applied.

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_ARCustomer.CurrencyID

Customer Class

The ‘Customer Class' property on the Customer record.

This defaults to blank for new records and is required. If not assigned, the message "Customer Processing Failed: Request 1 ([CustomerID]): Customer Class is required." will be displayed on Save. This field is always editable from the record view.The

Customer Class

is used to classify customers and to set default Properties and Accounts (GL Accounts). These defaults can be overwritten for individual Customers.The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Customer Classes.

Linked Database Field: ERPx_ARCustomer.CustomerClassSK

Insert excerpt
HELP:Def : - Customer ClassHELP:
Def : - Customer Class
nopaneltrue
 This  This is required and is always editable from the Customer the Customer Record  View but changing it will not update any of the default customer properties or accounts that are assigned on the new Class. Customer Classes are managed in the Customer Class master file.

Database Fields: ERPx_ARCustomerClass.Description, ERPx_ARCustomer.CustomerClassSK

Customer ID

A hyperlink that shows the value of the ‘Customer

ID

' property on the Customer record. Clicking on the link opens the record view for the selected Customer. 

This defaults to blank for new records and is required. If not assigned, the message "Customer Processing Failed: Request 1 (#MISSING#): Customer ID is required." will be displayed on Save. This value must be unique. If not unique, the message "Customer Processing Failed: Request 1 ([CustomerID]): Duplicate Customer ID is not allowed." will be displayed on Save. This field is always editable from the record view.

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

Linked Database Field: ERPx_ARCustomer.CustomerID

Insert excerpt
HELP:Def : - Customer IDHELP:
Def : - Customer ID
nopaneltrue
  Clicking on the hyperlink opens the record view for the selected Customer.

This is required and is always editable from the Customer the Customer Record View but only in systems that are not integrating Customers with a third party system. To be editable, the "Customer" 'Transaction Type on both the 'Inbound to NorthScope' and 'Outbound from NorthScope' Integration Modes  must be set to "None" on the Integration Configuration page. 

Database Field: ERPx_ARCustomer.CustomerID

Customer Name

The ‘Customer Name' property on the Customer record. This defaults to blank for new records and is required. If not assigned, the message "Customer Processing Failed: Request 1 ([CustomerID]): Customer Name is required." will be displayed on Save. This field is always editable from the record view.The

Customer Name

is used as a long description/name of the Customer account.Linked Database Field: ERPx_ARCustomer.CustomerName

Insert excerpt
HELP:Def : - Customer NameHELP:
Def : - Customer Name
nopaneltrue
 This  This is required and is always editable from the Customer the Customer Record View. 

Database Field: ERPx_ARCustomer.CustomerName

Hold

Identifies if the Customer is "On Hold". If set to 'Yes' then new Sales Orders or Quick Sales cannot be entered but Price Adjustments, Returns and Payment Receipts are allowed. This does not currently work, as On Hold Customers are not displayed in the Payment Receipt lookup. If set to 'No' then the record is not on hold and can be freely used. 'No' values display as blank in the grid. This is always editable from the Customer Record

Insert excerpt
Def - On Hold - Customer
Def - On Hold - Customer
nopaneltrue
 This is required and is always editable from the Customer Record View. 

Database Field: ERPx_ARCustomer.IsOnHold

Inactive

Identifies if the Customer is "Inactive". If set to 'Yes' then the record is "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then the record is "Active" and can be freely used. 'No' values display as blank in the grid.  This is always editable from the Customer Record but only for Customers that have no 'Open Transactions'. ←This does not currently work, any customer is currently allowed to be put on hold

Insert excerpt
Def - Inactive
Def - Inactive
nopaneltrue
 This is required and is always editable from the Customer Record View but only Customers with no open or unapplied transactions can be set to Inactive.

Database Field: ERPx_ARCustomer.IsInactive

Invoice Delivery

Identifies the default ‘Invoice Delivery Method’ for the Customer. This is a required and is always editable from the Customer Record. If not assigned, the message "Customer Processing Failed: Request 1 ([CustomerID]): Invoice Delivery Method is required." will be displayed on Save. The value is defaulted to “Print” (SOInvoiceDeliveryMethod Enumeration Class with an Enumeration Value of 1) for a new customer record and is always editable.

This lookup contains all the values in the SOInvoiceDeliveryMethod Enumeration Class.

Linked Database Field: ERPx_ARCustomer.InvoiceDeliveryMethodEN

Identifies the default ‘Invoice Delivery Method’ for the Customer. This is a

Insert excerpt
Def - Invoice Delivery Method
Def - Invoice Delivery Method
nopaneltrue
 This is required and is always editable from

the Customer

the Customer Record

. The applicable values are in the SOInvoiceDeliveryMethod Enumeration Class.

View. 

Database

Fields

Field: ERPx_ARCustomer.InvoiceDeliveryMethodEN

Payment Terms

The 'Payment Terms' property on the Customer record. This defaults from the Customer Class on new records, but can be overwritten, and is required. If not assigned, the message "Customer Processing Failed: Request 1 ([CustomerID]): Payment Terms is required." will be displayed on Save. This field is always editable from the record view.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' Payment Terms.

Payment Terms are used to calculate Due Dates, Payment Discounts, and Customer Aging.

Linked Database Field: ERPx_ARCustomer.PaymentTermsSK

Insert excerptHELP:Def: Payment TermsHELP:Def: Payment Terms

Insert excerpt
Def - Payment Terms
Def - Payment Terms
nopaneltrue
 This is required and is always editable from the Customer Record View but will only apply to new transactions, it will not update existing transactions.

Database Fields: ERPx_MFPaymentTerms.PaymentTermName, ERPx_ARCustomer.PaymentTermsSK 

Tax Class

Insert excerpt
Def - Tax Class
Def - Tax Class
nopaneltrue
 

This is

This defaults to blank for new records. This is not required and is always editable from

the Customer Record but will only apply to new transactions, it will not update existing transactions.

the record view.

Tax Classes are used to calculate sales tax on Quick Sales transactions. 

Database Fields: ERPx_

MFPaymentTerms

MFTaxClass.

PaymentTermName

TaxClassSK, ERPx_ARCustomer.

PaymentTermsSK 

TaxClassSK 

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' Tax Class records.

Related Topics



Expand
titlePage Definitions

Page Definitions


...