Versions Compared

Key

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

Description: The NorthScope Vendor Class master file allows the user to add and edit vendor classes. The master file list view displays all Vendor Classes configured in the system and classes can be edited on the record view. These records serve as a default for all future created vendors assigned to the corresponding vendor class. 

Table of Contents
typeflat

Header Toolbar

...

For NorthScope companies that do not integrate to a Host Database, or where the Vendor Class integration is set to None, clicking delete will remove the Vendor Class record provided the class is not assigned to any vendors (a message will be displayed notifying users when a vendor is assigned to a class).

...

Header Fields

...

Grid Toolbar

...

Grid Properties

...

This field displays the tax type of the vendor class. This field is a drop-down menu, which allows to select between the following:

  • No 1099
  • Dividend
  • Interest
  • Misc.

 If the vendors under the vendor class required a 1099 statement, select 'Misc'., 'Dividend' or 'Interest'. When one of these tax types has been selected, users can specify a 1099 amount when entering transactions and 1099 statements can be printed for the vendors at the end of the year. Select 'No 1099' if the vendors under the vendor class don't require 1099 or withholding information. This field defaults to 'No 1099'.

...

This field displays if the vendor class is inactive (Yes) or active (No).

Accounts Tab

...

This field displays a drop-down menu of all active GL accounts for the user to select the default account for the corresponding account type. The account is always editable. 

...

This field displays the name of the account type for which the account can be assigned. This field is never editable by the user.  The account types include the following: 

  • Accounts Payable: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.  
  • Accrued Purchases: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.  
  • Cash: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.  
  • Finance Charges: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.  
  • Freight: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.  
  • Miscellaneous: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required. 
  • Purchase Price Variance: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.  
  • Purchases: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.
  • Settlement Accrual: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.
  • Tax: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.
  • Terms Discount Available: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.  
  • Terms Discount Taken: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required.  
  • Trade Discount: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required. 
  • Write Off: The Account menu displays all active accounts allowing users to select the account for the corresponding account type. This field is not required. 

...

Description: The NorthScope Vendor Class master file allows the user to add and edit vendor classes. The master file list view displays all Vendor Classes configured in the system and classes can be edited on the record view. These records serve as a default for all future created vendors assigned to the corresponding vendor class. 

Software Version: 2022.11.28 and newer

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Delete

Insert excerpt
Delete - RV Header 3.0
Delete - RV Header 3.0
nopaneltrue

For NorthScope companies that do not integrate to a Host Database, or where the Vendor Class integration is set to None, clicking delete will remove the Vendor Class record provided the class is not assigned to any vendors (a message will be displayed notifying users when a vendor is assigned to a class).

New
Insert excerpt
New - Global 3.0
New - Global 3.0
nopaneltrue
Save
Insert excerpt
Save - RV Header 3.0
Save - RV Header 3.0
nopaneltrue
Save & Close
Insert excerpt
Save & Close - RV Header 3.0
Save & Close - RV Header 3.0
nopaneltrue
FieldsDescription
ClassThis drop-down menu displays all existing vendor classes and allows users to navigate between different records.

Properties Tab

Toolbar IconsDescription
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
FieldsDescription
Properties 
Insert excerpt
Properties - RV
Properties - RV
nopaneltrue
Roll Down
Insert excerpt
Rolldown Checkbox
Rolldown Checkbox
nopaneltrue
Value
Insert excerpt
Value - RV
Value - RV
nopaneltrue
Group: ID and Descriptions
Class ID

Class IDs are the unique identifier for vendor classes. This is a text box that defaults as blank, is required, must be unique, and must be <= 25 characters. If missing, the message "Class ID is required." will be displayed on Save. If not unique the message "Duplicate Class ID's are not allowed." will be displayed on Save. This is always enabled and editable.

Database Field: ERPx_APVendorClass.ClassID

Description

Identifies the Description associated with the Vendor Class ID. This is a text box that defaults as blank, is required, must be unique, and must be <= 50 characters. If missing, the message "Class Description is required." will be displayed on Save. If not unique the message "Duplicate Class Descriptions are not allowed." will be displayed on Save. This is always editable. 

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

Database Field: ERPx_APVendorClass.ClassDescription

Group: Configuration
Vendor Type

Identifies the type of vendor that the Vendor Class is being configured for. This is a single-select lookup that is required. It defaults as blank but is required before the initial save. It is not editable the after initial Save. This lookup contains the value: Vendor.

Database Field: ERPx_APVendorClass.VendorTypeEN

Attribute Class

