Insert excerpt

	Def - Vendor
	Def - Vendor
nopanel	true

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

type	flat

Page Header

...

Search

Build Payment BatchOpens Build Payment Batch Record View, where users can create new payment batches.Excel Insert excerptExcel - LVExcel - LV

Search Options	Description

Apply Payables DocumentsOpens Unapplied Payable Documents list view, which displays unapplied payable transactions for users to apply towards 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.

Auto Hide Filters

Insert excerpt

	Auto Hide Filters
	Auto Hide Filters
nopanel	true

Favorites Insert excerptInquiry Criteria - GlobalInquiry Criteria - Globalnopaneltrue

Auto Refresh on Open

Insert excerpt

Favorites Add/Remove - GlobalFavorites Add/Remove - GlobalnopaneltrueGrid Layout Insert excerptGrid Layout - GlobalGrid Layout - GlobalnopaneltrueHelp Insert excerptHelp - GlobalHelp - GlobalnopaneltrueInquiry Criteria

Auto Refresh on Open
	Auto Refresh on Open
nopanel	true

Hide Vendors where all balances are 0.00

: A text box

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.

Vendor Class:

Saved Searches

Image 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 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 PaymentsOpens Process Payments Record View, where users can modify, print and post check and ACH payments. Refresh

Page Detail

Clicking the link opens the Vendor record view for the selected Account. This comes from the 'Vendor Name' + '(Vendor ID)' fields on the 'Properties' tab of the Fishermen & Tenders record view or the Loans record view. This field is always editable.

Database Fields: ERPx_APVendor.VendorName, ERPx_APVendor.VendorID

This comes from the 'Vendor Class' field on the 'Properties' tab of the Fishermen & Tenders record view or the Loans record view. This field is always editable.

Database Fields: ERPx_APVendorClass.ClassDescription, ERPx_APVendor.VendorClassSK

Clicking the link opens the Vendor record view for the selected Account. This comes from the 'Vendor ID' field on the 'Properties' tab of the Fishermen & Tenders record view or the Loans record view. This field is always editable.

Database Field: ERPx_APVendor.VendorID

Clicking the link opens the Vendor record view for the selected Account. This comes from the 'Vendor Name' field on the 'Properties' tab of the Fishermen & Tenders record view or the Loans record view. This field is always editable.

Database Field: ERPx_APVendor.VendorName

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.

Database Field: ERPx_MFTransactionBatch.BatchID

Database Field: ERPx_APVendor.MasterVendorSKGLAccount.AccountNumber - ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef

Open POs amount distributed to the Account on purchase orders in a Status of 'New' or 'Approved', is ,

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Excel

Insert excerpt

	Excel - LV
	Excel - LV
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Refresh Help - GlobalRefresh
	Help - Global
nopanel	true

View

Displays a drop down menu of related drill-through inquiries. When an option is selected, it opens in a separate tab. The list of options includes:

Transactions: Opens the Vendor History Inquiry to display all transactions related to the selected Vendor

More Actions

Insert excerpt

	More Actions - Global 3.0
	More Actions - Global 3.0
nopanel	true

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.

Invoice Applications

Transactions: Opens the

AP Transaction & Check Applications Inquiry to shows the list of Invoices and the transactions that were applied to them.

Fields

Description

Vendor

Insert excerpt

Account Name

nopanel

true

Vendor Class

Insert excerpt

Fisherman (Account) Class

nopanel

true

Vendor ID

Insert excerpt

Account ID

nopanel

true

Vendor Name

Insert excerpt

Account Name

nopanel

true

Activity

A hyperlink that when clicked opens the 'Fisherman & Loan Activity' inquiry for the associated Account. By default, all transactions that are New, Approved, Ready to Post, Posted, and Voided will be displayed; excluding those that have been deleted by default.

Batch

Insert excerpt

Batch ID

nopanel

true

Default Settlement Accrual Account

Identifies the settlement accrual account for the associated Fisherman, Fisherman & Tender, Tender or Loan. This comes from the 'Settlement Accrual

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
nopanel	true

Saved Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Search Options

Insert excerpt

	Search Options - Inquiry Grid 3.0
	Search Options - Inquiry Grid 3.0
nopanel	true

Fields

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

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

Fishermen & Tenders record view or the Loans record view. This field is always editable

Vendor Record View.

Insert excerpt

	Def - GL Account -

Settlement Accural

Accounts Payable
	Def - GL Account -

Settlement Accural

Accounts Payable
nopanel	true

Database

Field

Fields: ERPx_

APVendor.SAGLAcctRef

Master Account

Identifies an Account associated with a Fisherman, Fisherman & Tender, Tender or Loan. Clicking the link opens the Vendor record view for the selected Account. This comes from the 'Master Account' field on the 'Properties' tab of the Fishermen & Tenders record view or the Loans record view. This field is always editable.

Insert excerpt

Def - Master Account - Fisherman

nopanel

true

Net Balance

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

On Hold

Displays 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 Transactions

Displays the total balance amount from all transactions in transactions in a status of '"New' " or 'Approved' (excludes transactions in a status of 'Ready to Post' or 'Posted')"Approved" for a Vendor. Once the Status is set to "Ready to Post" or "Posted", the transactions transaction totals will apply move to the Posted Balance. Negative balances amounts will appear within parentheses. The following transactions are included in this total: Adjustment, Balance Transfer, Payment Receipt, AP Credit Memo, Fish Ticket, Fisherman Sale, AP Invoice, Payment and Tender Resale. This is a calculated field , that is not editable and is not stored in the database.

Payment Amount

Identifies the amount to be paid to the Fisherman, Fisherman & Tender, Tender or Loan as a manual payment. This is a text box that . 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 BalanceD

isplays

Displays the total balance from all transactions in a status of

'

"Ready to Post

'

" or

'

"Posted

'. The following transactions are included in this total: Adjustment, Balance Transfer, Payment Receipt, AP Credit Memo, Fish Ticket, Fisherman Sale, AP Invoice, Payment and Tender Resale.

". 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
nopanel	true

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
nopanel	true

Insert excerpt

	Def - Vendor ID
	Def - Vendor ID
nopanel	true

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
nopanel	true

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
nopanel	true

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
nopanel	true

Database Fields: ERPx_APVendor.VendorName

Version	Old Version 2	New Version Current
Changes made by	Janice Dannenberg (Unlicensed)	Emma Greenwood
Saved on	Mar 26, 2021	Jul 05, 2023

Versions Compared

Key

Page Header

Search

Page Detail

Related Topics

Page Definitions

Page Comparison

Versions Compared

Key

Page Header

Search

Page Detail

Related Topics

Page Definitions