Build Settlement Batch Record View 3.0

Build Settlement Batch Record View 3.0

The purpose of this page is to create and update Fisherman Settlement batches for payments. Users will be able to search and include transactions on the payment batch for one or more fishermen, fishermen & tenders, tenders and loans.

Software Version: 2025.04.21 and newer

Page Header

Header Toolbar

Toolbar Icons

Description

Toolbar Icons

Description

Delete

Help

Print

Process Payments

Opens Process Payments record view, where users can create, print and post check and ACH payments from the payment batch.

Save

Save & Close

d

Batch Properties Tab

Fields

Description

Batch ID

 This is a single-select standard lookup that allows users to navigate between active batches. The field defaults to (Build New Batch) when the Build Settlement Batch page is opened. Once the Build Batch button is clicked, this field defaults to the username, formatted as [User First Name] + [User Last Name] + [Previous Batch Number + 1]. This is a system assigned value and is never editable by a user. 

Database Field: ERPx_MFTransactionBatch.BatchID

Checkbook

This is a single-select standard lookup that allows users to select the checkbook that will be used to make the payments. This is required and defaults to the Fisherman Accounting Settlement Default preference 'Default Fisherman Checkbook ID'. This is editable prior to clicking the Build Batch button.

The lookup contains a list of all the 'Active' Checkbooks where the Currency is USD.

Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK

Settlement Comment

Identifies the comment associated with the settlement batch. This is a text box that defaults as blank. It is not required, but if entered, it must be <= 250 characters. This field is always editable.

Database Field: ERPx_MFTransactionBatch.BatchComment

Settlement Date

Identifies the date the settlement will be applied. This is a date picker that defaults to the current date. It is required and if missing, will default to current date on Save. This date will automatically populate the 'Payment Date' field on the Process Payments page. This field must be on or after the 'Trans Date Thru' field. If not, the message "Trans Date Thru must be on or before the Settlement Date" will be displayed. This field is editable prior to clicking the Build Batch button.

Database Field: ERPx_MFTransactionBatch.BatchDate

Transaction Types

Identifies the types of transactions to be included in the settlement batch. This is a multi-select lookup that allows users to lookup transactions by the specified transaction types. This is defaulted as 'All' and required to display transactions in the settlement batch. This field is always editable. The transactions selected for the batch are filtered based on this. 

The lookup contains the following values: Adjustment, Balance Transfer, Credit Memo, Fish Ticket, Fisherman Sale, Invoice, Payment, Payment Receipt and Tender Resale.

Database Field: ERPx_MFTransactionBatch.IncludedTransactionTypeSKCSV

View

A single select lookup that allows users to choose how to see the included transactions on a batch.  This is required and defaults to "Included & Available Transactions".  

When the option is set to "Included & Available Transactions", the data in the grid will display any transactions that have been added to the settlement batch with an Amount to Settle as well as any transactions that are pending settlement.  Note: When a saved batch is first loaded, only the included transactions (or a blank grid if there are none) will be displayed, to see the Available transactions with this View option selected, click the Refresh / Save button. 

When the option is set to "Only Included Transactions", the data in the grid will just display the transactions that have been added to the settlement batch with an Amount to Settle.  If you would like to add more transactions to the batch you can change the View option to "Included & Available Transactions" and click the Refresh / Save button. 

This lookup contains all the values in the FAViewTransactions Enumeration Class.

Database Field: ERPx_MFTransactionBatch.ViewTransactionsEN

Filters Tab

Fields

Description

Fisherman

This is a text box that allows users to enter all or part of a Fisherman, Tender, or Loan account. This is not required to select transactions in the settlement batch, defaults as blank and is always editable. The transactions selected for the batch are filtered based on this. 

Database Field: ERPx_MFTransactionBatch.VendorSKCSV

Fisherman Class

This is a multi-select load on demand lookup that allows users to select one or more Fisherman Classes. This is not required to select transactions in the settlement batch, defaults as blank, and is always editable. The transactions selected for the batch are filtered based on this. 

The lookup contains a list of all the 'Active' Fisherman Classes.

Database Field: ERPx_MFTransactionBatch.VendorClassCSV

Search

This is a text box to enter all or part of a Transaction ID, Doc No, Ticket Number, Landing Number, or Delivery Number. This is defaulted as blank and is not required to display transactions in the settlement batch. This field is always editable. The transactions selected for the batch are filtered based on this. 

Database Field: ERPx_MFTransactionBatch.Search

Season

Identifies the Season associated with the transaction. This is a text box that allows users to limit the Fish Ticket Transactions by Season. It defaults as blank and is not required to display transactions in the settlement batch. This field is always editable. The Fish Tickets selected for the batch are filtered based on this. 

Database Field: ERPx_MFTransactionBatch.SeasonSearch

Trans Date Thru

Identifies the transaction date to use to filter transactions. This is a date picker that allows users to search for a transaction based on the GL Date of the transaction. This field must be on or before the 'Settlement Date' field. Else, the message "Trans Date Thru must be on or before the Settlement Date" will be displayed. This field defaults as blank and is not required to display transactions in the settlement batch. The transactions selected for the batch are filtered based on this. 

Database Field: ERPx_MFTransactionBatch.AsOfDate

Page Detail