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 is page is to show current balances for all Vendors. Users can view balances owed to or from Vendors, view transaction activity tied to a Vendor, view Payment and Invoice applications, apply Payable Documents, and process payments and payment batches.

Software Version: 20212023.0406.09 30 and newer

Table of Contents
typeflat

Page Header

Toolbar Icons
Search Options
Description
Apply Payables Documents

Opens the Unapplied Payable Documents list view, which displays unapplied payments and Credit Memos that can be selected and applied to invoices. If one or more Vendor(s) are selected prior to clicking the Apply Payables Documents button, the results will be filtered on the selected Vendor(s). Else if no Vendors are selected, then all applicable transactions will be displayed.

Build Payment BatchOpens Build Payment Batch Record View, where users can create new payment batches.
Auto Hide Filters
Insert excerpt
Auto Hide Filters
Auto Hide Filters
nopaneltrue
Auto Refresh on Open
Insert excerpt
Auto Refresh on Open
Auto Refresh on Open
nopaneltrue
Hide Vendors where all balances are 0.00

A single select lookup that defaults to "Yes", but also has an option for "No". This allows users to select whether or not to include Vendors with a balance of zero (0.00) in the List View.

Saved SearchesImage AddedDisplays the saved searches lookup and related icons. This tool allows users to select previously saved search options, create a new set of search options, save changes to existing search options, forget/delete saved search options and/or assign a saved search option as the default for the page. Once changes are made to the search options, the user can click the Save Options icon and save the changes. Saving search options will also save the preferences for 'Auto Refresh on Open' and 'Auto Hide Filters'. The new search option can also be set as the default.  Default searches can be removed by clicking the 'Set as Default' button again when the current default search is selected.  

Refer to this FAQ for advanced search options.

Vendor ClassA multi-select lookup that defaults to "All", but also includes a list of all the 'Active' Vendor Classes. This allows users to select specific Vendor Types to display in the List View.

Page Detail

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV
Excel - LV
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 - Global
Grid Layout
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Inquiry CriteriaMore ActionsOpens Process

Insert excerpt
Inquiry Criteria
More Actions - Global
Inquiry Criteria
3.0
More Actions - Global 3.0
nopaneltrue

  • Hide Vendors where all balances are 0.00: A text box that defaults to "Yes", but also has an option for "No". This allows users to select whether or not to include Vendors with a balance of zero (0.00) in the List View.
  • Vendor Class: A multi-select lookup that defaults to "All", but also includes a list of all the 'Active' Vendor Classes. This allows users to select specific Vendor Types to display in the List View.
Process Payments
  • Invoice Applications: Opens the AP Transaction & Check Applications Inquiry to shows the list of Invoices and the transactions that were applied to them.
  • Payment Applications: Opens Opens the AP Transaction & Check Applications Inquiry to shows the list of Credit Memos and Payments and the transactions they were applied to. 
  • Transactions: Opens the Vendor History Inquiry to display all transactions related to the selected Vendor.

  • Apply Documents: Opens the Unapplied Payable Documents list view, which displays unapplied payments and Credit Memos that can be selected and applied to invoices. If one or more Vendor(s) are selected prior to clicking the Apply Payables Documents button, the results will be filtered on the selected Vendor(s). Else if no Vendors are selected, then all applicable transactions will be displayed.
  • Build Payment Batch: Opens Build Payment Batch Record View, where users can create new payment batches.
  • Process Payments: Opens the Process Payments Record View, where users can modify, print and post Check and ACH payments that are included in an open Batch or manual payments that have been entered on this page.  Note: If users manually enter a payment amount for Vendors with different currencies, the message "The selected Vendors have multiple currencies, manual payments can be made with only one currency." will be displayed when this button is clicked. 
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
View

