Payment Receipt History Inquiry (Sales)
- Tom Williams
- Emma Greenwood
- Janice Dannenberg (Unlicensed)
The purpose of the Payment Receipt History Inquiry is to view all the Payment Receipts that were received in the Sales Functional Area. From here, users can review 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: 2022.10.31 and newer
Page Header
Search
| Search Options | 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 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. |
| 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". |
| 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. |
| Trans. Date | A text box to identify the method for selecting a date range, a specific date, or a min/max date. This is required to return results and defaults with a date range of the past 30 days. For help on using this control refer to the FAQ Article Using the NorthScope Date Control. |
Page Details
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 |
|
| 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. | |
| Quick Column Filter |  Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
| 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.
|
| Saved Layouts |  Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default. |
| Search Options |  Toggles between displaying and hiding the Search Options portion of the page. |
Fields | Description |
|---|---|
| Checkbox | Used to select one or more records for Mass Update or Delete. |
| Applied Amt. | A non-editable text box to identify how much of the Receipt, in the Receipt currency, has been 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 stored in the database. |
| Checkbook | Identifies the Checkbook assigned to the transaction. Database Field: ERPx_ARTransactionHeader.CheckbookSK |
| Checkbook Currency | Identifies the Currency assigned to the Checkbook that is assigned to the transaction. This is set in the Checkbook Master File. Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_MFCheckbook.CurrencySK, ERPx_ARTransactionHeader.CurrencySK |
| 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. Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_ARTransactionHeader.CheckbookSK |
| Comment | Shows the Comment entered for the transaction or transaction line. Database Field: ERPx_ARTransactionHeader.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_ARTransactionHeader.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_ARTransactionHeader.CreatedBy |
| Customer ID | Customer IDs are used as a short description and the unique identifier for Customers. They can be changed at any time to any alphanumeric value. If you do not have an existing strategy for Customer IDs the 3-3-2 method would be recommended. Database Field: ERPx_ARTransactionHeader.CustomerSK |
| Customer Name | Customer Names are used as a long description for Customer records. Database Fields: ERPx_ARCustomer.CustomerName, ERPx_ARTransactionHeader.CustomerSK |
| 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 if a GL date does not already exist on the transaction. Linked Database Field: ERPx_ARTransactionHeader.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. |
| Home Currency | Identifies the 'Home Currency' of the Company. Database Field: ERPx_MFCurrency.CurrencyID |
| Home Currency Amt. | Identifies the amount of the payment you received, formatted in the 'Home Currency'. This is a calculated field that is not stored in the database. |
| 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_ARTransactionHeader.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_ARTransactionHeader.LastUser |
| Payment # | Identifies the number of the payment, most often associated with the Check #. This field is always editable from the record view, even after the transaction is posted. Database Field: ERPx_ARTransactionHeader.DocNumber |
| Receipt Amt. | Identifies the amount of the payment, formatted in the 'Currency' specified. Database Field: ERPx_ARTransactionHeader.ExtendedAmount |
| Receipt Currency | Identifies the currency of the Payment Receipt. Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_ARTransactionHeader.CurrencySK |
| Receipt Date | Identifies the date the Receipt was actually received. This field is only editable while the transaction Status is "New" but is disabled once an application for this receipt has been made.
Database Field: ERPx_ARTransactionHeader.TransactionDate |
| Receipt Type | Identifies the type of the Receipt. This defaults to "Check" but can be changed. This is required to Approve and/or Post. This field is only editable after a 'Customer' has been selected and while the transaction Status is "New". The lookup contains all the values in the MFCashReceiptType Enumeration Class which includes options of Card, Cash, Check, Electronic, and Other. Database Field: ERPx_ARTransactionHeader.CashReceiptTypeEN |
| Status | Identifies the Status of the transaction. Database Field: ERPx_ARTransactionHeader.TransactionStatusSK |
| Transaction | Identifies the unique Transaction ID for each transaction. Database Field: ERPx_ARTransactionHeader.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 stored in the database. |
Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.