Identifies the Attribute Class configured for the Vendor. This is a single-select lookup that defaults as blank, is not required, and is always editable. If the Rolldown is used, this value will be updated for all Vendors in the associated Vendor Class.

Attribute Classes are assigned to master files to control which Attributes are visible, and/or required, to records within the master file.

The lookup contains a blank value, the current assigned value, and a list of all the 'Attribute Classes' with an 'Attribute Type' of "Vendor Attribute Class". 

Database Fields: ERPx_MFAttributeClass.ClassDescription, ERPx_APVendorClass.AttributeClassSK

Currency

This field displays a lookup of currencies for the user to identify the currency of the vendor class. This field is required, 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_APVendorClass.CurrencySK

Payment Terms

Insert excerpt
Def - Payment Terms
Def - Payment Terms
nopaneltrue
  This is a single-select lookup that defaults to 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_APVendorClass.PaymentTermSK

1099 Type

Insert excerpt
Def - 1099 Type
Def - 1099 Type
nopaneltrue
 This is a single-select lookup to assign the '1099 Type & Box' property for the Vendor. This defaults to blank is not required and is always editable.

This lookup contains all the values in the ERPx_APTenNinetyNineType table.

Database Fields: ERPx_APTenNinetyNineType.TenNinetyNineTypeDescription, ERPx_APVendorClass.TenNinetyNineTypeSK

Group: Other
Inactive

Insert excerpt
Def - Inactive
Def - Inactive
nopaneltrue
 This is a single-select standard lookup to select if the Vendor Class record is active or not. 

The lookup contains the values 'Yes' or 'No' and defaults to 'No'. 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. This field is always editable. 

Database Field: ERPx_APVendorClass.IsInactive

GL Accounts Tab

Toolbar IconsDescription
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
FieldsDescription
Properties 
Insert excerpt
Properties - RV
Properties - RV
nopaneltrue
Roll Down
Insert excerpt
Rolldown Checkbox
Rolldown Checkbox
nopaneltrue
Value
Insert excerpt
Value - RV
Value - RV
nopaneltrue
Group: Account Type
Account Type

This field displays the name of the account type for which the account can be assigned. This field is never editable by the user.  The account types include the following: 

  • Accounts Payable
    Insert excerpt
    Def - GL Account - Accounts Payable
    Def - GL Account - Accounts Payable
    nopaneltrue
     The 'Account' lookup for this 'Account Type' is a single-select lookup that contains a blank value, the current assigned value, and all the 'Active' GL Accounts. This Account is not editable on transactions.
  • Purchases
    Insert excerpt
    Def - GL Account - Purchases
    Def - GL Account - Purchases
    nopaneltrue
     The 'Account' lookup for this 'Account Type' is a single-select load on demand lookup that contains a blank value, the current assigned value, and all the 'Active' GL Accounts. This Account is editable on transactions. 
  • Terms Discount Taken
    Insert excerpt
    Def - GL Account - Terms Discount Taken
    Def - GL Account - Terms Discount Taken
    nopaneltrue
     The 'Account' lookup for this 'Account Type' is a single-select load on demand lookup that contains a blank value, the current assigned value, and all the 'Active' GL Accounts. This Account is not editable on transactions.
  • Write Off
    Insert excerpt
    Def - GL Account - Write Off
    Def - GL Account - Write Off
    nopaneltrue
     The 'Account' lookup for this 'Account Type' is a single-select load on demand lookup that contains a blank value, the current assigned value, and all the 'Active' GL Accounts. This Account is editable when applying payments.
Account 

This field displays a single select lookup of all active GL accounts for the user to select the default account for the corresponding account type. The account is always editable. 

Database Fields: ERPx_GLAccount.AccountNumber,  ERPx_GLAccount.Description, ERPx_APVendorClass.APGLAcctRef, ERPx_APVendorClass.PurchGLAcctRef, ERPx_APVendorClass.DistTakenGLAcctRef, WriteOffGLAcctRef

Roll Down

A check box to identify whether or not the corresponding account selection will roll down to all vendors assigned to the vendor class. Selecting this checkbox and saving will roll down the account selection to all vendors currently assigned to the corresponding vendor class.

 

Related Topics

...

Vendor Class User Guide


Expand
titlePage Definitions

Page Definitions

...

SPx_MFSEL_ClassAccount

Expand
titleTechnical Details

Technical Details

Table Names:
dbo.ERPx_APVendorClass
Stored Procedures:
SPx_MFSEL_ClassHeader
SPx_MFUpdate_Class
SPx_MFSEL_ClassProperties