AnsweredAssumed Answered

Inventory Report

Question asked by user17640 on Nov 25, 2009
Latest reply on Nov 25, 2009 by 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   -->







Outcomes