Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
This page lists each unique Purchase Order item on New and Released Purchase Orders. The purpose of this page is to view line items on open Purchase Orders.
This list view also contains columns for each Attribute that is set up for the 'AP Purchasing' and 'Items' attribute types. Because these are user defined, they are not included in the default view but can be added a saved layout. AP Purchasing and Items attributes are not included in the help documentation.
Software Version: 20222023.1006.10 30 and newer
Table of Contents | ||||
---|---|---|---|---|
|
...
Toolbar Icons | Description | ||||||||||||||||
Column Filter Show/Hide |
| ||||||||||||||||
Edit |
| ||||||||||||||||
Excel |
| ||||||||||||||||
Favorites |
| ||||||||||||||||
Group By Show/Hide |
| ||||||||||||||||
Help |
| ||||||||||||||||
More Actions |
| ||||||||||||||||
New |
| ||||||||||||||||
| |||||||||||||||||
Quick Column Filter |
| ||||||||||||||||
Refresh |
| ||||||||||||||||
Saved Column Layout |
| ||||||||||||||||
Fields | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Checkbox |
| ||||||||||||||||
Amt. Ordered | Identifies the extended amount of the Purchase Order Item. This is required and can only be edited by changing either the 'Qty Ordered' or the 'Price' of a line item on the Items Grid of the Purchase Order Record View. It is calculated as [Qty Ordered] * [Price] and is formatted to 2 decimal places. This is editable until the Purchase Order is 'Closed'. Database Field: ERPx_APPoLine.ExtendedAmount | ||||||||||||||||
AP Amt. Fully invoiced | Identifies whether the 'Amt. Ordered' of the Purchase Order item has been fully Invoiced. If the 'AP Amt. Remaining' for a Purchase Order item is <= 0, the item is considered "Fully Invoiced" in terms of Amount (cost) and will display as "Yes", otherwise it will be blank. This allows users to easily determine which PO's have amounts that have not yet been invoiced. This is a calculated field and is not stored in the database. | ||||||||||||||||
AP Amt. Posted | Identifies the extended amount of the line item that has been included on "Posted" AP Invoices and AP Credit Memos. This is a calculated field that is formatted to 2 decimal places. When AP Invoices and/or Credit Memos, with line items that reference a Purchase Order are posted, this value is updated. Database Field: ERPx_APPoLine.InvoicedAmount | ||||||||||||||||
AP Amt. Remaining | Identifies the dollar amount of the line item that has not yet been accounted for on an AP Invoice/Credit Memo. This is a calculated field and can only be changed by changing either the 'Qty Ordered' or the 'Price' of a line item on the Items Grid of the Purchase Order Record View or by entering and/or posting AP Invoices/Credit Memos that are linked to this item. It is calculated as [Amt. Ordered] - [AP Amt. Posted] - [AP Amt. Unposted] and is formatted to 2 decimal places. This is editable until the Purchase Order is 'Closed'. This is a calculated field that is not stored in the database. | ||||||||||||||||
AP Amt. UnPosted | Identifies the extended amount of the line item that has been included on "UnPosted" AP Invoices and AP Credit Memos. This is a calculated field that is formatted to 2 decimal places and is not stored in the database. When AP Invoices and/or Credit Memos, with line items that reference a Purchase Order are entered, but not posted, this value is updated. | ||||||||||||||||
AP Qty Fully Invoiced | Identifies whether the 'Qty Ordered' of the Purchase Order item has been fully Invoiced. If the 'AP Qty Remaining' for a Purchase Order item is <= 0, the item is considered "Fully Invoiced" in terms of quantity (units or weight) and will display as "Yes", otherwise it will be blank. This allows users to easily determine which PO's have quantities that have not yet been invoiced. This is a calculated field that is not stored in the database. | ||||||||||||||||
AP Qty Posted | Identifies the quantity of the line item that has been included on "Posted" AP Invoices and AP Credit Memos. This is a calculated field that is formatted to the Item's 'Unit Decimals' or 'Weight Decimals' depending on the Item's UOM. When AP Invoices and/or Credit Memos, with line items that reference a Purchase Order are posted, this value is updated. Database Field: ERPx_APPoLine.InvoicedQty | ||||||||||||||||
AP Qty Remaining | Identifies the quantity of the line item that has not yet been accounted for on an AP Invoice/Credit Memo. This is a calculated field and can only be changed by changing the 'Qty Ordered' of a line item on the Items Grid of the Purchase Order Record View or by entering and/or posting AP Invoices/Credit Memos that are linked to this item. It is calculated as [Qty Ordered] - [AP Qty Posted] - [AP Qty Unposted] and is formatted to the Item's 'Unit Decimals' or 'Weight Decimals' depending on the Item's UOM. This is a calculated field that is not stored in the database. | ||||||||||||||||
AP Qty UnPosted | Identifies the quantity of the line item that has been included on "UnPosted" AP Invoices and AP Credit Memos. This is a calculated field that is formatted to the Item's 'Unit Decimals' or 'Weight Decimals' depending on the Item's UOM. When AP Invoices and/or Credit Memos, with line items that reference a Purchase Order are entered, but not posted, this value is updated. This is a calculated field that is not stored in the database. | ||||||||||||||||
AP vs IM Posted Qty | Identifies the difference between the quantities accounted for on "Posted" AP Invoices/Credit Memos and "Posted" Inventory Receipts for the line item. This is a calculated field that is formatted to the Item's 'Unit Decimals' or 'Weight Decimals' depending on the Item's UOM. It is calculated as [IM Qty Posted] - [AP Qty Posted].
When AP Invoice, AP Credit Memo, and/or Inventory Receipt transactions with line items that reference a Purchase Order are posted, this value is updated. This is a calculated field that is not stored in the database. | ||||||||||||||||
Buyer | Identifies the person responsible for issuing the Purchase Order. This is not required and can be edited from the 'Buyer' field on the 'Home' tab of the Purchase Order Record View. Database Field: ERPx_APPoHeader.Buyer | ||||||||||||||||
Comment |
Database Field: ERPx_APPoHeader.Description | ||||||||||||||||
Currency ID |
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APVendor.CurrencySK | ||||||||||||||||
Distributed To |
Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APPoLine.ToDistributionAccountSK | ||||||||||||||||
Distributed Type |
The options include:
Database Field: ERPX_APPoLine.ToMFDistributionTypeEN | ||||||||||||||||
Expire By |
Database Field: ERPx_APPoHeader.ExpireDate | ||||||||||||||||
IM Qty Fully Received | Identifies whether the 'Qty Ordered' of the Purchase Order item has been fully Received. If the 'IM Qty Remaining' for a Purchase Order item is <= 0, the item is considered "Fully Received" in terms of quantity (units or weight) and will display as "Yes" otherwise it will be blank. This allows users to easily determine which PO's have quantities that have not yet been received. This is a calculated field that is not stored in the database. | ||||||||||||||||
IM Qty Posted | Identifies the quantity of the line item that has been included on "Posted" IM Receipts. This is a calculated field that is formatted to the Item's 'Unit Decimals' or 'Weight Decimals' depending on the Item's UOM. When IM Receipts, with line items that reference a Purchase Order are posted, this value is updated. |