Versions Compared

Key

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

The purpose of the Payment Receipts Inquiry is to view all the Payment Receipts that were received in the Fisherman Accounting Functional Area. From here, users can review Payment Receipts, apply/unapply Payment Receipts, open the Payment Receipt transaction, and/or open the Deposit the Payment Receipt was deposited on. This inquiry is typically used to view posted Payment Receipts but all Payment Receipts, including open (unposted) Payment Receipts can be found here.

Software Version: YYYY2020.MM01.DD 10 and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Excel
Insert excerpt
Excel - Global
Excel - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout
Grid Layout
nopaneltrue
Help
Insert excerpt
Help - Global Icon
Help - Global Icon
nopaneltrue
Inquiry Criteria

Insert excerpt
Inquiry Criteria - Global
Inquiry Criteria - Global
nopaneltrue

  • Checkbook: a multi-select lookup to select one or more Checkbooks. If left blank, the data will not be limited by this parameter. If one or more values are selected then only Payment Receipts for the selected Checkbooks will be returned.
  • Receipt Date From: a text box to enter the beginning date range (from date) of the Payment Receipt records you are selecting. If blank the data will not be limited by this parameter. If entered, it must be a valid date format and must be <= the 'Receipt Date To' parameter. This defaults to 90 days from the current date but can be changed to any valid date that is <= the 'Receipt Date To'.
  • Receipt Date To: a text box to enter the ending date range (to date) of the Payment Receipt records you are selecting. If blank the data will not be limited by this parameter. If entered, it must be a valid date format and must be >= the 'Receipt Date From' parameter. This defaults to blank but can be changed to any valid date that is >= the 'Receipt Date From'.
  • Include Open Transactions: a Yes/No lookup to identify if the data returned includes open (unposted) Payment Receipts. This defaults to "no" but can be changed to "Yes". 
Print
Insert excerpt
Print - Global
Print - Global
nopaneltrue
Refresh
Insert excerpt
Refresh - Global
Refresh - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox (Tag)- RV
Checkbox (Tag)- RV
nopaneltrue
Account ID

Identifies the ID of the Fisherman, Tender, or Loan the Payment Receipt was received from.

Linked Database Field: ERPX_APVendor.VendorID

Account NameThe value from the 'Vendor Name' property, of the Fisherman & Tender or Loan Master File, for the account that is assigned to the transaction. This is a referential value that comes from ERPX_APVendor.VendorName
Applied Amt.Identifies how much of the Receipt, in the Receipt currency, has been applied. This defaults to 0.00 but will re-calculate as the receipt is applied. Receipts can be posted without applying, but if they have been applied, this amount will be >0.00. This is a calculated field that is not editable on this page. This field is not linked to a Database Field.
Checkbook

Insert excerpt
Checkbook - List View/Inquiry Field
Checkbook - List View/Inquiry Field
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CheckbookSK

Checkbook Currency
Insert excerpt
Checkbook Currency - List View/Inquiry Field
Checkbook Currency - List View/Inquiry Field
nopaneltrue
Checkbook Description
Insert excerpt
Checkbook Description - List View/Inquiry Field
Checkbook Description - List View/Inquiry Field
nopaneltrue
Comment

Insert excerpt
Comment - List View/Inquiry Field
Comment - List View/Inquiry Field
nopaneltrue
 The value comes from the 'Description' field of the Payment Receipt.

Linked Database Field: ERPx_APTransactionHeader.Description

Created

Insert excerpt
Created (Date & Time) - List View/Inquiry
Created (Date & Time) - List View/Inquiry
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CreatedDate

Created By

Insert excerpt
Created By- List View / Inquiry
Created By- List View / Inquiry
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CreatedBy

Deposit IDA hyperlink that displays the Transaction ID of the Deposit the Payment Receipt was included on.
GL Date

Insert excerpt
GL Date - List View/Inquiry Field
GL Date - List View/Inquiry Field
nopaneltrue

This date comes from the Receipt Date.

Linked Database Field: ERPx_APTransactionHeader.

Description

GLDate

GL Period
Insert excerpt
GL Period - List View/Inquiry Field
GL Period - List View/Inquiry Field
nopaneltrue
GL Year
Insert excerpt
GL Year - List View/Inquiry Field
GL Year - List View/Inquiry Field
nopaneltrue
Last Updated

Insert excerpt
Last Updated (Date & Time) - List View/Inquiry
Last Updated (Date & Time) - List View/Inquiry
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.LastUpdated

Last Updated By

Insert excerpt
Last Updated By - List View/Inquiry
Last Updated By - List View/Inquiry
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.LastUser

Payment #

Identifies the value entered in the 'Reference #' field. This identifies the number of the payment you received, most often associated with the Check #. 

Linked Database Field: ERPx_APTransactionHeader.DocNumber

Receipt Amt.

Identifies the amount of the payment you received, formatted in the Company Currency specified. 

Linked Database Field: ERPx_APTransactionHeader.ExtendedAmount

Receipt Currency

Identifies the currency of the Payment Receipt. This is automatically set to the Company Currency.

Linked Database Field: ERPx_MFCurrency.CurrencyID

Receipt Date

Identifies the date the Receipt was actually received.

Linked Database Field: ERPx_APTransactionHeader.TransactionDate

Receipt Type

Identifies the type of the Receipt. 

The lookup contains all the values in the MFCashReceiptType Enumeration Class. 

Linked Database Field: ERPx_APTransactionHeader.CashReceiptType

Status

Insert excerpt
Status - List View/Inquiry Field
Status - List View/Inquiry Field
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Insert excerpt
Trans. ID - List View/Inquiry Field
Trans. ID - List View/Inquiry Field
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.TransactionID

Unapplied Amt.

Identifies how much of the Receipt still needs to be applied. This will re-calculate as the receipt is applied. Receipts can be posted without applying, but if they have been applied, this amount will be >0.00 and < 'Amount'. This is a calculated field that is not editable.

Related Topics



Expand
titlePage Definitions

Page Definitions


...