Versions Compared

Old Version 45

changes.mady.by.user Emma Greenwood

Saved on

compared with

New Version 46

changes.mady.by.user Emma Greenwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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: 20202021.1006.05 04 and newer

Table of Contents
typeflat

Page Header

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.

Insert excerpt
Def - Fisherman Class
Def - Fisherman Class
nopaneltrue

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
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue


Page Detail

  • 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.
    Toolbar IconsDescription
    Apply DocumentsOpens 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 BatchOpens Build Settlement Batch record view, where users can create new Fisherman Settlement batches.
    Column Filter Show/Hide
    Insert excerpt
    Column Filter Show/Hide - Global
    Column Filter Show/Hide - Global
    nopaneltrue
    Excel
    Insert excerpt
    Excel - LV
    Excel - LV
    nopaneltrue
    Favorites
    Insert excerpt
    Favorites Add/Remove - Global
    Favorites Add/Remove - Global
    nopaneltrue
    Grid LayoutGroup By Show/Hide
    Insert excerpt
    Grid Layout
    Group By Show/Hide - Global
    Grid Layout
    Group By Show/Hide - Global
    nopaneltrue
    Help
    Insert excerpt
    Help - Global
    Help - Global
    nopaneltrue
    		Inquiry Criteria
    Insert excerpt
    Inquiry Criteria - GlobalInquiry Criteria - Global
    nopaneltrue
    Mass Update

    Insert excerpt
    Mass Update - Global
    Mass Update - Global
    nopaneltrue

    • 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.

    (lightbulb) 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

    Insert excerpt
    More Actions - Global 3.0
    More Actions

    Allows users to select between "Process Interest Charges" or "Process Interest Payments" and opens the associated page

    - Global 3.0
    nopaneltrue

    • IQ: Activity - Opens the Fisherman & Loan Activity Inquiry in a separate tab to display all transactions that affect Fisherman Balances associated with with the selected Fisherman, Fisherman & Tender, Tender or Loan. By default, all transactions that are New, Approved, Ready to Post, Posted, and Void will be displayed and will include Beginning Balances.
    • IQ: Fisherman Balance Details - Opens the Fisherman Balance Detail Inquiry in a separate tab to display the most current versions of transactions that affect Fisherman Balances associated with the selected Fisherman, Fisherman & Tender, Tender or Loan.
    • RV: Fisherman Account - Opens the Fishermen & Tenders Record View to display Account information for the selected Fisherman, Fisherman & Tender, Tender or Loan.
    • RV: Master Account - Opens the Fishermen & Tenders Record View to display Account information for the Master Account associated with the selected Fisherman, Fisherman & Tender, Tender or Loan.
    • Process Interest Charges - Opens the Process Interest Charges Record View to calculate/process interest charges on Fisherman loan balances.
    • Process Interest Payments - Opens the Process Interest Payments Record View to calculate/process interest payments on Fisherman accounts that have a credit balance.
    Process PaymentsOpens Process Payments record view, where users can modify, print and post check and ACH payments. Quick Column Filter
    Insert excerpt
    Quick Filter
    Quick Filter
    nopaneltrue
    Refresh
    Insert excerpt
    Refresh - Global
    Refresh - Global
    nopaneltrue
    Saved Layouts
    Insert excerpt
    Column Layouts for Framework 3.0 - Global
    Column Layouts for Framework 3.0 - Global
    nopaneltrue
    Search Options
    Insert excerpt
    Search Options - Inquiry Grid 3.0
    Search Options - Inquiry Grid 3.0
    nopaneltrue
    FieldsDescriptionAccount

    Insert excerpt
    Account Name
    Account Name
    nopaneltrue
    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

    Insert excerpt
    Fisherman (Account) Class
    Fisherman (Account) Class
    nopaneltrue
    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

    Insert excerpt
    Account ID
    Account ID
    nopaneltrue
    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

    Insert excerpt
    Account Name
    Account Name
    nopaneltrue
    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.

    Insert excerpt
    Def - Vendor Type
    Def - Vendor Type
    nopaneltrue

    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

    Insert excerpt
    Batch ID
    Batch ID
    nopaneltrue
    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.

    Insert excerpt
    Def - GL Account - Settlement Accural
    Def - GL Account - Settlement Accural
    nopaneltrue

    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.

    Insert excerpt
    Def - Master Account - Fisherman
    Def - Master Account - Fisherman
    nopaneltrue

    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 POsPO'sDisplays 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 TransactionsDisplays 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 BalanceDisplays 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.StatementA

    Displays a 'View' hyperlink that

    when clicked

    opens the Fisherman Statement

    report for the associated Account

    Report to display balances for the selected Fisherman, Fisherman & Tender, Tender or Loan.

    Related Topics



    Expand
    titlePage Definitions

    Page Definitions


    ...