Selecting orders with multiple transaction types
*If you see an underscore _ it is represented as a space.
At TCL Type:
SELECT_ORDER_WITH_TRANS.TYPE_"DI""CI""WI"_AND_WITH_INVOICE.DATE_>=
_"7/1/98"_AND_WITH_INVOICE.DATE_<=_"7/31/98" <ENTER>
Then type: SL_JULY <enter>
Then type: GL_JULY <enter>
Then type:
SORT_ORDER_BY_SHIPTO.NAME_BY_SHIPTO_BY_TRANS.TYPE_BY-EXP_PARTNO_BREAK-ON_SHIPTO.NAME_"'UVP'"_ROLL ON_TRANS.TYPE_"'U'"_INVOICE.DATE_PARTNO_UM_PDESC TOTAL_QTY.SHIP_PRICE_TOTAL_EPRICE_GRAND-TOTAL_"Grand_Total_'PU'"_TCL-SUPP_ID SUPP