Auto Hide Filters

Auto Refresh on Open 

Date Range

A text box to identify the method for selecting a date range, a specific date, or a min/max date.  This defaults to 'Last 30 Days' and is always editable. 

Group By

A single select lookup that identifies the transaction types that were applied.  This defaults based on which inquiry option was selected from the Vendor Balances List View.  If the IQ: Invoice Applications option was selected this Group By lookup will display 'Invoices' and the data in the grid will show the AP Invoice information and which transaction is applied to it.  If the IQ: Payment Applications option was selected then this Group By lookup will display 'Payments & Credit Memos' and the data in the grid will show the Payment / Credit Memo information and which transaction is applied to it. 

Saved Searches

Vendor

A multi-select lookup that defaults to the Account(s) that was selected prior to clicking the Apply Documents button on the Vendor Balances list view. If no Account was selected, all the accounts that were visible in the grid will default in the lookup. 

Column Filter Show/Hide

Excel

Group By Show/Hide

Help

Quick Column Filter

Refresh

Saved Layouts

Search Options

Fields

Description

Checkbox

Used to select one transaction to apply a document to.

Applied Doc No

Displays the Doc No of the applied transaction. This comes from the 'Doc No' on the Home tab of the corresponding Invoice and will be blank for Payments. 

Database Field: ERPx_APTransactionHeader.DocNumber (Invoice/Credit Memo)

Applied Transaction 

Displays the Transaction ID of the applied transaction. This field is a hyperlink displaying the transaction ID, which opens the corresponding transaction record.

Database Fields: ERPx_APTransactionHeader.TransactionID (Invoice/Credit Memo), ERPx_MFTransactionBatch.TransactionID (Payment)

Applied Transaction Amount

Displays the total amount of the applied transaction. This field is for information and is never editable.

Database Field: ERPx_APSettlementApplication.AppliedAmount

Applied Transaction Date

Displays the transaction date of the applied transaction record. For Invoices this is the 'Doc Date' on the Home tab of the transaction and for Payments this is the 'Pmt. Date'. This field is for information use and is never editable.

Database Field: ERPx_APSettlementApplication.ApplicationDate

Applied Transaction Type

Displays the type of Transaction that is applied to the corresponding Invoice/Payment. If this page is opened from 'IQ: Invoice Applications' the value will either be 'Payment' or 'Credit Memo'.  If this page is opened from 'IQ: Payment Applications' the value will be 'Invoice'.  This field is never editable. 

Database Field: ERPx_APTransactionType.TransactionName

Discount Taken

Displays the dollar amount of a discount that was used during the application process. This field is for informational use and is never editable.

Database Field: ERPx_APSettlementApplication.DiscountTakenAmount

Doc No

Database Fields: ERPx_APTransactionHeader.DocNumber (Credit Memo), ERPx_MFTransactionBatch.TransactionID (Payment)

Remaining Amount

A non-editable text box to display the balance remaining after entry of any 'Applied Amount' and 'Terms Discount Taken' amounts. This is calculated as ([Original Amount]-[sum of all applied amounts]-[Terms Discount Taken]). This is not directly editable but updates as the 'Applied Amount' and 'Terms Discount Taken' values are edited. 

This is a calculated field that is not stored in the database. 

Transaction

A non-editable text box to display the transaction information including the original transaction amount and the unapplied amount, if applicable.  If this page is opened from 'IQ: Invoice Applications' the information is displayed as: [Doc No] - [TransactionID] Invoice Amt: [ExtendedAmount] Unapplied Amount: 'calculated amount'.  If this page is opened from 'IQ: Payment Applications' the information is displayed as [Payment #] Payment Amt: [TransactionTotalAmount] Unapplied Amount: 'calculated amount'. 

Transaction

Database Fields: ERPx_APTransactionHeader.TransactionID (Credit Memo), ERPx_MFTransactionBatch.TransactionID (Payment)

Transaction Amount

A non-editable numeric textbox to display the total transaction amount of the Invoice/Payment prior to any applications.

Database Fields: ERPx_APTransactionHeader.ExtendedAmount (Invoice/Credit Memo), ERPx_MFTransactionBatch.TransactionTotalAmount

Transaction Type

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionClass.TransactionTypeSK, ERPx_APTransactionHeader.TransactionClassSK

Vendor

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK (Credit Memo), ERPx_MFCheckbookTransaction.EntitySK (Payment)