This page lists each unique Purchase Order line item. The purpose of this page is to view, add, edit, remove, and close Purchase Orders.

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..

Software Version: 2021.07.23 and newer

[ 1 Page Header ] [ 1.1 Related Topics ] [ 1.1.1 Page Definitions ] [ 1.1.2 Technical Details ]

Page Header

Toolbar Icons	Description

Toolbar Icons	Description
Column Filter Show/Hide
Edit
Excel
Favorites
Group By Show/Hide
Help
New
Print
Quick Column Filter
Refresh
Saved Column Layout
Fields	Description
Checkbox
Amount	Identifies the extended amount of the line item based on the ordered quantity. This is a numeric text box that is auto calculated as [Quantity] x [Price]. This can only be updated by changing either the 'Quantity' or 'Price'. This is formatted to 2 decimal places. Database Field: ERPx_APPoLine.ExtendedAmount
Currency ID	This is required and comes from the 'Currency ID' on the 'Properties' tab of the Purchase Order Record View. This is not editable on the transaction as it comes in from the 'Currency' assigned to the Vendor. Database Fields: ERPx_MFCurrency.CurrencyID
Description	This is not required and can be edited from the 'Description' on the 'Home' tab of the Purchase Order Record View. This is always editable until the Purchase Order is 'Closed'. Database Field: ERPx_APPoHeader.Description
Distributed To	This is not required and is editable until the Purchase Order is 'Closed'. Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APPoLine.ToDistributionAccountSK
Distributed To Type	This is an auto generated field that is not editable by the user. The options include: AP Vendor Project Database Field: ERPX_APPoLine.ToMFDistributionTypeEN
Expire By	This is required and can be edited from the 'Expire By' date on the 'Home' tab of the Purchase Order Record View. This is always editable until the Purchase Order is 'Closed'. Database Field: ERPx_APPoHeader.ExpireDate
Item Added By
Item Added
Item Last Updated By
Item Last Updated
Item Description	This is required and can be edited from the 'Description' column of the Items Grid on the 'Home' tab of the Purchase Order Record View. This is always editable until the Purchase Order is 'Closed'.
Ordered	This is required and can be edited from the 'Ordered' date on the 'Home' tab of the Purchase Order Record View. This is always editable until the Purchase Order is 'Closed'. Database Field: ERPx_APPoHeader.PODate
Payable Account	This is required and is only editable from "Accounts Payable" GL Account, on the Accounts Tab of the Vendor Record View of the assigned Purchase Order's Vendor. Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor,APGLAcctRef
Payable Account Description	This is only editable by changing the 'Account Description' for the Vendors assigned 'Accounts Payable' from the GL Accounts List View.
PO	Clicking on this link opens the Purchase Order Record View for the selected record. This is a system assigned number that comes from the 'Transaction Class' and is required and is editable by users until the Purchase Order is 'Closed'. Database Field: ERPx_APPoHeader.PurchaseOrderID
Price	This is a numeric text box that is required and must be greater than or equal to 0. It is formatted to the Item's 'Price Decimals'. This is editable until the Purchase Order is 'Closed'. Database Field: ERPx_APPoLine.Price
Purchase Account	This is not required and is editable from the 'Purchase Account' column of the Items Grid on the Purchase Order Record View. When AP Invoices and/or Credit Memos are loaded from a PO, the 'Purchase Account' will default from the current Purchase Account assigned to the Purchase Order Item. Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK
Purchase Account Description	This is only editable by changing the 'Account Description' for the line items assigned 'Purchase Account' from the GL Accounts List View.
Quantity	Identifies the quantity of the line item being ordered. This is a numeric text box that must be greater than 0. It is formatted to 2 decimal places. This is editable until the Purchase Order is 'Closed'. Database Field: ERPx_APPoLine.OrderedQuantity
Status	This is required and can be edited from the 'Status' on the 'Home' tab of the Purchase Order Record View. The Statuses that apply to transactions in this List View include: Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APPoHeader.TransactionStatusEN
Transaction Class	This is required and comes from the 'Transaction Class' on the 'Properties' tab of the Purchase Order Record View. This is not editable. Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APPoHeader.TransactionClassSK
Type	Identifies whether or not more than one AP Invoice can be recorded against the Purchase Order. This is editable until the Purchase Order is 'Closed' and the options include: Allow Single Invoice: If this option is selected, the Purchase Order can only be assigned to a single AP Invoice. Once it has been assigned on and AP Invoice, it can no longer be manually entered and will no longer be displayed in the PO Lookups for that transaction and the Purchase Order's Status will be auto set to "Closed". An 'Open' Purchase Order can always be applied to multiple AP Credit Memos. Allow Multiple Invoices: If this option is selected, the Purchase Order can be assigned to multiple AP Invoices. Purchase Orders set to this Type must be manually Closed. This lookup contains all the values in the APPOType Enumeration Class Database Field: ERPx_APPoHeader.TransactionTypeEN
UOM	This is a single-select lookup and is required and is editable until the Purchase Order is 'Closed'. The lookup contains all 'Active' UOMs Database Fields: ERPx_IMUOM.UOMName, ERPx_APPoLine.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 Purchase Order Record View. Because this defaults from the Vendor it is not editable on the transaction. Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APPoHeader.VendorSK
Vendor ID	This is required and represents the ID of the 'Vendor' on the 'Home' tab of the Purchase Order Record View. This is only editable by changing the Vendor assigned to the transaction. Database Fields: ERPx_APVendor.VendorID, ERPx_APPoHeader.VendorSK
Vendor Name	This is required and represents the name of the 'Vendor' on the 'Home' tab of the Purchase Order Record View. This is only editable by changing the Vendor assigned to the transaction. Database Fields: ERPx_APVendor.VendorName, ERPx_APPoHeader.VendorSK

Purchase Order Lines List View - previous version

Page Header