The purpose of this page is to see the Vendor Items that have been setup on the Vendor master file record to add to AP Invoice, AP Credit Memo and Purchase Order transactions.

Software Version: 2023.09.29 and newer

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

Page Header

Fields

Description

Search

Item Description
Item ID

Once items have been added to the grid and users have entered the quantities they wish to order for the item(s), there are two ways to add the item(s) to the order, users can click back into the Search box and press the Enter key or click the Refresh button.

Page Details

Toolbar Icons	Description

Toolbar Icons	Description
Column Filter Show/Hide
Excel
Group By Show/Hide
Help
More Actions	IQ: Item Purchase Order History: Opens the "Purchase Order Lines History" Inquiry showing all the Purchase Order Lines for the Vendor. IQ: Line Item History: Opens the "Invoice Lines History" Inquiry showing all the AP Invoice and AP Credit Memo lines for the Vendor.
Quick Column Filter
Refresh
Save & Close
Saved Layouts
Fields	Description
Checkbox
Ext. Amount	This is required and is calculated as [Quantity] * [Price] for each line item. This can only be edited by changing the Quantity and/or Price of the line item. This is a calculated field and is not stored in the database.
Item	This is never editable from this page, users can edit the Vendor Items from the "Vendor Items" tab on the Vendor master file. Database Fields: ERPx_IMItem.ItemID:ItemDescription, ERPx_APVendorItem.ItemSK
Last Paid Date	Displays the last date the corresponding item was invoiced for the Vendor. This is a non-editable date field that is not required. This value updates when AP Invoices are Posted for the Vendor and the Item and UOM on the AP Invoice matches the Item and UOM setup on the Vendor Items for the Vendor. If the item has never been invoiced this field will be blank. This field is not stored in the database.
Last Paid Price	Displays the last Price that was paid for the corresponding item that was invoiced for the Vendor. This is a non-editable numeric text box that is not required. This value updates when AP Invoices are Posted for the Vendor and the Item and UOM on the AP Invoice matches the Item and UOM setup on the Vendor Items for the Vendor. If the item has never been invoiced this field will be blank. This field is not stored in the database.
Last Paid Qty	Displays the last quantity of the corresponding item that was invoiced for the Vendor. This is a non-editable numeric text box that is not required. This value updates when AP Invoices are Posted for the Vendor and the Item and UOM on the AP Invoice matches the Item and UOM setup on the Vendor Items for the Vendor. If the item has never been invoiced this field will be blank. This field is not stored in the database.
Line Comment	This is an editable text box that is not required. If a value is entered it must be <= 200 characters and is editable while the transaction is in a status of New, Open or Released. If a value exists on the Vendor Items tab of the Vendor master file for the item, this value will default but can be overwritten. This value will display in the Line Comment field of the AP Invoice, AP Credit Memo and Purchase Order when added to the record from this page. Database Field: ERPx_APVendorItem.LineComment
PO Min. Ord Qty	Displays the minimum quantity that should be ordered for the item. For example, a Vendor may require an item to be ordered in a minimum of 50 cases. This is a non-editable numeric text box that defaults to the value specified for the Vendor Item on the Vendor master file record that is not required. Database Field: ERPx_APVendorItem.POMinOrderQty
PO Order Multiple Of	Displays the multiple of quantity that the item should be ordered in. For example, a Vendor may require an item to be ordered in multiples of 10 cases. This is a non-editable numeric text box that defaults to the value specified for the Vendor Item on the Vendor master file record that is not required. Database Field: ERPx_APVendorItem.POOrderMultiple
Price	This is a numeric text box that is not required. It defaults to the price entered for the Vendor Item on the Vendor master file. This is editable while the transaction is in 'New' Status. Database Field: ERPx_APVendorItem.Price
Qty	This defaults as 0.00 and is not required. If a value is entered and added to the transaction, this will display in the 'Quantity' field for the line item. This is editable while the transaction is in 'New', 'Open' and 'Released' Status. If the Quantity entered does not meet the PO Minimum Order Quantity (PO Min. Ord Qty), and/or the PO Order Multiple Of quantity, when added to a Purchase Order record, the following warning messages will be displayed on Save: "The Qty ordered for Item [Item ID]: [Item Description] is less than the PO Min. Order Qty specified." and "The Qty ordered for Item [Item ID]: [Item Description] is not in the PO Order Multiple Of specified.". Note: The above messages are only applicable to Purchase Orders. This value is not stored in the database.
Seq.	This is an editable text box that defaults to the next available base-10 number. It is required, and is always editable. To re-sequence the line items, edit one or more lines with a new positive number that would put the line item where you want it sorted, and click the Save button. On save, the line items will be resorted, and the Ln. values will be re-set to base-10 values. For example, if you had line items 10, 20, and 30 and you wanted the last one (Ln. 30) to be second, you could edit the value to any number between 10 and 20 (i.e. 15) and on save the lines would be sorted in the new sequence (10, 15, and 30) and then all Ln.'s would be re-set to base 10 numbers (10, 20, 30). Database Field: ERPx_APVendorItem.LineItemSort
UOM	This defaults from the 'UOM' saved to the Vendor Item on the Vendor's master file record. This is always editable from the Vendor's master file record. Database Fields: ERPx_IMUOM.UOMID, ERPx_APVendorItem.PriceUOMSK
Vendor Item Description	Displays the description of the Vendor Item. This is an editable text box that is not required. If a value is entered it must be <= 200 characters and is editable while the transaction is in a status of New, Open or Released. If a value exists on the Vendor Items tab of the Vendor master file for the item, this value will default but can be overwritten. This value will display in the Line Description field of the AP Invoice, AP Credit Memo and Purchase Order when added to the record from this page. Database Field: ERPx_APVendorItem.VendorItem

Find Vendor Items Record View

Page Header

Page Details