Versions Compared

Key

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

The purpose of this page is to create and update settlement batches for payments.

...

Toolbar IconsDescription
Append to Batch

Updates the grid section with new transactions that match the filter criteria. This toolbar 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 based on the criteria a user has selected / entered. This toolbar icon is only displayed when a new batch is being created and is replaced with "Append to Batch" after the initial batch is created. 

Delete
Insert excerpt
Delete - RV Header
Delete - RV Header
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Print Reports
Insert excerpt
Print - RV Header
Print - RV Header
nopaneltrue
Process PaymentsOpens Process Payments record view, where users can create, print and post check and ACH payments.
FieldsDescription
Batch ID

Insert excerpt
Batch ID
Batch ID
nopaneltrue
 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] + [Batch Number + 1]. This is a system assigned value and is never editable by a user. 

Database Field: ERPx_MFTransactionBatch.BatchID

Checkbook

Insert excerpt
Checkbook
Checkbook
nopaneltrue
This is a single-select standard lookup that allows users to select the checkbook used to pay for the vendors in the settlement batch. 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.

Insert excerpt
Def - Checkbook
Def - Checkbook
nopaneltrue

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

Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_MFTransactionBatch.CheckbookSK

Fisherman

Insert excerpt
Account name
Account name
nopaneltrue
This is a text box that allows users to lookup a specific vendor. This is not required to display transactions in the settlement batch, defaults as blank and is always editable.

Database Field: ERPx_MFTransactionBatch.VendorSKCSV

Fisherman Class

Insert excerpt
Fisherman (Account) Class
Fisherman (Account) Class
nopaneltrue
This is a multi-select load on demand lookup that allows users to lookup results by the specified Fisherman Class. This is not required to display transactions in the settlement batch, defaults as blank, and is always editable.

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 lookup contains the following values: All, Adjustment, Balance Transfer, Cash Receipt, Credit Memo, Fish Ticket, Fisherman Sale, Invoice, Payment, Tender Resale

Database Field: ERPx_MFTransactionBatch.IncludedTransactionTypeSKCSV

Search

This is a text box that allows users to lookup transactions for Transaction ID, Doc No, Ticket Number, Landing Number, and Delivery Number. This is defaulted as blank and is not required to display transactions in the settlement batch. This field is always editable.

Database Field: ERPx_MFTransactionBatch.Search

Season

Identifies the Season associated with the transaction. This is a text box that allows users to search by Season. It defaults as blank and is not required to display transactions in the settlement batch. This field is always editable.

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' filed on the Process Payments page. This field must be on or after the 'Trans Date Thru' field. Else, 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.

Database Field: ERPx_MFTransactionBatch.AsOfDate

...

Page Detail

Transactions Grid

The purpose of this grid is to display and manage transactions associated with the batch. Users may chose to edit the 'Hold Back Amt.' and 'Amount to Settle' fields for any payable transaction that credits the settlement accrual account. The default grid layout for the Transactions grid displays rows that are 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.

Toolbar IconsDescription
Edit Amounts

