Page Comparison

The purpose of this page is to display all outstanding Debit balance transactions that have not been fully applied. From here, users can select a single transaction and click the 'Apply Document' icon in the header toolbar to manually apply the selected transaction to one or more Credit balance transactions.

Software Version: YYYY2020.MM05.DD 22 and newer

Table of Contents

type	flat

...

Toolbar Icons

Description

Apply Document

Opens the Apply Fishing Transactions record view. Users must select a transaction prior clicking this toolbar icon. Only one transaction can be selected at a time.

Excel

Insert excerpt

	Excel - LV
	Excel - LV
nopanel	true

Grid Layout

Insert excerpt

	Grid Layout - Global
	Grid Layout - Global
nopanel	true

Help

Insert excerpt

	Help - Global
	Help - Global
nopanel	true

Inquiry Criteria

Insert excerpt

	Inquiry Criteria - Global
	Inquiry Criteria - Global
nopanel	true

Include transactions through: A textbox that defaults to the current date.
Hide fully applied transactions: A Yes/No lookup that defaults to "Yes". If set to Yes then fully applied transactions will not be visible.
Fisherman: A single-select standard lookup that defaults to the Account(s) that was selected prior to clicking the Apply Documents button on the Fisherman Balances list view. If no Account was selected, this field defaults to blank.

Refresh

Insert excerpt

	Refresh - Global
	Refresh - Global
nopanel	true

Fields

Description

Checkbox

Used to select one transaction to apply a document to.

Account

Insert excerpt

	Account ID
	Account ID
nopanel	true

This is required and comes from the 'Vendor ID' field on the Fishermen & Tenders record view or Loan record view. This is only editable by changing the Fisherman, Fisherman & Tender, Tender, or Loan assigned to the transaction.

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK, ERPx_APTransactionLine.AccountSK, ERPx_APTransactionLine.FromDistributionAccountSK, ERPx_APTransactionLine.ToDistributionAccountSK, ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK

Account Class

Insert excerpt

	Fisherman (Account) Class
	Fisherman (Account) Class
nopanel	true

This is required and comes from the 'Vendor Class' field on the Fishermen & Tenders record view. This is only editable by changing the Fisherman, Fisherman & Tender or Tender assigned to the transaction.

Database Fields: ERPx_APVendor.VendorClassSK, ERPx_APTransactionHeader.VendorSK, ERPx_APTransactionLine.AccountSK, ERPx_APTransactionLine.FromDistributionAccountSK, ERPx_APTransactionLine.ToDistributionAccountSK , ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK

Account Name

Insert excerpt

	Account Name
	Account Name
nopanel	true

This is required and comes from the 'Vendor Name' field on the Fishermen & Tenders record view or Loan record view. This is only editable by changing the Fisherman, Fisherman & Tender, Tender or Loan assigned to the transaction.

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

Distributed Description

Insert excerpt

	Distributed Description - FA
	Distributed Description - FA
nopanel	true

This is required for Tender Resale, AP Invoice/Credit Memo and Balance Transfer transaction types and not required for all other transaction types.For Tender Resale transaction types, this field can be edited from the 'Tender' field on the Tender Resale record view. For AP Invoice/Credit Memo transaction types, this field can be edited from the 'Vendor' field on the Invoice/Credit Memo record view. For Balance Transfer transaction types, this field can be edited from the 'Transfer Balance To - Credit' field on the Balance Transfer record view. This is only editable by changing the 'Tender', 'Vendor' or 'Transfer Balance To - Credit' fields on the associated transactions.

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.FromVendorSK (Tender Resale), ERPx_APTransactionHeader.VendorSK (AP Invoice/Credit Memo), ERPx_APTransactionLine.ToDistributionAccountSK (Balance Transfer)

Doc Date

Insert excerpt

	Doc Date
	Doc Date
nopanel	true

This is required and can be edited from the 'Date' field on the in the associated transaction header. This is always editable while the transaction is in a Status of New.

Database Fields: ERPx_APTransactionHeader.TransactionDate, ERPx_APDeliveryTicketHeader.TicketDate

Doc Description

Insert excerpt

	Description Comment - HeaderDescription
	Comment - Header
nopanel	true

This is not required and can be edited from the 'Description' field on the associated transaction header. This is always editable.

Database Field: ERPx_APTransactionHeader.Description

Doc No

Insert excerpt

	Doc No
	Doc No
nopanel	true

This is not required and can be edited from the 'Doc No' field on the in the associated transaction header. This is always editable while the transaction is in a Status of New. Depending on the transaction type, this is sometimes editable after the transaction has been posted.

Database Field: ERPx_APTransactionHeader.DocNumber

GL Date

Insert excerpt

	GL Date
	GL Date
nopanel	true

This is required and can be edited from the 'GL Date' on the 'Properties' tab of the associated transaction. If not manually edited, this will be automatically set to match the 'Doc Date' when the transaction is saved with a Status of either Approved or Ready to Post. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.GLDate

GL Period

Insert excerpt

	GL Period
	GL Period
nopanel	true

This is required and calculated using the 'GL Date' on the 'Properties' tab of the associated transaction. This can only be edited by changing the GL Date.

GL Year

Insert excerpt

	GL Year
	GL Year
nopanel	true

This is required and calculated using the 'GL Date' on the 'Properties' tab of the associated transaction. This can only be edited by changing the GL Date.

Line Description

Insert excerpt

	Description - Item
	Description - Item
nopanel	true

This is required for Adjustments, AP Invoices/Credit Memos, Tender Resales and Balance Transfers. This can be edited from the 'Description' on the Item grid of the associated transaction. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionLine.LineDescription

Original Amount

Insert excerpt

	Amount - Original
	Amount - Original
nopanel	true

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.

This field will display as positive (for example $100.00) when the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference is set to "Negative". This field will display as negative (for example ($100.00)) when the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference is set to "Positive".

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

Transaction

Insert excerpt

	Transaction ID
	Transaction ID
nopanel	true

Clicking on this link opens the record view for the selected transaction. 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
nopanel	true

Database Fields: ERPx_APTransactionHeader.TransactionID, ERPx_APDeliveryTicketHeader.TicketNumber

Transaction Type

Insert excerpt

	Transaction Type
	Transaction Type
nopanel	true

This is required and comes from the Transaction Type selected when starting a new transaction. This is never editable. The following transaction types have the ability to debit the Settlement Accrual Account and display on this page:

Adjustment Lines with a positive line where the Account is selected for the 'Distributed To' field
Balance Transfer line lines for the Account selected as the 'Transfer Balance From - Debit' field
AP Credit Memo with a negative line where the Account is selected in the 'Distributed To' field
Fish Ticket with a negative amount
Fisherman Sale with a positive line
AP Invoice with a positive line where the Account is selected in the 'Distributed To' field
Payment Check or ACH
Tender Resale with a positive line
Tender Resale Transfer (for a Fisherman) with a positive line

Insert excerpt

	Def - Transaction Types
	Def - Transaction Types
nopanel	true

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

Unapplied Amount

Insert excerpt

	Amount - Unapplied
	Amount - Unapplied
nopanel	true

This is required and updates when amounts are entered in the 'Applied Amount' field on the Apply Fishing Transactions record view. This is calculated by subtracting previous applications from the original amount. This value is not stored in the database.

This field will display as positive (for example $100.00) when the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference is set to "Negative". This field will display as negative (for example ($100.00)) when the 'Show Credit balances on the Fisherman Balance page and aging reports as:' default preference is set to "Positive".

...

Versions Compared

Old Version 48

New Version Current

Key