/
Apply Fishing Transactions Record View 3.0

Apply Fishing Transactions Record View 3.0

Apr 24, 2025

The purpose of this page is to view and apply Fishing Transactions (Debit balance transactions to Credit balance transactions). This page displays the selected transaction from the Unapplied Fishing Documents list view or the Payment Receipt record view in the header and a grid containing all the Credit balances transaction with an Unapplied Amount.

Software Version: 2025.04.21 and newer

[ 1 Page Header ] [ 2 Page Detail ] [ 2.1 Transactions Grid ] [ 2.1.1.1 Toolbar Icons ] [ 2.1.2 Related Topics ] [ 2.1.2.1 Page Definitions ] [ 2.1.2.2 Technical Details ]

Page Header

Toolbar Icons

Description

Help

Save

Save & Close

Fields

Description

Account

This is a single-select standard lookup that defaults from fisherman, fisherman & tender, tender or loan associated with the selected document. This field is required to Save. If this page was launched from the Unapplied Fishing Documents list view, then this field is always enabled. Changing the Account will automatically refresh the page to display posted transactions with an Unapplied Amount > 0.00 for the selected Account. If this page was launched from the Payment Receipt record view, then this field is always disabled.

If this page was launched from the Unapplied Fishing Documents list view, then the lookup contains the current assigned value and a list of all the 'Active' Fishermen, Fishermen & Tenders, and Tenders and Loans who have one or more unapplied transactions.

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK, ERPx_APTransactionLine.AccountSK, ERPx_APTransactionLine.FromDistributionAccountSK, ERPx_APTransactionLine.ToDistributionAccountSK

Open Amount

Displays the original amount of the transaction or the transaction line. This is a non-editable text box that defaults from the 'Original Amount' field on the Unapplied Fishing Documents list view for the selected transaction. This field is required and is never editable by the user. This is a calculated field and not stored in the database.

 This field will always display as positive, 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.TotalAmount

Transaction

This is a single-select standard lookup that is required to Save. This is defaulted from the 'Transaction' field on the Unapplied Fishing Documents list view for the selected transaction. If this page was launched from the Unapplied Fishing Documents list view, then this field is always enabled. Changing the Transaction will automatically refresh the page to display documents that are available to be applied. If this page was launched from the Payment Receipt record view, then this field is always disabled. This is a system assigned number that comes from the 'Transaction Class'. Types of transactions include: Adjustments, Balance Transfers, AP Credit Memos, Fish Tickets, Fisherman Sales, AP Invoices, Payments and Tender Resales.

If this page was launched from the Unapplied Fishing Documents list view, then the lookup contains the current assigned value and a list of all the transactions for the selected 'Account' that have an Unapplied Amount > 0.00. Please note that for transactions where each line separately debits the settlement accrual account, duplicate transactions for each line item will be listed in the lookup, as the 'Open Amount' field will be unique. Additionally, once a transaction has been fully applied and saved, it will no longer display in the lookup once the page is refreshed.

Database Field: ERPx_APTransactionHeader.TransactionID

Unapplied

This is a non-editable text box that defaults from the 'Unapplied Amount' field for the selected transaction. This is calculated by subtracting any previous applications from the original amount. This field is required to Save and is never editable by the user. This value is not stored in the database.

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

Page Detail

Transactions Grid

The purpose of this grid is to display all payable documents that have either been applied to the selected transaction or have an available Unapplied Amount. All transactions in this grid credited the Settlement Accrual Account and include: Adjustment Lines with a negative extended amount, Balance Transfer lines for the Account selected as the 'Transfer Balance To - Credit' field, AP Credit Memo Lines with a positive extended amount, Fish Tickets with a positive amount, Fisherman Sales with a negative extended amount, AP Invoice Lines with a negative extended amount, Payment Receipts, Tender Resales with a negative extended amount, and Tender Resale Transfers with a positive extended amount.

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Group By Show/Hide

Quick Column Filter

Saved Layouts

Fields

Description

Checkbox

Used to select one or more documents to apply to a transaction. Checking the checkbox will automatically populate the Applied Amount field with the Unapplied Amount of the payable document or the Unapplied Amount of the selected payment transaction in the header section, whichever is the lesser amount.

Applied Amount

This is a text box that defaults to blank. The amount entered cannot be greater than the 'Unapplied Amount' field or the Open Amount of the selected payment transaction in the header section. Else, the message "You cannot apply more than the amount that is remaining." will be displayed when the user clicks out of the field. This field is always editable.

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

Database Field: ERPx_APSettlementTransaction.AppliedAmount

