Customer Class Record View

Customer Classes are used to identify default values that are applied to new Customer records and to group Customers and transactions together for reporting and data selection purposes. The purpose of the Customer Class Record View is to enter and edit Customer Class records. From here, users can add, edit, remove, and activate/inactivate these records.  

Software Version: 2023.06.30 and newer

Page Header

Toolbar IconsDescription
Delete Deletes the transaction, batch, or master file record. When clicked, users will be prompted with: "Are you sure you want to delete this record?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted!

Grid LayoutsOpens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

Help Opens the online WIKI help page for the current page. 
NewOpens a new blank record for data entry.
SaveSaves all changes.
FieldsDescription
Class 

A single-select lookup that identifies the Customer Class that the page is being displayed for. This is displayed as [Class ID] - [Class Description]. This default to blank on New. If changed, the details below will be updated to reflect the new Customer Class. The lookup contains a list of all Customer Classes.

Database Field: ERPx_ERPx_ARCustomerClass.ClassID + ERPx_ERPx_ARCustomerClass.Description

Properties Tab

This tab shows all the properties that default to new customers assigned this Customer Class.

Toolbar IconsDescription
Excel Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 
FieldsDescription
Properties Identifies the Property that is being set up.
Roll Down

A check box to identify whether or not the corresponding value should be pushed to all records (customers, fishermen, items, vendors) assigned to the Class. On 'Save', the values for all the selected fields will be rolled down the records assigned to the Class.

ValueA text box or lookup to set the value of the property. Property values are always editable and can be changed at any time, unless otherwise specified. 
Group: ID and Descriptions
Class ID

A textbox to enter the unique identifier for the Class. This defaults to blank for new records and is required. If not assigned, the message "Class ID is required." will be displayed on Save. This value must be unique. If not, the message "Duplicate Class IDs are not allowed." will be displayed on Save. This field is always editable from the record view and must be <= 25 characters. 

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

Linked Database Field: ERPx_ERPx_ARCustomerClass.ClassID

Description

A textbox to enter a description for the Class. This defaults to blank for new records and is required but duplicate values are allowed. If not assigned, the message "Description is required." will be displayed on Save. This field is always editable from the record view and must be <= 50 characters. 

The Description is used as a long description/name of the Class.

Linked Database Field: ERPx_ERPx_ARCustomerClass.Description

Group: Configuration
Checkbook

Checkbooks represent individual bank accounts (checking, savings, petty cash) that have funds deposited into, or payments made out of, that are reconciled to a bank statement. They are used in the Financial, Fisherman Accounting, Grower Accounting, Purchasing, and Sales Functional Areas to support receiving payments from customers, making payments, deposits, and other bank transactions. This is a single-select lookup to assign the default 'Checkbook' that will be used for Payment Receipts received from a customer. This defaults as blank, is not required, and is always editable.

The lookup contains a blank value, the current assigned value, and a list of all 'Active' Checkbooks.

Database Fields: ERPx_MFCheckbook.CheckbookID, ERPx_ARCustomerClass.CheckbookSK

Currency

The Currency identifies the kind of money used for transactions. For example, if a Customer or Vendor is setup with a Currency of "USD" then all transactions for them are stated in terms of US Dollars and all payments received or made must be in US Dollars. This is a single-select lookup that defaults from the Currency assigned to the 'Home Currency' on the Company → Configuration → Preferences page. This is required and always editable. If missing, the message "Currency is required." will be displayed on Save.

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_ARCustomerClass.CurrencySK 

Payment Terms

Payment Terms identify the terms your company extends to your Customers and that your Vendors extend to you. Payment Terms are used to calculate aging and payment discounts. This is a single-select lookup to assign the default 'Payment Terms' that will be assigned to customers in this class. This defaults as blank, is not required, and is always editable.  

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_ARCustomerClass.PaymentTermSK

Discount Grace Period

This field is not used.

Database Field: ERPx_ARCustomerClass.DiscountGracePeriod 

Due Date Grace Period

This field is not used.

Database Field: ERPx_ARCustomerClass.DueDateGracePeriod

Group: Credit Limits and Finance Charges
Credit Limit Option

A single select lookup to identify if, and how, Credit Limits are established for the Class. This defaults as "Unlimited Credit", is required and is always editable. If missing, the message "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_ARCustomerClass.CreditLimitOptionEN

