Hi
my client want a report for inventory like (opening stock quantity,In quantity, out quantity, closing stock quantity, opening stock value , In value , out value, closing stock value ) Group wise .
Let we have 3 group A,B and C.
So result should be come .
Item Group, Opening Stock In Quantity, Out Quantity, Closing Stock Balance, Opening Stock Value, In Quantity Value, Out Qty value, Closing Stock Value ,
A 100 50 20 130 1000 500 200 1300
B 50 50 30 70 1000 1000 600 1400
C 20 25 10 35 200 250 100 350
Parameter Should be From Date, To Date, Item Group
Thanks & Regard
Khan