| 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 - LV |
|---|
| Currency - LV |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Currency |
|---|
| Def - 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.
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK |
| Distributed To | Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK |
| Distributed To Type | Database Field: ERPx_APTransactionLine.ToMFDistributionTypeEN |
| Doc Date | Database Field: ERPx_APTransactionHeader.TransactionDate |
| Doc Description | Database Field: ERPx_APTransactionHeader.Description |
| Doc No | Database Field: ERPx_APTransactionHeader.DocNumber |
| Extended | Database Field: ERPx_APTransactionLine.ExtendedAmount |
| GL Date | Database Field: ERPx_APTransactionHeader.GLDate |
| GL Period | Database Fields: ERPx_MFFiscalPeriod.FiscalPeriodSK, ERPx_APTransactionHeader.GLDate |
| GL Year | Database Fields: ERPx_MFFiscalPeriod.FiscalYearSK, ERPx_APTransactionHeader.GLDate |
| Item Description | Database Field: ERPx_APTransactionLine.LineDescription |
| Payable Account | Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.APGLAcctRef |
| Payable Account Description | Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef |
| Pmt./Apply Hold | Database Field: ERPx_APTransactionHeader.IsOnApplicationHold |
| PO | Database Field: ERPx_APTransactionHeader.PurchaseOrderID |
| Price | Database Field: ERPx_APTransactionLine.Price |
| Purchase Account | Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK |
| Purchase Account Description | Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK |
| Quantity | Database Field: ERPx_APTransactionLine.Quantity |
| Status | Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK |
| Transaction | Database Field: ERPx_APTransactionHeader.TransactionHeaderID |
| Transaction Class | Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK |
| Transaction Type | Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK |
| UOM | Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK |
| Vendor | Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK |
| Vendor Class | Database Fields: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK |
| Vendor Name | Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK |