Customer Class Record View 3.0
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: 2025.04.21 and newer
Page Header
Toolbar Icons | Description |
---|---|
Delete | WARNING: Records cannot be recovered once they are deleted! 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. |
Help | Opens the online WIKI help page for the current page. |
New | Opens a new blank record for data entry. |
Save | Saves the changes made to the record. |
Save & Close | Saves your changes and closes the page. |
Fields | Description |
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 Fields: 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 Icons | Description |
---|---|
Column Filter Show/Hide | Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
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. |
Group By Show/Hide | Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
Quick Column Filter | Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
Saved Layouts | Please note that existing saved grid layouts will display the Filter Row as hidden by default. Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. |
Fields | Description |
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. |
Value | A 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. 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. 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:
Database Field: ERPx_ARCustomerClass.CreditLimitOptionEN |
Credit Amount | A textbox to identify the Credit Amount for the Class. This defaults as "0.00" formatted to the selected currency and must be >=0. If missing, negative, or the 'Credit Limit Option' is set to "No Credit", or "Unlimited Credit" this will be set to 0.00 on Save and disabled. 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.
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 Icons | Description |
---|---|
Column Filter Show/Hide | Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
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. |
Group By Show/Hide | Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
Quick Column Filter | Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
Saved Layouts | Please note that existing saved grid layouts will display the Filter Row as hidden by default. Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. |
Fields | Description |
Account Type | This field contains the following account types: |
Accounts Receivable: The 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 | |
Sales: This Account Type is not managed from here; it is configured on the Item. Database Field: ERPx_ARCustomerClass.SalesActSK | |
Cost of Sales: This Account Type is not managed from here; it is configured on the Item. Database Field: ERPx_ARCustomerClass.COGSActSK | |
Inventory: This Account Type is not managed from here; it is configured on the Item. Database Field: ERPx_ARCustomerClass.InventoryActSK | |
Terms Discount Taken: The 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 Returns: This 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. |
Rolldown | 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. |