Versions Compared

Key

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

Insert excerpt
Def - Customer
Def - Customer
nopaneltrue
 The purpose of the Customer Record View is to enter and edit Customer records. From here, users can add, edit, remove, and activate/inactivate these records.  

Software Version: 2023.0608.30 31 and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Excel
Insert excerpt
Excel - RV Header 3.0
Excel - RV Header 3.0
nopaneltrue
FieldsDescription
Properties 
Insert excerpt
Properties - RV
Properties - RV
nopaneltrue
Value
Insert excerpt
Value - RV
Value - RV
nopaneltrue
Group: ID and Descriptions
Customer ID

Insert excerpt
Def - Customer ID
Def - Customer ID
nopaneltrue
 This is a text box that defaults to blank for new records, is required and must be <= 50 characters. If not assigned, the message "Customer Processing Failed: ([CustomerID]): Customer ID is required." will be displayed on Save. This value must be unique across all Customer accounts. If not unique, the message "Customer Processing Failed: ([CustomerID]): Duplicate Customer ID is not allowed." will be displayed on Save. This is always editable, 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

Insert excerpt
Def - Customer Name
Def - Customer Name
nopaneltrue
 This is a text box that defaults to blank, is required and must be <=100 characters. If not assigned, the message "Customer Processing Failed: ([CustomerName]): Customer Name is required." will be displayed on Save. This is always editable.

Database Field: ERPx_ARCustomer.CustomerName

Statement Name

Insert excerpt
Def - Statement Name
Def - Statement Name
nopaneltrue
 This  This is a text box that defaults to the Customer Name but is not required. If entered, it must be <be <=100 characters. This  This is always editable.

Database Field: ERPx ERPx_ARCustomer.StatementNameStatementName

Group: Configuration
Customer Class

Insert excerpt
Def - Customer Class ID
Def - Customer Class ID
nopaneltrue
 This is a single-select lookup that defaults to blank but is required. If missing, the message "Customer Processing Failed: ([CustomerID]): Customer Class is required." will be displayed on Save. This field is always editable but changing it will not update any of the default customer properties or accounts that are assigned on the new Customer Class. 

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

Attribute Class

Insert excerpt
Def - Attribute Class
Def - Attribute Class
nopaneltrue
 This  This is a single-select lookup that defaults from the Attribute Class assigned to the 'Customer Class' and to blank, is not required, but without it, attribute values cannot be assigned or edited for this account. This 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 Attribute Class". 

Database Field: ERPx ERPx_ARCustomer.AttributeClassSK

