Versions Compared

Version Old Version 19 New Version 20
Changes made by

Janice Dannenberg (Unlicensed)

Janice Dannenberg (Unlicensed)

Saved on

Key

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

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
 The purpose of this page is to display all outstanding fishing transactions to apply a Payment, AP Invoice, AP Credit Memo, Tender Resale, Fisherman Sale, Balance Transfer, Adjustment or Cash Receipt.

...


Toolbar IconsDescription
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Save
Insert excerpt
Save - Global
Save - Global
nopaneltrue
FieldsDescription
Account

Insert excerpt
Account Name
Account Name
nopaneltrue
This is a single-select standard lookup that defaults from the 'Account Name' field for the selected document. This field is required to Save. Changing the Account will automatically refresh the page to display posted transactions with an Unapplied Amount for the selected Account.

The lookup contains the current assigned value and a list of all the 'Active' Fishermen, Fishermen & Tenders, and Tenders and Loans.

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

Open Amount
Insert excerpt
Amount - Original
Amount - Original
nopaneltrue
This is a non-editable text box that defaults from the 'Remaining Amount' field for the selected document. This field is required to Save and is never editable by the user. This is a calculated field and not stored in the database.
Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
This is a single-select standard lookup that is required to Save and is never editable by the user. This is a system assigned number that comes from the 'Transaction Class'.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

The lookup contains the current assigned value and a list of all the documents for the selected 'Account' that have an Unapplied Amount > 0.

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 document. This is calculated by subtracting 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

Page Detail

FieldsDescription
CheckboxUsed to select one transaction to apply a document to. Checking the checkbox will automatically populate the Applied Amount field with the Unapplied Amount of the payable transaction or the Open 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' 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.

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. 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 Fish Ticket 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 To - Credit' 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. Else, this defaults from the 'Doc Date' field on the associated payable transaction.

Database Field: ERPx_APDeliveryTicketHeader.TicketDate (Fish Ticket), ERPx_APTransactionHeader.TransactionDate

Doc Description

Insert excerpt
Description - Header
Description - Header
nopaneltrue
This is a non-editable text box that is not required. This field defaults from the 'Description' field on the associated payable transaction.

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 parable transaction.

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

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

Line Description

Insert excerpt
Description - Item
Description - Item
nopaneltrue
This is a non-editable text box that is not required. This defaults to the 'Description' field for a specific line on the associated payable transaction.

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 and Balance Transfer transaction types, this defaults to the 'Extended' amount of an individual line item.

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

Remaining AmountDisplays the unapplied amount of the payable transaction. This is a non-editable text box that is required. This is a calculated field that defaults to [Original Amount] - [Sum of all previously Applied Amounts] and is not stored in the database.
Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
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 required but is not editable by users.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database 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 selected when starting a new transaction. This is never editable.

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 'Applied Amount' field.


...