The purpose of this page is to show all the open, Posted, Void, and Replaced transactions based upon what parameters are set in the Search Filter criteria.

This list view also contains columns for each Attribute that is set up for the 'AP Purchasing' and 'Items' attribute types. Because these are user defined, they are not included in the default view but can be added a saved layout. AP Purchasing and Items attributes are not included in the help documentation.

Software Version: 2023.08.31 and newer

[ 1 Page Header ] [ 1.1 Search ] [ 2 Page Detail ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Search

Filter Items	Description

Filter Items	Description
Auto Hide Filters
Auto Refresh on Open
Also Include	Voids & Replaced Unposted Transactions
Date Option	Doc Date GL Date
Date Range
Saved Searches
Search	Description Doc No Purchase Order Transaction Vendor ID Vendor Name
Transaction Class	The values in this lookup are listed alphabetically. If there is more than one Transaction Class for the Transaction Type, then the value in the lookup will display as [Transaction Type] - [Transaction Class]. This is a multi-select standard lookup that is not required to return results. It defaults as blank. The lookup contains a list of all 'Active' AP Transaction Classes.
Vendor	Used to select one or more Vendors. This is a multi-select standard lookup that is not required to return results. It defaults as blank. The lookup contains a list of all 'Active' Vendors.
Vendor Class	This is a multi-select standard lookup that is not required to return results. It defaults as blank. The lookup contains a list of all 'Active' AP Vendor Classes.

Page Detail

Toolbar Icons	Description

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

Mass Update

Pmt./Apply Hold: Used to place one or more transactions on a Payment Hold.

More Actions

IQ: PO Linked Transactions - Opens the "PO Linked Transactions" inquiry showing the Purchase Order and all AP Invoices, AP Credit Memos, and Inventory Receipts associated with it.
RV: Transaction - Opens the Transaction Record View in a new Tab.
RV: Purchase Order - Opens the record view of the Purchase Order. If there is not a linked PO, a message will appear indicating "There is no Purchase Order for this transaction."
View in PaperVision - This is only visible when the preferences for PaperVision are configured.
Void Transaction -

Print

Quick Column Filter

Refresh

Saved Layouts

Search Options

Fields

Description

Checkbox

Amount

This is calculated from the sum of all transaction lines 'Amount'. This can only be edited by changing the quantity and/or price of one or more transaction lines.

Database Field: ERPx_APTransactionHeader.ExtendedAmount

Comment

This can be edited from the 'Comment' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable, even after the transaction is Posted.

Database Field: ERPx_APTransactionHeader.Description

Created

Database Field: ERPx_APTransactionHeader.CreatedDate

Created By

Database Field: ERPx_APTransactionHeader.CreatedBy

Currency

This comes from the 'Currency' on the 'Properties' tab of the Invoice/Credit Memo Record View. This is not editable on the transaction.

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK

Doc Date

This can be edited from the 'Doc Date' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc No

This can be edited from the 'Doc No' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the transaction/Invoice # assigned by your Vendor. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.DocNumber

GL Date

This is required and can be edited from the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. If not manually edited, this will be automatically set to match the 'Doc Date' when the transaction is saved with a Status of either Approved or Ready to Post. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.GLDate

GL Period

This is required and calculated using the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This can only be edited by changing the GL Date.

GL Year

This is required and calculated using the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This can only be edited by changing the GL Date.

Last Updated

Database Field: ERPx_APTransactionHeader.LastUpdated

Last Updated By

Database Field: ERPx_APTransactionHeader.LastUser

Linked Receipt Transaction ID

Identifies the transaction ID from the linked Receipt transaction. This is not required and not editable. This will be populated if a Receipt was created from this AP Invoice/Credit Memo or if the AP Invoice/Credit Memo was auto-created from the Receipt. If a Receipt was linked but was either deleted or voided, the link will be removed. This feature has not been implemented yet.

Database Field: ERPx_APTransactionHeader.LinkedReceiptSK

Payment Terms

This can be edited from the 'Payment Terms' on the 'Properties' tab of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New.

Database Fields: ERPx_MFPaymentTerms.PaymentTermName, APTransactionHeader.PaymentTermSK

Pmt./Apply Hold

Displays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold. This can be edited from the 'Pmt./Apply Hold' on the 'Properties' tab of the Invoice/Credit Memo Record View. This is always editable, even for posted transactions as long as they have not yet been fully applied.

Invoices on hold will not be selected for payment when building AP Check Batches.
Credit Memos on hold cannot be selected to apply to open Invoice

Database Field: ERPx_APTransactionHeader.IsOnApplicationHold

PO #

This can be edited from the 'PO #' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the purchase order you used when making the purchase. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.PurchaseOrderID

Reference

This is text box that is not required and is always editable even after the transaction is posted.

Status

This can be edited from the 'Status' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the status of the transaction. This is always editable while the transaction is in a Status of 'New' or 'Approved'.

The Statuses that apply to transactions in this Inquiry include:

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Clicking on this link opens the AP Invoice / Credit Memo Record View for the selected record. This is a system assigned number that comes from the 'Transaction Class' and is not editable by users.

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Class ID

This comes from the 'Transaction Class ID' on the 'Properties' tab of the Invoice/Credit Memo Record View. This is not editable.

Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK

Transaction Type

This is required and comes from the Transaction Type selected when starting a new transaction. This is never editable.

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

Vendor Class ID

This is required and comes from the 'Vendor Class' assigned to the 'Vendor' that is selected on the 'Home' tab of the Invoice/Credit Memo Record View. Because this defaults from the Vendor it is not editable on the transaction.

Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK

Vendor ID

This is required and represents the ID of the 'Vendor' on the 'Home' tab of the Invoice/Credit Memo Record View. This is only editable by changing the Vendor assigned to the transaction.

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

Vendor Name

This is required and represents the name of the 'Vendor' on the 'Home' tab of the Invoice/Credit Memo Record View. This is only editable by changing the Vendor assigned to the transaction.

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

Invoice History Inquiry

Page Header

Search

Page Detail