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' 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.??.?? and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
Search
...
...
- Description
- Doc No
- Purchase Order
- Transaction
- Vendor ID
- Vendor Name
...
The lookup contains a list of all 'Active' AP Purchase Order Classes
...
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.
...
The lookup contains a list of all 'Active' Vendors.
...
The lookup contains a list of all 'Active' AP Vendor Classes.
Page Detail
...
- IQ: PO Transactions - Opens an inquiry with all the Purchase Orders, AP Invoices, AP Credit Memos, and Inventory Receipts with this Purchase Order assigned. This inquiry has not been designed yet.
- RV: Transaction. Opens the Transaction Record View.
...
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.
...
Identifies the sum of the 'Amt. Ordered' of all the line items on the Purchase Order. This is a calculated field that is formatted to 2 decimal places.
Database Field: ERPx_APPoHeader.OrderedAmount
AP Amt. Fully Invoiced
...
AP Amt. Posted
...
Identifies the sum of the extended amounts of all the line item that have 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_APPoHeader.InvoicedAmount
AP Amt. Remaining
...
Identifies the sum of line item's 'AP Amt. Remaining' values. This is a calculated field and can only be changed by changing either the 'Qty Ordered' or the 'Price' of one or more line items on the Items Grid of the Purchase Order Record View or by entering and/or posting AP Invoices/Credit Memos that are linked to a PO line item. It is calculated as the sum of all line's [Amt. Ordered] - [AP Amt. Posted] - [AP Amt. Unposted] and is formatted to 2 decimal places.
This is a calculated field that is not stored in the database.
AP Qty Fully Invoiced
...
Identifies whether the 'Qty Ordered' for every 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). If all the Purchase Order items are "Fully Invoiced" in terms of their quantities, this 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 formatted to two decimal places and is not stored in the database.
AP Qty Posted
...
Identifies the sum of the quantities of all the line items that have 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_APPoHeader.InvoicedQty
AP Qty Remaining
...
Identifies the sum of all the line items 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 one or more line items on the Items Grid of the Purchase Order Record View or by entering and/or posting AP Invoices/Credit Memos that are linked to one or more PO line items. It is calculated as the sum of each line items [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 formatted to two decimal places.
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 two decimal places and is not stored in the database. It is calculated as [IM Qty Posted] - [AP Qty Posted].
- A zero value means there is no difference between the sum of the line items quantities of "Posted" AP Invoices and "Posted" Inventory Receipts.
- A positive value indicates more Qty has been received than has been paid for.
- A negative value indicates more Qty has been paid for than has been received.
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.
...
Identifies the person responsible for issuing the Purchase Order. This is not required.
Database Field: ERPx_APPoHeader.Buyer
...
Database Field: ERPx_APPoHeader.Description
...
Database Field: ERPx_APPoHeader.CreatedDate
...
Database Field: ERPx_APPoHeader.CreatedBy
...
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APVendor.CurrencySK
...
Identifies the Discount % associated with the Payment Terms of the Vendor. This is not editable on the transaction.
Database Fields: ERPx_MFPaymentTerms.DiscountPercent, APPOHeader.DiscountPercent
...
Database Field: ERPx_APPoHeader.ExpireDate
IM Qty Fully Received
...
Identifies whether the 'Qty Ordered' of all the Purchase Order items have 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). If all the Purchase Order items are "Fully Received" in terms of their quantities, this 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 and is not stored in the database.
IM Qty Posted
...
Identifies the sum of the line items that have been included on "Posted" IM Receipts. This is a calculated field that is formatted to two decimal places.
When IM Receipts, with line items that reference a Purchase Order are posted, this value is updated.