Vendor Record View
A Vendor is a company or person that sells goods or services to your company. They are used in Purchasing and on Brokerage Sales Programs. 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: 2024.09.27 and newer
Page Header
Header Toolbar
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! |
Help | Opens the online WIKI help page for the current page. |
New | Opens a new blank record for data entry. |
Notes | Opens the Notes dialog, filtered for the appropriate Note Type(s). From here, users can add, review, or edit Notes associated with the record. This icon is always enabled. |
Save | Saves the changes made to the record. |
Save & Close | Saves your changes and closes the page. |
Fields | Description |
Vendor Name | Vendor Names are used as a long description for Vendors. This defaults to blank for new records but is required. This is editable from the 'Properties' tab on the Vendor Record View. Database Field: ERPx_APVendor.VendorName |
Properties Tab
Toolbar Icons | Description |
---|---|
Column Filter Show/Hide | Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
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. |
Group By Show/Hide | Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
Quick Column Filter | Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
Saved Layouts | Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
Fields | Description |
Properties | Identifies the Property that is being set up. |
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 | |
Vendor ID | Vendor IDs are used as a short description and unique identifier for Vendor records. They can be changed at any time to any alphanumeric value. If you do not have an existing strategy for Vendor IDs the 3-3-2 method would be recommended. 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 | Vendor Names are used as a long description for Vendors. 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 | The Payment Name is used to identify the name that will be printed as the payee on Check Payments and/or an ACH Remittance. 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 | Vendor Class IDs are used as a short description and unique identifier for Vendor Class records. 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 | Attribute Classes are assigned to master files to control which Attributes are visible, and/or required, to records within the master file. 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 | 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 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 | 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 '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 | If you plan on sending the Vendor a 1099 statement at the end of the year, this is used to specify the 1099 statement box number where you are most likely to report amounts. This is informational only and does not drive functionality. 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 | Vendor Accounts represent the account number the vendor has assigned to you. This is informational only and does not drive functionality. This is text box to assign the account number associated with the Vendor. This 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 | Identifies the address used when mailing out 1099s. 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 | Identifies the address used on check payments. 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 | Identifies the physical address of the account. 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 | This is the Tax ID of the Vendor that is used on the 1099 statement. This is informational only and does not drive functionality. 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 | Used to record the company's tax registration number, most commonly used for companies tracking Goods and Services Taxes (GST) or Value-Added Taxes (VAT). This is informational only and does not drive functionality. This is text box to assign the tax registration number associated with the Vendor. This 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 | Identifies if the Vendor is "on Hold". If a Vendor is on hold (set to "Yes") then new transactions can be entered for them but payments cannot be issued to them. If set to "No" or blank, the Vendor is not on hold and all transactions can be processed. 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 | 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 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 Icons | Description |
---|---|
Add Item | Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item. |
Column Filter Show/Hide | Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
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. |
Group By Show/Hide | Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
Quick Column Filter | Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
Remove Items | Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'. 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 | Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
Fields | Description |
Checkbox | Used to select one or more records for Mass Update or Delete. |
Address 1 | Address Line 1 typically contains the primary address information such as the street address. 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 | Address Line 2 typically contains secondary address information (e.g. floor, suite or mail stop number) related to Address Line 1. 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 | Address Line 3 is used for additional address information that could not be contained in Address Line 1 or 2. 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 | Vendor Address IDs are used as a short description and unique identifier for Vendor Address records. These can be changed at any time to any alphanumeric value. For Vendors with only one Address, the default value of PRIMARY can be used. Address IDs Like BILLING and PHYSICAL are often used for Vendors with separate addresses. 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 | The City identifies the value of 'City' in an address record. 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 | The Country identifies the 'Country' of an address record. 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 | If you plan on sending the Vendor a 1099 statement at the end of the year, this is used to specify the 1099 statement box number where you are most likely to report amounts. This is informational only and does not drive functionality. 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 | If you plan on sending the Vendor a 1099 statement at the end of the year, this is used to specify the 1099 statement box number where you are most likely to report amounts. This is informational only and does not drive functionality. 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 | If you plan on sending the Vendor a 1099 statement at the end of the year, this is used to specify the 1099 statement box number where you are most likely to report amounts. This is informational only and does not drive functionality. 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", "Check", "Draft", and "Wire" and defaults to "Check". If set to Check, a physical check 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 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 Fields: ERPx_MFModuleTransaction.TransactionName, ERPx_APVendorAddress.DefaultPaymentTypeSK |
Email is used to record the email address(es) associated with an address. 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 | The Payment Name is used to identify the name that will be printed as the payee on Check Payments and/or an ACH Remittance. 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 | Used to record the primary phone number associated with an address. This is informational only. 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 | The State identifies the value of 'State' in an address record. 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 | The Zip identifies the value of 'Zip' (Zip Code) in an address record. 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 |
Contacts Tab
Toolbar Icons | Description |
---|---|
Column Filter Show/Hide | Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
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. |
Group By Show/Hide | Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
Quick Column Filter | Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
Saved Layouts | Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
Fields | Description |
Contact Type | Contact Types are used to classify Contacts. 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 |
Used to record the email address(es) associated with a Contact. This is informational only. 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 | Used to record the fax number associated with a Contact. This is informational only. 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 | Used to record the name associated with a Contact. This is informational only. 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 | Used to record a note associated with a Contact. This is informational only. 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 | Used to record the primary phone number associated with a Contact. This is informational only. 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 Icons | Description |
---|---|
Column Filter Show/Hide | Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
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. |
Group By Show/Hide | Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
Saved Layouts | Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
Fields | Description |
Attribute | A non editable text box that shows the name of the Attribute. Attributes are user-definable fields that are used on master files and transactions and are editable from the Attributes List View. The Attribute will only be displayed if the Applies property on the Assign Attribute Rules by page is set to either "Yes - Required" or "Yes - Not Required". Attributes set to "No" will not be displayed. 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 | Identifies the value assigned to the corresponding attribute. Because Attributes are configurable as either Text, List, Date, or Date/Time the data entry is either a text box, lookup, or date picker. The value defaults to blank and is only required if the Attribute's 'Applies' property is set to "Yes - Required" in the Assign Attribute Rules page. Attribute Values for Master Flies are always editable. Attribute Values for transactions are always editable for unposted transactions. |
Vendor Items Tab
Toolbar Icons | Description |
---|---|
Add Item | Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item. |
Column Filter Show/Hide | Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
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. |
Group By Show/Hide | Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
Quick Column Filter | Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
Remove Items | Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'. |
Saved Layouts | Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
Fields | Description |
Created | Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_APVendorItem.Created |
Created By | Identifies the name of the user that created the record. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Database Field: ERPx_APVendorItem.CreatedBy |
Item | Identifies the Item, displayed as Item ID: Item Description. 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. Items represent objects that you sell, produce, and/or purchase that are tracked within the system. They are used on Sales, Inventory, Fisherman Accounting and Purchasing transactions. Database Fields: ERPx_IMItem.ItemID:ItemDescription, ERPx_APVendorItem.ItemSK |
Last Paid Date | Displays 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 | Identifies the Last Updated Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_APVendorItem.LastUpdated |
Last Updated By | Identifies the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Database Field: ERPx_APVendorItem.LastUser |
Line Comment | Identifies an alternate comment/description for a line item. This is most commonly used to either identify the Vendor's Item ID or to add more clarity to a generic/bulk Item ID. 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 | Identifies the price of the line item. 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. | Displays the numerical sequence the line item appears in the Item's grid on the transaction or master file. For example, if you had line items 10, 20, and 30 a |