Page Comparison

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

Table of Contents

type	flat

...

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global 3.0
	Help - Global 3.0
nopanel	true

More Actions

Insert excerpt

	More Actions - Global 3.0
	More Actions - Global 3.0
nopanel	true

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

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Refresh

Insert excerpt

	Refresh - Global 3.0
	Refresh - Global 3.0
nopanel	true

Save & Close

Insert excerpt

	Save & Close - RV Header 3.0
	Save & Close - RV Header 3.0
nopanel	true

Saved Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Fields

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Ext. Amount

Insert excerpt

	Amount - Extended
	Amount - Extended
nopanel	true

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

Insert excerpt

	Item ID & Item Description
	Item ID & Item Description
nopanel	true

This is never editable from this page, users can edit the Vendor Items from the "Vendor Items" tab on the Vendor master file.

Insert excerpt

	Def - Item
	Def - Item
nopanel	true

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

Insert excerpt

	Line Item Comment
	Line Item Comment
nopanel	true

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. This is a numeric text box 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 This is a numeric 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

Insert excerpt

	Price
	Price
nopanel	true

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

Insert excerpt

	Quantity
	Quantity
nopanel	true

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

This value is not stored in the database.

Seq.

Insert excerpt

	Seq.
	Seq.
nopanel	true

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

Insert excerpt

	UOM - Price
	UOM - Price
nopanel	true

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

Version	Old Version 2	New Version 3
Changes made by	Emma Greenwood	Emma Greenwood
Saved on	Sept 26, 2023	Sept 26, 2023

Versions Compared

Key

Related Topics

Page Definitions