Dear all,

In my report the stock is grouped as ItemID and Batch in which ItemID identify the Item in Stock and Batch identity the actual stock level, say If My stock of Acetone I have 1 bottle of 500 ml and 1 bottle of 100 ml.

In the report of dispense, I record the Date, Quantity and BatchID whicn I consumed.
In the report it show the history say

Acetone
xxxxxx001 500ml
2-4-1990 300 Consumed
6-6-1992 100 Consumed
---------------------------
400

Here I can sum up the total consumed volume, but I fail to calcualate the quantity left by OriginalQuantity-sum(ConsumedQuanttiy) at Batch group footer which the program report nonexisting of sum.prg(!)

Is there anything wrong or otherwise calculate the result by another view before getting the report??

Regards,



Ransome