Fisherman Sale Lines List View

A Fisherman Sale is a transaction used to record sales from the company to a Fisherman, Tender or Loan Account. These transactions can be settled against Fish Ticket balances.

A Tender resale is a transaction used to record sales transactions made between Tenders and Fishermen. These may include line items that the Tender owns and/or line items that the company owns. Line items for Tender owned products create a balance transfer event between the Tender and Fisherman. They have no financial impact on the company and show up on the Fisherman Statement for both the Tender and Fisherman. Line items for Company owned products create a sale between the company and fisherman. These line items only show on the Fisherman Statement for the Fisherman and can be settled against Fish Ticket balances. 


 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.09.15 and newer

Page Header

Toolbar IconsDescription
Edit

Opens the selected record for editing. If a record is not selected, the page will not open.

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. 

(lightbulb) 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).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) This icon is only visible on pages that are documented in the online help.

More Actions

Displays a drop down menu of related actions. The list of options includes:

  • Void/Correct: Opens the Void/Correct Fish Ticket utility to allow users to void or correct one or more posted Fisherman Sale or Tender Resale transactions.
New

Allows users to select the class for the transaction they want to add. The list contains: 

  • Fisherman SaleA Fisherman Sale is a transaction used to record sales from the company to a Fisherman, Tender or Loan Account. These transactions can be settled against Fish Ticket balances.
  • Tender Resale: A Tender resale is a transaction used to record sales transactions made between Tenders and Fishermen. These may include line items that the Tender owns and/or line items that the company owns. Line items for Tender owned products create a balance transfer event between the Tender and Fisherman. They have no financial impact on the company and show up on the Fisherman Statement for both the Tender and Fisherman. Line items for Company owned products create a sale between the company and fisherman. These line items only show on the Fisherman Statement for the Fisherman and can be settled against Fish Ticket balances.
FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Credit Account

Identifies the GL Account that will be Credited on a sale or Debited on a sales return.

Database Field: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK 

Credit Account Description

A GL Account Description is the name given to a GL Account ID.

Database Field: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK 

Debit 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 Field: ERPx_GLAccount.AccountNumber, ERPx_APVendor.SAGLAcctref, ERPx_APTransactionHeader.VendorSK, ERPx_APTransactionLine.TransactionHeaderSK 

Debit Account Description

A GL Account Description is the name given to a GL Account ID.

Database Field: ERPx_GLAccount.Description,  ERPx_APVendor.SAGLAcctref, ERPx_APTransactionHeader.VendorSK, ERPx_APTransactionLine.TransactionHeaderSK 

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 Description

Identifies the header comment/description of the transaction or batch. This is a text box to assign a description to the Fisherman Sale transaction. 

Database Field: ERPx_APTransactionHeader.Description

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 Extended amount of the line item. This is calculated as [Quantity] * [Price] for each transaction line. This can only be edited by changing the Quantity and/or Price of the transaction line. Positive lines represent a purchase (Credit entry) and negative lines represent a return (Debit entry).

Database Field: ERPx_APTransactionLine.ExtendedAmount for Items and ERPx_APTransactionTax.TaxAmount for Tax Lines

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.

Database Field: ERPx_APTransactionHeader.GLDate

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.

Database Field: ERPx_APTransactionHeader.GLDate

Item

Identifies the ID of the Item.

Database Field: ERPx_IMItem.ItemID, ERPx_APTransactionLine.ItemSK

Item Class

Identifies the class that is assigned to the Item on the transaction or transaction line.

Item Classes are used to identify default values that will be applied to new Inventory Items and to group Items together for reporting purposes.

Database Fields: ERPx_IMItemClass.ClassID, ERPx_IMItemClass.Description, ERPx_IMItem.ItemClassSk, ERPx_APTransactionLine.ItemSK

Item Description

Identifies the Description associated with the Item ID assigned to a transaction line, journal line detail or master file record.

Database Field: ERPx_APTransactionLine.LineDescription

Line Type

Identifies the type of the line item. This will either be:

  • Sale: The row is for an Inventory Item ID that was sold.
  • Tax: The row is for a total tax amount that was calculated for the transaction
Price

Identifies the Price for the line item. This defaults to '0.00' on New, but will be updated after Save to display the number of decimals that is set on the corresponding Item's master file record for Price Decimals.  This is editable while in status of New. 

Note: This will be blank if the Line Type = Tax

Database Fields: ERPx_APTransactionLine.Price 

Price List ID

Identifies the ID of the Price List that is assigned to the transaction.

Price Lists are used to store a group of Items with pre-defined prices and effective dates.

Database Fields: ERPx_MFPriceListHeader.PriceListID, ERPx_APTransactionHeader.PriceListHeaderSK

Quantity

Identifies the Quantity for the line item. This defaults to '1.00' on New, but will be updated after Save to display the number of decimals that is set on the corresponding Item's master file record for Unit/Weight Decimals depending on the UOM selected.  This is editable while in status of New. 

Note: This will be blank if the Line Type = Tax

Database Fields: ERPx_APTransactionLine.Quantity

Site Name

Identifies the name of the Site (Warehouse) that the transaction, shipment, receipt, item, or lot is associated with. 

Database Fields: ERPx_MFSite.SiteName, ERPx_APTransactionHeader.SiteSK

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".

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Tax Class

Tax Classes store all the Tax Details (individual taxes) used to calculate sales tax on Quick Sales, Fisherman Sales, and Tender Resale transactions. 

Database Field: ERPx_APTransactionHeader.TaxClassSK

Tender

Identifies the ID of the Tender account that is assigned to the transaction.

A Tender is a vessel that is attendant to other vessels and is used to transport or ferry unprocessed fish or shellfish received from another vessel to a shoreside processor or mothership.  Tender vessels operate, in most circumstances, as an agent for a specific processor and take deliveries from harvesting vessels.

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.FromVendorSK 

Tender Name

Identifies the name of the Tender assigned to the transaction or master file. This is set in the Fishermen & Tenders Record View.

A Tender is a vessel that is attendant to other vessels and is used to transport or ferry unprocessed fish or shellfish received from another vessel to a shoreside processor or mothership.  Tender vessels operate, in most circumstances, as an agent for a specific processor and take deliveries from harvesting vessels.

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.FromVendorSK 

Trans Created

Identifies the Created Date & Time of the record, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user. This is required and is not editable.

Database Field: ERPx_APTransactionHeader.CreatedDate

Trans Created By

Identifies the name of the user that created the record. 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. This is required and is not editable.

Database Field: ERPx_APTransactionHeader.CreatedBy

Trans 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. This is required and is not editable.

Database Field: ERPx_APTransactionHeader.LastUpdated

Trans Last Updated By

Identifies 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. This is required and is not editable.

Database Field: ERPx_APTransactionHeader.LastUser

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'. Clicking on the hyperlink opens the transaction record view.

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. 

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

UOM

A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.

Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK


Related Topics

Correcting Fish Tickets (UG)

Entering New Fish Tickets (UG)

Repricing Fish Ticket Items (UG)

Repricing Delivery Ticket Premiums & Taxes

Voiding Fish Tickets (UG)


 Page Definitions

Page Definitions


 Technical Details

Technical Details