Selecting Orders with Multiple Transaction Types
Previous Topic  Next Topic 

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