| Toolbar Icons | Description |
|---|
| Column Filter Show/Hide |  |
| Excel |  |
| Favorites |  |
| Group By Show/Hide |  |
| Help |  |
| More Actions | 
- RV: Transaction. Opens the Transaction Record View.
- Void Transaction.
|
| Print |  When clicked, all the Reports assigned to the Functional Area of Purchasing, that launch from the Print Dialog, are assigned to this page, and that the user has rights to (if Report Data Access is enabled) are displayed.
|
| Quick Column Filter |  |
| Refresh |  |
| Saved Layouts |  |
| Search Option |  |
| Fields | Description |
| Checkbox | Used to select one or more records. |
| Amount |  This is required and comes from the 'Extended' column on the Item grid of the Invoice/Credit Memo Record View and is calculated by multiplying the Quantity and Price of the transaction line. This can only be edited by changing the Quantity and/or Price of the transaction line. Positive lines represent a purchase and negative lines represent a purchase credit.
Database Field: ERPx_APTransactionLine.ExtendedAmount |
| Currency ID |  This is required and comes from the 'Currency ID' 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 |
| Description |  This is not required and 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 |
| Distributed To |  This is not required and 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.
Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK |
| Distributed Type |  This is not required and is derived from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. Because this defaults from the Project, Employee, Fisherman, Tender or Loan, it is only editable by changing the Distributed To field on the transaction. This contains the associated value in the MFDistributionType Enumeration Class.
Database Field: ERPx_APTransactionLine.ToMFDistributionTypeEN |
| Doc Date |  This is required and can be edited from the 'Doc Date' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable.
Database Field: ERPx_APTransactionHeader.TransactionDate |
| Doc No |  This is required and 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.
|
| Item Added |  |
| Item Added By |  |
| Item Description |  This is required and can be edited from the 'Description' on the Item grid of the Invoice/Credit Memo Record View. This is always editable even after the transaction is posted.
Database Field: ERPx_APTransactionLine.LineDescription |
| Item Last Updated |  |
| Item Last Updated By |  |
| Payable Account |  This is required and 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.AccountNumber, ERPx_APVendor.APGLAcctRef |
| Payable Account Description |  This is required and 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 is not required and 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 is not required and 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 is required and can be edited from the 'Price' 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_APTransactionLine.Price |
| Purchase Account |  This is required and 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.AccountNumber, ERPx_APTransactionLine.AccountSK |
| Purchase Account Description |  This is required and 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 |  This is required and 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 Fields: ERPx_APTransactionLine.Quantity |
| 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 transaction 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 required but is not editable by users.
Database Field: ERPx_APTransactionHeader.TransactionID |
| Transaction Class |  This is required and 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 |
| UOM |  This is not required and can be edited from the 'UOM' on the Item grid of the Invoice/Credit Memo Record View. This is only editable while the transaction is in a Status of New.
Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK |
| Vendor Class |  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 |