Apply Fishing Transactions Record View

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: 2020.05.22 and newer

Page Header

Toolbar IconsDescription
Grid LayoutOpens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) This icon is only visible on pages that are documented in the online help.

SaveSaves the changes made to the record. 

(lightbulb) It is only necessary to click the Save button when a change is detected on the page. When a change has been made, a ‘ + ‘ character is displayed prior to the page name in the page title bar (light blue bar in the upper left corner of the page). Clicking Save reloads the page.

FieldsDescription
Account

Identifies the name of the Fisherman, Fisherman & Tender, Tender or Loan. 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.

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

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

Transaction

Identifies the unique Transaction ID for each 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.

Transaction numbers are system assigned IDs to differentiate unique transactions. Transaction ID's are unique by the unique combination of 'Transaction Type' + 'Transaction Class'.

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

Displays the amount of the transaction that is not yet applied.  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.

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

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.

FieldsDescription
CheckboxUsed 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

Displays the amount to be applied from the payment transaction towards the payable transaction.
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.

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

Database Field: ERPx_APSettlementTransaction.AppliedAmount

Apply Date

Identifies the date for the application. 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

Identifies a description of the distribution, including the name of the Vendor, Fisherman, Fisherman & Tender, Tender or Loan. 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

Identifies the date of the transaction. 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

Identifies the header comment/description of the transaction or batch. 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

Identifies the Doc No (document number) for the transaction. Unlike a Transaction ID that is system assigned based on the Transaction Class of the Transaction Type, this is a manually entered value. 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

Identifies the date the transaction posted (or will post) to the general ledger.  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

Identifies the Fiscal Period based on the GL date on the source transaction or manual journal entry. 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

Identifies the Fiscal Year based on the GL date on the source transaction or manual journal entry. 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

Identifies the Description for the line item. 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

Displays the total amount of the transaction. 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.

(lightbulb) 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.

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

Transaction

Identifies the unique Transaction ID for each 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.

Transaction numbers are system assigned IDs to differentiate unique transactions. Transaction ID's are unique by the unique combination of 'Transaction Type' + 'Transaction Class'.

Database Fields: ERPx_APTransactionHeader.TransactionID, ERPx_APDeliveryTicketHeader.TicketNumber

Transaction Type

Identifies the Transaction Type for each transaction. 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

Transaction Types are used to differentiate unique types transactions within the system. Transactions with the same Transaction Type share the same record view pages and business rules. Transaction Types can be further classified using Transaction Classes. Every transaction in the system is assigned a Transaction Type.

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

Unapplied Amount

Displays the amount of the transaction that is not yet applied.  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.

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

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details