Hi,

I designed a report in CR9 and grouped accordingly by supplier/product/order no.

I want the total for the balance qty.

ABC <- Group 1 (Supplier)
i10 <- Group 2 (Product)
PO-1 <- Group 3 (Order No)

PR No Date      Cust PO Qty    Rec Balance
----------------------------------------<- Details
PR-1 29/11/2011 79600   30000 6963 23037
PR-2 22/12/2011 81441   30000 6000 17037
PR-3 29/12/2011 81636   30000 6000 11037
PR-4 09/01/2011 82116   30000 9500 1537 (Balance)

PR-5 04/10/2011 78012   30000 16000 14000 (Balance)
-----------------------------------------------
                      (1537+14000)=15537 (Required)

Please help me very urgent...

thank you,