Other Transactions List View

Other Transactions List View

The purpose of this page is to view, add, edit, remove, and post Adjustments, Balance Transfers and Payment Receipts. Additionally, users can Mass Update the Status of multiple transactions at once.

Software Version: 2021.02.19 and newer

Page Header

Toolbar Icons

Description

Toolbar Icons

Description

Delete

Edit

Excel

Favorites

Grid Layout

Help

Mass Update

  • Status: A single-select lookup that defaults to "(No Change)", but also has options for "New", "Approved" and "Ready to Post". Assigns the selected Status to selected/filtered transactions when Apply is clicked.

New

  • Adjustment: A transaction to adjust an amount for a Fisherman, Fisherman & Tender, Tender or Loan account.

  • Balance Transfer: A transaction to transfer amounts from one Fisherman, Fisherman & Tender, Tender or Loan account to another.

  • Payment Receipt: A transaction to enter payments received by Fishermen, Fishermen & Tenders, Tenders and Loans. 

Print

Fields

Description

Checkbox

Amount

 This comes from the total of all the 'Extended' values for each line item on the Adjustment and Balance Transfer, and the 'Receipt Amount' for Payment Receipt transactions.  This is required on all transaction types, for Adjustments and Balance Transfers it can only be edited by changing the quantity and/or price of one or more transaction lines and for Payment Receipts while the transaction is in New status and does not have any applications.

Database Field: ERPx_APTransactionHeader.ExtendedAmount

Created

Linked Database Field: ERPx_APTransactionHeader.CreatedDate

Created By

Linked Database Field: ERPx_APTransactionHeader.CreatedBy

Doc Date

 This is required and can be edited from the 'Date' or 'Receipt Date' field on the associated Record View. This editable from the Record View while the transaction is in New status.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc Description

 This is not required and can be edited from the 'Description' field on the Payment Receipt Record View. This is always editable, even after the transaction is Posted.

 This field will be blank for Adjustment and Balance Transfer transactions, it is only applicable to Payment Receipt type transactions.

Database Field: ERPx_APTransactionHeader.Description

Doc No

 This is required and can be edited from the 'Doc No' / 'Payment #' on the associated Record View.  This is always editable, even after the transaction is Posted.

Database Field: ERPx_APTransactionHeader.DocNumber

Fisherman

 This is required and represents the ID of the Fisherman selected in the 'Received From' field on the Payment Receipt Record View. This is only editable by changing the Fisherman assigned to the transaction while in New status and no applications have been made.

 

 This field will be blank for Adjustment and Balance Transfer transactions, it is only applicable to Payment Receipt type transactions.  

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

Fisherman Name

This is required and represents the name of the Fisherman selected in the 'Received From' field on the Payment Receipt Record View. This is only editable by changing the Fisherman assigned to the transaction while in New status and no applications have been made.

 This field will be blank for Adjustment and Balance Transfer transactions, it is only applicable to Payment Receipt type transactions.  

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

GL Period

 This is required and calculated using the 'GL Date' on the 'Properties' tab of the Adjustment and Balance Transfer Record View and the 'Receipt Date' on the Payment Receipt Record View. This can only be edited by changing the GL Date/Receipt Date.

GL Year

  This is required and calculated using the 'GL Date' on the 'Properties' tab of the Adjustment and Balance Transfer Record View and the 'Receipt Date' on the Payment Receipt Record View. This can only be edited by changing the GL Date/Receipt Date.

Last Updated

 

Linked Database Field: ERPx_APTransactionHeader.LastUpdated

Last Updated By

 

Linked Database Field: ERPx_APTransactionHeader.LastUser

Status

 This is required and can be edited from the 'Status' field on each Record View and represents the status of the transaction. This is always editable while the transaction is in a Status of 'New' or 'Approved'.

 The Statuses that apply to transactions in this List View include:

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Transaction

 Clicking on this link opens the Record View for the corresponding record. This is a system assigned number that comes from the 'Transaction Class' and is required but is not editable by users.

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Type

 This is required and displays the type of transaction for the corresponding record.  There are three different transaction types for this page:

  • Adjustment

  • Balance Transfer

  • Payment Receipt

This is never editable.

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK