PO Line Item Entry Items Grid Columns

In PO Line Item Entry, after items selected for an order are accepted, they are listed in the Items grid. Certain order defaults entered on the Main tab in Purchase Order Maintenance are defaults for each line item. If a change is made to a field on a line item, that individual trailer record's data is used; not the order's default.

Certain columns in the Items grid are changeable and other columns are not. Changeable columns generally are displayed in a different color. To edit data in a column for a line item, scroll to a changeable column, then click the column. You can also use the Tab key to move to each changeable column in the grid. Enter the required data and press the Enter key to accept the change(s).

Note Certain columns that are changeable may not be changeable after the order has been entered, received, or closed.

The following table lists the columns in the Items grid, whether the column can be changed, and a description of the column.

Column Name

Can Change?

Description

Product Code

No

This column displays the product code for each line item.

Product Name

Yes

This column displays the corresponding name for a line item, which can be changed from the default product name.

Quantity

Yes

This column displays the purchase quantity for each line item.

U/M

No

This column displays the purchase unit of measure for each line item.

Note Double-click a line item to change the Unit U/M field for a line item.

Unit Cost

Yes

Enter the cost of the product being ordered for each line item. The cost defaults to the cost entered in an active cost matrix for the selected product and supplier in Purchase Cost Matrix Maintenance. If no active cost matrix exists for the product, the cost defaults to the cost entered in an active cost matrix for the cost class of the product/location and supplier.

If no cost matrix has been defined, the cost defaults to the cost for the last purchase order for the selected product and supplier (even if the product was not received), or to zero (based on the selected Default PO Cost option in Purchasing Control Maintenance).

Note The active cost matrix used for a supplier is determined by the purchase order date or line item required date based on the selected Cost Based On option on the Purchasing/Receiving tab in Supplier Maintenance.

Cost Adj

Yes

Enter any adjustments (positive or negative) to the cost of each line item.

Charges

No

This column displays any additional charges associated with each line item.

Extended Cost

No

This column displays the extended cost for each line item. It is the unit cost plus or minus any cost adjustment, times the quantity ordered.

Cost Source

No

This column displays the cost source for each line item. One of the following values appears in this column:

  • Product - The unit cost defaulted to the cost from the active purchase cost matrix for the product and supplier.

  • Cost Class - The unit cost defaulted to the cost from the active purchase cost matrix for the cost class of the product/location and supplier.

  • Last Cost - The unit cost defaulted to the unit cost for the last purchase order for the selected product and supplier (even if the product was not received).

  • Manual - The unit cost was manually entered.

  • Manual-VAT - The unit cost (including VAT) was manually entered in the VAT-Inclusive Cost field.

Qty Received

No

This column displays the quantity received for each line item.

Qty Invoiced

No

This column displays the quantity invoiced for a line item.

Required Date

Yes

This column displays the date each line item is required, which defaults from the Main tab.

Ship Date

Yes

This column displays the ship date for each line item, which defaults from the Main tab.

Delivery

Yes

This column displays the delivery date, which defaults from the Main tab; this date is used for DRP (expected date to be delivered and available for sale) and for the Available to Promise Inquiry.

Rcpt. Cmp

Yes

Select the check box in this column for each line item for which receiving is complete. If the check box in the Inv. Cmp column is selected and you clear the check box in this column, the check box in the Inv. Cmp column is also cleared.

Note You cannot mark a purchase order line item as receipt complete if there is an unreceived container for the purchase order line item.

Inv. Cmp

Yes

Select the check box in this column for each line item for which invoicing is complete. If you select this check box, the check box in the Rcpt. Cmp column is selected automatically.

Total Weight

No

This column displays the total weight for each line item.

Total Volume

No

This column displays the total volume for each line item.

Weight U/M

No

This column displays the weight unit of measure for a line item. A default unit weight and weight unit of measure is stored in the product record, or can be added or adjusted in PO Line Item Entry.

Note Double-click a line item to change the weight unit of measure.

Unit Weight

No

This column displays the unit weight for each line item. A default unit weight is stored in the product record, or can be added or adjusted in P/O Line Item Entry.

Note Double-click a line item to change the unit weight.

