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 page is to enter, edit, and post Adjustment transactions.

Software Version: 2023.08.31 and newer

Page Header

Toolbar Icons	Description
Delete	Deletes the transaction or master file record. When clicked, users will be prompted with: "Are you sure you want to delete this record?". Click "OK" to confirm, or "Cancel" to return without deleting. _{WARNING: Records cannot be recovered once they are deleted!}
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. Clicking the Saved Grid Layout icon allows the user to save a new view for the grid layout. 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 for vendors that have high volumes of activity, to separate transaction types (i.e. Invoice specific vs. Credit Memo specific), etc. 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.
Journal Details	Opens the Journal Details window showing the Journal Entry for this transaction. Until the transaction Approved or Posted, this is a temporary journal entry so no Journal ID will be assigned.
New	Opens a new blank record for data entry. Users can select the type of transaction they want to add. The drop-down includes: Adjustment (all Adjustment Classes), Balance Transfer, and Payment Receipt.
Print	Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed.
Save	Saves the changes made to the record. It is only necessary to click the Save button when a change is detected on the page. When a change has been made, a ‘ + ‘ character is displayed prior to the page name in the page title bar (light blue bar in the upper left corner of the page). Clicking Save reloads the page.

Home Tab

Field	Description
Amount	Displays the total amount of the adjustment transaction. This is a calculated field that updates on Save and is never editable by the user. Database Field: ERPx_APTransactionHeader.ExtendedAmount
Date	Identifies the date the transaction posted (or will post) to the general ledger. This defaults to the current date but can be edited while the transaction is set to a status of 'New.' This is required and must be within a Fiscal Period open to both Purchasing and Financial. Database Field: ERPx_APTransactionHeader.TransactionDate
Doc No	An editable field that identifies the Doc No (document number) such as a Vendor's Invoice # or a reference number that you assign for the transaction. This defaults to blank, not required, and is always editable, even after the transaction is posted. If entered, it must be <= 50 characters and be unique across all Adjustment transactions. Database Field: ERPx_APTransactionHeader.DocNumber
Status	A single-select lookup to identify the Status of the transaction. This defaults to "New" but can be edited until the transaction is Posted. Identifies the Status of the transaction. This is required and can be edited while in a Status of New or Approved. 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". Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Properties Tab

Property Name	Description
Created By	A non-editable text box to identify the name of the user that created the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Database Field: ERPx_APTransactionHeader.CreatedBy
Created Date	A non-editable text box to identify the Created Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_APTransactionHeader.CreatedDate
Currency ID	Identifies the Currency assigned to the transaction. This defaults to the Home Currency of the company and is not editable. Database Field: ERPx_APTransactionHeader.CurrencySK
GL Date	The date the transaction posted (or will post) to the general ledger. If unassigned when the transactions Status is changed to "Approve" or "Ready to Post", it will default from the Transaction Date. To Approve or Post, the GL Date must be in a valid period that is open for posting. If not the message, "The Fiscal Period is not open." will be displayed on Save. Database Field: ERPx_APTransactionHeader.GLDate
Last Updated	Identifies the Last Updated Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. Database Field: ERPx_APTransactionHeader.LastUpdated
Last User	A non-editable text box to identify the name of the user that last updated the Transaction. It is formatted to be the "logged-in" users [User First Name] + [User Last Name]. This is a system assigned value and is never editable by a user. Database Field: ERPx_APTransactionHeader.LastUser
Posted Date	Identifies the Date & Time the transaction was posted. Database Field: ERPx_APTransactionHeader.PostedDate
Transaction Class	Displays the Transaction Class of "Default. This is informational only and cannot be edited. Transaction Classes are used to differentiate transactions within a Transaction Type. For example, Transaction Classes of Fresh and Frozen can be setup for the Transaction Type of 'Sales Order'. Transaction Classes are used in all functional areas throughout the application. Database Field: ERPx_APTransactionHeader.TransactionClassSK

Attributes Tab

