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
...
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
...
Database Field: ERPx_APPoHeader.Description
...
Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APPoLine.ToDistributionAccountSK
...
The options include:
- AP Vendor
- Project
Database Field: ERPX_APPoLine.ItemTOMFDistributionTypeEN
...
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 |
| ||||||||||||||||
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 |
Database Fields: ERPx_MFCurrency.CurrencyID | ||||||||||||||||
Description |
Database Field: ERPx_APPoHeader.Description | ||||||||||||||||
Distributed To |
Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APPoLine.ToDistributionAccountSK | ||||||||||||||||
Distributed To Type |
The options include:
Database Field: ERPX_APPoLine.ToMFDistributionTypeEN | ||||||||||||||||
Expire By |
Database Field: ERPx_APPoHeader.ExpireDate | ||||||||||||||||
Item Added By |
| ||||||||||||||||
Item Added |
| ||||||||||||||||
Item Last Updated By |
| ||||||||||||||||
Item Last Updated |
| ||||||||||||||||
Item Description |
| ||||||||||||||||
Ordered |
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. ExpireDate | Item Added By | |||||||||||||||
Insert excerpt | Item Added By | Item Added By | |||||||||||||||
nopanel | true | Item Added | Insert excerpt | | Item Added (Date/Time) | Item Added (Date/Time) | |||||||||||
nopanel | true | ||||||||||||||||
Payable Account | Item Last Updated By
| Item Last Updated By |
|
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
Insert excerpt |
---|
|
|
for the Vendors assigned 'Accounts Payable' from the GL Accounts List View.
Doc Date Insert excerpt
|
Database Field: ERPx_APPoHeader.PODate PurchaseOrderID
Payable Account Insert excerpt
Payable AccountPrice
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.Price nopanel true
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor,APGLAcctRef
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 | ||||||
---|---|---|---|---|---|---|
|
from the 'Purchase Account' column of the Items Grid on the Purchase Order Record View
Database Field: ERPx_APPoHeader.PurchaseOrderID
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_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.
PriceOrderedQuantity
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.OrderedQuantityInsert 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_APTransactionLine.AccountSK
|
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: Insert excerpt Def - Status Def - Status nopanel true
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
This is required and comes from the 'Transaction Class' on the 'Properties' tab of the Purchase Order Record View. This is not editable. Insert excerpt Transaction Class Transaction Class nopanel true
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' 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
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 |