| Toolbar Icons | Description |
|---|
| Excel | | Insert excerpt |
|---|
| Excel - LV |
|---|
| Excel - LV |
|---|
| nopanel | true |
|---|
|
|
| Favorites | | Insert excerpt |
|---|
| Favorites Add/Remove - Global |
|---|
| Favorites Add/Remove - Global |
|---|
| nopanel | true |
|---|
|
|
| Grid Layout | | Insert excerpt |
|---|
| Grid Layout - Global |
|---|
| Grid Layout - Global |
|---|
| nopanel | true |
|---|
|
|
| Help | | Insert excerpt |
|---|
| Help - Global |
|---|
| Help - Global |
|---|
| nopanel | true |
|---|
|
|
| Inquiry Criteria | | Insert excerpt |
|---|
| Inquiry Criteria - Global |
|---|
| Inquiry Criteria - Global |
|---|
| nopanel | true |
|---|
|
- Date From: a text box to enter a starting Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
- Date To: a text box to enter an ending Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
- Status: a multi-select check box to limit the data that is returned to one or more selected Statuses. Options include: New, Approved, Ready To Post, Posted, Void, Deleted, Replaced. The default values are "New, Approved, Ready To Posted and Posted".
|
| Refresh | Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. |
| Fields | Description |
| Checkbox | Used to select one or more records. |
| Currency | | Insert excerpt |
|---|
| Currency |
|---|
| Currency |
|---|
| nopanel | true |
|---|
|
This comes from the 'Currency ID' on the 'Properties' tab of the Invoice/Credit Memo Record View. This defaults from the Currency setup on the Vendor and is not editable on the transaction. | Insert excerpt |
|---|
| Def - Currency |
|---|
| Def - Currency |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK |
| Distributed To | | Insert excerpt |
|---|
| Distributed To |
|---|
| Distributed To |
|---|
| nopanel | true |
|---|
|
This can be edited from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New. | Insert excerpt |
|---|
| Def - Not Defined |
|---|
| Def - Not Defined |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK |
| Distributed To Type | | Insert excerpt |
|---|
| Distributed To Type |
|---|
| Distributed To Type |
|---|
| nopanel | true |
|---|
|
This is derived from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. Because this defaults from the Vendor, Employee or Project, it is not editable on the transaction . This contains the associated value in the MFDistributionType Enumeration Class.Database Field: ERPx_APTransactionLine.ToMFDistributionTypeEN |
| Doc Date | | Insert excerpt |
|---|
| Doc Date |
|---|
| Doc Date |
|---|
| nopanel | true |
|---|
|
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 Description | | Insert excerpt |
|---|
| Doc Description |
|---|
| Doc Description |
|---|
| nopanel | true |
|---|
|
This
can be edited from the 'Description' 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 |
| Doc No | This comes 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 defaults as blank and is required. This is always editable while the transaction is in a Status of New. Database Field: ERPx_APTransactionHeader.DocNumber |
| Extended | | Insert excerpt |
|---|
| Extended |
|---|
| Extended |
|---|
| nopanel | true |
|---|
|
This comes from the 'Extended' on the Item grid of the Invoice/Credit Memo Record View and is calculated based on the product of the Quantity and Price of the transaction line. This can only be edited by changing the Quantity and/or Price of the transaction line.Database Field: ERPx_APTransactionLine.ExtendedAmount |
| GL Date | | Insert excerpt |
|---|
| GL Date |
|---|
| GL Date |
|---|
| nopanel | true |
|---|
|
This
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 | | Insert excerpt |
|---|
| GL Period |
|---|
| GL Period |
|---|
| nopanel | true |
|---|
|
This can only be edited by changing the GL Date. |
| GL Year | | Insert excerpt |
|---|
| GL Year |
|---|
| GL Year |
|---|
| nopanel | true |
|---|
|
This is a calculated field using the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This can This can only be edited by changing the GL Date.
|
| Item Description | | Insert excerpt |
|---|
| Description - Item |
|---|
| Description - Item |
|---|
| nopanel | true |
|---|
|
This
can be edited from the 'Description' on the Item grid of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New or Approved. Database Field: ERPx_APTransactionLine.LineDescription |
| Payable Account | | Insert excerpt |
|---|
| Payable Account |
|---|
| Payable Account |
|---|
| nopanel | true |
|---|
|
This comes from the Vendor's 'Accounts Payable' on the 'Accounts' tab of the Vendors List View. Because this defaults from the Vendor, it is not editable on the transaction.| Insert excerpt |
|---|
| Def - Not Defined |
|---|
| Def - Not Defined |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.APGLAcctRef |
| Payable Account Description | | Insert excerpt |
|---|
| Payable Account Description |
|---|
| Payable Account Description |
|---|
| nopanel | true |
|---|
|
This comes from the Vendor's 'Accounts Payable' on the 'Accounts' tab of the Vendors List View. Because this defaults from the Vendor, it is not editable on the transaction.
Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef |
| Pmt./Apply Hold | Displays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold. This comes can be edited from the 'Pmt./Apply Hold' on the 'Properties' tab of the Invoice/Credit Memo Record View. This defaults as blank and 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 | | Insert excerpt |
|---|
| Purchase Order |
|---|
| Purchase Order |
|---|
| nopanel | true |
|---|
|
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 |
| Price | This comes can be edited from the 'Price' on the Item grid of the Invoice/Credit Memo Record View. This defaults as "0.00" and is required when the Status is set to Approved. This is always editable while the transaction is in a Status of New. Database Field: ERPx_APTransactionLine.Price |
| Purchase Account | | Insert excerpt |
|---|
| Purchase Account |
|---|
| Purchase Account |
|---|
| nopanel | true |
|---|
|
This comes can be edited from the 'Purchase Account' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is required when the Status is set to Approved. This is always editable while the transaction is in a Status of New. | Insert excerpt |
|---|
| Def - Not Defined |
|---|
| Def - Not Defined |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK |
| Purchase Account Description | | Insert excerpt |
|---|
| Purchase Account Description |
|---|
| Purchase Account Description |
|---|
| nopanel | true |
|---|
|
This
can be edited from the 'Purchase Account' on the Item grid of the Invoice/Credit Memo Record View . This is always editable while the transaction is in a Status of New. Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK |
| Quantity | | Insert excerpt |
|---|
| Quantity |
|---|
| Quantity |
|---|
| nopanel | true |
|---|
|
This can be edited from the 'Quantity' on the Item grid of the Invoice/Credit Memo Record View . This is always editable while the transaction is in a Status of New. Database Field: ERPx_APTransactionLine.Quantity |
| Status | comes 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 always editable while the transaction is in a Status of 'New' or 'Approved'. | Insert excerpt |
|---|
| Def - Status |
|---|
| Def - Status |
|---|
| nopanel | true |
|---|
|
The Statuses that apply to transaction in this List View include:| Insert excerpt |
|---|
| Def - Status - New |
|---|
| Def - Status - New |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Approved |
|---|
| Def - Status - Approved |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Ready to Post |
|---|
| Def - Status - Ready to Post |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Posted |
|---|
| Def - Status - Posted |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Void |
|---|
| Def - Status - Void |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Deleted |
|---|
| Def - Status - Deleted |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Replaced |
|---|
| Def - Status - Replaced |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK |
| Transaction | | Insert excerpt |
|---|
| Transaction ID |
|---|
| Transaction ID |
|---|
| nopanel | true |
|---|
|
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. | Insert excerpt |
|---|
| Def - Transaction ID |
|---|
| Def - Transaction ID |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.TransactionHeaderID |
| Transaction Class | | Insert excerpt |
|---|
| Transaction Class |
|---|
| Transaction Class |
|---|
| nopanel | true |
|---|
|
This comes from the 'Transaction Class' on the 'Properties' tab of the Invoice/Credit Memo Record View. This
is not editable. | Insert excerpt |
|---|
| Def - Transaction Class |
|---|
| Def - Transaction Class |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK |
| Transaction Type | | Insert excerpt |
|---|
| Transaction Type |
|---|
| Transaction Type |
|---|
| nopanel | true |
|---|
|
This comes from the Transaction Type selected when starting a new transaction. This is never not editable. | Insert excerpt |
|---|
| Def - Transaction Types |
|---|
| Def - Transaction Types |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK |
| UOM | | Insert excerpt |
|---|
| UOM - Units |
|---|
| UOM - Units |
|---|
| nopanel | true |
|---|
|
This can be edited from the 'UOM' on the Item grid of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New. | Insert excerpt |
|---|
| Def - Not Defined |
|---|
| Def - Not Defined |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK |
| Vendor | This 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. | Insert excerpt |
|---|
| Def - Vendor ID |
|---|
| Def - Vendor ID |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK |
| Vendor Class | | Insert excerpt |
|---|
| Vendor Class |
|---|
| Vendor Class |
|---|
| nopanel | true |
|---|
|
This 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 This is only editable by changing the Vendor assigned to the transaction.
| Insert excerpt |
|---|
| Def - Vendor Class |
|---|
| Def - Vendor Class |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK |
| Vendor Name | | Insert excerpt |
|---|
| Vendor Name |
|---|
| Vendor Name |
|---|
| nopanel | true |
|---|
|
This 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.
| Insert excerpt |
|---|
| Def - Vendor Name |
|---|
| Def - Vendor Name |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK |