Versions Compared

Old Version 6

changes.mady.by.user Tom Williams

Saved on

compared with

New Version Current

changes.mady.by.user Emma Greenwood

Saved on

Key

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

Description:

Software Version: 2021.06.18 and newer

Table of Contents
exclude(Toolbar Icons|Column Headers)
typeflat

Page Header

...

Filter Items

...

The lookup contains a list of all 'Active' Fisherman Classes.

...

The lookup contains a list of all Fishermen, Tenders, Fishermen & Tenders, and Loans.

...

The Fisherman Transactions inquiry lists all the transactions posted against a Fisherman Account. From here, users can open the transaction, the Journal Details, or the Fisherman record view.

Software Version: 2021.06.18 and newer

Table of Contents
exclude(Toolbar Icons|Column Headers)
typeflat

Page Header

Filter Items

Description
Auto Hide Filters
Insert excerpt
Auto Hide Filters
Auto Hide Filters
nopaneltrue
Auto Refresh on Open
Insert excerpt
Auto Refresh on Open
Auto Refresh on Open
nopaneltrue
Account Class

Insert excerpt
Inq - Vendor Class
Inq - Vendor Class
nopaneltrue
This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Vendor
Type
Class
Def - Vendor
Type
Class
nopaneltrue

This lookup contains the values in the APVendorType Enumeration Class where Enumeration Value is 2, 3, 4, or 5.

Date

The lookup contains a list of all 'Active' Fisherman Classes.

Account NameDate Control Text Box

Insert excerpt

Date Control Text Box

Inq - Fishermen
Inq - Fishermen
nopaneltrue

Date Option

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Date Type Lookup

Insert excerpt

Date Type Lookup

Def - Fisherman
Def - Fisherman
nopaneltrue

  • Transaction Date
  • GL Date
Include

Insert excerpt

Inq

Def -

Include

Fisherman & Tender

Inq

Def -

Include

Fisherman & Tender
nopaneltrue

  • Open Transactions. Select to include unposted transactions. Selected by default.
  • Posted. Select to include Posted transactions. Selected by default.
  • Void Transactions. Select to include Voided transactions. Not selected by default.
  • Beginning Balances. Select to display and compute beginning balances.
Saved SearchesSearch Options for Framework 3.0 - Global

Insert excerpt
Def - Tender
Def - Tender
nopaneltrue
Insert excerpt

Search Options for Framework 3.0 - Global

Def - Loan
Def - Loan
nopaneltrue

Search


The lookup contains a list of all Fishermen, Tenders, Fishermen & Tenders, and Loans.

Account Type

Insert excerpt

Search

Inq -

Search Options

Vendor Type

Search

Inq -

Search Options

Toolbar Icons

DescriptionColumn Filter Show/Hide Insert excerptColumn Filter Show/Hide - GlobalColumn Filter Show/Hide - Global

Vendor Type
nopaneltrue

  • Account ID 
  • Account Name
  • Transaction ID

Page Detail

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Vendor Type
Def - Vendor Type
nopaneltrue

This lookup contains the values in the APVendorType Enumeration Class where Enumeration Value is 2, 3, 4, or 5.

Date
Insert excerpt
Date Control Text Box
Date Control Text Box
nopaneltrue
ExcelDate OptionExcel - LV 3.0

Insert excerpt

Excel - LV 3.0

Date Type Lookup
Date Type Lookup
nopaneltrue

Favorites
  • Transaction Date
  • GL Date
IncludeFavorites Add/Remove - Global

Insert excerpt

Favorites Add/Remove - Global

Inq - Include
Inq - Include
nopaneltrue

Group By Show/Hide Insert excerptGroup By Show/Hide - GlobalGroup By Show/Hide - GlobalnopaneltrueHelp Insert excerptHelp - Global 3.0Help - Global 3.0nopaneltrueMore Actions Insert excerptMore Actions - Global 3.0More Actions - Global 3.0nopaneltrue
  • RV: Fisherman/Loan Account: Opens the Account Record View. 
  • RV Journal Details: Opens the Journal Entry Record View for the selected transaction.
  • RV Transaction: Opens the transaction record view for the selected transaction.
