2 Replies Latest reply: Sep 19, 2011 6:09 AM by stefano santini RSS

    script;How can I get only the last transaction

      Dear QV-Users,


      I have 2 tabels. One with the transactions in a period and the ohter table is a MASTER FILE with the StockNo. I would like to write a script that will show me only the last transaction date for each StockNo. My tabels are:



      • StockNo
      • ReceivingDate  (format is YYYYMMDD; for today it will be "20110919")
      • Account
      • AccountCr




      • StockNo
      • UnitCost
      • QuantityOnHand



      Could someone tell me what the best approach will be for this case?