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
Page Header
Search
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 |
|
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 |
|---|---|
Column Filter Show/Hide | |
Excel | |
Favorites | |
Group By Show/Hide | |
Help | |
Quick Column Filter | |
Refresh | |
Saved Layouts | |
Search Options | |
Fields | Description |
Checkbox | |
Comment |
Database Field: ERPx_APPoHeader.Description, ERPx_APTransactionHeader.Description, ERPx_IMTransactionHeader.Description |
Currency |
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APVendor.CurrencySK, ERPx_APPoHeader.CurrencySK ERPx_APTransactionHeader.CurrencySK |
Requisition # |
Database Field: ERPx_APPoHeader.Requisition |
Site ID |
Database Field: ERPx_MFSite.SiteID, ERPx_APPoHeader.SiteSK, ERPx_IMTransactionHeader.SiteSK |
Status |
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 |
Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APPoHeader.TransactionClassSK, ERPx_APTransactionHeader.TransactionClassSK, ERPx_IMTransactionClass.TransactionClassID, ERPx_IMTransactionHeader.TransactionClassSK |
Transaction Date |
Database Field: ERPx_APPoHeader.PODate, ERPx_APTransactionHeader.TransactionDate, ERPx_IMTransactionHeader.TransactionDate |
Transaction ID | Database Field: ERPx_APPoHeader.PurchaseOrderID, ERPx_APTransactionHeader.TransactionID, ERPx_IMTransactionHeader.TransactionID |
Transaction Type |
|
Vendor ID |
Database Fields: ERPx_APVendor.VendorID, ERPx_APPoHeader.VendorSK, ERPx_APTransactionHeader.VendorSK, ERPx_IMTransactionHeader.ReceivedFromVendorSK |
Vendor Name |
Database Fields: ERPx_APVendor.VendorName, ERPx_APPoHeader.VendorSK, ERPx_APTransactionHeader.VendorSK, ERPx_IMTransactionHeader.ReceivedFromVendorSK |