Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerptDef - Purchase

Insert excerpt
Def - Purchase Order
Def - Purchase Order
nopaneltrue

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

(lightbulb) 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
typeflat

Page Header

...

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
typeflat

Page Header

Group By Show/Hide - Global

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Edit

Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
nopaneltrue

Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Column Filter Group By Show/Hide - GlobalColumn Filter
Group By Show/Hide - GlobalGlobal
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
EditNew
Insert excerpt
Edit
New -
LV
Global 3.0
Edit
New -
LV
Global 3.0
nopaneltrue
ExcelPrint

Insert excerpt

Excel

Print - LV 3.0

Excel
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Print - LV 3.0
nopaneltrue

Favorites Insert excerptFavorites Add/Remove - Global

When clicked, all the Reports assigned to the Functional Area of Purchasing, that launch from the Print Dialog, assigned to the Purchase Order Lines List View page, and that the user has rights to are displayed.

Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
HelpRefresh
Insert excerpt
Help
Refresh - Global 3.0
Help
Refresh - Global 3.0
nopaneltrue
NewSaved Column Layout
Insert excerpt
New
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0
New
- Global
3.0
nopaneltrue
PrintFieldsDescriptionCheckboxPrint - LV 3.0
Insert excerpt
Print - LV 3.0
Checkbox
Checkbox
nopaneltrue
When clicked, all the Reports assigned to the Functional Area of Purchasing, that launch from the Print Dialog, assigned to the Purchase Order Lines List View page, and that the user has rights to are displayed.Quick Column Filter
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 Insert excerptCheckboxCheckboxnopaneltrueAmount

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 Insert excerptCurrencyCurrencynopaneltrue 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. Insert excerptDef - CurrencyDef - Currencynopaneltrue

Database Fields: ERPx_MFCurrency.CurrencyID 

DescriptionQuick Column Filter

Insert excerpt

Quick Column Filter

Currency
Currency
nopaneltrue

Refresh

 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.

Insert excerptDescription - HeaderDescription - Headernopaneltrue This is not

Insert excerpt

Refresh - Global 3.0Refresh - Global 3.0nopaneltrueSaved Column Layout Insert excerptColumn Layouts for Framework 3.0 - GlobalColumn Layouts for Framework 3.0 - GlobalnopaneltrueFieldsDescriptionCheckbox

Def - Currency
Def - Currency
nopaneltrue

Database Fields: ERPx_MFCurrency.CurrencyID 

Description

Insert excerpt
Description - Header
Description - Header
nopaneltrue
 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

Insert excerpt
Distributed To - Vendor
Distributed To - Vendor
nopaneltrue
This is not required and editable until the Purchase Order is 'Closed'.

Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APPoLine.ToDistributionAccountSK 

Distributed To Type

Insert excerpt
Distributed To Type
Distributed To Type
nopaneltrue
 This is an auto generated field that is not editable by the user. 

The options include:

  • AP Vendor 
  • Project

Database Field: ERPX_APPoLine.ItemTOMFDistributionTypeEN 

Expire By

Insert excerpt
PO Expire By
PO Expire By
nopaneltrue
This is required and can be edited from the '

Description

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

Distributed To

Insert excerptDistributed To - VendorDistributed To - VendornopaneltrueThis is not required and editable until the Purchase Order is 'Closed'.

Database FieldsField: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APPoLine.ToDistributionAccountSK 

Distributed To Type

APPoHeader.ExpireDate

Item Added By
Insert excerpt
Item Added By
Item Added By
nopaneltrue
Item Added
Insert excerpt
Item Added (Date/Time)
Item Added (Date/Time)
nopaneltrue
Item Last Updated ByDistributed To Type
Insert excerpt
Distributed To Type
Item Last Updated By
Item Last Updated By
nopaneltrue
 This is an auto generated field that is not editable by the user. 

The options include:

  • AP Vendor 
  • Project

Database Field: ERPX_APPoLine.ItemTOMFDistributionTypeEN 

Expire ByItem Last Updated
Insert excerpt
PO Expire ByPO Expire BynopaneltrueThis 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 Last Updated (Date & Time)
Item Last Updated (Date & Time)
nopaneltrue
Item Description

Insert excerpt
Item Description
Item Description
nopaneltrue
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

Insert excerpt
Doc Date
Doc Date
nopaneltrue
 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

Insert excerpt
Payable Account
Payable Account
nopaneltrue
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

Insert excerpt
Payable Account Description
Payable Account Description
nopaneltrue
This is only editable by changing the 'Account Description' for the Vendors assigned 'Accounts Payable' from the GL Accounts List View. 

PO

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
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 . 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

Insert excerpt
Price
Price
nopaneltrue
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_

APPoHeader

APPoLine.

PurchaseOrderID

Price

PricePurchase Account

Price

Insert excerpt
Price
Purchase Account - Item
Purchase Account - Item
nopaneltrue
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

not required and is editable from the 'Purchase Account' column of the Items Grid on the Purchase Order Record View.

(lightbulb) 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

Insert excerpt
Purchase Account - ItemDescription
Purchase Account - ItemDescription
nopaneltrue
This is not required and is editable from the 'Purchase Account' column of the Items Grid on the Purchase Order Record View. (lightbulb) When AP Invoices and/or Credit Memos are loaded from a PO, the only editable by changing the 'Account Description' for the line items assigned '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 Insert excerptPurchase Account DescriptionPurchase Account DescriptionnopaneltrueThis 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

Trans CreatedTrans Created ByTrans Last UpdatedTrans Last Updated ByTransaction Class Insert excerptTransaction ClassTransaction Classnopaneltrue This is required and comes from the 'Transaction Class' on the 'Properties' tab of the Purchase Order Record View. This is not editable. Insert excerptDef - Transaction ClassDef - Transaction Classnopaneltrue

Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APPoHeader.TransactionClassSK

Type

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

Transaction Class

Insert excerpt
Transaction Class
Transaction Class
nopaneltrue
 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
Def - Transaction Class
Def - Transaction Class
nopaneltrue

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:

  1. Allow Single Invoice: If this option is selected, the Purchase Order can only be assigned to a single AP Invoice.
    1. 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".
    2. An 'Open' Purchase Order can always be applied to multiple AP Credit Memos.   
  2. Allow Multiple InvoicesIf 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

Insert excerpt
UOM - Units
UOM - Units
nopaneltrue
This is a single-select lookup and is required and is editable until the Purchase Order is 'Closed'.

The lookup contains all 'Active' UOMs 

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

Database Fields: ERPx_IMUOM.UOMName, ERPx_APPoLine.QuantityUOMSK

Vendor Class

Insert excerpt
Vendor Class
Vendor Class
nopaneltrue
 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
Def - Vendor Class
Def - Vendor Class
nopaneltrue

Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APPoHeader.VendorSK

Vendor ID

Insert excerpt
Vendor ID
Vendor ID
nopaneltrue
 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
Def - Vendor ID
Def - Vendor ID
nopaneltrue

Database Fields: ERPx_APVendor.VendorID, ERPx_APPoHeader.VendorSK

Vendor Name

Insert excerpt
Vendor Name
Vendor Name
nopaneltrue
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
Def - Vendor Name
Def - Vendor Name
nopaneltrue

Database Fields: ERPx_APVendor.VendorName, ERPx_APPoHeader.VendorSK

...