PO Linked Transactions Inquiry

PO Linked Transactions Inquiry

This page lists the Purchase Order, all AP Invoices/Credit Memo, and all Inventory Receipt transactions. The purpose of this page is to quickly show all the Purchase Order related transactions.

 This list view also contains columns for each Attribute that is set up for 'AP Purchasing'. 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: 2023.06.30 and newer

[ 1 Page Header ] [ 1.1 Search ] [ 2 Page Detail ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Search

Filter Items

Description

Filter Items

Description

Auto Hide Filters

Auto Refresh on Open

PO #

Used to select all or part of a PO #. This is a text box that is not required.

Requisition

Used to select all or part of a Requisition #. This is a text box that is not required.

Saved Searches

Search

  • 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.

The lookup contains a list of all 'Active' Vendors

Page Detail

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

Print

Quick Column Filter

Refresh

Saved Layouts

Search Options

Fields

Description

Checkbox

Comment

 This is not required and can be edited from the 'Comment' field on the 'Home' tab of the transaction Record View. This is always editable even after the transaction is 'Closed'.

Database Field: ERPx_APPoHeader.Description, ERPx_APTransactionHeader.Description, ERPx_IMTransactionHeader.Description

Currency

 This is required and comes from the 'Currency' on the 'Properties' tab of the transaction Record View. This is not editable on the transaction.

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APVendor.CurrencySK, ERPx_APPoHeader.CurrencySK ERPx_APTransactionHeader.CurrencySK

Requisition #

 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'.

Database Field: ERPx_APPoHeader.Requisition 

Site ID

 This is only applicable for Purchase Order and IM Receipts (it is not applicable for AP Invoice/Credit Memos) and it is only required for IM Receipts.

Database Field: ERPx_MFSite.SiteID, ERPx_APPoHeader.SiteSKERPx_IMTransactionHeader.SiteSK

Status

 This is required and is always editable.

The Statuses that apply to Purchase Orders in this inquiry include:

The Statuses that apply to AP Invoices/Credit Memos and IM Receipts in this inquiry include:

Database Fields: ERPx_APPOStatus.StatusName, ERPx_APPoHeader.POStatusSK, ERPx_APTransactionHeader.TransactionStatusSK, ERPx_IMTransactionHeader.TransactionStatusSK

Transaction Class

 This is required and comes from the 'Transaction Class' on the 'Properties' tab of the transaction Record View. This is not editable.

Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APPoHeader.TransactionClassSK, ERPx_APTransactionHeader.TransactionClassSK, ERPx_IMTransactionClass.TransactionClassID, ERPx_IMTransactionHeader.TransactionClassSK

Transaction Date

This is required and can be edited from the 'Home' tab of the Transaction Record View. This is editable until the Purchase Order is 'Closed' or the transaction is in a Status >= "Approved".

Database Field: ERPx_APPoHeader.PODate, ERPx_APTransactionHeader.TransactionDateERPx_IMTransactionHeader.TransactionDate

Transaction ID

Database Field: ERPx_APPoHeader.PurchaseOrderID, ERPx_APTransactionHeader.TransactionID, ERPx_IMTransactionHeader.TransactionID

Transaction Type

 The Transaction Types applicable to this inquiry include:

  • Purchase Order

  • AP Invoice

  • Credit Memo

  • IM Receipt

Vendor ID

 This is required and represents the ID of the 'Vendor' on the 'Home' tab of the transaction Record View. This is only editable by changing the Vendor assigned to the transaction.

Database Fields: ERPx_APVendor.VendorID, ERPx_APPoHeader.VendorSK, ERPx_APTransactionHeader.VendorSKERPx_IMTransactionHeader.ReceivedFromVendorSK

Vendor Name

This is required and represents the name of the 'Vendor Name' on the 'Home' tab of the transaction Record View. This is only editable by changing the Vendor assigned to the transaction.

Database Fields: ERPx_APVendor.VendorName, ERPx_APPoHeader.VendorSK, ERPx_APTransactionHeader.VendorSKERPx_IMTransactionHeader.ReceivedFromVendorSK