Update BOL Grid Columns

The Update BOL grid on the Update BOL tab in Planned Bill of Lading Management contains different columns based on whether you select the Stop, Order, or Product radio button. The following table provides information on the included columns.

Selected Option

Description

Stop

 The grid includes the following columns:

  • Create BOL - Select the check box in this column for stops to include on a bill of lading if you are creating or editing a bill of lading. If you are editing a bill of lading, you can clear this check box for a stop only if pick demands do not exist for the stop.

  • Record Seq # - This column displays the original sequence of the stops when they were selected and displayed in the grid.

  • Delivery Sequence - Enter a delivery sequence for stops if you are creating or editing a bill of lading. If this is entered, pick demands can be printed in this sequence. If there are no gaps in the sequence (i.e., 1,2,3,4,5, etc.) and you move a stop up in the sequence, all higher numbers are increased by one.

  • Ship Complete - The check box in this column is selected for any ship complete orders for a bill of lading stop.

  • Amount Ordered - This column displays the original ordered for each stop.

  • Amount Allocated - This column displays the allocated amount on orders for each stop.

Note Select the Allow Unallocated Quantity on Planned BOL check box in Warehouse Management Control Maintenance to allow unallocated sales order lines to be selected.

  • Amount Available - This column displays the amount available to be selected for each stop. This is equal to the amount allocated minus the amount that is on a pick demand, picked, and/or on other bills of lading.

  • Ship Complete Amount Available - This column displays the ship complete amount available to be selected for each stop.

  • Amount Selected - This column displays the selected amount that will be on the bill of lading for each stop. This cannot exceed the allocated amount.

  • Amount On Pick Demand - This column displays the amount that is already on a printed pick demand for each stop.

  • Amount Picked - This column displays the confirmed amount on a pick demand for each stop.

  • Amount On Backorder - This column displays the backordered amount for each stop.

  • Amount On Future - This column displays the amount that is a future quantity for each stop. This amount cannot be allocated to a bill of lading.

  • Amount On Other BOL - This column displays the amount that is already selected that is on a different bill of lading.

  • Weight Ordered - This column displays the original weight of ordered products for each stop.

  • Weight Allocated - This column displays the allocated weight on orders for each stop.

  • Weight Available - This column displays the weight available to be selected for each stop.

  • Ship Complete Weight Available - This column displays the ship complete weight available to be selected for each stop.

  • Weight Selected - This column displays the selected weight that will on the bill of lading for each stop.

  • Weight On Pick Demand - This column displays the weight of products already on a pick demand for each stop.

  • Weight Picked - This column displays the confirmed weight on a pick demand for each stop.

  • Weight On Backorder - This column displays the weight of backordered products for each stop.

  • Weight On Future - This column displays the weight of future quantities for each stop.

  • Cube Ordered - This column displays the original volume of ordered products for each stop.

  • Cube Allocated - This column displays the volume allocated on orders for each stop.

  • Cube Available - This column displays the volume available to be selected for each stop.

  • Ship Complete Cube Available - This column displays the ship complete volume available to be selected for each stop.

  • Cube Selected - This column displays the selected volume that will be on the bill of lading for each stop.

  • Cube On Pick Demand - This column displays the volume of products already on a pick demand for each stop.

  • Cube Picked - This column displays the confirmed volume on a pick demand for each stop.

  • Cube On Backorder - This column displays the volume of backordered products for each stop.

  • Cube On Future - This column displays the volume of future quantities for each stop.

  • Total Lines - This column displays the total number of order lines for each stop.

  • Total Lines Allocated - This column displays the total number of allocated order lines for each stop.

  • Freight Charges - This column displays the amount of freight charged for each stop. To override the freight charges, click the Freight Charges button in the ribbon.

  • Non-Freight Charges - This column displays the amount of non-freight additional charges for each stop.

  • Customer Code - This column displays the customer code for each stop.

  • Customer Name - This column displays the customer name for each stop.

  • Store ID - This column displays the store ID for each stop.

  • Department Number - This column displays the department number for each stop.

  • Ship to Name - This column displays the ship-to address name for each stop.

  • Ship Address 1 - This column displays the first line of the ship-to address for each stop.

  • Ship Address 2 - This column displays the second line of the ship-to address for each stop.

  • Ship Address 3 - This column displays the third line of the ship-to address for each stop.

  • City - This column displays the city for the ship-to address for each stop.

  • State - This column displays the state for the ship-to address for each stop.

  • Postal Code - This column displays the postal code for the ship-to address for each stop.

  • EDI Trade ID - This column displays the EDI trade ID for each stop.

  • EDI Distribution Center - This column displays the EDI distribution center for each stop.

  • Cancel After Date - This column displays the cancel-after date for each stop.

  • Earliest Ship Date - This column displays the earliest ship date for each stop.

  • Latest Ship Date - This column displays the latest ship date for each stop.

  • Child BOL # - This column displays the child bill of lading number for each stop. This number is only assigned after a master bill of lading is created.

  • Created Date - This column displays the date the child bill of lading was created for each stop.

  • Routing Request Number - This column displays the routing request number for each stop.

  • Qty Ordered - This column displays the quantity ordered for each stop.

  • % Qty Allocated - This column displays the percentage of the quantity allocated for each stop.

  • % Amt Allocated - This column displays the percentage of the amount allocated for each stop.

  • % Qty Backordered - This column displays the percentage of the quantity backordered for each stop.

  • % Amt Backordered - This column displays the percentage of the amount backordered for each stop.

  • Qty Allocated - This column displays the quantity allocated for each stop.

  • Qty Picked - This column displays the quantity picked for each stop.

  • BOL Qty On Pick Demand - This column displays the bill of lading quantity on a pick demand for each stop.

  • Qty On Pick Demand - This column displays the quantity on pick demands for each stop.

  • Qty on BO - This column displays the quantity on backorder for each stop.

  • Qty on Future - This column displays the future order quantity for each stop.

  • Weight On 753 - This column displays the weight on the EDI form 753 for each stop.

  • Cube On 753 - This column displays the volume on the EDI form 753 for each stop.

  • Packages On 753 - This column displays the packages on the EDI form 753 for each stop.

  • Hazardous Materials - The check box is selected in this column if hazardous materials are being delivered for a stop.

  • Fully Shippable - The check box is selected in this column if all products for the stop can be shipped.

  • Partially Shippable - The check box is selected in this column if some products for the stop can be shipped.

  • Open Return Qty - This column displays the open return quantity for all order line items for each stop.

  • Open Return Cube - This column displays the open return cube for all order line items for each stop.

