[grid dtl_grid gridlines program=orders;makegrid nosort class=font_90 size=auto/27] [col width=5 ttl="Drag" align=center event=*Rowdrag][symbol reorder][/col] [col source=productcode$ ttl="Product" width=20 query=scrnlib.en;product.q event=chgprod] [col source=Qoh$ ttl="QOH" width=(showall*6) align=center locked] [col source=QtyPricing width=0 locked] [col class=align_left ttl="Ordered" width=10][input ItemsOrdered bwz format=(QtyFmt$) event=chgQty eventif=dtl_grid:qtyPricing!=0][/col] [col source=ItemUom$ ttl="UOM" width=6 event=orders@chgUOM] [col source=ItemsShipped ttl="Ship" width=8 align=center bwz calc="dtl_grid:Qoh$=="" | CreditNote? dtl_grid:ItemsOrdered : min(dtl_grid:ItemsOrdered,Number(dtl_grid:Qoh$))" locked ] [col source=ItemBackOrder ttl="B/O" class=text_red align=center width=8 bwz calc="dtl_grid:Qoh$=="" | CreditNote? 0 : dtl_grid:ItemsOrdered-dtl_grid:ItemsShipped" locked ] [col source=ItemDescription$ ttl="Description" width=30] [col ttl="Base Price" source=ItemPrice format="-##,##0.00" width=12] [col ttl="Disc %" source=Itemdiscount format="#0.00" width=9] [col ttl="Adj Price" width=10 source=AdjPrice format="##,##0.00" calc="dtl_grid:ItemPrice*(100-dtl_grid:ItemDiscount)/100" locked] [col ttl="Extension" source=priceext width=13 format="-###,##0.00" calc="(dtl_grid:ItemsOrdered==0 ? 1 : dtl_grid:ItemsShipped)*dtl_grid:AdjPrice" locked] [col ttl="Tax Group" width=13][list ProdTaxGrp$ query=scrnlib;Prodtax.Q drop (tbl(productCode$="","locked","")) event=chgTax][/list][/col] [col ttl="Tax Rate" source=ItemTaxRate width=(showall*10) align=center bwz locked] [col ttl="Tax" align=center width=10 format="-##,##0.00" source=ItemTaxamt calc="(dtl_grid:priceext*dtl_grid:ItemTaxRate/100)" locked] [col ttl="Weight" width=(showall*10) source=ItemWeight] [col ttl="TotWeight" width=(showall*10) source=ItemTotWeight calc="dtl_grid:ItemsShipped*dtl_grid:ItemWeight"] [col width=4.5 align=center ttl="Del"][symbol trash event=*Rowdel][/grid]
[button Text="+10 rows" size=auto/2 event=orders@add10]  [checkbox showAll text=" Extended Display" event=orders@redraw]