| Toolbar Icons | Description |
|---|
| Column Filter Show/Hide | | Insert excerpt |
|---|
| Column Filter Show/Hide - Global |
|---|
| Column Filter Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Delete | | Insert excerpt |
|---|
| Delete - LV 3.0 |
|---|
| Delete - LV 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Edit | | Insert excerpt |
|---|
| Edit - LV 3.0 |
|---|
| Edit - LV 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Excel | | Insert excerpt |
|---|
| Excel - LV 3.0 |
|---|
| Excel - LV 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Favorites | | Insert excerpt |
|---|
| Favorites Add/Remove - Global |
|---|
| Favorites Add/Remove - Global |
|---|
| nopanel | true |
|---|
|
|
| Group By Show/Hide | | Insert excerpt |
|---|
| Grid Layout Group By Show/Hide - GlobalGrid Layout |
|---|
| Group By Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Help | | Insert excerpt |
|---|
| Help - Global 3.0 |
|---|
| Help - Global 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Mass Update | | Insert excerpt |
|---|
| Mass Update - Global 3.0 |
|---|
| Mass Update - Global 3.0 |
|---|
| nopanel | true |
|---|
|
- GL Date: A date field that defaults to "(No Change)", but also allows users to select a date from the calendar. Assigns the selected date to the selected/filtered transactions when the 'Apply' icon is clicked.
- Pmt./Apply Hold: A single-select lookup that defaults to "(No Change)", but also has options for (blank) and "Yes". Assigns the selected value to selected/filtered transactions when the 'Apply' icon is clicked.
- Status: A single-select lookup that defaults to "(No Change)", but also has options for "New", "Approved" and "Ready to Post". Assigns the selected Status to selected/filtered transactions when the 'Apply' icon is clicked.
|
| More Actions | | Insert excerpt |
|---|
| More Actions - Global 3.0 |
|---|
| More Actions - Global 3.0 |
|---|
| nopanel | true |
|---|
|
- 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 option is only visible when the preferences for PaperVision are configured.
|
| New | | Insert excerpt |
|---|
| New - Multi-Select Trans Type - Global 3.0 |
|---|
| New - Multi-Select Trans Type - Global 3.0 |
|---|
| nopanel | true |
|---|
|
- Invoice: A transaction to record a purchase you are making from a Vendor.
- Credit Memo: A transaction to record a return/refund you are getting from Vendor.
|
| Print | | Insert excerpt |
|---|
| Print - LV 3.0 |
|---|
| Print - LV 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Quick Column Filter | | Insert excerpt |
|---|
| Quick Column Filter |
|---|
| Quick Column Filter |
|---|
| nopanel | true |
|---|
|
|
| Refresh | | Insert excerpt |
|---|
| Refresh - Global 3.0 |
|---|
| Refresh - Global 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Saved Layouts | | Insert excerpt |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| nopanel | true |
|---|
|
|
| Fields | Description |
| Checkbox | | Insert excerpt |
|---|
| Checkbox - LV |
|---|
| Checkbox - LV |
|---|
| nopanel | true |
|---|
|
|
| Amount | | Insert excerpt |
|---|
| Amount (- Transaction |
|---|
| Amount ) - List View/Inquiry FieldAmount ( Transaction Amount) - List View/Inquiry Field |
|---|
| nopanel | true |
|---|
|
This comes from the 'Amount' on the 'Home' tab of the Invoice/Credit Memo Record View and is calculated based on 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 |
| CurrencyComment | Currency LV FieldCurrency LV Field | Insert excerpt |
|---|
Def - Currency | Def - Currency | | nopanel | true |
|---|
This comes This can be edited from the 'Currency IDComment' field on the 'PropertiesHome' tab of the Invoice/Credit Memo Record View. This defaults from the Currency setup on the Vendor and is not editable on the transactionis always editable, even after the transaction is Posted.Database FieldsField: ERPx_MFCurrency.CurrencyID, ERPxAPTransactionHeader.Description |
| Created | | Insert excerpt |
|---|
| Created |
|---|
| Created |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.CurrencySKCreatedDate |
| Doc DateCreated By | | Insert excerpt |
|---|
Doc Date - List View/Inquiry Field | Doc Date - List View/Inquiry Field |
|---|
| Created By |
|---|
| Created By |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.CreatedBy |
| Currency | | Insert excerpt |
|---|
| Currency |
|---|
| Currency |
|---|
| nopanel | true |
|---|
|
This comes from the ' Doc DateCurrency' on the ' HomeProperties' tab of the Invoice/Credit Memo Record View. This defaults from the current date and is always editable while the transaction is in a Status of New.Database Field: ERPx_APTransactionHeader.TransactionDate is not editable on the transaction. | Insert excerpt |
|---|
| Def - Currency |
|---|
| Def - Currency |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK |
| Doc Date | Description - List View/Inquiry Field Description - List View/Inquiry Field This comes can be edited from the 'DescriptionDoc Date' on the 'Home' tab of the Invoice/Credit Memo Record View. This defaults as blank and is always editable, even after the transaction is Posted. Database Field: ERPx_APTransactionHeader.DescriptionTransactionDate |
| Doc No | - List View/Inquiry Field - List View/Inquiry Field 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 |
| GL Date | | Insert excerpt |
|---|
| GL Date - List View/Inquiry Field |
|---|
| GL Date - List View/Inquiry Field |
|---|
| nopanel | true |
|---|
|
This comes This is required and can be edited from the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This defaults as blank and if 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 - List View/Inquiry Field |
|---|
| GL Period - List View/Inquiry Field |
|---|
| nopanel | true |
|---|
|
This This is a required and calculated field 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 | | Insert excerpt |
|---|
| GL Year - List View/Inquiry Field |
|---|
| GL Year - List View/Inquiry Field |
|---|
| nopanel | true |
|---|
|
This This is a required and calculated field 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 | | Insert excerpt |
|---|
| Last Updated |
|---|
| Last Updated |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.LastUpdated |
| Last Updated By | | Insert excerpt |
|---|
| Last Updated By |
|---|
| Last Updated By |
|---|
| nopanel | true |
|---|
|
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. Database Field: ERPx_APTransactionHeader.IMTransactionHeaderSK |
| Payment Terms | | Insert excerpt |
|---|
| Def - Payment TermsDef - |
|---|
| Payment Terms |
|---|
| nopanel | true |
|---|
|
This comes can be edited from the 'Payment Terms' on the ' HomeProperties' tab of the Invoice/Credit Memo Record View. This defaults from the 'Payment Terms' setup on the Vendor and is always editable while the transaction is in a Status of New. If the Payment Terms are changed, the 'Due Date' and 'Discount Date' values will be automatically updated based on the new Payment Terms.| Insert excerpt |
|---|
| Def - Payment Terms |
|---|
| Def - Payment Terms |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_MFPaymentTerms.PaymentTermName, ERPx_ APTransactionHeader.PaymentTermSK |
| 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 #
| - List View/Inquiry Field - List View/Inquiry Field This comes 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 defaults as blank and is not required. This is always editable while the transaction is in a Status of New. Database Field: ERPx_APTransactionHeader.PurchaseOrderID | Status |
| This comes Reference
| | Insert excerpt |
|---|
| Reference |
|---|
| Reference |
|---|
| nopanel | true |
|---|
|
This is text box that is not required and is always editable even after the transaction is posted.
| Insert excerpt |
|---|
| Def - Reference # |
|---|
| Def - Reference # |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.Reference |
| Status | This is required and 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 defaults as 'New' and is required. This is 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 transactions in this List View include:
| Insert excerpt |
|---|
| Def - Status - New |
|---|
| Def - Status - |
|---|
|
all exc. Sales Order
| Insert excerpt |
|---|
| Def - Status - Approved |
|---|
| Def - Status - Approved |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Ready to Post |
|---|
| Def - Status - |
|---|
|
all exc. Sales Order
Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK |
Transaction| Insert excerpt |
|---|
| Trans. ID - List View/Inquiry Field | Trans. ID - List View/Inquiry Field| nopanel | true |
|---|
| Insert excerpt |
|---|
| Def - Transaction IDDef - |
|---|
| Transaction ID |
|---|
| nopanel | true |
|---|
|
This 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 required but is not editable by users. | Insert excerpt |
|---|
| Def - Transaction ID |
|---|
| Def - Transaction ID |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionHeader.TransactionID |
Transaction Class ID
| Def - Def - | Transaction Class |
|---|
| nopanel | true |
|---|
|
This comes from the 'Transaction Class' on the 'Properties' tab of the Invoice/Credit Memo Record View. This defaults as 'Default' and is not editable. | Insert excerpt |
|---|
| Def - Transaction Class |
|---|
| Def - Transaction Class |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK |
| Transaction Type | Def - TypesDef - Types This is required and comes from the Transaction Type selected when starting a new transaction. This is never editable. | Insert excerpt |
|---|
| Def - Transaction Types |
|---|
| Def - Transaction Types |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK |
Vendor Class ID
| | Def - | ID | Def - | ID | represents the ID of 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. | This is only editable by changing the Vendor assigned to the transaction.Database Fields: ERPx_APVendor.VendorIDBecause this defaults from the Vendor it is not editable on the transaction. | Insert excerpt |
|---|
| Def - Vendor Class |
|---|
| Def - Vendor Class |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK |
| Vendor | ClassID |
| Def -
| Class
| Def -
| Class This | comes from the 'Vendor Class' assigned to is required and represents the ID of 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. | Database Field| Insert excerpt |
|---|
| Def - Vendor ID |
|---|
| Def - Vendor ID |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_ | APVendorClassAPVendor. | ClassDescriptionVendorID, ERPx_APTransactionHeader.VendorSK |
| Vendor Name | Def - Def - This 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. | Insert excerpt |
|---|
| Def - Vendor Name |
|---|
| Def - Vendor Name |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK |
This list view also contains columns for each Attribute that is set up for the 'AP Purchasing' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. AP Purchasing attributes are not included in the help documentation.