In Purchase Order Maintenance, after items selected for an order are accepted, they are listed in the Items grid on the Items tab. The following table lists the columns in the Items grid.
Column Name |
Description |
Line # |
This column displays an internal line number assigned to each line item entered in the order. |
Product Code |
This column displays the product code for each line item. |
Qty Ordered |
This column displays the purchase quantity for each line item. |
U/M |
This column displays the purchase unit of measure for each line item. |
Unit Cost |
This column displays the unit cost for each line item. |
Cost Adj |
This column displays any adjustments (positive or negative) to the cost of each line item. |
Extended Cost |
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. |
Required Date |
This column displays the date each line item is required, which defaults from the Main tab. |
Product Name |
This column displays the corresponding name for a line item, which can be changed from the default product name. |
Search Name |
This column displays the product search name. |
Supplier Prod Code |
This column displays the supplier’s code for the product. |
Category |
This column displays the product's category for each line item. |
Cost Source |
This column displays the cost source for each line item. One of the following values appears in this column:
|
Unit Ext. Cost |
This column displays the unit cost for a line item with additional charges. |
Charge Total |
This column displays any additional charges associated with a line item. |
Total Item Cost |
This column displays the extended cost for each line item. It is the unit cost plus or minus any cost adjustment, plus additional charges, times the quantity ordered. |
Unit Weight |
This column displays the unit weight 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 P/O Line Item Entry. |
Extended Weight |
This column displays the total weight for a line item. |
Net Landed Cost |
This column displays the unit extended cost plus additional charges on a shipment. |
Selling Net Landed Cost |
This column displays the unit extended cost plus additional charges on a shipment (in the default sales unit of measure). |
Style |
This column displays the style associated with the product. For information on setting up styles, see Style Maintenance.
|
Color |
This column displays the color associated with the product. For information on setting up colors, see Color Maintenance. |
Size |
This column displays the size associated with the product. For information on setting up sizes, see Size Maintenance. |
Ship Date |
This column displays the ship date for each line item, which defaults from the Main tab. |
Qty Received |
This column displays the quantity received for each line item. |
Rcpt. Cmp |
The check box in this column is selected for each line item for which receiving is complete. |
Total Weight |
This column displays the total weight for each line item. |
Weight U/M |
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. |
Unit Volume |
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. |
Total Volume |
This column displays the total volume for each line item. |
Delivery |
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. |
Volume U/M |
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. |
Qty Invoiced |
This column displays the quantity invoiced for each line item. |
Inv. Cmp |
The check box in this column is selected for each line item for which invoicing is complete. |
Project Number |
This column displays the project number for each line item, which defaults from the Main tab. |
Freight Free |
The check box in this column is selected if the freight is free for the line item. |
Shipper ID |
This column displays the shipper ID for each line item, which defaults from the Main tab. |
FOB |
This column displays the FOB terms for each line item. |
Delivery Time |
This column displays the delivery time for each line item. |
Country of Origin |
This column displays the country of origin for each line item. This defaults from the supplier product record, or if that is blank, from the supplier record, or if that is blank, from the product record. |
Entered Cost |
This column displays the cost generated by the system or manually entered for each line item. |
VAT-Inclusive Cost |
This column displays 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. |
VAT Rate |
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 |
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. |
Sales Order # |
This column displays the sales order number associated with each line item (if the line item is for a drop-ship order). |
Sales Order Line # |
This column displays the sales order line number associated with each line item (if the line item is for a drop-ship order). |
Customer PO # |
This column displays the customer purchase order number associated with each line item. |
Store ID |
This column displays the store ID associated with each line item. |
Cancelled |
The check box in this column is selected if the line item is cancelled. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance. |
Cancelled Reason Code |
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 |
This column displays remarks for cancelled line items. This column is only available if the Audit Amendments check box is selected in Purchasing Control Maintenance. |
Cancelled by |
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 |
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 |
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 |
This field displays the sales contract code associated with each line item. For information on setting up sales contracts, see Sales Contract Maintenance. |
Sales Contract Stage ID |
This column displays the sales contract stage ID if the line item is associated with a sales contract stage. |
Sales Contract Line Number |
This field displays a sales contract line number for each line item that is associated with a sales contract line number. |
Product Duty Basis |
This column displays the total product duty basis for each line item. |
Charge Duty Basis |
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 |
This column displays the quantity that is not in a container and not received for each line item. |
Unrounded Extended VAT |
This column displays the unrounded extended VAT amount for each line item. |
Extended VAT |
This column displays the extended VAT amount for each line item. |
Unrounded VAT Amount |
This column displays the unrounded VAT amount for each line item. |
VAT Amount |
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. |