Displays a drop down menu of related drill-through inquiries. The list of options includes:

  • Transactions: Opens the Vendor History Inquiry to display all transactions related to the selected Vendor.
  • Payment Applications: Opens Opens the AP Transaction & Check Applications Inquiry to shows the list of Credit Memos and Payments and the transactions they were applied to. 
  • Invoice Applications: Opens the AP Transaction & Check Applications Inquiry to shows the list of Invoices and the transactions that were applied to them.Saved Layouts
    Insert excerpt
    Column Layouts for Framework 3.0 - Global
    Column Layouts for Framework 3.0 - Global
    nopaneltrue
    Search Options
    Insert excerpt
    Search Options - Inquiry Grid 3.0
    Search Options - Inquiry Grid 3.0
    nopaneltrue
    FieldsDescription
    Checkbox
    Insert excerpt
    Checkbox
    Checkbox
    nopaneltrue
    Default Accounts Payable Account

    Identifies the accounts payable account for the associated Vendor, displayed as [Account Number] - [Description]. This is not required and is always editable from the 'Accounts Payable' field in the 'Accounts' tab of the Vendor Record View.

    Insert excerpt
    Def - GL Account - Accounts Payable
    Def - GL Account - Accounts Payable
    nopaneltrue

    Database Fields: ERPx_GLAccount.AccountNumber - ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef

    Net Balance

    Displays the total unapplied balance for the Vendor, including balances on open transactions, before any payments are processed. It is calculated as [Unpaid Invoices] - [Unapplied Payments] - [Unapplied Credits] + [Open Transactions]. Negative net balances will appear within parentheses. This is a calculated field that is not editable and is not stored in the database.

    On HoldDisplays the total dollar amount of Invoices/Credit Memos that are on hold for a Vendor. This is not required. If "Yes" is selected for the 'Pmt./Apply Hold' field on the 'Properties' tab of the Invoice or Credit Memo Record View, then the 'Extended' amount of the transaction will be added to this column. Negative amounts will appear within parentheses. This is a calculated field that is not editable and not stored in the database.
    Open TransactionsDisplays the total balance amount from all transactions in a status of "New" or "Approved" for a Vendor. Once the Status is set to "Ready to Post" or "Posted", the transaction totals will move to the Posted Balance. Negative amounts will appear within parentheses. This is a calculated field that is not editable and is not stored in the database.
    Payment Amount

    Identifies the amount to be paid. This field can be manually edited to create a manual payment or it will display the amount of a payment included in an open Payment Batch.  It defaults to '0.00'. Entering a value in this field and clicking the 'Process Payments' icon in the header toolbar will create a new Quick Payment batch. This field is always editable.

    Database Fields: ERPx_MFCheckbookTransaction.Amount, ERPx_MFTransactionBatch.TransactionBatchSK

    Pending Payments

    Identifies whether or not there is a pending payment for the Vendor. This field is not required and displays "Yes" if the Vendor has any checks on a check batch that has not been printed yet. This field auto-populates after a payment has been entered, processed, but not yet Posted or when a settlement batch has been built, but not yet Posted. This field is not editable and not stored in the database.

    Posted Balance

    Displays the total balance from all transactions in a status of "Ready to Post" or "Posted". Negative balances will appear within parentheses. This is a calculated field that is not editable and is not stored in the database. 

    [Posted Balance] = [Unpaid Invoices] + [Unapplied Payments] + [Unapplied Credits].

    Transaction Currency

     This field displays the transaction(s) currency for the corresponding Vendor. This is required and is not editable. 

    Insert excerpt
    Def - Currency
    Def - Currency
    nopaneltrue

    Database Fields: ERPx_MFCurrency.CurrencyID

    Unapplied Credits

    Displays the total amount of available credits for a Vendor that have not been applied towards Invoices. This is not required. This is a calculated field that is not editable and is not stored in the database.

    [Unpaid Invoices] + [Unapplied Payments] + [Unapplied Credits] = [Posted Balance]

    Unapplied Payments

    Displays the total amount of payments for a Vendor that have not been applied towards Invoices. This is not required. This is a calculated field that is not editable and is not stored in the database.

    [Unpaid Invoices] + [Unapplied Payments] + [Unapplied Credits] = [Posted Balance]

    Unpaid Invoices

    Displays the total Invoice amount for a Vendor that have no credit or payment applications. This is not required. This is a calculated field that is not editable and is not stored in the database.

    [Unpaid Invoices] + [Unapplied Payments] + [Unapplied Credits] = [Posted Balance]

    Vendor

    Identifies the name and ID of the Vendor, displayed as 'Vendor Name' + '(Vendor ID)'. Clicking the link opens the Vendor Record View for the selected Vendor. This is required and is always editable from the 'Vendor Name' field on the 'Properties' tab of the Vendor Record View.

    Insert excerpt
    Def - Vendor Name
    Def - Vendor Name
    nopaneltrue
    Insert excerpt
    Def - Vendor ID
    Def - Vendor ID
    nopaneltrue

    Database Fields: ERPx_APVendor.VendorName, ERPx_APVendor.VendorID

    Vendor Class

    Identifies the class that is assigned to the Vendor. This is required and is always editable from the 'Vendor Class' field on the 'Properties' tab of the Vendor Record View.

    Insert excerpt
    Def - Vendor class
    Def - Vendor class
    nopaneltrue

    Database Fields: ERPx_APVendorClass.ClassDescription, ERPx_APVendor.VendorClassSK

    Vendor ID

    Identifies the unique ID of the Vendor. Clicking the link opens the Vendor Record View for the selected Vendor. This is required and is always editable from the 'Vendor ID' field on the 'Properties' tab of the Vendor Record View.

    Insert excerpt
    Def - Vendor ID
    Def - Vendor ID
    nopaneltrue

    Database Field: ERPx_APVendor.VendorID

    Vendor Name

    Identifies the name of the Vendor. Clicking the link opens the Vendor Record View for the selected Vendor. This is required and is always editable from the 'Vendor Name' field on the 'Properties' tab of the Vendor Record View.

    Insert excerpt
    Def - Vendor Name
    Def - Vendor Name
    nopaneltrue

    Database Fields: ERPx_APVendor.VendorName

    ...