Column Filter Show/Hide

Delete

Edit

Excel

Favorites

Group By Show/Hide

Help

Mass Update

• Status

New

Print

Quick Column Filter

Saved Layouts

Fields

Description

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

Currency

Identifies the currency of the Payment Receipt. 

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_ARTransactionHeader.CurrencySK

Customer ID

Database Field: ERPx_ARTransactionHeader.CustomerSK

Customer Name

Database Fields: ERPx_ARCustomer.CustomerName, ERPx_ARTransactionHeader.CustomerSK

GL Date

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 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 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. 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. This is a calculated field that is not stored in the database.