Auto Hide Filters

Auto Refresh on Open

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

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.

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

More Actions

• 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

Quick Column Filter

Refresh

Saved Layouts

Search Options

Checkbox

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

Database Field: ERPx_ARTransactionHeader.CheckbookSK

Checkbook Currency

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

Checkbook Description 

Database Fields: ERPx_MFCheckbook.CheckbookDescription, ERPx_ARTransactionHeader.CheckbookSK

Comment

Database Field: ERPx_ARTransactionHeader.Description

Created

Database Field: ERPx_ARTransactionHeader.CreatedDate

Created By 

Database Field: ERPx_ARTransactionHeader.CreatedBy

Customer ID

Database Field: ERPx_ARTransactionHeader.CustomerSK

Customer Name 

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

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 

GL Year

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

Database Field: ERPx_ARTransactionHeader.LastUpdated

Last Updated By

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.

 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

Database Field: ERPx_ARTransactionHeader.TransactionStatusSK

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.