Payment Receipts Inquiry (FA)
- Tom Williams
- Emma Greenwood
- Alexander Moritz (Unlicensed)
- Janice Dannenberg (Unlicensed)
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: 2023.08.11 and newer
Page Header
Search
Filter Items | Description |
|---|---|
| Auto Hide Filters |  A 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.
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 Open |  A non-required text box that defaults as checked and is used to determine if the inquiry opens with or without data in the grid.
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 Date | Used 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 Searches |  Displays 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 Icons | Description |
|---|---|
| Column Filter Show/Hide |  Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column. |
| Excel |  Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid 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.
|
| Group By Show/Hide |  Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. |
| Help |  Opens the online WIKI help page for the current page. |
| More Actions |
|
 Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. When clicked, all the Reports that launch from the Print Dialog that are assigned to this page, and that the user has rights to (if Report Data Access is enabled) are displayed. | |
| Refresh |  Re-queries the contents of the grid/page based on the Search Options or the default values for grids that do not support Search Options.
|
| Fields | Description |
| Checkbox | Used 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. Database Field: ERPX_APVendor.VendorID |
| Account Name | The 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. Database Field: ERPx_APTransactionHeader.CheckbookSK |
| Checkbook Currency | Identifies the Currency assigned to the Checkbook that is assigned to the transaction. This is set in the Checkbook Master File. |
| Checkbook Description | Shows 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. 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. 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. 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 ID | A 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. Database Field: ERPx_APTransactionHeader.GLDate |
| GL Period | Identifies the Fiscal Period based on the GL date on the source transaction or manual journal entry. |
| GL Year | Identifies 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. 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. 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 #. Database Field: ERPx_APTransactionHeader.DocNumber |
| Receipt Amt. | Identifies the amount of the payment you received, formatted in the Company Currency specified. Database Field: ERPx_APTransactionHeader.ExtendedAmount |
| Receipt Date | Identifies the date the Receipt was actually received. 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. Database Field: ERPx_APTransactionHeader.CashReceiptType |
| Status | Identifies the Status of the transaction. Database Field: ERPx_APTransactionHeader.TransactionStatusSK |
| Transaction | Identifies the unique Transaction ID for each transaction. 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. |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.