Vendor Balances List 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 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: 2023.06.30 and newer

Page Header

Search Options
Description
Auto Hide FiltersA non-required text box that defaults as checked and is used to determine if the Search Options should be hidden when the Inquiry runs or is refreshed.
  • When checked, each time the 'Refresh' button is clicked, the search options will be hidden, allowing for more rows of data to be visible on the page. This behavior is ideal for users that have entered their search parameters and want to see the results in full-screen. 
  • When unchecked, the search options will not be hidden when the 'Refresh' button is clicked. This behavior is ideal for users that need to run several searches with different search parameters.

Users can only change the default value of this setting with a custom search in the "Saved Searches" lookup. If you change the default setting but do not save it in a custom search, it will only remain this way while the page is opened.

Refer to this FAQ for advanced search options.

Auto Refresh on OpenA non-required text box that defaults as checked and is used to determine if the inquiry opens with or without data in the grid.
  • When checked, each time the page is opened, the search is run using the default parameters (or a 'Saved Search' if one was set as your default for the page) so the grid will be populated with data .  
  • When unchecked, the search is NOT run when the page opens and no data will be present until the 'Refresh' button is clicked. 

Users can only change the default value of this setting with a custom search in the "Saved Searches" lookup.

Refer to this FAQ for advanced search options.

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 SearchesDisplays 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 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.
ExcelExport the contents of the list view 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 only the filtered contents will be exported. 
Favorites Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline. 

(lightbulb) Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.

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. 
HelpOpens the online WIKI help page for the current page. 

(lightbulb) This icon is only visible on pages that are documented in the online help.

More Actions

 Displays a drop down menu of related actions. The list of options includes:

  • 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 Re-queries the contents of the grid/page based on the Search Options or the default values for grids that do not support Search Options. 

(lightbulb) This ONLY re-queries the contents of columns that are currently visible, if you add a new column the contents will be empty until you click 'Refresh' again.

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.

Search Options Toggles between displaying and hiding the Search Options portion of the page.
FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
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.

The GL Account that is assigned for the "Accounts Payable" Account Type, on the Accounts tab of the Vendor Record View and Vendor Class Record View. This is the account where accounts payable amounts are posted for the selected Vendor. 

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. 

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.

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.

Vendor Names are used as a long description for Vendors. 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.

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.

Vendor Classes are used to identify default values that will be applied to new Vendor accounts and to group Vendor accounts together for reporting purposes. 

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.

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.

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.

Vendor Names are used as a long description for Vendors.

Database Fields: ERPx_APVendor.VendorName

Related Topics

User Guide: Vendor Balances


 Page Definitions

Page Definitions


 Technical Details

Technical Details