Unit Volume

No

This column displays the unit volume for each line item. A default unit volume is stored in the product record, or can be added/adjusted in PO Line Item Entry.

Note Double-click a line item to change the Volume field for a line item.

Volume U/M

No

This column displays the volume unit of measure for each line item. A default volume unit of measure is stored in the product record, or can be added/adjusted in PO Line Item Entry.

Note Double-click a line item to change the Volume U/M field for a line item.

Project Number

No

This column displays the project number, which defaults from the Main tab.

Note Double-click a line item to change the Project # field for the line item.

Freight Free

Yes

The check box in this column is selected if the freight is free for the line item.

Shipper ID

No

This column displays the shipper ID for the line item, which defaults from the Main tab.

Note Double-click a line item to change the Shipper ID field for a line item.

FOB

No

This column displays the FOB terms.

Note Double-click a line item to change the FOB field for the line item.

Delivery Time

Yes

This column displays the delivery time for each line item, which defaults from the Main tab.

Style

No

This column displays the style associated with each line item. For information on setting up styles, see Style Maintenance.

 

Color Code

No

This column displays the color associated with each line item. For information on setting up colors, see Color Maintenance.

Size Code

No

This column displays the size associated with each line item. For information on setting up sizes, see Size Maintenance.

Country of Origin

Yes

This column displays the country of origin for each line item. The country of origin defaults from the supplier product. If it is not set up for the supplier product, it defaults from the supplier. If it is not set up for the supplier, it defaults from the product.

VAT-Inclusive Cost

Yes

Enter the cost of the product being ordered for each line item, including VAT. This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

Entered Cost

No

This column displays the cost generated by the system or manually entered in the Cost or VAT-Inclusive Cost field or column for each line item.

VAT Rate

No

This column displays the VAT percentage for each line item, which is the rate for the VAT class associated with the line item. This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

VAT Class Code

No

This column displays the VAT class used to calculate VAT for each line item that is VAT taxable. This defaults from the first VAT class found in the following hierarchy:

  1. product/location

  2. product

  3. country

This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

VAT Taxable

No

The check box is selected in this column for each line item that is VAT taxable. This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

VAT Exempt Reason Code

No

If a line item is not VAT taxable, but is on a VAT-taxable order, this column displays a VAT exempt reason code to explain why the product is exempt from VAT. This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

Line #

No

This column displays an internal line number assigned to each line item entered in the order.

Category

No

This column displays the product's category for each line item.

Cancelled

Yes (for line items that are not cancelled)

Select this check box to cancel a line item. When you cancel a line item, Purchase Order Line Cancellation appears, and allows you to enter a purchase order line cancellation reason code and remark to explain the reason for the cancellation. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled Reason Code

No

This column displays the purchase order line cancellation reason code for each line item that was cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled Remark

Yes

Enter a remark for the cancellation of the purchase order line item. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled by

No

This column displays the user ID of the user that cancelled each line item that was cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled Date

No

This column displays the date when each cancelled line item was cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Cancelled Time

No

This column displays the time when each cancelled line item was cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance.

Sales Contract Code

Yes

Enter a sales contract code associated with each line item, or double-click to select a sales contract code. For information on setting up sales contracts, see Sales Contract Maintenance.

Sales Contract Stage ID

No

This column displays the sales contract stage ID if the line item is associated with a sales contract stage.

Sales Contract Line Number

Yes

Enter a sales contract line number for each line item that is associated with a sales contract line number.

Product Duty Basis

No

This column displays the total product duty basis for each line item.

Charge Duty Basis

No

This column displays the total purchase additional charge duty basis for each line item. This includes charges set up to be included in the duty basis.

Open Qty

No

This column displays the quantity that is not in a container and not received for each line item.

Unrounded Extended VAT

No

This column displays the unrounded extended VAT amount for each line item.

Extended VAT

No

This column displays the extended VAT amount for each line item.

Unrounded VAT Amount

No

This column displays the unrounded VAT amount for each line item.

VAT Amount

No

This column displays the amount of VAT for each VAT-taxable line item, which is equal to the VAT rate of the product/location multiplied by the sum of the cost and cost adjustment. This column is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.