Versions Compared

Old Version 9

changes.mady.by.user Tom Williams

Saved on

compared with

New Version 10

changes.mady.by.user Tom Williams

Saved on

Key

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

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.

...

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 Class
Def - Vendor Class
nopaneltrue

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

Account Name

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

Insert excerpt
Def - Fisherman
Def - Fisherman
nopaneltrue
Insert excerpt
Def - Fisherman & Tender
Def - Fisherman & Tender
nopaneltrue
Insert excerpt
Def - Tender
Def - Tender
nopaneltrue
Insert excerpt
Def - Loan
Def - Loan
nopaneltrue

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

Account Type

Insert excerpt
Inq - Vendor Type
Inq - Vendor Type
nopaneltrue
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
Date Option

Insert excerpt
Date Type Lookup
Date Type Lookup
nopaneltrue

  • Transaction Date
  • GL Date
Include

Insert excerpt
Inq - Include
Inq - Include
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 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

...

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

...