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 Icons | Description |
---|---|
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 Layouts | Opens 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). 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. |
New | Opens a new blank record for data entry. |
Save | Saves all changes. |
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 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 Icons | Description |
---|---|
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. |
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. 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:
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.
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 |
---|---|
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. |
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. |