This page lists ..... The purpose of this page is to
This list view also contains columns for each Attribute that is set up for the 'AP Purchasing' and 'Items' attribute typetypes. Because these are user defined, they are not included in the default view but can be added a saved layout. AP Purchasing Purchasing and Items attributes are not included in the help documentation..
Software Version: 2021.??.?? and newer
...
| Filter Items | Description |
|---|
| Item |
|
| PO # |
|
| Requisition |
|
| Search | | Insert excerpt |
|---|
| Search - Search Options |
|---|
| Search - Search Options |
|---|
| nopanel | true |
|---|
|
- Item
- Requisition
- Transaction
- Vendor ID
- Vendor Name
|
| 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 |
|---|
| nopanel | true |
|---|
|
The lookup contains a list of all 'Active' Vendors. |
Page Detail
| Toolbar Icons | Description |
|---|
| Column Filter Show/Hide | | Insert excerpt |
|---|
| Column Filter Show/Hide - Global |
|---|
| Column Filter Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Excel | | Insert excerpt |
|---|
| Excel - LV 3.0 |
|---|
| Excel - LV 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Favorites | | Insert excerpt |
|---|
| Favorites Add/Remove - Global |
|---|
| Favorites Add/Remove - Global |
|---|
| nopanel | true |
|---|
|
|
| Group By Show/Hide | | Insert excerpt |
|---|
| Group By Show/Hide - Global |
|---|
| Group By Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Help | | Insert excerpt |
|---|
| Help - Global 3.0 |
|---|
| Help - Global 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Print | | Insert excerpt |
|---|
| Print - Global |
|---|
| Print - Global |
|---|
| nopanel | true |
|---|
|
When clicked, all the Reports assigned to the Functional Area of Purchasing, that launch from the Print Dialog, are assigned to this inquiry, and that the user has rights to (if Report Data Access is enabled) are displayed. |
| Quick Column Filter | | Insert excerpt |
|---|
| Quick Column Filter |
|---|
| Quick Column Filter |
|---|
| nopanel | true |
|---|
|
|
| Refresh | | Insert excerpt |
|---|
| Refresh - Global |
|---|
| Refresh - Global |
|---|
| nopanel | true |
|---|
|
|
| Saved Layouts | | Insert excerpt |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| nopanel | true |
|---|
|
|
| Search Options | | Insert excerpt |
|---|
| Search Options - Inquiry Grid 3.0 |
|---|
| Search Options - Inquiry Grid 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Fields | Description |
| Checkbox | | Insert excerpt |
|---|
| Checkbox |
|---|
| Checkbox |
|---|
| nopanel | true |
|---|
|
|
| Amt |
|
| Buyer | Identifies the person responsible for issuing the Purchase Order. This is not required. Database Field: ERPx_APPoHeader.Buyer |
| Comment | | Insert excerpt |
|---|
| Description Comment - HeaderDescription |
|---|
| Comment - Header |
|---|
| nopanel | true |
|---|
|
This is not required and can be edited from the 'Comment' field on the 'Home' tab of the Purchase Order Record View. This is always editable even after the Purchase Order is 'Closed'.
Database Field: ERPx_APPoHeader.Description |
| Item Description | | Insert excerpt |
|---|
| Item Description |
|---|
| Item Description |
|---|
| nopanel | true |
|---|
|
This is required and can only be edited from the 'Item Description' property on the Item Record View of the assigned Item ID.
Database Fields: ERPx_IMItem.ItemDescription, ERPx_APPoLine.ItemSK |
| Item ID | | Insert excerpt |
|---|
| Item ID - LV |
|---|
| Item ID - LV |
|---|
| nopanel | true |
|---|
|
This represents the Item ID assigned to the Purchase Order Line Item and is not editable.
Database Fields: ERPx_IMItem.ItemID, ERPx_APPoLine.ItemSK |
| Item Type | | Insert excerpt |
|---|
| Item Type |
|---|
| Item Type |
|---|
| nopanel | true |
|---|
|
This represents the Item Type assigned to the Item ID and is not editable.
Database Fields: ERPx_IMItemType.Description, ERPx_IMItem.ItemTypeSK |
| Line Comment | Description Description This is always editable from the Purchase Order Record View Items Grid until the Purchase Order is 'Closed'.
When AP Invoices, Credit Memos, and IM Receipts are loaded from a PO, this will default as the 'Line Comment' on those transactions. Database Field: ERPx_APPoLine.LineDescription |
| Ln. | | Insert excerpt |
|---|
| Ln. - RV Items Grid |
|---|
| Ln. - RV Items Grid |
|---|
| nopanel | true |
|---|
|
This is required and can be edited from the Ln. field on the Purchase Order Record View Items Grid until the Purchase Order is 'Closed'.
Database Field: ERPx_APPoLine.LineNumber |
| Owner |
|
| PO Ln. | Identifies the Purchase Order line item that the AP Invoice/Credit Memo line item is linked to. This is a single-select lookup that is not required. This is editable while the transaction is in a Status of "New".  The Price and Quantity will not default from the Purchase Order line item.
Database Field: ERPx_APTransactionLine.POLineSK |
| Price | This is required and can be edited from the 'Price' field on the Items Grid of the Purchase Order Record View. It is formatted to the Item's 'Price Decimals' and is editable until the Purchase Order is 'Closed'. Database Field: ERPx_APPoLine.Price |
| Prod Batch |
|
| Purchase GL Account | | Insert excerpt |
|---|
| Purchase Account - Item |
|---|
| Purchase Account - Item |
|---|
| nopanel | true |
|---|
|
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_APPoLine.AccountSK |
| Qty | Identifies the 'Qty Ordered' of the line item on the Purchase Order. This is required and can be edited from the 'Qty Ordered' field on the Items Grid of the Purchase Order Record View. It is formatted to the Item's 'Unit Decimals' or 'Weight Decimals' depending on the Item's UOM. This is editable until the Purchase Order is 'Closed'. When AP Invoices and/or Credit Memos are loaded from a PO, the 'Quantity' will default as [Qty Ordered] - [AP Qty Posted] - [AP Qty Unposted]. If this results in a negative amount it will default as 0.00. When IM Receipts are loaded from a PO, the 'Quantity' will default as [Qty Ordered] - [IM Qty Posted] - [IM Qty Unposted]. If this results in a negative amount it will default as 0.00. Database Field: ERPx_APPoLine.OrderedQuantity |
| Requisition # | | Insert excerpt |
|---|
| Requisition Number |
|---|
| Requisition Number |
|---|
| nopanel | true |
|---|
|
This is not required and can be edited from the 'Requisition' field on the 'Home' tab of the Purchase Order Record View. This is always editable until the Purchase Order is 'Closed'.
| Insert excerpt |
|---|
| Def - Requisition # |
|---|
| Def - Requisition # |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APPoHeader.Requisition |
| Site ID |
|
| Status |
|
| Transaction Class | | Insert excerpt |
|---|
| Transaction Class |
|---|
| Transaction Class |
|---|
| nopanel | true |
|---|
|
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 |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APPoHeader.TransactionClassSK |
| Transaction Date |
|
| Transaction ID |
|
| Transaction Type |
|
| UOM | | Insert excerpt |
|---|
| UOM - Units |
|---|
| UOM - Units |
|---|
| nopanel | true |
|---|
|
This is required and can be edited from the 'UOM' field on the Items Grid of the Purchase Order Record View until the Purchase Order is 'Closed'.| Insert excerpt |
|---|
| Def - UOM |
|---|
| Def - UOM |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_IMUOM.UOMName, ERPx_APPoLine.QuantityUOMSK |
| Vendor ID | | Insert excerpt |
|---|
| Vendor ID |
|---|
| Vendor ID |
|---|
| nopanel | true |
|---|
|
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 |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APVendor.VendorID, ERPx_APPoHeader.VendorSK |
| Vendor Name | | Insert excerpt |
|---|
| Vendor Name |
|---|
| Vendor Name |
|---|
| nopanel | true |
|---|
|
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 |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_APVendor.VendorName, ERPx_APPoHeader.VendorSK |
| Warehouse Lot |
|
| Vendor Class ID | | Insert excerpt |
|---|
| Vendor Class |
|---|
| Vendor Class |
|---|
| nopanel | true |
|---|
|
This is required and comes from the 'Vendor Class' assigned to the 'Vendor' that is selected on the 'Home' tab of the Purchased Order Record View. Because this defaults from the Vendor it is not editable on the transaction.
| Insert excerpt |
|---|
| Def - Vendor Class ID |
|---|
| Def - Vendor Class ID |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Def - Vendor Class |
|---|
| Def - Vendor Class |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APPoHeader.VendorSK |
...