Versions Compared

Key

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

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

...

Search OptionsDescription
Auto Hide Filters
Insert excerpt
Auto Hide Filters
Auto Hide Filters
nopaneltrue
Auto Refresh on Open
Insert excerpt
Auto Refresh on Open
Auto Refresh on Open
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.

Include Open TransactionsA 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
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
Trans. DateA 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
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide

Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue

Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • RV: Journal Details - Opens the Journal Details page showing the journal details for the selected payment receipt
  • RV: Transaction - Opens the Payment Receipt record view for the selected payment receipt 
Print
Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
Search Options
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue

Fields

Description
Checkbox
Insert excerpt
Checkbox (Tag)- RV
Checkbox (Tag)- RV
nopaneltrue
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

Insert excerpt
Checkbook
Checkbook
nopaneltrue

Database Field: ERPx_ARTransactionHeader.CheckbookSK

Checkbook Currency

Insert excerpt
Checkbook Currency - LV
Checkbook Currency - LV
nopaneltrue

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_MFCheckbook.CurrencySK, ERPx_ARTransactionHeader.CurrencySK

Checkbook Description 

Insert excerpt
Checkbook Description - LV
Checkbook Description - LV
nopaneltrue

Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_ARTransactionHeader.CheckbookSK

Comment

Insert excerpt
Comment
Comment
nopaneltrue

Database Field: ERPx_ARTransactionHeader.Description

Created

Insert excerpt
Created
Created
nopaneltrue

Database Field: ERPx_ARTransactionHeader.CreatedDate

Created By 

Insert excerpt
Created By
Created By
nopaneltrue

Database Field: ERPx_ARTransactionHeader.CreatedBy

Customer ID

Insert excerpt
Def - Customer ID
Def - Customer ID
nopaneltrue

Database Field: ERPx_ARTransactionHeader.CustomerSK

Customer Name 

Insert excerpt
Def - Customer Name
Def - Customer Name
nopaneltrue

Database Fields: ERPx_ARCustomer.CustomerName, ERPx_ARTransactionHeader.CustomerSK

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 if a GL date does not already exist on the transaction.

Linked Database Field: ERPx_ARTransactionHeader.GLDate

GL Period 
Insert excerpt
GL Period
GL Period
nopaneltrue
GL Year
Insert excerpt
GL Year
GL Year
nopaneltrue
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

Insert excerpt
Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_ARTransactionHeader.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue

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.

(lightbulb) Since the 'Receipt Date' can impact a Currency Gain / Loss when it is applied, it the cannot be edited once an application exists for receipts that are not in the Home Currency. If you need to change the 'Receipt Date', you must unapply all the transactions that are currently applied.

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

Insert excerpt
Status
Status
nopaneltrue

Database Field: ERPx_ARTransactionHeader.TransactionStatusSK

Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue

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. 


Related Topics



Expand
titlePage Definitions

Page Definitions


...