Versions Compared

Key

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

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
exclude(Toolbar Icons|Column Headers)
typeflat

Page Header

Filter ItemsDescription
Ordered DateUsed to select the date the Purchase Order was ordered. This is a date range control that allows users to select a single date or a range of dates, formatted from the users 'Date Format' preference. This is required to return results and defaults with a date range of the past 30 days.
Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

  • Description
  • Item Description
  • Purchase Order
  • Vendor ID
  • Vendor Name
Transaction Class

Insert excerpt
Inq - Transaction Class
Inq - Transaction Class
nopaneltrue
The values in this lookup are listed alphabetically. If there is more than one Transaction Class for the Transaction Type, then the value in the lookup will display as [Transaction Type] - [Transaction Class]. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Transaction Class - General
Def - Transaction Class - General
nopaneltrue

The lookup contains a list of all 'Active' Transaction Classes.

Vendor

Used to select one or more Vendors. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Vendor
Def - Vendor
nopaneltrue

The lookup contains a list of all 'Active' Vendors

Vendor Class

Insert excerpt
Inq - Vendor Class
Inq - Vendor Class
nopaneltrue
 This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Vendor Class
Def - Vendor Class
nopaneltrue

The lookup contains a list of all 'Active' AP Vendor Classes.

Page Detail

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
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • RV: Transaction: Opens the Purchase Order Record View for the selected transaction.
  • Void Transaction: Opens the Void Transaction page
Print

Insert excerpt
Print - LV 3.0
Print - LV 3.0
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 Inquiry, and that the user has rights to are displayed.

Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved Column Layout
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
Search Options
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue

Fields

Description
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
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 excerpt
Currency
Currency
nopaneltrue
 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
Def - Currency
Def - Currency
nopaneltrue

Database Fields: ERPx_MFCurrency.CurrencyID 

Description

Insert excerpt
Description Comment - HeaderDescription
Comment - 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 is editable until the Purchase Order is 'Closed'.

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

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

Expire By

Insert excerpt
PO Expire By
PO Expire By
nopaneltrue
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
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 By
Insert excerpt
Item Last Updated By
Item Last Updated By
nopaneltrue
Item Last Updated
Insert excerpt
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 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_APPoLine.Price

Purchase Account

Insert excerpt
Purchase Account - Item
Purchase Account - Item
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 '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 Description
Purchase Account Description
nopaneltrue
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
Insert excerpt
Status
Status
nopaneltrue

This is required and can be edited from the 'Status' on the 'Home' tab of the Sales Transaction Record View.

Insert excerpt
Def - Status
Def - Status
nopaneltrue
 The Statuses that apply to transactions in this List View include:

Insert excerpt
Def - Status - New
Def - Status - New
nopaneltrue

Insert excerpt
Def - Status - Released
Def - Status - Released
nopaneltrue

Insert excerpt
Def - Status - Closed
Def - Status - Closed
nopaneltrue

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APPoHeader.TransactionStatusEN

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

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

Related Topics


Expand
titlePage Definitions


...