Versions Compared

Key

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

Insert excerpt
Def - Vendor
Def - Vendor
nopaneltrue
The purpose of this page is to add, edit, remove, and activate/inactive these records.

(lightbulb) This list view also contains columns for each Attribute that is set up for the 'Vendors' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. Vendor attributes are not included in the help documentation.

Software Version: 20192021.0911.03 and 24 and newer

Table of Contents
typeflat

Page Header

 This is not required, but without it, attribute values cannot be assigned or edited for this account. This is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.AttributeClassSK

Def - Check Name
Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Delete
Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue
Edit
Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid LayoutGroup By Show/Hide
Insert excerpt
Grid Layout Group By Show/Hide - GlobalGrid Layout
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
New
Insert excerpt
New - Global 3.0
New - Global 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved Column Layout
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
1099 Type

Insert excerpt
Def - 1099 Type
Def - 1099 Type
nopaneltrue
 This is not required and is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.TenNinetyNineTypeSK

Address Line 1

Insert excerpt
Def - Address - Address Line 1
Def - Address - Address Line 1
nopaneltrue
 This represents the 'Address 1' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View.

Database Field: ERPx_APVendorAddress.AddressLine1

Address Line 2

Insert excerpt
Def - Address - Address Line 2
Def - Address - Address Line 2
nopaneltrue
 This represents the 'Address 2' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View.

Database Field: ERPx_APVendorAddress.AddressLine2

Attribute ClassAddress Line 3

Insert excerpt
Def -
Attribute Class
Def - Attribute Class
nopaneltrue
Check Name

Insert excerpt
Def - Check Name
Address - Address Line 3
Def - Address - Address Line 3
nopaneltrue
 This is not required and is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.CheckName

Checkbook

Insert excerptDef - CheckbookDef - Checkbooknopaneltruerepresents the 'Address 3' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always always editable from the 'Addresses' tab of the Vendor Record View.

Database Field: ERPx_APVendorAPVendorAddress.CheckbookSKAddressLine3

City

Insert excerpt
Def - Address - City
Def - Address - City
nopaneltrue
 This represents the 'City' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View.

Linked Database Field: ERPx_APVendorAddress.City

Currency

Insert excerpt
Def - Currency
Def - Currency
nopaneltrue
 This is required, but is only for information and does not drive any functionality. This is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.CurrencySK

Default Payment Address ID

Identifies the Address ID on the Vendor account where the 'Payment' Default

'

Address is set to "Yes". Each Vendor is required to have one, and only one, address ID identified as the Payment Default.

The Address Identified as the default is the one that payments are automatically associated with.

Database Field: ERPx_APVendorAddress.IsRemitTo = 1

Email

Insert excerpt
Def - Address - Email
Def - Address - Email
nopaneltrue
 This represents the 'Email' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View.

Database Field: ERPx_APVendorAddress.Email

InactiveGL-Accounts Payable

Insert excerpt
Def - GL Account -

Inactive

Accounts Payable
Def -

Inactive

GL Account - Accounts Payable
nopaneltrue
 This is not required but if blank, transactions for this Vendor will not be able to be posted. This is

always

always editable from

the 

the Vendor Record View

 but only Vendors with no open transactions can be set to Inactive

.

Database Field: ERPx_APVendor.

IsInactive Master Account

APGLAcctRef

GL-Purchases

Insert excerpt
Def - GL Account - Purchases
Def - GL Account - Purchases
nopaneltrue
 This is not required and is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.APGLAcctRef

GL-Terms Discount Taken

Insert excerpt
Def - GL Account - Terms Discount Taken
Def -

Master

GL Account - Terms Discount Taken
nopaneltrue
 This is not required and is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.DiscTakenGLAcctRef

GL-Write Off

Insert excerpt
Def - GL Account - Write Off
Def -

Master

GL Account - Write Off
nopaneltrue
 This is not required and is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.WriteOffGLAcctRef

Inactive

Insert excerpt
Def - Inactive
Def - Inactive
nopaneltrue
 This is always editable from the Vendor Record View but only Vendors with no open transactions can be set to Inactive.

Database Field: ERPx_APVendor.

MasterVendorSK

IsInactive 

On Hold

Insert excerpt
Def - On Hold - Vendor
Def - On Hold - Vendor
nopaneltrue
 This is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.IsOnHold 

Payable AccountPayment Name

Insert excerpt
Def -

GL Account - Accounts Payable

Payment Name
Def -

GL Account - Accounts Payable

Payment Name
nopaneltrue

 This is not required but if blank, transactions for this Vendor will not be able to be posted. This

 This is not required and is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.

APGLAcctRef

CheckName

Payment Terms

Insert excerpt
Def - Payment Terms
Def - Payment Terms
nopaneltrue
 This is required and is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.PaymentTermSK

Phone

Insert excerpt
Def - Address - Phone 1
Def - Address - Phone 1
nopaneltrue
 This represents the 'Phone' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View.

Database Field: ERPx_APVendorAddress.Phone1

Purchase Account

Insert excerptDef - GL Account - PurchasesDef - GL Account - Purchasesnopaneltrue This is not required and is always editable from the Vendor Record View.Database Field: ERPx_APVendor.APGLAcctRef

State

Insert excerpt
Def - Address - State
Def - Address - State
nopaneltrue
 This represents the 'State' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View.

Database Field: ERPx_APVendorAddress.State 

Tax 1099 TypeID

Insert excerpt
Def -
1099 Type
Tax ID
Def -
1099 Type
Tax ID
nopaneltrue
 
This is not required and is always always editable from the Vendor Record View.

Database Field: ERPx_APVendor.1099TypeENTaxID

Tax TypeRegistration

Insert excerpt
Def - Tax
Type
Registration
Def - Tax
Type
Registration
nopaneltrue
 
This is not required and is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.TaxRegistration

Vendor Account

Insert excerpt
Def - Vendor Account
Def - Vendor Account
nopaneltrue
 This is not required and is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.

TaxTypeEN

VendorAccount

Vendor Attribute Class

Insert excerpt
Def - Attribute Class
Def - Attribute Class
nopaneltrue
 This is not required, but without it, attribute values cannot be assigned or edited for this account. This is always editable from the Vendor Record View.

Database Field: ERPx_APVendor.AttributeClassSK

Vendor Class ID

Insert excerpt
Def - Vendor Class Description
Def - Vendor Class Description
nopaneltrue
 This is not required and is always editable from the Vendor Record View but changing it will not update any of the default vendor properties or accounts that are assigned on the new Class. Vendor Classes are managed in the Vendor Class master file.

Database Fields: ERPx_APVendorClass.Description, ERPx_APVendor.VendorClassSK

Vendor ID

Insert excerpt
Def - Vendor ID
Def - Vendor ID
nopaneltrue
 Clicking on the hyperlink opens the record view for the selected Customer.

This is required and is always  editable from the Vendor Record View but only in systems that are not integrating Vendors with a third party system. To be editable, the "Vendor" '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_APVendor.VendorID

Vendor Name

Insert excerpt
Def - Vendor Name
Def - Vendor Name
nopaneltrue
 This is required and is always  editable from the Vendor Record View.

Database Field: ERPx_APVendor.VendorName

Zip

Insert excerpt
Def - Address - Zip
Def - Address - Zip
nopaneltrue
 This represents the 'State' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View.

Database Field: ERPx_APVendorAddress.Zip

...