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: 2021.06.0411 and newer
| Table of Contents | ||
|---|---|---|
|
...
Search
Search Options | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Fisherman Class | Used to select one or more Fisherman Classes. This is a multi-select standard lookup that is not required to return results. It defaults as blank.
The lookup contains a list of all 'Active' Fisherman Classes. | ||||||||
| Hide Accounts where all balances are 0.00 | Used to select whether or not returned results will include fishermen, fishermen & tenders, tenders or loans that have a balance of 0.00. This is a Yes/No lookup that is required to return results. It defaults as "Yes". | ||||||||
| Saved Searches |
|
...
| 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. | ||||||||
| Column Filter Show/Hide |
| ||||||||
| Excel |
| ||||||||
| Favorites |
| ||||||||
| Group By Show/Hide |
| ||||||||
| Help |
| ||||||||
| Mass Update |
| ||||||||
| More Actions |
| ||||||||
| Process Payments | Opens Process Payments record view, where users can modify, print and post check and ACH payments. | ||||||||
| Quick Column Filter |
| ||||||||
| Refresh |
| ||||||||
| Saved Layouts |
| ||||||||
| Search Options |
| ||||||||
| Fields | Description | ||||||||
| Account |
Database Fields: ERPx_APVendor.VendorName, ERPx_APVendor.VendorID | ||||||||
| Account Class |
Database Fields: ERPx_APVendorClass.ClassDescription, ERPx_APVendor.VendorClassSK | ||||||||
| Account ID |
Database Field: ERPx_APVendor.VendorID | ||||||||
| Account Name |
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.
Database Field: ERPx_APVendor.VendorTypeEN | ||||||||
| Batch |
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.
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.
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 PO's | 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 | Displays a 'View' hyperlink that opens the Fisherman Statement Report to display balances for the selected Fisherman, Fisherman & Tender, Tender or Loan. |
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....