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:

       

      Transactions:

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

       

       

      MasterFileStock:

      • StockNo
      • UnitCost
      • QuantityOnHand

       

       

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

       

      Regards,

       

      Aissam