Auto Hide Filters

Auto Refresh on Open

Account Class

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

Account Name

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

Account Type

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

Date

Date Option

• Transaction Date

• GL Date

Include

• Open Transactions. Select to include unposted transactions. Selected by default.

• Posted. Select to include Posted transactions. Selected by default.

• Void Transactions. Select to include Voided transactions. Not selected by default.

• Beginning Balances. Select to display and compute beginning balances. Selected by default.

Saved Searches

Search

• Account ID 

• Account Name

• Transaction ID

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 Details: 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

Account ID

Database Fields: ERPx_APVendor.VendorID

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

Default Settlement Accrual Account

Database Fields: ERPx_APVendor.SAGLAcct

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

Database Field: ERPx_APTransactionHeader.DocNumber

GL Date

GL Period

GL Year

IsFullySettled

A system-calculated flag that indicates whether the Transaction associated with the fisherman has been fully applied and there is no remaining Settlement Balance.  This is a Yes/No field and will display 'Yes' when the transaction has been fully applied and no balance is remaining, otherwise if a balance remains it will display 'No'.  This field is not editable. 

Note: Beginning Balance lines will be blank. 

Database Field: ERPx_APSettlementTransaction.IsFullySettled

Master Account

Identifies the Master Account assigned to the Account.

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".

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

Trans Type

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

Transaction

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