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