Credit Amount

A textbox to identify the Credit Amount for the Class. This defaults as "0.00000" and must be >=0. If missing, negative, or the 'Credit Limit Option' is set to "No Credit" this will be set to 0.00 on Save. 

Database Field: ERPx_ARCustomerClass.CreditLimitAmount

Finance Charge Option

This field is not used.

Database Field: ERPx_ARCustomerClass.FinanceChargeOptionEN

Finance Charge Amount

This field is not used.

Database Field: ERPx_ARCustomerClass.FinanceChargeAmount

Group: Other
Tax Class

A single select lookup to assign the Tax Class to the Class. This defaults to blank, is not required and is always editable.

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

Tax Classes store all the Tax Details (individual taxes) used to calculate sales tax on Quick Sales, Fisherman Sales, and Tender Resale transactions.

Database Fields: ERPx_MFTaxClass.TaxClassSK, ERPx_ARCustomerClass.TaxClassSK 

Inactive

Identifies if the record is "Inactive". If inactive (set to "Yes"), it will not be included in look-ups for transactions or other master files. If set to "No" or blank, the record is active and can be freely used.This is a Yes/No lookup to identify if the Class is active or not. This defaults to "No" and is always editable.

  • 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. 

Database Field: ERPx_ARCustomerClass.IsInactive

Accounts Tab

This tab shows the list of GL Accounts that will default to customers assigned this Customer Class.

Toolbar IconsDescription
Excel Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 
FieldsDescription
Account Type

This field contains the following account types: 

Accounts ReceivableThe GL Account that is assigned for the "Accounts Receivable" Account Type, on the Accounts tab of the Customer Record View and Customer Class Record View. This is the account where accounts receivable amounts are posted for the selected customer.  This Account is not editable on transactions.

Database Field: ERPx_ARCustomerClass.GLARAccountSK 

SalesThis Account Type is not managed from here; it is configured on the Item.  

Database Field: ERPx_ARCustomerClass.SalesActSK

Cost of SalesThis Account Type is not managed from here; it is configured on the Item.  

Database Field: ERPx_ARCustomerClass.COGSActSK

InventoryThis Account Type is not managed from here; it is configured on the Item.  

Database Field: ERPx_ARCustomerClass.InventoryActSK

Terms Discount TakenThe GL Account that is assigned for the "Terms Discount Taken" Account Type, on the Accounts tab of the Customer, Vendor, Fisherman, and Loan Record Views and the Customer Class, Vendor Class, and Fisherman Class Record Views. This is the account where payment discounts, entered during Payment Receipt applications and when building AP check batches, are posted to.   This Account is not editable on transactions.

Database Field: ERPx_ARCustomerClass.TermsDiscTakenActSK

Terms Discount Available: This Account Type is not used.  

Database Field: ERPx_ARCustomerClass.TermsDiscAvailActSK

Finance Charges: This Account Type is not used.  

Database Field: ERPx_ARCustomerClass.FinanceChgActSK

Writeoffs:  The GL Account that is assigned for the "Write Off" Account Type, on the Accounts tab of the Customer, Vendor, Fisherman, and Loan Record Views and the Customer Class, Vendor Class, and Fisherman Class Record Views. This is the account where write off amounts entered during Payment Receipt applications are posted to.   This Account is editable when applying payments.

Database Field: ERPx_ARCustomerClass.WriteOffActSK

Overpayment Writeoffs: This Account Type is not used.  

Database Field: ERPx_ARCustomerClass.OverPmtWriteOffActSK

Sales Order ReturnsThis Account Type is not managed from here; it is configured on the Item.  

Database Field: ERPx_ARCustomerClass.SalesReturnActSK

Account 

A single-select load on demand lookup to assign the GL Account. This defaults from the value assigned on the Customer Class and is not required to save the master file record but may be required to post a transaction. This is always editable.

The lookup contains a blank value, the current assigned value, and all the 'Active' GL Accounts.

RolldownA check box to identify whether or not the corresponding value should be pushed to all records (customers, fishermen, items, vendors) assigned to the Class. On 'Save', the values for all the selected fields will be rolled down the records assigned to the Class.

Related Topics

 Page Definitions

Page Definitions

 Technical Details

Technical Details