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: 2021.04.09 and newer
Page Header
Toolbar Icons | Description |
---|---|
Apply Payables Documents | Opens 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. |
Build Payment Batch | Opens Build Payment Batch Record View, where users can create new payment batches. |
Excel | Export 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. Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab. |
Grid Layout | Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). The bolded view is the default view, which will determine the view will automatically display in when opened. |
Help | Opens the online WIKI help page for the current page. This icon is only visible on pages that are documented in the online help. |
Inquiry Criteria | Opens Inquiry Criteria window where users can define the following criteria:
|
Process Payments | Opens Process Payments Record View, where users can modify, print and post check and ACH payments. |
Refresh | Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. |
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:
|
Fields | Description |
Default Accounts Payable Account | Identifies the settlement accrual account for the associated Fisherman, Fisherman & Tender, Tender or Loan. This comes from the 'Settlement Accrual' field in the 'Accounts' tab of the Fishermen & Tenders record view or the Loans record view. This field is always editable. The GL Account that is assigned for the "Settlement Accrual" Account Type, on the Accounts tab of the Fisherman or Loan Record View and Fisherman Class Record View. This is the Balance Sheet account that is Debited or Credited when Fishing Transactions are posted for the selected Fisherman, Tender, or Loan account. Database Field: ERPx_APVendor.SAGLAcctRef |
Net Balance | Displays the total balance for the Account before any payments are processed. This is calculated as [Posted Balance]+[Open Transactions]-[Open POs]. Negative net balances will appear within parentheses. This field is not editable and not stored in the database. |
On Hold | |
Open Transactions | Displays the total balance amount from all transactions in a status of 'New' or 'Approved' (excludes transactions in a status of 'Ready to Post' or 'Posted'). Once the Status is set to "Ready to Post" or "Posted", the transactions will apply to the Posted Balance. Negative balances 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, 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 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. Database Fields: ERPx_MFCheckbookTransaction.Amount, ERPx_MFTransactionBatch.TransactionBatchSK |
Pending Payments | Displays the name of the batch. 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 |
Posted Balance | 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, is not editable and is not stored in the database. |
Unapplied Credits | |
Unapplied Payments | |
Unpaid Invoices | |
Vendor | Identifies the name of the Fisherman, Fisherman & Tender, Tender or Loan. 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 |
Vendor Class | Identifies the description of the Fisherman Class associated with the transaction. 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 |
Vendor ID | Identifies the ID of the Fisherman, Fisherman & Tender, Tender or Loan. 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 |
Vendor Name | Identifies the name of the Fisherman, Fisherman & Tender, Tender or Loan. 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 |