Adjustment Line History Inquiry (FA)
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
Page Header
Toolbar Icons | Description |
---|---|
Excel | Export the contents of the list view to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported. |
Favorites | Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline. Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab. |
Grid Layout | Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). The bolded view is the default view, which will determine the view will automatically display in when opened. |
Help | Opens the online WIKI help page for the current page. This icon is only visible on pages that are documented in the online help. |
Inquiry Criteria | Opens Inquiry Criteria window where users can define the following criteria:
|
Journal Details | Opens the Journal Detail for all the rows selected. |
Refresh | Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. |
Fields | Description |
Checkbox | Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete. |
Accrual Account | The GL Account that is assigned for the "Settlement Accrual" Account Type, on the Accounts tab of the Fisherman or Loan Record View and Fisherman Class Record View. This is the Balance Sheet account that is Debited or Credited when Fishing Transactions are posted for the selected Fisherman, Tender, or Loan account. Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionHeaderVendorSK |
Accrual Account Description | The GL Account Description of the Payable Account. The GL Account that is assigned for the "Settlement Accrual" Account Type, on the Accounts tab of the Fisherman or Loan Record View and Fisherman Class Record View. This is the Balance Sheet account that is Debited or Credited when Fishing Transactions are posted for the selected Fisherman, Tender, or Loan account. Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionHeaderVendorSK |
Doc Date | Identifies the date of the transaction. This can be edited from the 'Doc Date' on the 'Home' tab of the Record View. Database Field: ERPx_APTransactionHeader.TransactionDate |
Doc No | Identifies the Doc No (document number) for the transaction. Unlike a Transaction ID that is system assigned based on the Transaction Class of the Transaction Type, this is a manually entered value. 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 | Identifies the ID of the Fisherman, Fisherman & Tender or Tender associated with the transaction. Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK |
Fisherman Name | Identifies the name of the Fisherman, Fisherman & Tender or Tender associated with the transaction. Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK |
GL Period | Identifies the Fiscal Period based on the GL date on the source transaction or manual journal entry. This field is not stored in the database. |
GL Year | Identifies the Fiscal Year based on the GL date on the source transaction or manual journal entry. This field is not stored in the database. |
Item Description | Identifies the Description for the line item. 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.
|
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 | Identifies the Status of the transaction. Status is used to identify where a transaction, Purchase Order, Price List, BOM, or Master File record is in its life cycle. Records start in a Status of 'New' and progress sequentially through additional statuses until they are 'Posted' or 'Closed'. The list of potential Statuses changes depending on the transaction type. The Statuses that apply to transactions in this List View include: New: This is the default Status for all new Transactions. While in the Status of 'New' transactions are considered open and all editable fields are open for edit, no posting or approval validations are performed, GL Dates are not assigned, and journal entries are not created. If the transaction was moved back from Approved to New, the GL Date will be assigned and a Journal Entry will exist. Approved: Performs all the data validations required to post the transaction and applies to all Transactions. While in the Status of 'Approved' transactions are considered open but have limited fields open for edit. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled except for the Status lookup (and any fields that are always editable), journal entries are created/updated, journal ID's are assigned to the journal entry, and blank 'GL Dates' are assigned. Ready to Post: Runs the Approval validations and applies to all transactions. While in the Status of 'Ready to Post' transactions are considered closed and all the fields are disabled with the exception of a few fields that are always editable. If one or more validations fail, messages are provided indicating what needs to be corrected. If all the validations pass, then all the fields are disabled with the exception any fields that are always editable and updates the Transaction Status to "Posted". Posted: Signifies the transaction has been posted and/or applied to a transactions (e.g. Payment Receipt). When a transaction is posted, it updates the General Ledger and/or On Hand Item Balances. While in the Status of 'Posted' transactions are considered closed and all the fields are disabled with the exception of a few fields that are always editable. Void: Signifies a previously posted transaction has been voided. This status is only available for transactions that support voiding posted records (not all transactions support this). Voided transactions remain in the database and can be viewed from history inquiries. Deleted: Signifies the transaction has been deleted. When a user deletes an open transaction, in some instances the transaction is not removed from the database but is changed to a Status of 'Deleted'. Deleted transactions are not visible from transaction list views but can be found in inquiries. Transaction in the Status of 'Deleted' are only used a information. Replaced: Signifies the transaction was voided or corrected. When a transaction is corrected or Voided, the Status of the original transaction is changed to 'Replaced' and a new transaction is cloned and marked as 'Void'. This is done to ensure that a reversal journal entry can be created and posted in an open fiscal period to record the Void. Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK |
Transaction | Transaction numbers are system assigned IDs to differentiate unique transactions. Transaction ID's are unique by the unique combination of 'Transaction Type' + 'Transaction Class'. Database Field: ERPx_APTransactionHeader.TransactionID |
Transaction Type | Transaction Types are used to differentiate unique types transactions within the system. Transactions with the same Transaction Type share the same record view pages and business rules. Transaction Types can be further classified using Transaction Classes. Every transaction in the system is assigned a Transaction Type. This will always be "Adjustment". Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionClass.TransactionTypeSK, ERPx_APTransactionHeader.TransactionClassSK |
UOM | Displays the unit of measure upon which the line item price is based. Database Field: ERPx_APTransactionLine.QuantityUOMSK |
Related Topics
Entering New Fish Tickets (UG)
Repricing Fish Ticket Items (UG)
Repricing Delivery Ticket Premiums & Taxes