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: YYYY2020.MM05.DD 22 and newer
| Table of Contents | ||
|---|---|---|
|
...
| 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 |
| ||||||||
| Favorites |
| ||||||||
| Grid Layout |
| ||||||||
| Help |
| ||||||||
| Inquiry Criteria |
| ||||||||
| Mass Update |
| ||||||||
| 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 |
| ||||||||
| 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 | ||||||||
| 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 |
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 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. |
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....