Versions Compared

Key

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

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

Software Version: 2023.0912.29 19 and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - RV Header 3.0
Excel - RV Header 3.0
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Properties 
Insert excerpt
Properties - RV
Properties - RV
nopaneltrue
Value
Insert excerpt
Value - RV
Value - RV
nopaneltrue
Group: ID and Descriptions
Vendor ID

Insert excerpt
Def - Vendor ID
Def - Vendor 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 "Vendor Processing Failed: ([VendorID]): Vendor ID is required." will be displayed on Save. This value must be unique across all AP Vendor, Fishermen, Tender, and Loan accounts. If not unique, the message "Vendor Processing Failed: ([VendorID]): Duplicate Vendor IDs are not allowed." will be displayed on Save. This is always editable, 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 a text box that defaults to blank, is required and must be <=100 characters. If not assigned, the message "Vendor Processing Failed: ([VendorName]): Vendor Name is required." will be displayed on Save. This is always editable.

Database Field: ERPx_APVendor.VendorName

Payment Name

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

Database Field: ERPx_APVendor.CheckName

Group: Configuration
Vendor Class ID

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

The lookup contains a blank value, the current assigned value, and a list of all the 'Active' records in the Vendor Class master file.

Database Fields: ERPx_APVendorClass.ClassDescription, ERPx_APVendor.VendorClassSK

Vendor Attribute Class

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

Database Field: ERPx_APVendor.AttributeClassSK

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 'Vendor Class'. This is required and is always editable. If missing, the message "Vendor Processing Failed: ([VendorID]): Payment Terms is required." will be displayed on Save.  When a new Vendor record is created, if there is no Payment Terms value set on the Vendor Class and a Payment Terms value is not manually selected, the message "There is no Payment Terms set on the Vendor Class for this Vendor and Payment Terms is required. Please select a value from the Payment Terms property for the Vendor.” 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_APVendor.PaymentTermSK

Currency

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

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 is required, is always editable, and defaults to "No 1099". 

This lookup contains all the values in the ERPx_APTenNinetyNineType table.

Database Field: ERPx_APVendor.TenNinetyNineTypeSK

Vendor Account

Insert excerpt
Def - Vendor Account
Def - Vendor Account
nopaneltrue
 This is text box to assign the account number associated with the VendorThis defaults to blank and is not required, but if entered, it must be <=25 characters. This is always editable. This is not visible until after the record is initially saved. 

Database Field: ERPx_APVendor.VendorAccount

Group: Default Address
1099

Insert excerpt
Def - Default Address 1099
Def - Default Address 1099
nopaneltrue
 This is a single-select lookup to assign the Address ID that contains the address used for 1099s. 

This is not editable on new records until they are initially saved. Then, this defaults to 'PRIMARY' but is always editable.

The lookup contains the current assigned value and a list of all the 'Active' vendor Address IDs for the current Vendor.

Database Field: ERPx_APVendorAddress.Is1099Default

Payment

Insert excerpt
Def - Default Address Payment
Def - Default Address Payment
nopaneltrue
 This is a single-select lookup to assign the Address ID that contains the address used for Payments.

This is not editable on new records until they are initially saved. Then, this defaults to 'PRIMARY' but is always editable.

The lookup contains the current assigned value and a list of all the 'Active' vendor Address IDs for the current Vendor.

Database Field: ERPx_APVendorAddress.IsPaymentDefault

Physical

Insert excerpt
Def - Default Address Physical
Def - Default Address Physical
nopaneltrue
 This is a single-select lookup to assign the Address ID that contains the address used for the physical location.

This is not editable on new records until they are initially saved. Then, this defaults to 'PRIMARY' but is always editable.

The lookup contains the current assigned value and a list of all the 'Active' vendor Address IDs for the current Vendor.

Database Field: ERPx_APVendorAddress.IsPhysicalDefault

Group: Tax
Tax ID

Insert excerpt
Def - Tax ID
Def - Tax ID
nopaneltrue
 This is text box to assign the Tax ID associated with the Vendor. This defaults to blank and is not required but if a value is entered it must be <=15 characters. This is always editable.

Database Field: ERPx_APVendor.TaxID

Tax Registration

Insert excerpt
Def - Tax Registration
Def - Tax Registration
nopaneltrue
 This is text box to assign the tax registration number associated with the VendorThis defaults to blank and is not required but if a value is entered it must be <=25 characters. This is always editable.

Database Field: ERPx_APVendor.TaxRegistration

Group: Other
Hold