Order

 The grid includes the following columns:

  • Create BOL - Select the check box in this column for orders to include on a bill of lading if you are creating or editing a bill of lading. If you are editing a bill of lading, you can clear this check box for an order only if pick demands do not exist for the order.

  • Seq # - This column displays the original sequence of the stops when they were selected and displayed in the grid.

  • Order Number - This column displays each order number.

  • Customer PO # - This column displays the customer purchase order number (if it exists) for each order.

  • Order Status - This column displays the status of each order.

  • Ship Complete - The check box in this column is selected for any ship complete orders.

  • Amount On Other BOL - This column displays the amount that is already selected that is on a different bill of lading.

  • Amount Ordered - This column displays the original ordered for each order.

  • Amount Allocated - This column displays the allocated amount on orders for each order.

Note Select the Allow Unallocated Quantity on Planned BOL check box in Warehouse Management Control Maintenance to allow unallocated sales order lines to be selected.

  • Amount Available - This column displays the amount available to be selected for each order. This is equal to the amount allocated minus the amount that is on a pick demand, picked, and/or on other bills of lading.

  • Ship Complete Amount Available - This column displays the ship complete amount available to be selected for each order.

  • Amount Selected - This column displays the selected amount that will be on the bill of lading for each order. This cannot exceed the allocated amount.

  • Amount On Pick Demand - This column displays the amount that is already on a printed pick demand for each order.

  • Amount Picked - This column displays the confirmed amount on a pick demand for each order.

  • Amount On Backorder - This column displays the backordered amount for each order.

  • Amount On Future - This column displays the amount that is a future quantity for each order. This amount cannot be allocated to a bill of lading.

  • Weight Ordered - This column displays the original weight of ordered products for each order.

  • Weight Allocated - This column displays the allocated weight on orders for each order.

  • Weight Available - This column displays the weight available to be selected for each order.

  • Ship Complete Weight Available - This column displays the ship complete weight available to be selected for each order.

  • Weight Selected - This column displays the selected weight that will on the bill of lading for each order.

  • Weight On Pick Demand - This column displays the weight of products already on a pick demand for each order.

  • Weight Picked - This column displays the confirmed weight on a pick demand for each order.

  • Weight On Backorder - This column displays the weight of backordered products for each order.

  • Weight On Future - This column displays the weight of future quantities for each order.

  • Cube Ordered - This column displays the original volume of ordered products for each order.

  • Cube Allocated - This column displays the volume allocated for each order.

  • Cube Available - This column displays the volume available to be selected for each order.

  • Ship Complete Cube Available - This column displays the ship complete volume available to be selected for each order.

  • Cube Selected - This column displays the selected volume that will be on the bill of lading for each order.

  • Cube On Pick Demand - This column displays the volume of products already on a pick demand for each order.

  • Cube Picked - This column displays the confirmed volume on a pick demand for each order.

  • Cube On Backorder - This column displays the volume of backordered products for each order.

  • Cube On Future - This column displays the volume of future quantities for each order.

  • Total Lines - This column displays the total number of lines for each order.

  • Total Lines Allocated - This column displays the total number of allocated lines for each order.

  • Freight Charges - This column displays the amount of freight charged for each order. To override the freight charges, click the Freight Charges button in the ribbon.

  • Non-Freight Charges - This column displays the amount of non-freight additional charges for each order.

  • Customer Code - This column displays the customer code for each order.

  • Customer Name - This column displays the customer name for each order.

  • Store ID - This column displays the store ID for each order.

  • Department Number - This column displays the department number for each order.

  • Ship to Name - This column displays the ship-to address name for each order.

  • Ship Address 1 - This column displays the first line of the ship-to address for each order.

  • Ship Address 2 - This column displays the second line of the ship-to address for each order.

  • Ship Address 3 - This column displays the third line of the ship-to address for each order.

  • City - This column displays the city for the ship-to address for each order.

  • State - This column displays the state for the ship-to address for each order.

  • Postal Code - This column displays the postal code for the ship-to address for each order.

  • EDI Trade ID - This column displays the EDI trade ID for each order.

  • EDI Distribution Center - This column displays the EDI distribution center for each order.

  • Cancel After Date - This column displays the cancel-after date for each order.

  • Earliest Ship Date - This column displays the earliest ship date for each order.

  • Latest Ship Date - This column displays the latest ship date for each order.

  • Shipper ID - This column displays the shipper ID for each order.

  • Child BOL # - This column displays the child bill of lading number for each order. This number is only assigned after a master bill of lading is created.

  • Created Date - This column displays the date the child bill of lading was created for each order.

  • Routing Request Number - This column displays the routing request number for each order.

  • Required Date - This column displays the required date for each order.

  • Hazardous Materials - The check box is selected in this column if hazardous materials are being delivered for an order.

  • % Qty Allocated - This column displays the percentage of the quantity allocated for each order.

  • % Amt Allocated - This column displays the percentage of the amount allocated for each order.

  • % Qty Backordered - This column displays the percentage of the quantity backordered for each order.

  • % Amt Backordered - This column displays the percentage of the amount backordered for each order.

