The purpose of the Fisherman Balances page is to show current balances for all Fishermen, Fishermen & Tenders, Tenders and Loans. Users can view balances owed to or from Accounts, open Fisherman Statements, view transaction activity tied to an Account, Apply Documents, as well as process payments and settlement batches.

Software Version: 2020.05.22 and newer

Page Header

Toolbar Icons	Description
Apply Documents	Opens Unapplied Fishing Documents list view, which displays unapplied payment transactions for users to apply towards payable documents. If one Fisherman, Fisherman & Tender, Tender or Loan is selected prior to clicking the Apply Documents button, the results will be filtered on the selected Fisherman, Fisherman & Tender, Tender or Loan. Else if nothing is selected, all applicable transactions will be displayed.
Build Settlement Batch	Opens Build Settlement Batch record view, where users can create new Fisherman Settlement 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: Hide Accounts 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 fishermen, fishermen & tenders, tenders or loans with a balance of zero (0.00) in the list view. Fisherman Class: A multi-select lookup that defaults to "All", but also includes a list of all the 'Active' Fisherman Classes. This allows users to select specific Account Types to display in the list view.
Mass Update	Opens the mass update dialog, which allows to mass update the following properties: Auto Pay: A single-select lookup that defaults to "(No Change)", but has the options of "Net Balance" and "Posted Balance". Selecting "Net Balance" will automatically enter the payment amount (based on the method) that will be applied to the Net Balance amount. Selecting "Posted Balance" will automatically enter the payment amount (based on the method) that will be applied to the Posted Balance amount, so if there are transactions in New or Approved statuses, these will not be included in the posted balance. Auto Pay Method: A single-select lookup that defaults to blank, but has the options of "Full Amount" or "Percentage". Selecting "Full Amount" will automatically enter either the total Net Balance or Posted Balance amount depending on what was selected in the Auto Pay property. Selecting "Percentage" allows the user to specify what percent of the Net Balance or Posted Balance they wish to pay. Auto Pay Amount: A numeric text box that defaults to blank and allows the user to enter a number to calculate the percent when the Auto Pay Method "Percentage" is selected. Do you want to FIFO Apply Transactions?: A single-select lookup that defaults to "(No Change)", but also has options for "Yes" and "No". Selecting "Yes" will utilize the FIFO (First In, First Out) process to apply the transaction types selected in the 'Incl. Payable Transactions (Balance Sheet Credit)' field to transaction types selected in the 'Incl. Receivable Transactions (Balance Sheet Debit)' field to all filtered/selected Accounts. Selecting "No" will not apply any transactions. Incl. Payable Transactions (Balance Sheet Credit): A multi-select lookup that defaults to blank, but also has options for "ALL", "Adjustment", "Balance Transfer", "Credit Memo", "Fish Ticket", "Fisherman Sale", "Invoice", "Payment Receipt" and "Tender Resale". The transaction types selected in this field will be applied to the transaction types selected in the 'Incl. Receivable Transactions (Balance Sheet Debit)' field, given "Yes" is selected for the 'Do you want to FIFO Apply Transactions?' field. Incl. Receivable Transactions (Balance Sheet Debit): A multi-select lookup that defaults to blank, but also has options for "ALL", "Adjustment", "Balance Transfer", "Credit Memo", "Fish Ticket", "Fisherman Sale", "Invoice", "Payment" and "Tender Resale". The transaction types selected in the 'Incl. Payable Transactions (Balance Sheet Credit)' field will be applied to the transaction types selected in this field, given "Yes" is selected for the 'Do you want to FIFO Apply Transactions?' field. The FIFO process looks to the transaction date and makes applications to the oldest transactions first. If several transactions occur on the same date, then the smallest TransactionSK number will be applied to next.
More Actions	Allows users to select between "Process Interest Charges" or "Process Interest Payments" and opens the associated page.
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.
Fields	Description
Account	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
Account 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
Account 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
Account 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
Account Type	Identifies type of vendor to which the Account belongs. This comes from the 'Vendor Type' field on the 'Properties' tab of the Vendor Class record view. This field is only editable when the 'Vendor Class' is updated for the associated Account. Vendor Types are used to classify Vendor Classes by functionality. In Accounts Payable, all Vendors are auto-assigned a Vendor Type of "Vendor". In Fisherman Accounting, accounts can be assigned a Vendor Type of either Fisherman, Tender, Fisherman & Tender, or Loan. Database Field: ERPx_APVendor.VendorTypeEN
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	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
Default Settlement Accrual 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
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. The Master Account is a way to associate more than one Fisherman Accounts together for informational purposes. Database Field: ERPx_APVendor.MasterVendorSK
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.
Open POs	Displays the total amount distributed to the Account on purchase orders in a Status of 'New' or 'Approved'. This is a calculated field, is not editable and is not stored in the database.
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	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
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.
Statement	A hyperlink that when clicked opens the Fisherman Statement report for the associated Account.

Page Header

Related Topics

Page Definitions

Technical Details

Fisherman Balances List View

Page Header

Related Topics

Page Definitions

Technical Details