Insert excerpt
Def - On Hold - Vendor
Def - On Hold - Vendor
nopaneltrue
 This is a single-select standard lookup to select if the Vendor's account should be placed on hold or not.

The lookup contains the values 'Yes' or 'No' and defaults to 'No'.  If set to 'Yes' then new transactions can be entered for the Vendor but payments cannot be issued to them. If set to 'No' then the record is not on hold and can be freely used. This field is always editable.

Database Field: ERPx_APVendor.IsOnHold 

Inactive

Insert excerpt
Def - Inactive
Def - Inactive
nopaneltrue
 This is a single-select standard lookup to select if the Vendor's account 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. 

Only Vendors with no open transactions/ balances can be set to Inactive, otherwise the message "Vendor Name([VendorID]) has a balance or is on an open transaction and cannot be saved as Inactive" will be displayed. This is not visible until after the record is initially saved. 

Database Field: ERPx_APVendor.IsInactive


Addresses Tab

Toolbar IconsDescription
Add Item
Insert excerpt
Add Item - RV Grid 3.0
Add Item - RV Grid 3.0
nopaneltrue
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - RV Header 3.0
Excel - RV Header 3.0
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Remove Items

Insert excerpt
Remove Items - RV Grid 3.0
Remove Items - RV Grid 3.0
nopaneltrue

When attempting to delete a Vendor  Fisherman, Fisherman & Tender, and Tender address or Loan address configured for ACH, the message "[Vendor Name]: has an address, [Address ID], that has been used for ACH. Please navigate to the Fisherman ACH configuration page (Fisherman Accounting > Configuration > Fisherman ACH) to remove the record prior to deleting the address record." will be displayed when Remove Items is clicked.

When attempting to delete a Vendor address configured for ACH, the message "[Vendor Name]: Address [Address ID] cannot be deleted because it is configured for ACH" will be displayed when Remove Items is clicked.

When attempting to delete a Vendor Address that is set as default the message "[Vendor Name] [Vendor ID]: Address [AddressID] is the [Default address type] address and cannot be deleted." will be displayed when Remove Items is clicked.

Additionally when attempting to delete a Vendor Address that has been used on a check, the message "[Vendor Name] [Vendor ID]: Address [AddressID] has been used on Checks and cannot be deleted." when Remove Items is clicked.

Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - 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_APVendorAddress.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 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_APVendorAddress.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 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_APVendorAddress.AddressLine3

Address ID

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

Database Field: ERPx_APVendorAddress.AddressID

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 <=25 characters. This is always editable.

Database Field: ERPx_APVendorAddress.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_APVendorAddress.Country

Default - 1099

Insert excerpt
Def - 1099 Type
Def - 1099 Type
nopaneltrue
 This is a non-editable text box that displays as "Yes" for the Address ID assigned as the default '1099' Address ID on the Properties tab of the Vendor Record View, all other Address IDs within a Vendor will have a blank value. This field is never editable from here, but is set from the 1099 default address field on the Properties tab of the Vendor Record View or from the Mass Update on the Vendor Addresses list view. 

Database Field: ERPx_APVendorAddress.Is1099Default

Default - Payment

Insert excerpt
Def - 1099 Type
Def - 1099 Type
nopaneltrue
 This is a non-editable text box that displays as "Yes" for the Address ID assigned as the default 'Payment' Address ID on the Properties tab of the Vendor Record View, all other Address IDs within a Vendor will have a blank value. This field is never editable from here, but is set from the Payment default address field on the Properties tab of the Vendor Record View or from the Mass Update on the Vendor Addresses list view. 

Database Field: ERPx_APVendorAddress.IsPaymentDefault

Default - Physical

Insert excerpt
Def - 1099 Type
Def - 1099 Type
nopaneltrue
 This is a non-editable text box that displays as "Yes" for the Address ID assigned as the default 'Physical' Address ID on the Properties tab of the Vendor Record View, all other Address IDs within a Vendor will have a blank value. This field is never editable from here, but is set from the Physical default address field on the Properties tab of the Vendor Record View or from the Mass Update on the Vendor Addresses list view. 

ERPx_APVendorAddress.IsPhysicalDefault

Default Payment Type

A single-select standard lookup to assign the default payment type for the corresponding address. The lookup contains the values "ACH" or , "Check", "Draft", and "Wire" and defaults to "Check". If set toCheck, a physical check will can be printed when payments are processed for this Vendor, using this address. If set to ACH, an ACH record will be created as part of an ACH batch when payments are processed for this Vendor, using this address. If set to Draft or Wire a remittance can be printed when payments are processed for this Vendor, using this address. 