Product

 The grid includes the following columns:

  • Create BOL - Select the check box in this column for order lines to include on a bill of lading if you are creating or editing a bill of lading. If you are editing a bill of lading, you can clear this check box for an order line only if pick demands do not exist for the order line.

  • Seq # - This column displays the original sequence of the stops when they were selected and displayed in the grid.

  • Order Number - This column displays the order number for each order line.

  • Line # - This column displays each order line number.

  • Customer PO # - This column displays the customer purchase order number (if it exists) for each order line.

  • Order Status - This column displays the order status for each order line.

  • Product Code - This column displays the product code for each order line.

  • Product Alt. Search - This column displays the product search name for each order line.

  • Product Name - This column displays the product name for each order line.

  • Ordered U/M - This column displays the unit of measure for each order line.

  • Ship Complete - The check box in this column is selected for any ship complete order lines.

  • Qty Ordered - This column displays the quantity ordered for each order line.

  • Qty Allocated - This column displays the quantity allocated for each order line.

  • Qty Available - This column displays the quantity available for each order line.

  • Ship Complete Qty Available - This column displays the ship complete quantity available for each order line.

  • Qty Selected - Enter a product quantity to ship a partial line on a shipment if you are creating or editing a bill of lading.

  • Component Qty - This column displays the component quantity for each order line.

  • Qty on Pick Demand - This column displays the quantity on pick demands for each order line.

  • BOL Qty on PT - This column displays the bill of lading quantity on a pick demand for each order line.

  • Qty Picked - This column displays the quantity picked for each order line.

  • Qty on BO - This column displays the quantity on backorder for each order line.

  • Qty on Future - This column displays the future order quantity for each order line.

  • Qty On Other BOL - This column displays the quantity on other bills of lading for each order line.

  • Kit Item - The check box is selected in this column if an order line product is a kit.

  • Pieces Per Unit - This column displays the number of pieces per unit for each order line.

  • Amount On Other BOL - This column displays the amount that is already selected that is on a different bill of lading.

  • Amount Ordered - This column displays the original ordered amount for each order line.

  • Amount Allocated - This column displays the allocated amount on orders for each order line.

