/
Build Settlement Batch Record View

Build Settlement Batch Record View

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: 2020.05.22 and newer

Page Header

Toolbar IconsDescription
Append to Batch

Updates the grid section with new transactions that match the filter criteria. This icon is only displayed after the initial batch is created to allow users to redefine search criteria and add additional transactions to the batch. 

Note: Append to Batch only adds new transactions to the batch, but does not remove previously added transactions from the batch.

Build Batch

Builds a batch (selects open transactions) based on the criteria a user has selected / entered. This icon is only displayed when a new batch is being created, it is replaced with "Append to Batch" after the initial batch is created. 

DeleteDeletes the transaction or master file record. When clicked, users will be prompted with: "Are you sure you want to delete this record?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted!

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.

Print ReportsOpens the Print dialog, showing any applicable printable reports to be printed, downloaded, and/or emailed. 
Process PaymentsOpens Process Payments record view, where users can create, print and post check and ACH payments from the payment batch.
FieldsDescription
Batch ID

Displays the name of the batch. 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

Identifies the Checkbook assigned to the transaction.  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.

Checkbooks represent individual bank accounts (checking, savings, petty cash) that have funds deposited into, or payments made out of, that are reconciled to a bank statement. They are used in the Financial, Fisherman Accounting, Grower Accounting, Purchasing, and Sales Functional Areas to support receiving payments from customers, making payments, deposits, and other bank transactions.

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

Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK

Fisherman

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

Identifies the description of the Fisherman Class associated with the transaction.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

Included Transactions

Identifies the types of transactions to be included in the settlement batch. This is a multi-select load on demand lookup that allows users to lookup transactions by the specified transaction types. This is defaulted as blank and required to display transactions in the settlement batch. If missing, the message "Include Transactions is required." will be displayed when the Build Batch button is clicked. This field is always editable. The transactions selected for the batch are filtered based on this. 

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

Database Field: ERPx_MFTransactionBatch.IncludedTransactionTypeSKCSV

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

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: EERPx_MFTransactionBatch.BatchDate

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

d

Page Detail

Transactions Grid

The purpose of this grid is to display and manage the individual transactions associated with the settlement batch. Transactions that Credit the Settlement Accrual Account will be displayed as positive and in black font. Transactions that Debit the Settlement Accrual Account will be displayed as negative and in red font as they are will be subtracted from the payment amount. Users can edit the 'Hold Back Amt.' and 'Amount to Settle' fields for any Credit balance transaction (transaction that Credits the Settlement Accrual Account). The default grid layout for this grid is grouped by Fisherman Name. The group heading displays as "Fisherman Name: [VendorName] + ([VendorID]) + PO Amount: [POAmount]". The PO Amount comes from the 'Open PO's' field on the Fisherman Balance list view and if 0.00, then will not be appended to the Fisherman Name.

Toolbar IconsDescription
Edit Amounts

Clicking the Edit Amounts toolbar icon opens a dialog box that allows users to edit the amount to settle. It defaults to the Open Amount of the selected transaction. Users may enter the Amount and when Saved, the Amount will populate in the 'Amount to Settle' field. If the transaction that was edited is a payable transaction then the 'Hold Back Amt.' field will be recalculated as [Open Amt.] - [Amount to Settle] on the Build Settlement Batch page.

The 'Amount' field entered in the dialog box cannot be greater than the 'Open Amt.' field. If so, the message "The Amount cannot be greater than is left on the transaction." will be displayed on Save & Close. Additionally, if the 'Hold Back Comment' field was previously populated, the 'Hold Back Comment' field will be cleared if the user edits the 'Amount' field.

Note: The Edit Amounts toolbar icon will only open a dialog box when a single transaction is selected.  

Database Field: ERPx_MFTransactionBatchTransaction.AmountToConsume

ExcelExports the contents of the grid 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. 
Included Transactions

This button displays the following options: “Include Filtered” and “Include Selected”. This allows users to add previously removed transactions back to the batch by selecting/filtering the transactions in the grid and clicking “Include Transactions” and choosing either “Include Filtered” or Include Selected”.

Note: Removed transactions are displayed in blue font.

Mass Update

Opens the mass update dialog, which allows to mass update the following properties: 

  • Hold Back Comment: A text box that defaults to blank. Assigns the text to the selected/filtered transactions when Apply is clicked.
  • Hold Back Method: A single-select lookup that defaults to "Hold back all Transactions by a fixed Amount", but also has an option for "Hold back all Transactions by a fixed Percent". Takes the 'Hold Back Percent / Amount' value in conjunction with the selected method and assigns the calculated amount to the 'Hold Back Amt.' field and the 'Amount to Settle' field for the selected/filtered transactions when Apply is clicked.
  • Hold Back Percent / Amount: A text box that defaults to blank. Takes the 'Hold Back Method' selection in conjunction with the value entered and assigns the calculated amount to the 'Hold Back Amt.' field and the 'Amount to Settle' field for the selected/filtered transactions when Apply is clicked.

(lightbulb) Hold Back Amounts and Hold Back Comments will only apply to transactions where the 'Payable (GL Credit)" value is "Yes".

Remove Transactions

This button displays the following options: “Remove Filtered” and “Remove Selected”. If filter criteria have been entered in the grid, and “Remove Filtered” is clicked, the filtered transactions will be removed from the settlement batch. If the check box next to the transaction is checked and the “Remove Selected” is clicked, those transactions checked will be removed from the settlement batch. If there was value in the 'Hold Back Comment' field, it will be cleared when the transaction is removed from the settlement batch.

Note: Removed transactions are displayed in blue font.

FieldsDescription
Amount to Settle

Identifies the maximum amount to be paid for the document. This field is calculated as [Open Amount] - [Hold Back Amt.]. This field can be changed by clicking the 'Edit Amounts' icon in the grid header and entering a amount in the 'Amount' field or by entering a value in the 'Hold Back Amount' field on the Mass Update dialog box. This field is always editable.

(lightbulb) For transactions that Credit the Settlement Accrual Account, this field will display as positive (for example $100.00) regardless of the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference. For transactions that Debit the Settlement Accrual Account, this field will display as negative (for example -$100.00) regardless of the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference.

Database Field: ERPx_MFTransactionBatchTransaction.AmountToConsume

Distributed Description

Identifies a description of the distribution, including the name of the Vendor, Fisherman, Fisherman & Tender, Tender or Loan. This is displayed for Tender Resale, AP Invoice/Credit Memo and Balance Transfer transaction types and not displayed for all other transaction types. For Tender Resale transaction types, this field comes from the 'Tender' field on the 'Home' tab of the Tender Resale record view. For AP Invoice/Credit Memo transaction types, this field comes from the 'Vendor' field