Fisherman Balance Details

Fisherman Balance Details

 

This inquiry only shows the current version of a transaction. Users may utilize search options to filter the results.

Software Version: 2026.02.26 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

Account Class

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

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

Account Name

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

The lookup contains a list of all Fishermen, Tenders, Fishermen & Tenders, and Loans.

Account Type

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

This lookup contains the values in the APVendorType Enumeration Class where Enumeration Value is 2, 3, 4, or 5.

Saved Searches

Search

  • Account ID 

  • Account Name

  • Transaction ID

Page Detail

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

More Actions

  • RV: Fisherman/Loan Account: Opens the Account Record View. 

  • RV Journal: Opens the Journal Entry Record View for the selected transaction. This only applies to Posted transactions. 

  • RV Transaction: Opens the transaction record view for the selected transaction.

Quick Column Filter

Refresh

Saved Layouts

Search Options

Fields

Description

Account ID

Database Fields: ERPx_APVendor.VendorID

Account Class

This field is not editable. 

Database Field: ERPx_APVendor.VendorClassSK

Account Name

 

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK (Payment 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), ERPx_APPoHeader.VendorSK (Purchase Order)

Account Type

Identifies the type of account the transaction is associated with. This comes from the 'Vendor Type' field on the 'Properties' tab of the Vendor Class Record View. This field is only editable when the 'Vendor Class' is updated for the associated Account.

Database Field: ERPx_APVendor.VendorTypeEN

Date

 

Database Field: ERPx_APTransactionHeader.TransactionDate or ERPx_APDeliveryTicketHeader.TicketDate or ERPx_APPoHeader.PODate

Description

This field can be edited from the header 'Description' field on the 'Home' tab or header of the associated transaction. For Payment transactions, this can be edited from the 'Description' field in the grid of the Process Payments Record View. This is always editable while the transaction is in a Status of "New".

Database Field: ERPx_APTransactionHeader.Description or ERPx_APPoHeader.Description

Doc No

This field can be edited from the 'Doc No' field on the 'Home' tab or header of the associated transaction if the transaction contains the field. For Payment Receipt transactions, this field can be edited from the 'Payment #' field on the Payment Receipt Record View. This is always editable while the transaction is in a Status of "New".

Database Field: ERPx_APTransactionHeader.DocNumber

Net Balance

Displays the total net balance of the transaction. This is calculated as [Posted Balance]+[Open Transactions]-[Open POs]. Negative net balances will appear within parentheses. This field is not editable.

Database Fields: ERPx_APTransactionHeader.ExtendedAmount or ERPx_APDeliveryTicketHeaderTotalNetAmount

Open PO's

Displays the total amount distributed to the Account on a Purchase Order transaction in a Status of "Open". This is a calculated field and is editable by changing the 'Quantity' and/or 'Price' fields for a line item on the Purchase Order Record View while the transaction is in a Status of "New".

Database Field: ERPx_APPoHeader.OrderedAmount

Open Transactions

Displays the total balance of the transaction if the status is "New" or "Approved". Please note that Open Amounts for tickets will display the total amount for the ticket and may not accurately reflect the total amount that will affect the account on posting. Negative balances will appear within parentheses. This is a calculated field and is not editable.

Database Fields: ERPx_APTransactionHeader.ExtendedAmount or ERPx_APDeliveryTicketHeaderTotalNetAmount

Posted Balance

Displays the total balance of the transaction if the status is "Ready to Post" or "Posted". Negative balances will appear within parentheses. This is a calculated field and is not editable.

Database Fields: ERPx_APTransactionHeader.ExtendedAmount or ERPx_APDeliveryTicketHeaderTotalNetAmount

Status

This field will either display "Open", "Posted" or "Void". This can be edited from the 'Status' field on the 'Home' tab or header of the associated transaction. All statuses less than "Ready to Post" will be displayed as "Open". This field is editable while the transaction is in a Status less than "Ready to Post".

The Statuses that apply to transactions in this Inquiry include:

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK or ERPx_APDeliveryTicketHeader.TransactionStatusSK or ERPx_APPoHeader.TransactionStatusEN

Trans Type

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

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK or ERPx_APDeliveryTicketHeader.TransactionClassSK or ERPx_APPoHeader.TransactionTypeEN

Transaction

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 never editable.

Database Field: ERPx_APTransactionHeader.TransactionID or ERPx_APDeliveryTicketHeader.TicketNumber or ERPx_APPoHeader.PurchaseOrderID