Originally Posted By: Andrew Bates
To have the View "ask you" for a range of item numbers, use this fiter:

Code:
AND(
  UPPER(TRIM({Item #}))>=UPPER(TRIM(QUERYSTRING("Starting item?", ""))),
  UPPER(TRIM({Item #}))<=UPPER(TRIM(QUERYSTRING("Ending item?", "zzzzzzzzzzzzzzzz")))
  )

For date ranges use "=QUERYDATE()".

I asked the same question about the transaction codes in IC history the other day. Here are the values:
Code:
 Trx Trx
 Src Type Description
 1   1    Receipt
 1   2    Receipt adjustment
 1   3    Receipt return
 2   1    Shipment
 2   2    Shipment return
 3   1    Adjustment credit 
 3   2    Adjustment debit
 4   1    Stock transfer from
 4   2    Stock transfer to
 5   1    Component item assembly
 5   2    Master item assembly


Hope that helps.


Could I find out what these code are:

Trx Trx
Src Type Description

3 3 Adjustment ????
3 4 Adjustment ????
3 5 Adjustment ????
3 6 Adjustment ????


Thanks
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc