Line #

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

Return Code

This column displays the return code for each line item. This column is only available for return orders.

Adj. Type

This column displays Price or Inventory to indicate whether each return order line item is a price or inventory adjustment. This column is only available for return orders.

Receive Goods

The check box in this column is selected for return order line items if products will be received back into the warehouse. This column is only available for return orders.

Product Code

This column displays the product code for the each line item.

Qty Ordered

This column displays the quantity ordered for each line item. Changing this quantity may have an impact on any backordered, allocated, or future quantities.

Qty Backord

This column displays the quantity backordered for each line item.

Qty Future

This column displays the quantity for future allocations for each line item. This quantity is determined by the order's required date and the number of days entered in the Allocate X Business Days before Required Date field on the Warehouse tab in Product Location Maintenance.

Cancel Backorder

If the check box in this column is selected for a line item, and the line item is fully backordered, the backordered quantity is cancelled when a pick demand is printed for the order.

If the check box in this column is selected for a line item, and the line item is partially backordered, the backordered quantity is cancelled when inventory is adjusted for a pick demand for the line item.

Note This check box only functions in conjunction with pick demands printed for the line item (e.g., the customer will accept delivery of what can be shipped initially, but does not want the remainder of that line item). If no pick demand is printed for an order, and the Cancel after Date column is empty, the line item will remain open indefinitely.

Backorder Released on

This column displays the last date on which any backordered item was released.

Qty Alloc

This column displays the quantity allocated for each line item. A line item's quantity can be changed; however, it cannot be greater than the quantity ordered.

Qty Returned

This column displays the quantity returned for each return order line item. This column is only available for return orders.

Qty Received

This column displays the quantity received for each return order line item. This column is only available for return orders.

Fully Received

The check box in this column is selected for return order line items if inventory was fully received. This column is only available for return orders.

U/M

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

Unit Price

This column displays the unit price for each line item. For more information, see Price Logic FAQ.

Price Adj

This column displays adjustments to a unit price. A positive adjustment will increase the extended unit price while a negative adjustment will decrease the extended unit price, signifying a price discount. For more information, see Price Logic FAQ.

Extended Price

This column displays the extended price for each line item. Usually, this is the unit price plus or minus any price adjustments, times the quantity ordered. For cancelled line items, this is the unit price plus or minus any price adjustments, times either the quantity ordered (if the quantity ordered is equal to the quantity picked) or the quantity picked (if the quantity ordered is not equal to the quantity picked). As a result, this may equal zero if a line item is cancelled without being picked.

Rel. PO Num

This column displays the related purchase order number for a drop-ship or transfer order line item. For a transfer order, this column displays the purchase order number only after adjusting inventory for the order.

Double-click a purchase order number in this column to display Purchase Order Maintenance, which allows you to view and edit the purchase order.

Note If you are not authorized to use Purchase Order Maintenance, Purchase Order Inquiry appears instead, and allows you to view the purchase order.

Cancelled

The check box in this column is selected if the line item was cancelled.

Required Date

This column displays the required date entered on the Main tab in Order Entry.

Promise Date

This column displays the promise date for backordered line items; the date by which you expect to fill the backorder. The Promise Date Calculation window can be accessed by highlighting a backordered line item and clicking the Prom. Date button.

Cancel after Date

A line item will be cancelled the next day from the date assigned in this column, regardless of being allocated or backordered. In Pick Demand Create and Print, all sales order line items with a cancel-after date before today are automatically cancelled (e.g., the customer does not want the line item if it cannot be shipped prior to the cancel after date).

On Hold

The check box in this column is selected if a product is placed on hold due to backorders. If this check box is cleared, the product can be shipped.

Product Name

This column displays the product name for each line item. A change will only affect this line item. If you want to permanently change a product's name, use Product Maintenance.

Location

This column displays the shipping location for each line item. A location other than the default shipping location from the Main tab in Order Entry is selected during line item entry when a product cannot be sold from the default location, or when there is insufficient inventory in the default shipping location.

Category

This column displays the product category for each line item.

Price Source

This column displays the price source for each line item depending upon the pricing resolution. For more information, see Price Logic FAQ.

Unit Ext. Price

This column displays the extended unit price for each line item. This is the sum of the unit price and price adjustment for each line item.

Total Item Price

This column displays the total price for each line item. This includes any additional charges that are selected to post with items.

Tax Amount

This column displays tax amounts associated with a line item. This is tax over and above any tax included in the price of the product.

Tax Incl

The check box in this column is selected if tax is included in the price of the product.

Unit Weight

This column displays the unit weight for each line item.

Extended Weight

This column displays the extended unit weight for each line item. The calculation is determined by multiplying each unit weight by the quantity ordered.

Freight Free

The check box in this column is selected if the line item is freight free. It defaults to the selection on the Main tab in Order Entry. If the Freight Free check box is enabled on the Main tab, the Freight Free check box is also selected for the line items. Any changes to a line item's freight status impacts only that specific line item; the setting on the Main tab is not changed.

Qty on Pick Demands

This column displays the quantity on pick demands for each line item.

Qty Picked

This column displays the quantity picked for each line item. This quantity is automatically entered after an order is processed and picked or picked and confirmed.

Drop Ship

The check box in this column indicates whether line items are drop-ship items (products that are ordered and delivered without ever being receipted into a warehouse location). You cannot select this check box for a line item if the check box in the Spec. Order column is selected or if the product has been set up in Product Location Maintenance to not allow it to be drop-shipped. Drop shipped items must be ordered in Drop Ship and Special Order Create.

Spec. Order

The check box in this column is selected if the line item is a special order item. Special order items are similar to drop ship items except that these items arrive into your company's warehouse location, but are not stocked. Special order items are delivered from your company instead of directly from a supplier. If a line item is a special order item, the Rel. Supp grid column must contain a valid supplier code. No additional quantity is allocated for special order items (because they are not stocked); however, backordered quantities are removed. As with drop-ship items, special order items must be purchased in Drop Ship and Special Order Create. Special order items can be created on the fly in Order Entry using the New Item button only if you have the appropriate setup in the On the Fly Product Creation field in User Extended Options. For more information, see Products on the Fly.

Rel. WO Num

This column displays the related work order number for each line item. Double-click a work order number in this column to display Work Order Maintenance, which allows you to view and edit the work order. If multiple work orders are related to a line item, Multiple appears for the line item in this column, and if you double-click Multiple, Order and Work Order Relationships appears, and allows you to view the work orders associated with the line item.

Prc.Chg. Reas

This column can change based on setup. For more information, see Price Change Reason Code FAQ.

Prc.Chg. Comments

This column can change based on setup. For more information, see Price Change Reason Code FAQ.

Cust Rsrv. Qty

This column displays the quantity being allocated from the customer’s reservation quantity (this will reduce the customer’s reservation quantity by this quantity). For more information, see Product Inventory Reservation Maintenance.

Customer Product Code

This column displays the customer’s product code for each line item if it is set up. For more information, see Customer Product Maintenance.

Direct Ship

The check box in this column indicates whether each line item is to be direct shipped. After a line item is entered, select this check box to mark it as a direct shipped item. For more information, see Blanket Purchase Order Process Flow.

Forecast Hold

This check box in this column indicates whether this line item is on forecast hold. For more information, see DRP - Forecast Hold FAQ.

Fcst. Released Date

This column displays the date the line item was released from forecast hold. For more information, see DRP - Forecast Hold FAQ.

Fcst. Released by

This column displays the user that released this line item from forecast hold. For more information, see DRP - Forecast Hold FAQ.

Color Code

This column displays the color code associated with the product. For information on setting up color codes, see Color Maintenance.

Style Code

This column displays the style code associated with the product. For information on setting up style codes, see Style Maintenance.

Product Line

This column displays the product line associated with the product. For information on setting up product lines, see Product Line Maintenance.

Size

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

Released Qty

This column displays the released quantity for each line item.

EDI Spare 1

This column displays additional EDI information for each line item. You can edit this data for closed orders if the Can update EDI spare fields in Order Entry check box is selected for your user ID in User Extended Options.

EDI Spare 2

This column displays additional EDI information for each line item. You can edit this data for closed orders if the Can update EDI spare fields in Order Entry check box is selected for your user ID in User Extended Options.

EDI Spare 3

This column displays additional EDI information for each line item. You can edit this data for closed orders if the Can update EDI spare fields in Order Entry check box is selected for your user ID in User Extended Options.

EDI Spare 4

This column displays additional EDI information for each line item. You can edit this data for closed orders if the Can update EDI spare fields in Order Entry check box is selected for your user ID in User Extended Options.

EDI Spare 5

This column displays additional EDI information for each line item. You can edit this data for closed orders if the Can update EDI spare fields in Order Entry check box is selected for your user ID in User Extended Options.

Misc Data 1

This column displays additional miscellaneous information for each line item. You can edit this data for closed orders.

Misc Data 2

This column displays additional miscellaneous information for each line item. You can edit this data for closed orders.

Extended Volume

This column displays the extended unit volume for each line item. The calculation is determined by multiplying each unit volume by the quantity ordered.

Rel. Supp

This column displays the related supplier's supplier code for items if the check box in the Drop Ship or Spec. Order column is selected. A supplier code can be changed only for drop shipped or special order items.

Est. Cost

This column displays the estimated cost for each line item. The estimated cost can only be changed (increased or decreased) for items that are drop ship or special order. If no product cost is found, the estimated cost defaults to 0.00.

Est. Marg

This column displays the monetary estimated margin for each line item. Any amount for line item additional charges is not included. It is calculated as the unit extended price minus the estimated cost for each line item.

Est. Marg. %

This column displays the percentage of estimated margin for each line item. The percentage will not take into account any line item additional charges.

Misc

The check box in this column is cleared by default. Select this check box to mark a product as miscellaneous. This status is only informational, and allows you to track products for any purpose.

