Line Items Tab of the Purchase Orders Form

Use the Line Items tab to enter and edit the line items that make up a purchase order or change order.

Before you can submit a purchase order, it must have at least one line item in the grid on this tab.

To use a change order, you enter a new row of data to change the original data in a purchase order. You cannot edit the data in the original purchase order. This process keeps an audit trail of all of the changes that are made to a purchase order.

When the Inventory feature is enabled, this grid displays additional fields.

Line Items Grid Fields

You enter and display most information in grids on various forms. For information about using grids, see Working with Grids.

Field Description
Seq

This field prefills with the sequence number of a line item in a purchase order or change order.

For example, when you enter a purchase order, the Seq field prefills with 1 for the first line item that you enter, 2 for the second line item that you enter, and so on. Likewise, when you enter a change order, the Seq field prefills with 1 for the first line item of the change order, 2 for the second line item of the change order, and so on.

On the change order that you print, the change order number and sequence number display in the Seq column using the following format:

C/O <change order number> - <seq number>.

Example: Change order number 1 has two change order line items. When you print the change order:
  • The Seq column for the first line item displays C/O 1 - 1.
  • The Seq column for the second line item displays C/O 1 - 2.
C/O If a line item is for a change order, this field displays the change order number for the line item after you save the change order. Change order numbers are assigned automatically, starting with number 1 for the first change order entered, number 2 for the next change order entered, and so on. This field is blank for purchase order line items.
Item

Select an item from the Items lookup to add to the purchase order.

The items available on the lookup are set up on the Items form in Purchasing > Items. If you enter an item that is not already set up, and the Items checkbox is selected in the Automatic Add section on the General tab of the Purchasing & Inventory Company Settings form (Settings > Purchasing & Inventory > Company Settings), you receive a message that asks if you want to add the item. If you click Yes, the Items <New Item> dialog box opens and you can use it to add the new item.

Description This column displays the item's description.
Category

This field displays the item's category. If the Modify Default Item Category checkbox is selected in the Miscellaneous section of the General tab of the Purchasing & Inventory Company Settings form, you can change the category for the item that you entered in the grid. This changes the category only for the line item in the purchase order, not the category that is set up for the item in Purchasing > Items.

When you final print a purchase order, if the purchase order has only one project assigned to it:

  • An equipment item is automatically generated in the Equipment hub in the desktop application for any purchase order line item with a category type of Equipment.
  • An asset item is automatically generated in the Equipment hub in the desktop application for any purchase order line item with a category type of Capital Items, if the Purchase Order checkbox is selected in the Asset Item Source section on the General tab of the Asset Configuration form (Settings > Asset Management).

You set up system-wide item categories and specify a type for them on the Item Categories tab of the Purchasing & Inventory System Settings form in Settings > Purchasing & Inventory > System. You specify item categories for a company on the Item Categories tab of the Purchasing & Inventory Company Settings form in Settings > Purchasing & Inventory > Company.

Unit Price Enter the item's price for the unit of measure that is specified in the UOM field.
Qty Enter the quantity of the item that was ordered.
UOM

This column displays the item's usual unit of measure, from the General tab of the Items form.

If this is an inventory item, the available units of measure are the Purchasing units of measure defined in the Global UOM Conversion grid on the Inventory tab of either the Items form or the Purchasing & Inventory System Settings form (Settings > Purchasing & Inventory > General System).

If this is not an inventory item, click + Add New UOM to open the Add New UOM dialog box, on which you can add a new unit of measure for the item. For more information, go to Add New UOM Dialog Box.

Net Amount This column displays the result of the calculation (Qty x Unit Price).
Due Date This column displays the result of the calculation (Date to Order + Order Days). You can specify a different date.
INV This checkbox displays if the Inventory feature is enabled. The checkbox is selected if the Item is an inventory item.
Shipping Overrides This checkbox displays if there are shipping overrides applied to the line item.
Distribution Overrides This checkbox displays if there are distribution overrides applied to the line item.
Received Status This column indicates whether the item has been received through the Receiving application. The values can be Fully Received or Partially Received, which is based on the quantity values you entered in the Qty Accepted and Qty Rejected fields in the Receiving application.
Req # This required column is shown if the Requisition/RFQ Number in P.O. option is selected on the General tab of the Purchasing & Inventory Company Settings form Settings > Purchasing & Inventory > Company Settings.
  • Enter the number for a requisition or price quote request record.
  • The Requisition/RFQ lookup displays the requisitions and price quote requests that have a status of Approved.
Requester When you create a purchase order, you can enter the requester's name. This helps you to keep track of the purchase order. If the purchase order is created from a requisition or request for price quote, this column displays the data from Requested By on the requisition's or request's General tab.
Shipping This field displays when the Inventory feature is enabled, and is active when the Item is an inventory item. Enter the item's shipping cost, which is used to recalculate the item's average actual cost.
Tax This field displays when both the Inventory feature and the Tax Auditing feature are enabled, and is active when the Item is an inventory item. Enter the item's tax amount, which is used to recalculate the item's average actual cost.
Freight Charges This field displays when the Inventory feature is enabled, and is active when the Item is an inventory item. Enter the item's freight charges, which is used to recalculate the item's average actual cost.
Documents

Click the icon in this field to open the Supporting Documents dialog box and upload and associate one or more documents with the purchase order line item.

To view previously uploaded and associated documents, click the icon in this field:

  • An icon displays in this field if there are documents associated with the line item.
  • An icon with a plus sign displays in this field if there are no documents associated with the line item.

If you use the Vantagepoint on-premises product, this field displays only if Transaction Document Management is configured. For more information about the configuration, see the Configuring Supporting Documents online help topic.

Extra Amount Fields These fields display when the Inventory feature is enabled, and is active when the item is an inventory item. Enter the item's extra amount, which is used to recalculate the item's average actual cost.
View Detail This icon displays at the end of the row when you click or hover over a grid row entry. Click this option to open the Purchase Order Line Detail dialog box and change or view other information for the purchase order and line item. The dialog box contains information entered on other tabs of the Purchase Orders form.

For more information, go to Purchase Order Line Detail Dialog Box.

This icon displays at the end of the row when you click or hover over a grid row entry. Click the icon to select one of these actions for that row:
  • Copy: Select this option to copy the grid entry as a new line item.
  • Delete: For purchase orders that are in progress, select this option to delete the line item from the grid. For audit trail purposes, you cannot delete line items for purchase orders that are final printed or approved. As an alternative, copy a row and then change the quantity and net amount in the new row to be negative numbers.
  • View Details: Select this option to open the Purchase Order Line Detail dialog box. For more information, go to Purchase Order Line Detail Dialog Box.
+ Add Line Item Click this option to add a new line item for a purchase order. You cannot insert line items for approved or final printed purchase orders. Use a change order to modify approved or final printed purchase orders.