Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 14 Current »

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: 2020.01.13 and newer

Page Header

Toolbar IconsDescription
Excel Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, 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 LayoutOpens 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.

Inquiry Criteria

Opens Inquiry Criteria window where users can define the following criteria: 

  • 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". 
PrintOpens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. 
RefreshRe-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. 
FieldsDescription
CheckboxUsed to select one or more records for Mass Update or Delete.
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

Identifies the Checkbook assigned to the transaction. 

Linked Database Field: ERPx_APTransactionHeader.CheckbookSK

Checkbook CurrencyIdentifies the Currency assigned to the Checkbook that is assigned to the transaction. This is set in the Checkbook Master File
Checkbook DescriptionShows the value in the 'Checkbook Description' of the Checkbook assigned to the transaction. This value is set in the Checkbook Master File
Comment

Shows the Comment entered for the transaction or transaction line.  The value comes from the 'Description' field of the Payment Receipt.

Linked Database Field: ERPx_APTransactionHeader.Description

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.

Linked Database Field: ERPx_APTransactionHeader.CreatedDate

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.

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

Identifies the date the transaction posted (or will post) to the general ledger. 

This date comes from the Receipt Date.

Linked Database Field: ERPx_APTransactionHeader.GLDate

GL PeriodIdentifies the Fiscal Period based on the GL date on the source transaction or manual journal entry.
GL YearIdentifies the Fiscal Year based on the GL date on the source transaction or manual journal entry.
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.

Linked Database Field: ERPx_APTransactionHeader.LastUpdated

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.

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

Identifies the Status of the transaction.

Linked Database Field: ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Identifies the unique Transaction ID for each transaction.

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



 Page Definitions

Page Definitions


 Technical Details

Technical Details

  • No labels