Insert excerpt
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
Table of Contents | ||
---|---|---|
|
Page Header
...
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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
Table of Contents | ||
---|---|---|
|
Page Header
Toolbar Icons | Description | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Column Filter Show/Hide |
| |||||||||||||||||||||||||||||||||||||||
Edit |
| |||||||||||||||||||||||||||||||||||||||
Excel |
| |||||||||||||||||||||||||||||||||||||||
Favorites |
| |||||||||||||||||||||||||||||||||||||||
Group By Show/Hide |
| |||||||||||||||||||||||||||||||||||||||
Help |
| |||||||||||||||||||||||||||||||||||||||
New |
| |||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||
Quick Column Filter |
| |||||||||||||||||||||||||||||||||||||||
Refresh |
| |||||||||||||||||||||||||||||||||||||||
ExcelSaved Column Layout |
| |||||||||||||||||||||||||||||||||||||||
Fields | FavoritesDescription | |||||||||||||||||||||||||||||||||||||||
Checkbox | Favorites Add/Remove - Global
| Favorites Add/Remove - Global |
|
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
Database Fields: ERPx_MFCurrency.CurrencyID
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
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. Insert excerpt Currency Currency nopanel true
Insert excerpt Def - Currency Def - Currency nopanel true
Database Fields: ERPx_MFCurrency.CurrencyID
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'. Insert excerpt Comment - Header Comment - Header nopanel true
Database Field: ERPx_APPoHeader.Description
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APPoLine.ToDistributionAccountSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
The options include:
- AP Vendor
- Project
Database Field: ERPX_APPoLine.ToMFDistributionTypeEN
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'. Insert excerpt PO Expire By PO Expire By nopanel true
Database Field: ERPx_APPoHeader.ExpireDate
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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'. Insert excerpt Item Description Item Description nopanel true
Database Field: ERPx_APPoHeader.Description
Insert excerpt
Doc Date Doc Date nopanel true
This is
notrequired 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
FieldsField: ERPx_
APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APPoLine.ToDistributionAccountSK Distributed To TypeAPPoHeader.PODate
Insert excerpt |
---|
|
The options include:
- AP Vendor
- Project
Database Field: ERPX_APPoLine.ItemTOMFDistributionTypeEN
Expire ByThis 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
PO Expire By
Insert excerpt |
---|
|
Database Field: ERPx_APPoHeader.ExpireDate
Account Description' for the Vendors assigned 'Accounts Payable' from the GL Accounts List View.
Insert excerpt
Transaction ID Transaction ID nopanel true
Clicking on this link opens the Purchase Order Record View for the selected record. This
is always editableis a system assigned number that comes from the 'Transaction Class' and is required and is editable by users until the Purchase Order
is 'Closed'.Orderedis 'Closed'.
Database Field: ERPx_APPoHeader.PurchaseOrderID
Insert excerpt
Price
Price nopanel true
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
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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_APVendor,APGLAcctRef
APTransactionLine.AccountSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
.
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
Insert excerpt |
---|
|
|
This is required and can be edited from the '
Database Field: ERPx_APPoHeader.PurchaseOrderID
PriceStatus' on the 'Home' tab of the Purchase Order Record View.
Price Insert excerpt
|
Database Field: ERPx_APPoLine.Price
Insert excerpt
Insert excerpt Def - Status - New Def - Status - New nopanel true
Insert excerpt Def - Status - Released Def - Status - Released nopanel true
Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APPoHeader.TransactionStatusEN
Insert excerpt Transaction Class Transaction Class nopanel true
This is
required and
comes from the '
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
Transaction Class' on the 'Properties' tab of the Purchase Order Record View. This is not editable.
Insert excerpt Def - Transaction Class Def - Transaction Class nopanel true
Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APPoHeader.TransactionClassSK
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'
Database Field: ERPx_APPoLine.OrderedQuantity
Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APPoHeader.TransactionClassSK
Typeand 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
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
The lookup contains all 'Active' UOMs
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_IMUOM.UOMName, ERPx_APPoLine.QuantityUOMSK
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. Insert excerpt Vendor Class Vendor Class nopanel true
Insert excerpt Def - Vendor Class Def - Vendor Class nopanel true
Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APPoHeader.VendorSK
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. Insert excerpt Vendor ID Vendor ID nopanel true
Insert excerpt Def - Vendor ID Def - Vendor ID nopanel true
Database Fields: ERPx_APVendor.VendorID, ERPx_APPoHeader.VendorSK
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. Insert excerpt Vendor Name Vendor Name nopanel true
Insert excerpt Def - Vendor Name Def - Vendor Name nopanel true
Database Fields: ERPx_APVendor.VendorName, ERPx_APPoHeader.VendorSK
Related Topics
Expand | ||
---|---|---|
| ||
Page Definitions |
Expand | ||
---|---|---|
| ||
Technical Details |