Adjustments provide a way to make changes to Fishermen, Tender, and/or Loan account balances. This is most often used to load initial Fishermen, Tender, and/or Loan account balances on go live but can also be used for other reasons. Positive adjustments create a fisherman receivable and negative adjustments create a fisherman payable. The purpose of this inquiry is to view Fisherman Adjustment lines.

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

[ 1 Page Header ] [ 1.1 Related Topics ] [ 1.1.1 Page Definitions ] [ 1.1.2 Technical Details ]

Page Header

Toolbar Icons	Description

Toolbar Icons	Description
Excel
Favorites
Grid Layout
Help
Inquiry Criteria	Date From Date To Status
Journal Details	Opens the Journal Detail for all the rows selected.
Refresh
Fields	Description
Checkbox
Accrual Account	Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionHeaderVendorSK
Accrual Account Description	The GL Account Description of the Payable Account. Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionHeaderVendorSK
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_APTransactionHeader.ExtendedAmount
Fisherman	Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK
Fisherman Name	Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK
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
Line Type	A textbox to identify whether the line item is 'Owed to Account' or 'Due from Account'. This is required and not editable. Line items with a positive Extended amount are set to 'Due from Account'. Line items with a negative Extended amount are set to 'Owed to Account'.
Price	A textbox to enter the price of the adjustment line. Database Field: ERPx_APTransactionLine.Price
Purchase Account	Identifies the GL Account number of the GL Account that is used for the Adjustment line item. This will be the GL Account that is credited when the 'Extended' amount is positive and debited when it is negative. This lookup contains a blank value, the current assigned value, and all active GL Accounts where 'Use in AP' = "Yes". Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK
Purchase Account Description	Identifies the GL Account description of the GL Account that is used for the Adjustment line item. This will be the GL Account that is credited when the 'Extended' amount is positive and debited when it is negative. Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK
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
Transaction	Database Field: ERPx_APTransactionHeader.TransactionID
Transaction Type	This will always be "Adjustment". Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionClass.TransactionTypeSK, ERPx_APTransactionHeader.TransactionClassSK
UOM	Database Field: ERPx_APTransactionLine.QuantityUOMSK

Adjustment Line History Inquiry (FA)

Page Header