| |
|---|
Column Filter Show/Hide |
|
Delete |
|
Edit |
|
Excel |
|
Favorites | |
Group By Show/Hide |
|
Help |
|
Mass Update |
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 | 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 |
|
Print | |
Quick Column Filter |
|
Refresh |
|
Saved Layouts |
|
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' field 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, even after the transaction is Posted. 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. Database Field: ERPx_APTransactionHeader.IMTransactionHeaderSK |
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. 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.
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 is always editable while the transaction is in a Status of 'New' or 'Approved'. The Statuses that apply to transactions in this List View 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' 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 |