Quick Column Filter Insert excerptQuick FilterQuick FilternopaneltrueRefresh Insert excerptRefresh - Global 3.0Refresh - Global 3.0nopaneltrueSaved Layouts Insert excerptColumn Layouts for Framework 3.0 - GlobalColumn Layouts for Framework 3.0 - GlobalnopaneltrueSearch Options Insert excerptSearch Options - Inquiry Grid 3.0Search Options - Inquiry Grid 3.0nopaneltrue

Fields

DescriptionAccount ID Insert excerptAccount IDAccount IDnopaneltrue

Database Fields: ERPx_APVendor.VendorID

Account Name Insert excerptAccount NameAccount Namenopaneltrue

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK (Payment Receipt, Fisherman Sale & Tender Resale), ERPx_APTransactionLine.ToDistributionAccountSK (Adjustment & Balance Transfer), ERPx_APTransactionHeader.VendorSK (AP Invoice & AP Credit Memo), ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK (Fish Ticket), ERPx_APSettlementTransaction.SettleToEntitySK (Payment), ERPx_APPoHeader.VendorSK (Purchase Order)

Account Type

Identifies the type of account the transaction is associated with. This comes from the 'Vendor Type' field on the 'Properties' tab of the Vendor Class Record View. This field is only editable when the 'Vendor Class' is updated for the associated Account.

Insert excerptDef - Vendor TypeDef - Vendor Typenopaneltrue

Database Field: ERPx_APVendor.VendorTypeEN

Date Insert excerptDoc DateDoc Datenopaneltrue 

Database Field: ERPx_APTransactionHeader.TransactionDate or ERPx_APDeliveryTicketHeader.TicketDate or ERPx_APPoHeader.PODate

Default Settlement Accrual Account Insert excerptDoc DateDoc DatenopaneltrueDescription Insert excerptDescription - HeaderDescription - Headernopaneltrue

This field can be edited from the header 'Description' field on the 'Home' tab or header of the associated transaction. For Payment transactions, this can be edited from the 'Description' field in the grid of the Process Payments Record View. This is always editable while the transaction is in a Status of "New".

Database Field: ERPx_APTransactionHeader.Description or ERPx_APPoHeader.Description

Doc NoGL DateGL PeriodGL YearMaster AccountNet BalanceOpen PO'sOpen TransactionsPosted BalanceStatusTrans TypeTransaction

  • Open Transactions. Select to include unposted transactions. Selected by default.
  • Posted. Select to include Posted transactions. Selected by default.
  • Void Transactions. Select to include Voided transactions. Not selected by default.
  • Beginning Balances. Select to display and compute beginning balances.
Saved Searches
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

  • Account ID 
  • Account Name
  • Transaction ID

Page Detail

Toolbar Icons

Description
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • RV: Fisherman/Loan Account: Opens the Account Record View. 
  • RV Journal Details: Opens the Journal Entry Record View for the selected transaction. This only applies to Posted transactions. 
  • RV Transaction: Opens the transaction record view for the selected transaction.
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
Search Options
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue

Fields

Description
Account ID

Insert excerpt
Account ID
Account ID
nopaneltrue

Database Fields: ERPx_APVendor.VendorID

Account Name

Insert excerpt
Account Name
Account Name
nopaneltrue

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK (Payment Receipt, Fisherman Sale & Tender Resale), ERPx_APTransactionLine.ToDistributionAccountSK (Adjustment & Balance Transfer), ERPx_APTransactionHeader.VendorSK (AP Invoice & AP Credit Memo), ERPx_APDeliveryTicketHeader.FishermanAccountVendorSK (Fish Ticket), ERPx_APSettlementTransaction.SettleToEntitySK (Payment), ERPx_APPoHeader.VendorSK (Purchase Order)

Account Type

Identifies the type of account the transaction is associated with. This comes from the 'Vendor Type' field on the 'Properties' tab of the Vendor Class Record View. This field is only editable when the 'Vendor Class' is updated for the associated Account.

Insert excerpt
Def - Vendor Type
Def - Vendor Type
nopaneltrue

