");
write(" Order Status By Order Number");
write("" +
"Customer No | "+
"Customer Name | "+
"Cust P.O. | "+
"Order No | "+
"Order Date | "+
"Line No | "+
"Item No | "+
"Description | "+
"Qty Ord | "+
"Qty Shipped | "+
"Price | "+
"Qty B.O. | "+
"$ B.O. | "+
"
");
var no_data = "Y";
var bo_qty = 0;
var bo_amt = 0;
while(OrderQuery.next()){
no_data = "N";
if (OrderQuery.qty_shipped > 0 && OrderQuery.qty_shipped != OrderQuery.qty_ordered){
bo_qty = OrderQuery.qty_ordered - OrderQuery.qty_shipped;
bo_amt = bo_qty * OrderQuery.price;
}
write("" + OrderQuery.customer_no + " | ");
write("" + OrderQuery.customer_name + " | ");
write("" + OrderQuery.customer_po + " | ");
write("" + OrderQuery.order_no + " | ");
write("" + OrderQuery.order_date + " | ");
write("" + OrderQuery.line_no + " | ");
write("" + OrderQuery.item_no + " | ");
write("" + OrderQuery.description + " | ");
write("" + OrderQuery.qty_ordered + " | ");
write("" + OrderQuery.qty_shipped + " | ");
write("" + OrderQuery.price + " | ");
write("" + bo_qty + " | ");
write("" + bo_amt + " | ");
}
write("
");
if(no_data == "Y")
write("No Data Matches Your Selections");
project.unlock();