Column Headers	Description
Attributes	A non editable text box that shows the name of the Attribute. Attributes are user-definable fields that are used on master files and transactions and are editable from the Attributes List View. The Attribute will only be displayed if the Applies property on the Assign Attribute Rules by page is set to either "Yes - Required" or "Yes - Not Required". Attributes set to "No" will not be displayed. The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes → Fisherman Accounting).
Available	This field displays whether or not the attribute is available and required. Only available attributes will be displayed with a 'Yes' followed by whether or not it is a required attribute. Required attribute values must be entered before saving the transaction as Approved or Ready to Post.
Value	Identifies the value assigned to the corresponding attribute. Because Attributes are configurable as either Text, List, Date, or Date/Time the data entry is either a text box, lookup, or date picker. The value defaults to blank and is only required if the Attribute's 'Applies' property is set to "Yes - Required" in the Assign Attribute Rules page. Attribute Values for Master Flies are always editable. Attribute Values for transactions are always editable for unposted transactions.

Column Headers

Description

Attributes

A non editable text box that shows the name of the Attribute. Attributes are user-definable fields that are used on master files and transactions and are editable from the Attributes List View. The Attribute will only be displayed if the Applies property on the Assign Attribute Rules by page is set to either "Yes - Required" or "Yes - Not Required". Attributes set to "No" will not be displayed.

The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes → Fisherman Accounting).

Available

This field displays whether or not the attribute is available and required. Only available attributes will be displayed with a 'Yes' followed by whether or not it is a required attribute. Required attribute values must be entered before saving the transaction as Approved or Ready to Post.

Value

Identifies the value assigned to the corresponding attribute.

Because Attributes are configurable as either Text, List, Date, or Date/Time the data entry is either a text box, lookup, or date picker. The value defaults to blank and is only required if the Attribute's 'Applies' property is set to "Yes - Required" in the Assign Attribute Rules page. Attribute Values for Master Flies are always editable. Attribute Values for transactions are always editable for unposted transactions.

Grid

Columns	Description
Toolbar Icons	Description
Delete	Deletes the selected line(s) from the transaction or master file. This icon is only enabled for transactions with a Status of 'New'.
Excel	Exports the contents of the grid 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.
New	Inserts blank lines that allow adding multiple new records.
Checkbox	Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Date	A textbox to enter the date of the line item. Although this field can be edited, it will default to match the header date upon save. Database Field: ERPx_APTransactionLine.PurchaseDate
Description	A textbox to enter the description of the line item. This defaults to blank, is required and can be up to 200 characters. This is always editable, even after the transaction is posted. New line items on these transactions, without a Description, will not be saved. Database Field: ERPx_APTransactionLine.LineDescription
Distributed To	A single-select lookup to identify the Fisherman, Tender, or Loan account that the line item is being adjusted for. This is required and editable while the transaction is in a Status of "New". If missing, the message "Distributed To is required for all lines." will be displayed on Save. The lookup contains a blank value, the current assigned value, and the list of all 'Active' Fishermen, Tender, and Loan Accounts that have not been excluded from the 'Adjustment Class' transaction(s) (as assigned on the Excluded Transactions Tab in the Fishermen & Tenders and Loans Record View. Database Field: ERPx_APTransactionLine.ToDistributionAccountSK
Extended	A Calculated field to show the extended amount of the adjustment line. It is calculated/updated on Save as [Quantity] * [Price] and is never editable by the user. Database Field: ERPx_APTransactionLine.ExtendedAmount
Extended Amt 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. This defaults to 0.00, is required and must be > 0.00. This is only editable while the transaction is in a Status of "New". If missing or negative the message "Price is required and must be greater than zero." will be displayed on Save. Database Field: ERPx_APTransactionLine.Price
Purchase Account	Identifies the account number and description of the GL Account that is used for the Adjustment line item. This is required and is only editable while the transaction is in a Status of "New". If missing, the message "A Purchase Account is required for all lines." will be displayed on Save. The lookup contains a blank value, the current assigned value, and the list of all 'Active' GL Accounts where 'Use in AP' is enabled. Database Field: ERPx_APTransactionLine.AccountSK
Quantity	A textbox to enter the quantity of the adjustment line. This defaults to 1.00, is required and must be > 0.00. This is only editable while the transaction is in a Status of "New". If missing or < = 0, the message "Quantity is required and cannot be zero." will be displayed on Save. Database Field: ERPx_APTransactionLine.Quantity
UOM	Displays the unit of measure upon which the line item price is based. This defaults from the Purchasing Preference selection for "Default Fishing UOM". It is not required and can only be edited when the transaction is in a Status of "New". The lookup contains a list of all 'Active' UOMs. Database Field: ERPx_APTransactionLine.QuantityUOMSK

Page Header

Home Tab

Properties Tab

Attributes Tab

Grid

Related Topics

Page Definitions

Technical Details

Browser not supported