Versions Compared

Version Old Version 3 New Version Current
Changes made by

Janice Dannenberg

Adam Herman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerptDef - Not DefinedDef - Not Definednopaneltrue The purpose of this page is to display all outstanding fishing transactions to apply a Payment, Invoice, Tender Resale or Fisherman Saleview 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: YYYY2020.MM05.DD 22 and newer

Table of Contents
typeflat

Page Header


Toolbar IconsDescription
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Excerpt-include
Help - Global
Help - Global
nopaneltrue
Save
Insert excerpt
Save -
Global
RV Header
Save -
Global
RV Header
nopaneltrue
FieldsDescription
Account

Insert excerpt

Fisherman, Fisherman & Tender and TenderFisherman, Fisherman & Tender and Tendernopaneltrue

Account Name
Account Name
nopaneltrue
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

total

original amount of

the payment transaction.Transaction

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

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
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.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

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

Displays the transaction’s unapplied amount

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

Insert excerpt
Amount - Unapplied
Amount - Unapplied
nopaneltrue
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 transactions or more documents to apply to a document to. transaction. Checking the checkbox will automatically populate the Applied Amount This field allows users to enter the amount to be applied from the payment transaction towards the payable transaction. This field defaults to blank and the 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

Insert excerpt
Amount - Applied
Amount - Applied
nopaneltrue
This is a text box that defaults to blank. The amount entered cannot be greater than the

unapplied amount of the payable transaction or the open amount of the payment transaction selected in the header section.
Apply DateThis field allows users to enter a date for the application. This field defaults to today’s date and the date entered must reside within an open fiscal period.
Distributed Description
Doc DateDisplays the doc date of the payable transaction. The value is pulled from the payable transaction record.
Doc DescriptionDisplays the doc description. The value is pulled from the payable transaction record and is blank if no description has been entered.
Doc NoDisplays the document number. The value is pulled from the payable transaction record.
GL DateGL PeriodGL YearLine Description
Original AmountDisplays the total amount of the payable transaction.
Remaining AmountDisplays the unapplied amount of the payable transaction after the Terms Discount Taken Amount. This is calculated by subtracting the Terms Discount Taken amount from the Original Amount

'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

Insert excerpt
Applied Date
Applied Date
nopaneltrue
 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

Insert excerpt
Distributed Description - FA
Distributed Description - FA
nopaneltrue
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

Insert excerpt
Doc Date
Doc Date
nopaneltrue
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

Insert excerpt
Comment - Header
Comment - Header
nopaneltrue
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

Insert excerpt
Doc No
Doc No
nopaneltrue
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

Insert excerpt
GL Date
GL Date
nopaneltrue
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

Insert excerpt
GL Period
GL Period
nopaneltrue
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

Insert excerpt
GL Year
GL Year
nopaneltrue
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

Insert excerpt
Description - Item
Description - Item
nopaneltrue
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

Insert excerpt
Amount - Original
Amount - Original
nopaneltrue
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

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue

Clicking on this link opens the AP Invoice / Credit Memo Record View for the selected record

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.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database

Field

Fields: ERPx_APTransactionHeader.TransactionID, ERPx_APDeliveryTicketHeader.TicketNumber

Transaction Type

Insert excerpt
Transaction Type
Transaction Type
nopaneltrue
This is required and defaults from the Transaction Type

Unapplied AmountDisplays the amount of the payable transaction that is not applied yet. The value is calculated by subtracting the entered Applied Amount from the Remaining Amount

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

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

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

Unapplied Amount

Insert excerpt
Amount - Unapplied
Amount - Unapplied
nopaneltrue
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

Terms Discount Taken and Applied Amount fields

'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



Expand
titlePage Definitions

Page Definitions


...