Invoice Delivery Method

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:

  • Print
  • Email
  • Both

    • Print
    • Email
    • Both

    This lookup contains the values in the SOInvoiceDeliveryMethod Enumeration Class.

    Database Field: ERPx ERPx_ARCustomer.InvoiceDeliveryMethodEN 

    Checkbook

    Insert excerpt
    Def - Checkbook
    Def - Checkbook
    nopaneltrue

    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

    Currency

    Insert excerpt
    Def - Currency
    Def - Currency
    nopaneltrue
     This is a single-select lookup that defaults from the Currency assigned to the 'Customer Class'. This is required and editable until the Customer is assigned to a transaction. If missing, the message "Customer Processing Failed: ([CustomerID]): 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_ARCustomer.CurrencyID

    Payment Terms

    Insert excerpt
    Def - Payment Terms
    Def - Payment Terms
    nopaneltrue
     This is a single-select lookup that defaults from the Payment Terms assigned to the 'Customer Class'. This is required and is always editable. If missing, the message ""Customer Processing Failed: ([CustomerID]): Payment Terms are required." will be displayed on Save.

    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

    Discount Grace Period

    This field is not used.

    Database Field: ERPx ERPx_ARCustomer.DiscountGracePeriod 

    Due Date Grace Period

    This field is not used.

    Database Field: ERPx ERPx_ARCustomer.DueDateGracePeriod

    Group: Item Access
    Full Item Access

    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 ERPx_ARCustomer.HasFullItemAccess 

    Use Favorites For

    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  Favorites are auto assigned and managed at the Customer level and shared across all the Customer Addresses for the Customer. If  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  Favorites will not be auto be auto assigned, nor can they be manually assigned. The Favorites Tab on both the Customer and Customer Address Record Views will be disabled. 

    Insert excerpt
    Def - Customer Favorite Items
    Def - Customer Favorite Items
    nopaneltrue

    Database Field: ERPx ERPx_ARCustomer.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 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.   

    This lookup contains the values in the ARCreditLimitOption Enumeration Class.

    Database Field: ERPx ERPx_ARCustomer.CreditLimitOptionEN

    Credit Amount

    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 ERPx_ARCustomer.CreditLimitAmount

    Finance Charge Option

    This field is not used.

    Database Field: ERPx ERPx_ARCustomer.FinanceChargeOptionEN

    Finance Charge Amount

    This field is not used.

    Database Field: ERPx ERPx_ARCustomer.FinanceChargeAmount

    Avg Days to Pay

    Insert excerpt
    Average Days to Pay
    Average Days to Pay
    nopaneltrue
     This is calculated 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

    Group: Other
    Tax Class

    A single select lookup to assign the Tax Class to the customer. This  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.

    Insert excerpt
    Def - Tax Class
    Def - Tax Class
    nopaneltrue

    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.

    Trade Discount Method

    This field is not used.

    Database Field: ERPx ERPx_ARCustomer.TradeDiscountMethodEN

    Trade Discount Amount

    This field is not used.

    Database Field: ERPx ERPx_ARCustomer.TradeDiscount

    Parent Customer

    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 ERPx_ARCustomer.ParentCustomerSK

    Hold

    Insert excerpt
    Def - On Hold - Vendor
    Def - On Hold - Vendor
    nopaneltrue
     This is a Yes/No lookupNo lookup to identify if the Customer account account should be placed on hold or not. This defaults to "No" and is always editable.

    • 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 

    Default SO Certification

    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 

    Remit To Address

    A single select lookup to identify the Address where payments from this customer should be sent. This is not required, and always editable.  

    Insert excerpt
    Def - Remit To Address
    Def - Remit To Address
    nopaneltrue

     Database Field: ERPx_ARCustomer.RemitToAddressSK

    Inactive

    Insert excerpt
    Def - Inactive
    Def - Inactive
    nopaneltrue
    This is a Yes/No lookup to identify if the Customer account 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. 

    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

    Attributes Tab

    Toolbar IconsDescription
    Excel
    Insert excerpt
    Excel - RV Header 3.0
    Excel - RV Header 3.0
    nopaneltrue
    FieldsDescription
    Attribute

    Insert excerpt
    Attribute - Attribute
    Attribute - Attribute
    nopaneltrue
     The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes → Customers). 

    Available
    Insert excerpt
    Attribute - Available
    Attribute - Available
    nopaneltrue
    Value
    Insert excerpt
    Attribute - Value
    Attribute - Value
    nopaneltrue

    Addresses Tab

    This tab shows the list of all Address records that belong to the customer.

    Database Field: ERPx_SOFreightTerms.FreightTermName, ERPx_ARCustomerAddress.SOFreightTermsENName

    Toolbar IconsDescription
    Delete
    Insert excerpt
    Delete - RV Grid - No Status
    Delete - RV Grid - No Status
    nopaneltrue
    Excel
    Insert excerpt
    Excel - RV Header 3.0
    Excel - RV Header 3.0
    nopaneltrue
    New 

    Insert excerpt
    New - Global
    New - Global
    nopaneltrue

    FieldsDescription
    Checkbox
    Insert excerpt
    Checkbox (Tag)- RV
    Checkbox (Tag)- RV
    nopaneltrue
    Address 1

    Insert excerpt
    Def - Address - Address Line 1
    Def - Address - Address Line 1
    nopaneltrue
     This is a text box to assign/edit the 'Address 1' 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.AddressLine1

    Address 2

    Insert excerpt
    Def - Address - Address Line 2
    Def - Address - Address Line 2
    nopaneltrue
     This is a text box to assign/edit the 'Address 2' value for value for the Address ID. This defaults to blank and is not required. If entered, it  it must be <be <=75 characters. This is always is always editable.

    Database Field: ERPx_ARCustomerAddress.AddressLine2

    Address 3

    Insert excerpt
    Def - Address - Address Line 3
    Def - Address - Address Line 3
    nopaneltrue
     This is a text box to assign/edit the 'Address 3' value for value for the Address ID. This defaults to blank and is not required. If entered, it  it must be <be <=75 characters. This is always is always editable.

    Database Field: ERPx_ARCustomerAddress.AddressLine3

    Address ID

    Insert excerpt
    Def - Customer Address ID
    Def - Customer Address ID
    nopaneltrue
     This is a text box to assign/edit the value of the of the Address ID. This defaults to "Primary" and is required to be unique by Customer (For example, every Customer can have an Address ID of 'PRIMARY' but that ID can only be used once for each Customer account) and must be <each Customer account) and must be <=25 characters. This is always editable.

    Database Field: ERPx_ARCustomerAddress.AddressID

    Address Name

    Insert excerpt
    Def - Address - Address Name
    Def - Address - Address Name
    nopaneltrue
     This is a text box to assign/edit the value for value for the Address Name that 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 <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 ERPx_ARCustomerAddress.AddressName

    Address Type

    Insert excerpt
    Def - Customer Address Type
    Def - Customer Address Type
    nopaneltrue

    This lookup contains the values in the AddressType Enumeration Class.

    Database Field: ERPx ERPx_ARCustomerAddress.AddressTypeEN 

    City

    Insert excerpt
    Def - Address - City
    Def - Address - City
    nopaneltrue
     This is a text box to assign/edit the 'City' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=35 characters. This is always editable.

    Database Field: ERPx_ARCustomerAddress.City

    Country

    Insert excerpt
    Def - Address - Country
    Def - Address - Country
    nopaneltrue
     This is a text box to assign/edit the 'Country' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=50 characters. This is always editable.

    Database Field: ERPx_ARCustomerAddress.Country

    Email

    Insert excerpt
    Def - Address - Email
    Def - Address - Email
    nopaneltrue
     This is a text box to assign/edit the 'email' value for the Address ID. This defaults to blank and is not required. If entered, it must be <=1,000 characters. This is always editable.

    Database Field: ERPx_ARCustomerAddress.Email

    Fax

    Insert excerpt
    Def - Address - Fax
    Def - Address - Fax
    nopaneltrue
     This is a text box to assign/edit the '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

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

    Insert excerpt
    Def - Freight Terms
    Def - Freight Terms
    nopaneltrue

    The lookup contains a blank value, the current assigned value, and the list of all 'Active' Freight Terms.excerpt-include

    Def - Freight TermsDef - Freight Terms
    nopaneltrue
    Item Access

    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.

    This lookup contains the values in the ARItemAccessOption Enumeration Class.

    Database Field: ERPx_ARCustomerAddress.ARItemAccessOptionEN

    Phone

    Insert excerpt
    Def - Address - Phone 1
    Def - Address - Phone 1
    nopaneltrue
     This is a text box to assign/edit the '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

    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

    Insert excerpt
    Def - Salesperson - Inside
    Def - Salesperson - Inside
    nopaneltrue

    Database Field: ERPx_ARCustomerAddress.InsideSalespersonSK

    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

    Insert excerpt
    Def - Salesperson - Outside
    Def - Salesperson - Outside
    nopaneltrue

    Database Field: ERPx_ARCustomerAddress.SalespersonSK

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

    Insert excerpt
    Def - Carrier
    Def - Carrier
    nopaneltrue

    Database Field: ERPx_ARCustomerAddress.CarrierSK

    SO Freight Programs

    This field is not used.

    Database Field: ERPx_ARCustomerAddress.SOFreightProgramsEN

    SO 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' Sites.

    Insert excerpt
    Def - Site
    Def - Site
    nopaneltrue

    Database Field: ERPx_ARCustomerAddress.SiteSK

    State

    Insert excerpt
    Def - Address - State
    Def - Address - State
    nopaneltrue
     This is a text box to assign/edit the 'State' value for value for the Address ID. This defaults to blank and is not required. If entered, it  it must be <be <=30 characters. This is always is always editable.

    Database Field: ERPx_ARCustomerAddress.State

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

    Insert excerpt
    Def - Tax Class
    Def - Tax Class
    nopaneltrue

    Database Field: ERPx_ARCustomerAddress.TaxClassSK 

    Zip

    Insert excerpt
    Def - Address - Zip
    Def - Address - Zip
    nopaneltrue
     This is a text box to assign/edit the 'Zip' value for value for the Address ID. This defaults to blank and is not required. If entered, it  it must be <be <=15 characters. This is always is always editable.

    Database Field: ERPx_ARCustomerAddress.Zip

    Contacts Tab

    This tab shows the list of all Contacts that belong to the customer.

    Toolbar IconsDescription
    Excel
    Insert excerpt
    Excel - RV Header 3.0
    Excel - RV Header 3.0
    nopaneltrue
    FieldsDescription
    Contact Type

    Insert excerpt
    Def - Contact - Type
    Def - Contact - Type
    nopaneltrue
     This is a non-editable text box to display which department or classification the contact belongs to. Additional Contact Types can only be added by NorthScope support. 

    Database Field: ERPx_ARCustomerContact.ContactTypeSK

    Email

    Insert excerpt
    Def - Contact - Email
    Def - Contact - Email
    nopaneltrue
     This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=1,000 characters. This is always editable.

    Database Field: ERPx_ARCustomerContact.Email

    Fax

    Insert excerpt
    Def - Contact - Fax
    Def - Contact - Fax
    nopaneltrue
     This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=25 characters. This is always editable.

    Database Field: ERPx_ARCustomerContact.Fax

    Name

    Insert excerpt
    Def - Contact - Name
    Def - Contact - Name
    nopaneltrue
     This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=100 characters. This is always editable.

    Database Field: ERPx_ARCustomerContact.Name

    Note

    Insert excerpt
    Def - Contact - Note
    Def - Contact - Note
    nopaneltrue
     This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=500 characters. This is always editable.

    Database Field: ERPx_ARCustomerContact.Note

    Phone

    Insert excerpt
    Def - Contact - Phone 1
    Def - Contact - Phone 1
    nopaneltrue
     This is a text box to assign/edit the value for the Contact. This defaults to blank and is not required. If entered, it must be <=25 characters. This is always editable.

    Database Field: ERPx_ARCustomerContact.Phone

    ...

    Toolbar IconsDescription
    Excel
    Insert excerpt
    Excel - RV Header 3.0
    Excel - RV Header 3.0
    nopaneltrue
    FieldsDescription
    Address ID

    A text box to identify the Customer Address ID assigned to the Sales Program.

    Database Fields: ERPx_ARCustomerAddress.AddressID, ERPx_SPProgramCustomerAddress.CustomerAddressSK, ERPx_SPProgram.ProgramHeaderSK

    Active

    A textbox to identify if the Sales Program is 'Active'. If "Yes" the Program is Active, if blank the Program is Inactive.

    Database Fields: ERPx_SPProgram.IsInactive

    End

    A textbox to identify if the 'End Date' assigned to the Sales Program.

    Database Fields: ERPx_SPProgram.EndDate

    Program

    A hyperlink to identify the Program ID. Clicking on the hyperlink opens the Program Record View within the page.

    Database Fields: ERPx_SPProgram.ProgramID

    Program Class

    A textbox to identify the Program Class assigned to the Program ID. 

    Database Fields: ERPx_SPProgramClass.ClassName, ERPx_SPProgram.ProgramClassSK 

    Program Type

    A textbox to identify the Program Type. Program Types can be as follows:

    • Insert excerpt
      Def - Program Type - SP Accrual
      Def - Program Type - SP Accrual
      nopaneltrue
    • Insert excerpt
      Def - Program Type - SP Brokerage
      Def - Program Type - SP Brokerage
      nopaneltrue
    • Insert excerpt
      Def - Program Type - SP Off Book
      Def - Program Type - SP Off Book
      nopaneltrue
       
    • Insert excerpt
      Def - Program Type - SP On Invoice
      Def - Program Type - SP On Invoice
      nopaneltrue
    • Insert excerpt
      Def - Program Type - SP Rebate
      Def - Program Type - SP Rebate
      nopaneltrue

    Database Fields: ERPx_MFSysEnumeration.EnumerationValue where EnumerationClass = 'SPProgramType', ERPx_SPProgramClass.ProgramTypeSKClassNameERPx_SPProgramSPProgramCustomerAddress.ProgramClassSKProgramHeaderSK

    Start

    A textbox to identify if the 'Start Date' assigned to the Sales Program.

    Database Fields: ERPx_SPProgram.StartDate

    ...

    Toolbar IconsDescription
    Excel
    Insert excerpt
    Excel - RV Header 3.0
    Excel - RV Header 3.0
    nopaneltrue
    FieldsDescription
    Account Type

    This field contains the following account types: 

    Accounts Receivable

    Insert excerpt
    Def - GL Account - Accounts Receivable
    Def - GL Account - Accounts Receivable
    nopaneltrue
     This Account is not editable on transactions.

    Database Field: ERPx_ARCustomer.GLARAccountSK 

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

    Database Field: ERPx_ARCustomer.SalesActSK

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

    Database Field: ERPx_ARCustomer.COGSActSK

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

    Database Field: ERPx_ARCustomer.InventoryActSK

    Terms Discount Taken

    Insert excerpt
    Def - GL Account - Terms Discount Taken
    Def - GL Account - Terms Discount Taken
    nopaneltrue
     This Account is not editable on transactions.

    Database Field: ERPx_ARCustomer.TermsDiscTakenActSK

    Terms Discount Available: This Account Type is not used.  

    Database Field: ERPx_ARCustomer.TermsDiscAvailActSK

    Finance Charges: This Account Type is not used.  

    Database Field: ERPx_ARCustomer.FinanceChgActSK

    Writeoffs:  

    Insert excerpt
    Def - GL Account - Write Off
    Def - GL Account - Write Off
    nopaneltrue
     This Account is editable when applying payments.

    Database Field: ERPx_ARCustomer.WriteOffActSK

    Overpayment Writeoffs: This Account Type is not used.  

    Database Field: ERPx_ARCustomer.OverPmtWriteOffActSK

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

    Database Field: ERPx_ARCustomer.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.

    Related Topics

    Expand
    titlePage Definitions

    Page Definitions

    ...