Page Comparison

Identifies whether the 'Amt. Ordered' for every Purchase Order item has been fully Invoiced. If the 'Amt. Invoiced' for a Purchase Order item is >= the 'Amt. Ordered' for the item, the item is considered "Fully Invoiced" in terms of Amount (cost). If all the Purchase Order items are "Fully Invoiced" in terms of their amounts, then this 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.  

Identifies whether the 'Amt. Ordered' for every Purchase Order item has been fully Received. If the 'Amt. Received' for a Purchase Order item is >= the 'Amt. Ordered' for the item, the item is considered "Fully Received" in terms of Amount (cost). If all the Purchase Order Items are "Fully Received" in terms of their amounts, then this 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 received. This is a calculated field and is not stored in the database. 

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: ???

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. 

 When AP Invoices and/or Credit Memos are loaded from a PO, the 'Quantity' will default as [Qty Ordered] - [Qty Invoiced]. 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] - [Qty Received]. If this results in a negative amount it will default as 0.00.

Database Field: ???

Identifies the calculated sum of the extended amounts of all the line item that have been included on "Posted" AP Invoices, AP Credit Memos, and IM Receipts. This is a calculated field that is formatted to 2 decimal places.

 When IM Receipts, with line items that reference a Purchase Order are posted, this value is updated as [Qty Received] * [PO Item Price].

 Because non-Inventory Purchase Order Items are not "Received" using an Inventory Receipt transaction, the 'Amt. Received' value is updated from the extended amounts of posted AP Invoices and Credit Memos that reference the Purchase Order Item.

Database Field: ???

Database Field: ERPx_APPoHeader.CreatedDate

Database Field: ERPx_APPoHeader.CreatedBy

Identifies whether or not more than one AP Invoice and/or Inventory Receipt can be recorded against the Purchase Order. This is editable until the Purchase Order is 'Closed' and the options include:

1. Single Invoice and Receipt: If this option is selected, the Purchase Order can only be assigned to a single AP Invoice and a single Inventory Receipt transaction.
   1. Once it has been used on one of those transactions, it can be assigned to additional transactions but those transactions cannot be 'Approved' or 'Posted'.
   2. Once it has been used on both an AP Invoice and Inventory Receipt (for PO's that contain inventory items) the Purchase Order's Status will be auto set to "Closed".
   3. An 'Open' Purchase Order can always be assigned to multiple AP Credit Memos.   
2. Multiple Invoices and Receipts: If this option is selected, the Purchase Order can be assigned to multiple AP Invoices and multiple Inventory Receipt transactions. 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 

Identifies whether the 'Qty Ordered' for every Purchase Order item has been fully Invoiced. If the 'Qty Invoiced' for a Purchase Order item is >= the 'Qty Ordered' for the item, 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 and is not stored in the database.

Identifies whether the 'Qty Ordered' for every Purchase Order item has been fully Received. If the 'Qty Received' for a Purchase Order item is >= the 'Qty Ordered' for the item, 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.

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: ???

Identifies the sum of the 'Qty Ordered' of all the line items on the Purchase Order. This is a calculated field that is formatted to 2 decimal places. The 'Qty Ordered' can be 0.00 but it cannot be negative. 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] - [Qty Invoiced]. 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] - [Qty Received]. If this results in a negative amount it will default as 0.00.

Database Field: ???

Identifies the sum of the quantities of all the line items that have been included on "Posted" IM Receipts. This is a calculated field that is formatted to 2 decimal places.

 When IM Receipts, with line items that reference a Purchase Order are posted, this value is updated.

 Because non-Inventory Purchase Order Items are not "Received" using an Inventory Receipt transaction, the 'Qty Received' value is updated from posted AP Invoices and Credit Memos that reference the Purchase Order Item.

Database Field: ???