Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 23 Next »

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: YYYY.MM.DD and newer

Page Header

Toolbar IconsDescription
Apply DocumentsOpens Apply Documents list view, which displays unapplied payment transactions for users to apply payment transactions towards payable documents. If users  select one Fisherman, Fisherman & Tender, Tender or Loan prior to clicking the Apply Documents button, the results will be filtered on the selected Fisherman, Fisherman & Tender, Tender or Loan. Else, all results will be displayed.
Build Settlement BatchOpens Build Settlement Batch page, where users can create new payment batches.
ExcelExport 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. 

(lightbulb) Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.

Grid LayoutOpens 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).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) 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 any vendors 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: 

  • 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 'They Owe Transaction Type (GL Debit)' field to transaction types selected in the 'We Owe Transaction Type (GL Credit)' field to all filtered/selected fishermen. 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 "Adjustment", "Balance Transfer", "Cash Receipt", "Credit Memo", "Fish Ticket", "Fisherman Sale", "Invoice" and "Tender Resale". The transaction types selected in the 'Incl. Payable Transactions (Balance Sheet Debit)' field will be applied to selected transaction types, given "Yes" is selected for the 'Do you want to FIFO Apply Transactions' field.
  • Incl. Payable Transactions (Balance Sheet Debit): A multi-select lookup that defaults to blank, but also has options for "Adjustment", "Balance Transfer", "Credit Memo", "Fish Ticket", "Fisherman Sale", "Invoice", "Payment" and "Tender Resale". The selected transaction types will be applied to transaction types selected in the 'Incl. Payable Transactions (Balance Sheet Credit)'' field, given "Yes" is selected for the 'Do you want to FIFO Apply Transactions' field.

(lightbulb) The FIFO process takes the earliest transaction dates, then the transaction type into account when applying documents.

More ActionsAllows users to select between "Process Interest Charges" or "Process Interest Payments" and opens the associated page.
Process PaymentsOpens Process Payments page, where users can modify, print and post check and ACH payments.
RefreshRe-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. 
FieldsDescription
Account

Identifies the name of the Fisherman, Fisherman & Tender, Tender or Loan. 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. 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. 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.

Database Field: ERPx_APVendor.VendorTypeEN

ActivityDisplays a hyperlink that will open the Fisherman & Loan Activity Inquiry for the associated Account. By default, all transactions that are New, Approved, Ready to Post, Posted, Voided and Replaced 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 Account' 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. 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 Vendors 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 POsDisplays 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 amount from any transactions saved in a status less than '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, Cash 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. This is a text box that defaults to '0.00'. Entering a value in this field and clicking Process Payments will create a new Quick Payment batch.

Database Fields: ERPx_MFCheckbookTransaction.Amount, ERPx_MFTransactionBatch.TransactionBatchSK

Posted BalanceDisplays the total balance from any sales transactions saved in a status of 'Ready to Post' or 'Posted'.  The following transactions are included in this total: Adjustment, Balance Transfer, Cash 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.
StatementThis field displays a hyperlink that will open the Fisherman Statement report for the associated Account.

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details

  • No labels