Note Select the Allow Unallocated Quantity on Planned BOL check box in Warehouse Management Control Maintenance to allow unallocated sales order lines to be selected.

  • Amount Available - This column displays the amount available to be selected for each order line. This is equal to the amount allocated minus the amount that is on a pick demand, picked, and/or on other bills of lading.

  • Ship Complete Amount Available - This column displays the ship complete amount available to be selected for each order line.

  • Amount Selected - This column displays the selected amount that will be on the bill of lading for each order line. This cannot exceed the allocated amount.

  • Amount On Pick Demand - This column displays the amount that is already on a printed pick demand for each order line.

  • Amount Picked - This column displays the confirmed amount on a pick demand for each order line.

  • Amount On Backorder - This column displays the backordered amount for each order line.

  • Amount On Future - This column displays the amount that is a future quantity for each order line. This amount cannot be allocated to a bill of lading.

  • Weight Ordered - This column displays the original weight of ordered products for each order line.

  • Weight Allocated - This column displays the allocated weight on orders for each order line.

  • Weight Available - This column displays the weight available to be selected for each order line.

  • Ship Complete Weight Available - This column displays the ship complete weight available to be selected for each order line.

  • Weight Selected - This column displays the selected weight that will on the bill of lading for each order line.

  • Weight On Pick Demand - This column displays the weight of products already on a pick demand for each order line.

  • Weight Picked - This column displays the confirmed weight on a pick demand for each order line.

  • Weight On Backorder - This column displays the weight of backordered products for each order line.

  • Weight On Future - This column displays the weight of future quantities for each order line.

  • Cube Ordered - This column displays the original volume of ordered products for each order line.

  • Cube Allocated - This column displays the volume allocated for each order line.

  • Cube Available - This column displays the volume available to be selected for each order line.

  • Ship Complete Cube Available - This column displays the ship complete volume available to be selected for each order line.

  • Cube Selected - This column displays the selected volume that will be on the bill of lading for each order line.

  • Cube On Pick Demand - This column displays the volume of products already on a pick demand for each order line.

  • Cube Picked - This column displays the confirmed volume on a pick demand for each order line.

  • Cube On Backorder - This column displays the volume of backordered products for each order line.

  • Cube On Future - This column displays the volume of future quantities for each order line.

  • Freight Charges - This column displays the amount of freight charged for each order line. To override the freight charges, click the Freight Charges button in the ribbon.

  • Non-Freight Charges - This column displays the amount of non-freight additional charges for each order line.

  • Quantity On Order - This column displays the quantity on order for the product on each order line.

  • Customer Code - This column displays the customer code for each order line.

  • Customer Name - This column displays the customer name for each order line.

  • Store ID - This column displays the store ID for each order line.

  • Department Number - This column displays the department number for each order line.

  • Ship to Name - This column displays the ship-to address name for each order line.

  • Ship Address 1 - This column displays the first line of the ship-to address for each order line.

  • Ship Address 2 - This column displays the second line of the ship-to address for each order line.

  • Ship Address 3 - This column displays the third line of the ship-to address for each order line.

  • City - This column displays the city for the ship-to address for each order line.

  • State - This column displays the state for the ship-to address for each order line.

  • Postal Code - This column displays the postal code for the ship-to address for each order line.

  • EDI Trade ID - This column displays the EDI trade ID for each order line.

  • EDI Distribution Center - This column displays the EDI distribution center for each order line.

  • Cancel After Date - This column displays the cancel-after date for each order line.

  • Earliest Ship Date - This column displays the earliest ship date for each order line.

  • Latest Ship Date - This column displays the latest ship date for each order line.

  • Shipper ID - This column displays the shipper ID for each order line.

  • Child BOL # - This column displays the child bill of lading number for each order line. This number is only assigned after a master bill of lading is created.

  • Created Date - This column displays the date the child bill of lading was created for each order line.

  • Routing Request Number - This column displays the routing request number for each order line.

  • Required Date - This column displays the required date for each order line.

  • Hazardous Materials - The check box is selected in this column if hazardous materials are being delivered for an order line.

  • % Qty Allocated - This column displays the percentage of the quantity allocated for each order line.

  • % Amt Allocated - This column displays the percentage of the amount allocated for each order line.

  • % Qty Backordered - This column displays the percentage of the quantity backordered for each order line.

  • % Amt Backordered - This column displays the percentage of the amount backordered for each order line.

  • Package U/M - Enter the package unit of measure for each order line.