Versions Compared

Version Old Version 14 New Version Current
Changes made by

Emma Greenwood

Emma Greenwood

Saved on

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

Table of Contents
typeflat

Page Header


Filter Items

Description
Auto Hide FiltersImage AddedA non-required text box that defaults as checked and is used to determine if the Search Options should be hidden when the Inquiry runs or is refreshed.
  • When checked, each time the 'Refresh' button is clicked, the search options will be hidden, allowing for more rows of data to be visible on the page. This behavior is ideal for users that have entered their search parameters and want to see the results in full-screen. 
  • When unchecked, the search options will not be hidden when the 'Refresh' button is clicked. This behavior is ideal for users that need to run several searches with different search parameters.

Users can only change the default value of this setting with a custom search in the "Saved Searches" lookup. If you change the default setting but do not save it in a custom search, it will only remain this way while the page is opened.

Refer to this FAQ for advanced search options.

Auto Refresh on OpenImage AddedA non-required text box that defaults as checked and is used to determine if the inquiry opens with or without data in the grid.
  • When checked, each time the page is opened, the search is run using the default parameters (or a 'Saved Search' if one was set as your default for the page) so the grid will be populated with data .  
  • When unchecked, the search is NOT run when the page opens and no data will be present until the 'Refresh' button is clicked. 

Users can only change the default value of this setting with a custom search in the "Saved Searches" lookup.

Refer to this FAQ for advanced search options.

Checkbook

A multi-select lookup to select one or more Checkbooks.  If one or more values are selected then only Payment Receipts for the selected Checkbooks will be returned.  This defaults to 'All' checkbooks and contains all the active Checkbooks setup in the system. 

Include Open Transactions

Used to specify whether transactions in a status of New and Approved should be included.  This is a single select lookup that defaults to No and is required to return results.  The lookup contains the values "Yes" and "No". If "Yes" is selected any open Payment Receipts will be included in the search and if "No" is selected, only Posted transactions will be included. 

Trans DateUsed to select the date of the transaction. This is a date range control that allows users to select a single date or a range of dates, formatted from the users 'Date Format' preference. This is required to return results and defaults with a date range of the last 30 days.

For help on using this control refer to the FAQ Article Using the NorthScope Date Control.

Saved SearchesImage AddedDisplays the saved searches lookup and related icons. This tool allows users to select previously saved search options, create a new set of search options, save changes to existing search options, forget/delete saved search options and/or assign a saved search option as the default for the page. Once changes are made to the search options, the user can click the Save Options icon and save the changes. Saving search options will also save the preferences for 'Auto Refresh on Open' and 'Auto Hide Filters'. The new search option can also be set as the default.  Default searches can be removed by clicking the 'Set as Default' button again when the current default search is selected.  

Refer to this FAQ for advanced search options.


Page Detail

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - Global (old)LV 3.0
Excel - Global (old)LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid LayoutGroup By Show/Hide
Insert excerpt
Grid Layout Group By Show/Hide - GlobalGrid Layout
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
Inquiry CriteriaMore Actions

Insert excerpt
Inquiry Criteria More Actions - Global Inquiry Criteria 3.0
More Actions - Global 3.0
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"RV: Deposit: Opens the Deposit record in a new tab that is associated with the selected Payment Receipt. 
  • Void: Opens the Void page to void the selected Payment Receipt.  Payment Receipt's on a Deposit record cannot be voided until the Deposit record has been voided and only Posted Payment Receipts can be voided. 
Print
Insert excerpt
Print - GlobalLV 3.0
Print - GlobalLV 3.0
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
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
Checkbook
nopaneltrue

Linked

Database Field: ERPx_APTransactionHeader.CheckbookSK

Checkbook Currency
Insert excerpt
Checkbook Currency - LV
Checkbook Currency - LV
nopaneltrue
Checkbook Description
Insert excerpt
Checkbook Description - LV
Checkbook Description - LV
nopaneltrue
Comment

Insert excerpt
Comment
Comment
nopaneltrue
 The value comes from the 'Description' field of the Payment Receipt.

Linked Database Field: ERPx_APTransactionHeader.Description

Created

Insert excerpt
Created
Created
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CreatedDate

Created By

Insert excerpt
Created By
Created By
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CreatedBy

Currency

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

Database Field: ERPx_MFCurrency.CurrencyID

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

Insert excerpt
GL Date
GL Date
nopaneltrue

This date comes from the Receipt Date.

Linked Database Field: ERPx_APTransactionHeader.GLDate

GL Period
Insert excerpt
GL Period
GL Period
nopaneltrue
GL Year
Insert excerpt
GL Year
GL Year
nopaneltrue
Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
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 payment 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
Status
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Insert excerpt
Transaction ID
Transaction ID
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


...