Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 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: 20212023.1008.1531 and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Excel

Insert excerpt
Excel - LV
Excel - LV
nopaneltrue

Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout

Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue

Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Inquiry Criteria

Insert excerpt
Inquiry Criteria - Global
Inquiry Criteria - Global
nopaneltrue

Data
  • Date From
  • Date To
  • Status
Journal DetailsOpens the Journal Detail for all the rows selected.
Refresh
Insert excerpt
Refresh - Global
Refresh - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Accrual Account 

Insert excerpt
Def - GL Account - Settlement Accural
Def - GL Account - Settlement Accural
nopaneltrue

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionHeaderVendorSK 

Accrual Account Description

The GL Account Description of the Payable Account. 

Insert excerpt
Def - GL Account - Settlement Accural
Def - GL Account - Settlement Accural
nopaneltrue

Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.SAGLAcctRef, ERPx_APTransactionHeaderVendorSK 

Doc Date

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

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
 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

Insert excerpt
Fisherman ID
Fisherman ID
nopaneltrue
 

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

Fisherman Name

Insert excerpt
Fisherman, Fisherman & Tender and Tender
Fisherman, Fisherman & Tender and Tender
nopaneltrue
 

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

GL Period

Insert excerpt
GL Period
GL Period
nopaneltrue
 This field is not stored in the database.

GL Year

Insert excerpt
GL Year
GL Year
nopaneltrue
 This field is not stored in the database.

Item Description

Insert excerpt
Description - Item
Description - Item
nopaneltrue

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

Insert excerpt
Status
Status
nopaneltrue
  

Insert excerpt
Def - Status
Def - Status
nopaneltrue
 The Statuses that apply to transactions in this List View include:

Insert excerpt
Def - Status - New
Def - Status - New
nopaneltrue

Insert excerpt
Def - Status - Approved
Def - Status - Approved
nopaneltrue

Insert excerpt
Def - Status - Ready to Post
Def - Status - Ready to Post
nopaneltrue

Insert excerpt
Def - Status - Posted
Def - Status - Posted
nopaneltrue

Insert excerpt
Def - Status - Void
Def - Status - Void
nopaneltrue

Insert excerpt
Def - Status - Deleted
Def - Status - Deleted
nopaneltrue

Insert excerpt
Def - Status - Replaced
Def - Status - Replaced
nopaneltrue

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue
 

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Type

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue
 This will always be "Adjustment".

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

UOM

Insert excerpt
UOM - Price
UOM - Price
nopaneltrue
 

Database Field: ERPx_APTransactionLine.QuantityUOMSK


Related Topics

Correcting Fish Tickets (UG)

...