Balance Transfer Line History Inquiry (FA)

Balance Transfer Line History Inquiry (FA)

Balance Transfers allow for the movement of funds between Fishermen, Tenders, and Loan accounts. This is a net neutral transaction for the company since it just moves a Fisherman Payable from one fishing account to another. The 'Transfer Balance From' account is moving funds owed to them to the 'Transfer Balance To' account. These Balance Transfers show on the Fisherman Statement for both accounts. The purpose of this inquiry is to view Balance Transfers.

 This list view also contains columns for each Attribute that is set up for the 'Fisherman Accounting - Transactions' attribute type. However, because these attributes are user defined, they are not included in the help documentation.

Software Version: 2023.08.31 and newer

Page Header

Toolbar Icons

Description

Toolbar Icons

Description

Excel

Favorites

Grid Layout

Help

Inquiry Criteria

  • Date From

  • Date To

  • Status

Refresh

Fields

Description

Checkbox

Credit Account 

 This GL Account comes from the Fisherman, Tender, or Loan account assigned as the 'Transfer Balance To - Credit' on the Balance Transfer Line.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionLine.ToDistributionAccountSK

Credit Account Description

 This GL Account comes from the Fisherman, Tender, or Loan account assigned as the 'Transfer Balance To - Credit' on the Balance Transfer Line.

Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionLine.ToDistributionAccountSK

Debit Account 

 This GL Account comes from the Fisherman, Tender, or Loan account assigned as the 'Transfer Balance From - Debit' on the Balance Transfer Line.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionLine.FromDistributionAccountSK

Debit Account Description

 This GL Account comes from the Fisherman, Tender, or Loan account assigned as the 'Transfer Balance From - Debit' on the Balance Transfer Line.

Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionLine.FromDistributionAccountSK

Doc Date

 This can be edited from the 'Doc Date' on the 'Home' tab of the Record View. 

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc No

 This can be edited from the 'Doc No' on the 'Home' tab of the Record View and is used to enter a unique identifier from a pre-printed book of receipts. The Doc No value must be unique by transaction type. No two Fisherman Sale or Tender Resale Doc No values may be the same.

Database Field: ERPx_APTransactionHeader.DocNumber

Extended

Identifies the total amount of the transaction.

[Extended] = [Quantity] * [Price]

Database Field: ERPx_APTransactionLine.ExtendedAmount

From Fisherman

 This is the ID of the Fisherman, Tender. or Loan account that is assigned as the 'Transfer Balance From - Debit', the account the receivable balance will be transferred from.

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionLine.FromDistributionAccountSK

From Fisherman Name

 This is the Name of the Fisherman, Tender. or Loan account that is assigned as the 'Transfer Balance From - Debit', the account the receivable balance will be transferred from.

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionLine.FromDistributionAccountSK

GL Period

 This field is not stored in the database.

GL Year

 This field is not stored in the database.

Item Description

Database Field: ERPx_APTransactionLine.LineDescription

Price

A textbox to enter the price of the balance transfer line.  

Database Field: ERPx_APTransactionLine.Price

Quantity

Identifies the quantity of the adjustment line. 

Database Field: ERPx_APTransactionLine.Quantity

Status

  

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

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

To Fisherman

 This is the ID of the Fisherman, Tender. or Loan account that is assigned as the 'Transfer Balance To - Credit', the account the receivable balance will be transferred to.

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionLine.ToDistributionAccountSK

To Fisherman Name

 This is the Name of the Fisherman, Tender. or Loan account that is assigned as the 'Transfer Balance To - Credit', the account the receivable balance will be transferred to.

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionLine.ToDistributionAccountSK

Transaction

 

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Type

 This will always be "Balance Transfer".

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionClass.TransactionTypeSK, ERPx_APTransactionHeader.TransactionClassSK

UOM

 

Database Field: ERPx_APTransactionLine.QuantityUOMSK