/
Unapplied Fishing Documents List View 3.0

Unapplied Fishing Documents List View 3.0

Apr 24, 2025

The purpose of this page is to display all outstanding Debit balance transactions that have not been fully applied. From here, users can select a single transaction and click the 'Apply Document' icon in the header toolbar to manually apply the selected transaction to one or more Credit balance transactions. 

Software Version: 2025.04.21 and newer

[ 1 Page Header ] [ 1.1 Search ] [ 2 Page Detail ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Search

Search Options

Description

Search Options

Description

Auto Hide Filters

Auto Refresh on Open 

Fisherman

A multi-select lookup that defaults to the Account(s) that was selected prior to clicking the Apply Documents button on the Fisherman Balances list view. If no Account was selected, all the accounts that were visible in the grid will default in the lookup. 

Hide fully applied transactions

A Yes/No lookup that defaults to "Yes". If set to Yes then fully applied transactions will not be visible. 

Include transactions through

A Date picker to select a date that determines which transactions to include in the grid. It defaults to the current date but can be changed at any time. 

Saved Searches

Page Detail

Toolbar Icons

Description

Toolbar Icons

Description

Apply Document

Opens the Apply Fishing Transactions Record View. Users must select a transaction prior clicking this toolbar icon. Only one transaction can be selected at a time.

Column Filter Show/Hide

Excel

Group By Show/Hide

Help

Quick Column Filter

Refresh

Saved Layouts

Search Options

Fields

Description

Checkbox

Used to select one transaction to apply a document to.

Account

This is required and comes from the 'Fisherman ID' or 'Loan ID' field on the Fishermen & Tenders record view or Loan record view. This is only editable by changing the Fisherman, Fisherman & Tender, Tender, or Loan assigned to the transaction.

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK, ERPx_APTransactionLine.AccountSK, ERPx_APTransactionLine.FromDistributionAccountSK, ERPx_APTransactionLine.ToDistributionAccountSK, ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK

Account Class

This is required and comes from the 'Fisherman Class ID' field on the Fishermen & Tenders record view. This is only editable by changing the Fisherman, Fisherman & Tender or Tender assigned to the transaction.

Database Fields: ERPx_APVendor.VendorClassSK, ERPx_APTransactionHeader.VendorSK, ERPx_APTransactionLine.AccountSK, ERPx_APTransactionLine.FromDistributionAccountSK, ERPx_APTransactionLine.ToDistributionAccountSK , ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK

Account Name

This is required and comes from the 'Fisherman Name' or 'Loan Name' field on the Fishermen & Tenders record view or Loan record view. This is only editable by changing the Fisherman, Fisherman & Tender, Tender or Loan assigned to the transaction.

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

Distributed Description

This is required for Tender Resale, AP Invoice/Credit Memo and Balance Transfer transaction types and not required for all other transaction types. For Tender Resale transaction types, this field can be edited from the 'Tender' field on the Tender Resale record view. For AP Invoice/Credit Memo transaction types, this field can be edited from the 'Vendor' field on the Invoice/Credit Memo record view. For Balance Transfer transaction types, this field can be edited from the 'Transfer Balance To - Credit' field on the Balance Transfer record view. This is only editable by changing the 'Tender', 'Vendor' or 'Transfer Balance To - Credit' fields on the associated transactions.

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

Doc Date

This is required and can be edited from the 'Date' field on the in the associated transaction header. This is always editable while the transaction is in a Status of New.

Database Fields: ERPx_APTransactionHeader.TransactionDate, ERPx_APDeliveryTicketHeader.TicketDate

Doc Description

This is not required and can be edited from the 'Description' field on the associated transaction header. This is always editable.

Database Field: ERPx_APTransactionHeader.Description

Doc No

This is not required and can be edited from the 'Doc No' field on the in the associated transaction header. This is always editable while the transaction is in a Status of New. Depending on the transaction type, this is sometimes editable after the transaction has been posted.

Database Field: ERPx_APTransactionHeader.DocNumber

GL Date

This is required and can be edited from the 'GL Date' on the 'Properties' tab of the associated transaction. If not manually edited, this will be automatically set to match the 'Doc Date' when the transaction is saved with a Status of either Approved or Ready to Post. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.GLDate

GL Period

This is required and calculated using the 'GL Date' on the 'Properties' tab of the associated transaction. This can only be edited by changing the GL Date.

GL Year

This is required and calculated using the 'GL Date' on the 'Properties' tab of the associated transaction. This can only be edited by changing the GL Date.

Line Description

This is required for Adjustments, AP Invoices/Credit Memos, Tender Resales and Balance Transfers. This can be edited from the 'Description' on the Item grid of the associated transaction. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionLine.LineDescription

Original Amount

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 display as positive (for example $100.00) when the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference is set to "Negative". This field will display as negative (for example ($100.00)) when the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference is set to "Positive".

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

Transaction

Clicking on this link opens the record view for the selected transaction. 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 comes from the Transaction Type selected when starting a new transaction. This is never editable. The following transaction types have the ability to debit the Settlement Accrual Account and display on this page:

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

  • Balance Transfer lines for the Account selected as the 'Transfer Balance From - Debit' field

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

  • Fish Ticket with a negative amount

  • Fisherman Sale with a positive line

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

  • Payment Check or ACH

  • Tender Resale with a positive line

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

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

Unapplied Amount

This is required and updates when amounts are entered in the 'Applied Amount' field on the Apply Fishing Transactions record view. This is calculated by subtracting previous applications from the original amount. This value is not stored in the database.

 This field will display as positive (for example $100.00) when the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference is set to "Negative". This field will display as negative (for example ($100.00)) when the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference is set to "Positive".