To change from Check the payment type to ACH, the Address ID must be configured for ACH in the Vendor ACH list view, otherwise the message "Vendor Name (VendorID): Address ID [AddressID]: The Default Payment Type cannot be changed to ACH because the address has not been configured for ACH. Go to Purchasing > Configuration > Vendor ACH to configure this Address." will be displayed. 

This field is required

Database Field: Fields: ERPx_MFModuleTransaction.TransactionName, ERPx_APVendorAddress.DefaultPaymentTypeSK

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

Payment Description

An editable text box to enter the value that will display on the memo line of manual payments for the corresponding Address ID.  This field is not required but if a value is entered it must be <=250 characters. This is always editable.

Database Field: ERPx_APVendorAddress.CheckDescription

Payment Name

Insert excerpt
Def - Payment Name
Def - Payment Name
nopaneltrue
 This is a text box to assign/edit the value for the Payment Name that will be displayed on payments made to the vendor. This defaults from the Vendor Name entered on the Properties tab, but can be overwritten and must be <=150 characters. This is not required but without it the Payment Name field on the Properties tab will be used as the Payee on a printed check or ACH payment, but if both this field and the Payment Name on the Properties tab is blank then the Vendor Name will be used. This is always editable.

Database Field: ERPx_APVendorAddress.CheckName

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

State

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

Database Field: ERPx_APVendorAddress.State

Zip

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

Database Field: ERPx_APVendorAddress.Zip

...

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - RV Header 3.0
Excel - RV Header 3.0
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
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_APVendorContact.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_APVendorContact.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_APVendorContact.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_APVendorContact.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_APVendorContact.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_APVendorContact.Phone

Attributes Tab

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - RV Header 3.0
Excel - RV Header 3.0
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
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 → Vendors). 

Required

A non editable text box that shows whether the Attribute Value is required or not. If the Attribute Value is required, it will display "Yes". If it is optional, it will display as blank. This value is only editable from the 'Assign Attribute Rules' page (Company → Setup → Attributes → Vendors → Vendor Attribute Class hyperlink). 

Value

Insert excerpt
Attribute - Value
Attribute - Value
nopaneltrue

Vendor Items Tab

Toolbar IconsDescription
Add Item
Insert excerpt
Add Item - RV Grid 3.0
Add Item - RV Grid 3.0
nopaneltrue
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - RV Header 3.0
Excel - RV Header 3.0
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Remove Items
Insert excerpt
Remove Items - RV Grid 3.0
Remove Items - RV Grid 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Created 

Insert excerpt
Created
Created
nopaneltrue

Database Field: ERPx_APVendorItem.Created

Created By

Insert excerpt
Created By
Created By
nopaneltrue

Database Field: ERPx_APVendorItem.CreatedBy

Item

Insert excerpt
Item ID & Item Description
Item ID & Item Description
nopaneltrue
 This is a text box that is required. It defaults as blank and is not editable once the line item has been saved to the transaction.

When the 'Add Item' icon is clicked, users may enter all or part of an Item ID or Description and hit the Enter key on the keyboard. If a complete Item ID was entered, the line item will be saved, if not, the Item Lookup dialog box will open with a list of items containing the data entered. From the Item Lookup dialog box, users may check the checkbox next to one or multiple item(s) to add to the transaction using the Save & Close button.

From the Item Lookup page, if a user selects an Item(s) that has not got a Default Purchasing UOM setup on the Item master file record, the message "Item ID: Item Description: Cannot be added as a Vendor Item because it does not have a Default Purchasing UOM." will be displayed on Save.   Users can deselect this item to continue adding items via the lookup. 

Items must be unique by Item, UOM and Vendor, so the same item can be added with a different UOM if needed.  If a user tries to add an item that already exists with the same UOM, the message "The Same Item and UOM already exists." will be displayed on Save. 

Insert excerpt
Def - Item
Def - Item
nopaneltrue

Database Fields: ERPx_IMItem.ItemID:ItemDescription, ERPx_APVendorItem.ItemSK

Last Paid Date

isplays the last date the corresponding item was invoiced for the Vendor. This is a non-editable date field that is not required. This value updates when AP Invoices are Posted for the Vendor and the Item and UOM on the AP Invoice matches the Item and UOM setup on the Vendor Items for the Vendor.  If the item has never been invoiced this field will be blank. 

This field is not stored in the database. 

Last Paid Price