Clicking the Edit Amounts toolbar icon will open a dialog box with an Amount text box defaulted to the Open Amount of the selected transaction. User may enter the Amount and when Saved, the Amount will populate in the 'Amount to Settle' field and the 'Hold Back Amt.' field will be recalculated as [Hold Back 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.'. Else, 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

Excel
Insert excerpt
Excel - RV Grid
Excel - RV Grid
nopaneltrue
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

Insert excerpt
Mass Update - Global
Mass Update - Global
nopaneltrue

  • Hold Back Amount: A text box that defaults to blank. Takes the 'Hold Back Method' in conjunction with the 'Hold Back Amount' field and assigns the calculated amount to the 'Max Amount to Pay' field for the selected/filtered transactions when Apply is clicked.
  • 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 "Update all Transactions by a fixed amount", but also has an option for "Update all Transactions by a percentage". Takes the 'Hold Back Amount' in conjunction with the selected method and assigns the calculated amount to the 'Max Amount to Pay' 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.

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 button 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 negative (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 positive (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 on the 'Home' tab of the Invoice/Credit Memo record view. For Balance Transfer transaction types, this field comes from the 'Transfer Balance From - Debit' field on the Items grid of the Balance Transfer record view. This is only editable by changing the Tender, Vendor or Transfer Balance To fields on the associated transactions while in a Status of New.

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.FromVendorSK (Tender Resale), ERPx_APTransactionHeader.VendorSK (AP Invoice/Credit Memo), ERPx_APTransactionLine.FromDistributionAccountSK (Balance Transfer)

Doc Date

Insert excerpt
Doc Date
Doc Date
nopaneltrue
For Fish Tickets, this defaults from the 'Landed Date' field. For Adjustments, Balance Transfers and Tender Resales, this defaults from the 'Date' field. For AP Credit Memos/Invoices and Fisherman Sales, this defaults from the 'Doc Date' field. For check and ACH payments, this defaults from the 'Payment Date' field. This field is always editable while the transaction is in a Status of New.

Database Field: ERPx_APDeliveryTicketHeader.TicketDate (Fish Ticket), ERPx_APTransactionHeader.TransactionDate

Doc Description

Insert excerpt
Description - Header
Description - Header
nopaneltrue
This field comes from the header 'Description' field on the 'Home' tab of the associated transaction. This is always editable.

Database Field: ERPx_APTransactionHeader.Description

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
This field comes from the 'Doc No' field on the 'Home' tab of the associated transaction. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.DocNumber

Fisherman Name

Insert excerpt
Account Name
Account Name
nopaneltrue
For Adjustment transaction types, this field comes from the 'Distributed To' field in the Items grid of the Adjustment record view. For Balance Transfer transaction types, this field comes from the 'Transfer Balance To - Credit' field or 'Transfer Balance From - Debit' field on the Items grid of the Balance Transfer record view. For Cash Receipt transaction types, this field comes from the 'Received From' field in the header of the Cash Receipt record view. For AP Invoice/Credit Memo transaction types, this field comes from the 'Vendor' field on the 'Home' tab of the AP Invoice/Credit Memo record view. For Fish Ticket transaction types, this field comes from the 'Paid Account' field on the 'Home' tab of the Fish Ticket record view. For Fisherman Sale/Tender Resale transaction types, this field comes from the 'Fisherman' field on the 'Home' tab of the transaction record view. For Payment transaction types, this field comes from the 'Account' field in the header of the Process Payments page. This field is always editable while the transaction is in a Status of New.

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK (Cash Receipt, Fisherman Sale & Tender Resale), ERPx_APTransactionLine.ToDistributionAccountSK (Adjustment & Balance Transfer), ERPx_APTransactionHeader.VendorSK (AP Invoice & AP Credit Memo), ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK (Fish Ticket), ERPx_APSettlementTransaction.SettleToEntitySK (Payment)

Hold Back Amt.

Identifies the hold back amount to be paid for the payable document. This field comes from a fixed amount or percentage of the Original Transaction Amount that has been held back using the Mass Update button in the grid header. This field is also auto calculated as [Open Amt.] - [Amount to Settle] when the user clicks the 'Edit Amounts' button and enters an amount. For payable transactions that credit the Settlement Accrual Account, this field is always editable. For receivable transactions that debit the Settlement Accrual Account, this field displays "0.00" and is not editable. This value is not stored in the database.

(lightbulb) This field will always display as positive, regardless of the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference.

Hold Back Comment

Identifies the hold back comment for the transaction. This field comes from a combination of the values entered/selected on the 'Hold Back Amount', 'Hold Back Comment' and 'Hold Back Method' fields on the Mass Update dialog box. If no values are entered for the 'Hold Back Comment' field on the Mass Update dialog box, the 'Hold Back Comment' field on the Build Settlement Batch will be "Hold Back Amount: " + [Hold Back Amount] or "Hold Back Percent: " + [Hold Back Amount], depending on the user selection for the 'Hold Back Method' field. If a value is entered on the 'Hold Back Comment' field on the Mass Update dialog box, the 'Hold Back Comment' field on the Build Settlement Batch will be [Hold Back Comment] + "Amount/Percent: " + [Hold Back Amount]. This field is not required, but if entered, it must be <= 250 characters. For payable transactions that credit the Settlement Accrual Account, this field is always editable. For receivable transactions that debit the Settlement Accrual Account, this field is not editable. 

(lightbulb) This field is only populated when utilizing the Mass Update functionality from the grid header. When updating the 'Amount to Settle' field by clicking the Edit Amounts button, any existing value in the 'Hold Back Comment' field will be removed.

Database Field: ERPx_MFTransactionBatchTransaction.HoldBackComment

Line Description

Insert excerpt
Description - Item
Description - Item
nopaneltrue
This comes from the 'Description' field for a specific line on Tender Resale, AP Invoice/Credit Memo, Balance Transfer and Adjustment transaction types. This will be blank for Fish Ticket, Payment Receipt, Payment and Fisherman Sale transaction types. This field is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionLine.LineDescription

Open Amt.

Displays the amount due for payment on the transaction. This field is calculated by taking the Original Transaction Amount and subtracting any applications that have previously been made. Transactions that Debit the Settlement Accrual Account will be displayed in red font and be subtracted from the payment amount. This field is never editable.

(lightbulb) For transactions that Credit 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. For transactions that Debit 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.

Orig. Trans. Amt.

Insert excerpt
Amount - Original
Amount - Original
nopaneltrue
For AP Invoice/Credit Memo, Adjustment, Tender Resale and Balance Transfer transaction types, this comes from the 'Extended' amount of the individual line item. For Fish Ticket and Payment Receipt transaction types, this comes from the 'Amount' field. For Fisherman Sale transaction types, this comes from the 'On Account' field. For Check and ACH payment transaction types, this comes from the 'Amount' field for the specific check or ACH payment. This field is always editable by changing the Price or Quantity of line items while the transaction is in a Status of New.

(lightbulb) For transactions that Credit 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. For transactions that Debit 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.

Database Fields: ERPx_APTransactionLine.ExtendedAmount, ERPx_APTransactionheader.ExtendedAmount, ERPx_APDeliveryTicketHeader.TotalNetAmount

Payable (GL Credit)Displays whether or not the transaction is payable. The value will display as "Yes" if the transaction resulted in a Credit to the Settlement Accrual Account. The value will display as blank if the transaction resulted in a Debit to the Settlement Accrual Account. This field is not stored in the database and is never editable.
Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
Clicking on this link opens the transaction record view for the selected record. This is a system assigned number that comes from the 'Transaction Class' and is required but is never editable.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database Field: ERPx_APTransactionHeader.TransactionID, ERPx_APDeliveryTicketHeader.TicketNumber

Transaction Type

Insert excerpt
Transaction Type
Transaction Type
nopaneltrue
This comes from the Transaction Type selected when starting a new transaction. This is never editable.

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK, ERPx_APDeliveryTicketHeader.TransactionClassSK


...