Apply Date

 This is a text box that defaults to the current date and is required to Save an application. The date entered must be within an open fiscal period. Else, the message "This Fiscal Period is not open." will be displayed on Save. The date must be on or before the Doc Date of both the payable transaction and the payment transaction. Else, the message "Application for [TransactionID] must be on or after [Greater of the two GLDates]" will be displayed on Save. This field is always editable.

Database Field: ERPx_APSettlementApplication.ApplicationDate

Distributed Description

This is a non-editable text box that is required for Tender Resale, AP Invoice/Credit Memo and Balance Transfer transaction types and not required for Adjustment, Payment Receipt, Fish Ticket and Fisherman Sale transaction types. For Tender Resale transaction types, this field defaults from the 'Tender' field on the Tender Resale record view. For Invoice/Credit Memo transaction types, this field defaults from the 'Vendor' field on the AP Invoice/Credit Memo record view. For Balance Transfer transaction types, this field defaults from the 'Transfer Balance From - Debit' field on the Balance Transfer record view.

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

Doc Date

This is a non-editable text box that is required. 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.

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

Doc Description

This is a non-editable text box that is not required. This field defaults from the header 'Description' field on the associated payable document.

Database Field: ERPx_APTransactionHeader.Description

Doc No

This is a non-editable text box that is not required. This defaults from the 'Doc No' field on the associated payable transaction. 

Database Field: ERPx_APTransactionHeader.DocNumber

GL Date

This is a non-editable text box that is required. This defaults from the 'GL Date' on the 'Properties' tab of the associated payable document.

Database Field: ERPx_APTransactionHeader.GLDate, ERPx_APDeliveryTicketHeader.GLDate

GL Period

This is a non-editable text box that is required. It is calculated using the 'GL Date' on the 'Properties' tab of the associated payable document.

GL Year

This is a non-editable text box that is required. It is calculated using the 'GL Date' on the 'Properties' tab of the associated payable document.

Line Description

This is a non-editable text box that is required for Tender Resale, AP Invoice/Credit Memo, Balance Transfer and Adjustment transaction types. It is not required for Fish Ticket, Payment Receipt and Fisherman Sale transaction types. This defaults from the 'Description' field for a specific line on the associated payable document.

Database Field: ERPx_APTransactionLine.LineDescription

Original Amount

This is a non-editable text box that is required. For AP Invoice/Credit Memo, Adjustment, Tender Resale and Balance Transfer transaction types, this displays the 'Extended' amount of the individual line item. For Fish Ticket transaction types, this displays the 'Amount' field. For Fisherman Sale transaction types, this displays the 'On Account' field. For Check and ACH payment transaction types, this displays the 'Amount' field for the specific check or ACH payment. This is required and can be edited by changing the Price or Quantity of line items. This can only be edited while in a Status of New.

 This field will always display in the native sign. For Fisherman Sale, Tender Resale, AP Invoice and Adjustment transaction types, the amount will be displayed as negative. For Balance Transfers, Payment Receipts, AP Credit Memos and Fish Tickets, the amount will be displayed as positive.

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

Remaining Amount

Displays the remaining amount of the transaction. This is a non-editable text box that is required. This is a calculated field that defaults to [Original Amount] - [sum of all applied amounts not including the current applied amount] and is not stored in the database. This value remains unchanged when an Applied Amount is saved for the application, but can change when the document has been applied to another transaction.

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

Transaction

This is a non-editable text box that is required. This is a system assigned number that comes from the 'Transaction Class' and is required but is not editable by users.

Database Fields: ERPx_APTransactionHeader.TransactionID, ERPx_APDeliveryTicketHeader.TicketNumber

Transaction Type

This is required and defaults from the Transaction Type selected when starting a new transaction. This is never editable. The following transaction types have the ability to credit the Settlement Accrual Account and display on this page:

  • Adjustment with a negative line where the Account is selected for the 'Distributed To' field

  • Balance Transfer lines for the Account selected as the 'Transfer Balance To - Credit' field

  • AP Credit Memo with a positive line where the Account is selected in the 'Distributed To' field

  • Fish Tickets with a positive amount

  • Fisherman Sales with a negative extended amount

  • AP Invoice with a negative line where the Account is selected in the 'Distributed To' field

  • Payment Receipts

  • Tender Resale with a negative line

  • Tender Resale Transfer (for a Fisherman & Tender or Tender) with a positive line

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

Unapplied Amount

This is a non-editable text box that is required. This is a calculated field that defaults to [Remaining Amount] - [Applied Amount] and is not stored in the database. The field auto-updates when values are entered to the 'Applied Amount' field.

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