Database Field: ERPx_APVendor.VendorTypeEN

Date

Insert excerpt
Doc Date
Doc Date
nopaneltrue
 


Database Field: ERPx_APTransactionHeader.TransactionDate or ERPx_APDeliveryTicketHeader.TicketDate or ERPx_APPoHeader.PODate

Default Settlement Accrual Account

Insert excerpt
Doc Date
Doc Date
nopaneltrue

Database Fields: ERPx_APVendor.SAGLAcct

Description

Insert excerpt
Comment - Header
Comment - Header
nopaneltrue

This field can be edited from the header 'Description' field on the 'Home' tab or header of the associated transaction. For Payment transactions, this can be edited from the 'Description' field in the grid of the Process Payments Record View. This is always editable while the transaction is in a Status of "New".

Database Field: ERPx_APTransactionHeader.Description or ERPx_APPoHeader.Description

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
This field can be edited from the 'Doc No' field on the 'Home' tab or header of the associated transaction if the transaction contains the field. For Payment Receipt transactions, this field can be edited from the 'Payment #' field on the Payment Receipt Record View. This is always editable while the transaction is in a Status of "New".

Database Field: ERPx_APTransactionHeader.DocNumber

GL Date
Insert excerpt
GL Date
GL Date
nopaneltrue
GL Period
Insert excerpt
GL Period
GL Period
nopaneltrue
GL Year
Insert excerpt
GL Year
GL Year
nopaneltrue
Master Account

Identifies the Master Account assigned to the Account.

Insert excerpt
Def - Master Account - Fisherman
Def - Master Account - Fisherman
nopaneltrue

Net Balance

Displays the total net balance of the transaction. This is calculated as [Posted Balance]+[Open Transactions]-[Open POs]. Negative net balances will appear within parentheses. This field is not editable.

Database Fields: ERPx_APTransactionHeader.ExtendedAmount or ERPx_APDeliveryTicketHeaderTotalNetAmount

Open PO's

Displays the total amount distributed to the Account on a Purchase Order transaction in a Status of "Open". This is a calculated field and is editable by changing the 'Quantity' and/or 'Price' fields for a line item on the Purchase Order Record View while the transaction is in a Status of "New".

Database Field: ERPx_APPoHeader.OrderedAmount

Open Transactions

Displays the total balance of the transaction if the status is "New" or "Approved". Please note that Open Amounts for tickets will display the total amount for the ticket and may not accurately reflect the total amount that will affect the account on posting. Negative balances will appear within parentheses. This is a calculated field and is not editable.

Database Fields: ERPx_APTransactionHeader.ExtendedAmount or ERPx_APDeliveryTicketHeaderTotalNetAmount

Posted Balance

Displays the total balance of the transaction if the status is "Ready to Post" or "Posted". Negative balances will appear within parentheses. This is a calculated field and is not editable.

Database Fields: ERPx_APTransactionHeader.ExtendedAmount or ERPx_APDeliveryTicketHeaderTotalNetAmount

Status

This field will either display "Open", "Posted" or "Void". This can be edited from the 'Status' field on the 'Home' tab or header of the associated transaction. All statuses less than "Ready to Post" will be displayed as "Open". This field is editable while the transaction is in a Status less than "Ready to Post".

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

Insert excerpt
Def - Status - Open
Def - Status - Open
nopaneltrue

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

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

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK or ERPx_APDeliveryTicketHeader.TransactionStatusSK or ERPx_APPoHeader.TransactionStatusEN

Trans Type

Insert excerpt
Transaction Type
Transaction Type
nopaneltrue
This comes from the Transaction Type selected when starting a new transaction. This is never editable.

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK or ERPx_APDeliveryTicketHeader.TransactionClassSK or ERPx_APPoHeader.TransactionTypeEN

Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
Clicking on this link opens the transaction record view for the selected record. This is a system assigned number that comes from the 'Transaction Class' and is never editable.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database Field: ERPx_APTransactionHeader.TransactionID or ERPx_APDeliveryTicketHeader.TicketNumber or ERPx_APPoHeader.PurchaseOrderID

Related Topics


Expand
titlePage Definitions


...