Displays the last Price that was paid for the corresponding item that was invoiced for the Vendor. This is a non-editable numeric text box that is not required. This value updates when AP Invoices are Posted for the Vendor and the Item and UOM on the AP Invoice matches the Item and UOM setup on the Vendor Items for the Vendor. If the item has never been invoiced this field will be blank. 

This field is not stored in the database. 

Last Paid Qty

Displays the last quantity of the corresponding item that was invoiced for the Vendor. This is a non-editable numeric text box that is not required. This value updates when AP Invoices are Posted for the Vendor and the Item and UOM on the AP Invoice matches the Item and UOM setup on the Vendor Items for the Vendor. If the item has never been invoiced this field will be blank. 

This field is not stored in the database. 

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_APVendorItem.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue

Database Field: ERPx_APVendorItem.LastUser

Line Comment

Insert excerpt
Line Item Comment
Line Item Comment
nopaneltrue
 This is an editable text box that is not required.  If a value is entered it must be <= 200 characters and will default on the Find Vendor Items page which is used to add the Vendor Items to a Purchase Order or Invoice record. This is always editable. 

Database Field: ERPx_APVendorItem.LineComment

PO Min. Order Qty

Displays the minimum quantity that should be ordered for the item. For example, a Vendor may require an item to be ordered in a minimum of 50 cases and in multiples of 10 cases. This is a numeric text box that defaults to 0.00 that is not required. If entered, the value must be >= and divisible by the PO Order Multiple Of value (if a value is entered), else the messages "[Vendor Name] (Vendor ID): " Item ID: Item Description: The PO Minimum Order Quantity must be greater than or equal to the PO Order Multiple Of." and "[Vendor Name] (Vendor ID): " Item ID: Item Description: The PO Minimum Order Quantity value entered is not divisible by the PO Order Multiple Of specified." will be displayed on Save. This value is always editable. 

Database Field: ERPx_APVendorItem.POMinOrderQty

PO Order Multiple Of

Displays the multiple of quantity that the item should be ordered in. For example, a Vendor may require an item to be ordered in multiples of 10 cases.  This is a numeric text box that defaults to 0.00 that is not required. If entered, this value must be >= zero, else the message "[Vendor Name] (Vendor ID): " Item ID: Item Description: Negative PO Order Multiple Of is not allowed." will be displayed on Save.  This is always editable. 

Database Field: ERPx_APVendorItem.POOrderMultiple

Price

Insert excerpt
Price
Price
nopaneltrue
 This is a numeric text box that is not required.  It defaults to zero and will display the number of decimals setup on the corresponding Item's Price Decimals. If a value is entered it will default on the Find Vendor Items page which is used to add the Vendor Items to a Purchase Order or Invoice record. This is always editable. 

Database Field: ERPx_APVendorItem.Price

Seq.

Insert excerpt
Seq.
Seq.
nopaneltrue
 This is an editable text box that defaults to the next available base-10 number. It is required, and is always editable. To re-sequence the line items, edit one or more lines with a new positive number that would put the line item where you want it sorted, and click the Save button. On save, the line items will be resorted, and the Ln. values will be re-set to base-10 values.

For example, if you had line items 10, 20, and 30 and you wanted the last one (Ln. 30) to be second, you could edit the value to any number between 10 and 20 (i.e. 15) and on save the lines would be sorted in the new sequence (10, 15, and 30) and then all Ln.'s would be re-set to base 10 numbers (10, 20, 30).

Database Field: ERPx_APVendorItem.LineItemSort

UOM

Insert excerpt
UOM - Price
UOM - Price
nopaneltrue
 This is a single select lookup that defaults from the 'Purchases' Default UOM on the Item master file record if one is entered, else it is blank to select a value.  If a value is not selected the message "[Vendor Name] (Vendor ID): " Item ID: Item Description: A UOM is required to add a Vendor Item." will be displayed on Save.  The lookup contains a list of all the active UOM's setup on the Item's UOM schedule. 

Database Fields: ERPx_IMUOM.UOMID, ERPx_APVendorItem.PriceUOMSK

Vendor Item Description

Displays the description of the Vendor Item. This is an editable text box that is not required.  If a value is entered it must be <= 200 characters and will default on the Find Vendor Items page which is used to add the Vendor Items to a Purchase Order or Invoice record. This is always editable. 

Database Field: ERPx_APVendorItem.VendorItem

GL Accounts Tab

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - RV Header 3.0
Excel - RV Header 3.0
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Account Type

This field contains the following account types: 

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

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 

A single-select load on demand lookup to assign the GL Account. This defaults from the value assigned on the Vendor 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


...