2 Replies Latest reply on Nov 25, 2009 8:44 AM by user17640

    Inventory Report

    user17640

      Title

      Inventory Report

      Post

      I'm trying to do a report for tracking Inventory. I need the Inventory number to be deducted after each qty deduction. (I need the History not the actual inventoy.)

      Ex: at invoice Inv000000026 i want it to show on my report 98 and then at invoice INV000000047 show 88 if i sold 10 unit of the product

      How can it be done ?

      thx for any help




      Product ID     Name  Inventory  Invoices # Post Date Qty timestamp_mod
       
      PRO00000005 Amaretto 88 INV000000026 2009-07-16 1 2009-11-13 11:01:39
      PRO00000005 Amaretto 88 INV000000047 2009-10-09 10 2009-11-13 11:01:39
      PRO00000001 Espresso 65 INV000000006 2009-06-01 4 2009-11-13 11:01:39
      PRO00000001 Espresso 65 INV000000012 2009-07-03 3 2009-11-13 11:01:39
      PRO00000001 Espresso 65 INV000000015 2009-07-07 2 2009-11-13 11:01:39
      PRO00000001 Espresso 65 INV000000024 2009-07-15 4 2009-11-13 11:01:39
      PRO00000001 Espresso 65 INV000000025 2009-07-15 4 2009-11-13 11:01:39
      <!--   / message   -->