Cost Over

The check box in this column is selected if the value in the Est. Cost column is edited. The estimated cost can only be edited for items that are drop ship or special order.

Re-Allocation

The check box in this column indicates whether the product can be re-allocated to another customer. This defaults from the Allow Re-Allocation check box on the Warehouse tab in Product Location Maintenance.

Commission Override Rate

This column displays the commission override rate for each order line item.

Use Override Commission Rate

This check box is selected for each line item that is using a commission override rate. For more information, see Commission Override Maintenance.

Unit Volume

This column displays the unit volume for each line item.

VAT Taxable

The check box is selected in this column for each line item that is VAT taxable.

VAT Exempt Reason Code

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.

VAT Class Code

This column displays the VAT class used to calculate VAT for each line item that is VAT taxable.

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.

VAT-Inclusive Price

This column displays the price of the product being ordered for each line item, including VAT.

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 price and price adjustment.

Extended VAT

This column displays the extended VAT for each line item, which equals the quantity multiplied by the VAT amount.

Entered Price

This column displays the price generated by the system or manually entered for each line item.

Line Item Hold

This check box is selected for each line item that is on hold. If this check box is selected, the line item cannot be picked or added to a planned bill of lading.

Sales Contract Code

This column displays the sales contract code associated with each line item. For information on setting up sales contracts, see Sales Contract Maintenance.

Sample Reason Code

This column displays the sample reason code for each sample line item.

Require Customer Linkage

The check box is selected in this column for each sample line item associated with a sample reason code that requires a customer to be entered for the line item.

Sample Customer Code

This column displays the customer code of the customer that will receive each sample line item.

Sample Customer Name

This column displays the customer name of the customer that will receive each sample line item.

Billback Override Rate

This column displays the billback override rate for each sample line item (if one was entered).

Sample Comment

This column displays a comment to describe each sample line item

EDI Order Line Number

This column displays the line number from the customer's purchase order. You can edit this data for closed orders if the Can update EDI spare fields in Order Entry check box is selected for your user ID in User Extended Options.

Cancelled by

If a line item was cancelled, this column displays the user ID of the user that cancelled the line item.

Cancelled Date

If a line item was cancelled, this column displays the date the line item was cancelled.

Cancelled Time

If a line item was cancelled, this column displays the time the line item was cancelled.

Cancelled Reason

If a line item was cancelled, this field displays the order line cancel reason code associated with the cancelled line item. For information on setting up order line cancel reason codes, see Order Line Cancel Reason Code Maintenance.

Cancellation Comments

If a line item was cancelled, this field displays any comments entered to describe in detail why the order line item was cancelled.

Price Matrix Override

The check box in this column is selected if a price matrix was manually selected for the order line item.

Mix and Match Quantity

This column displays the quantity used for the price break calculation if the line item pricing is based on a mix and match price matrix.

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 column displays a sales contract line number for each line item that is associated with a sales contract line number.

Ship and Debit Unit Amount

This column displays the ship and debit unit amount for each line item (if applicable). This column is only available if you are allowed to view costs.

Ship and Debit Type

This column displays one of the following ship and debit types for each line item (if applicable):

• Units - Fixed Rebate - Calculate the rebate based on quantity breaks

• Price - Fixed Rebate - Calculate the rebate based on a specific price

• Units - Fixed Cost - Calculate the cost based on quantity breaks

This column is only available if you are allowed to view costs.

Margin Exception

The check box in this column is selected if the calculated margin for a line item does not pass the margin check.

Free Goods

The check box in this column is selected for each line item that is marked as free goods. This indicates the supplier will be billed back for the product.

Price Class Code

This column displays the price class code for the price matrix used for each line item.

Price Class Name

This column displays the price class name for the price matrix used for each line item.

Inventory Cost

This column displays the inventory cost for each line item. This column is only available if you are allowed to view costs.

Free Goods Cost

This column displays the cost for free goods for each line item (if applicable).

Free Goods Billback Amount

This column displays the billback amount for free goods for each line item (if applicable).

Customer Product Name

This column displays the customer product name for each line item if it is set up. For more information, see Customer Product Maintenance.

Price Book

This column displays the price book used to price each line item (if applicable).

Pre-Billed Quantity

This column displays the quantity on the pre-bill invoice for each line item for bill and hold orders.

Package U/M

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

Unrounded Tax Amount

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

Qty Returned - Restocked

This column displays the quantity returned and restocked for a return order after the return order receipt is confirmed. The return disposition code for the return order receipt controls whether the quantity is marked as restocked. This column is only available for return orders.

Qty Returned - Not Restocked

This column displays the quantity returned and not restocked for a return order after the return order receipt is confirmed. The return disposition code for the return order receipt controls whether the quantity is marked as not restocked. This column is only available for return orders.

Associated Invoice

If a return order line item is associated with an invoice for a sales order, this column displays the associated invoice number.

Generate Replacement S/O

The check box in this column is selected for line items to include on a replacement sales order for a return order. This column is only available for return orders.