I have PO Quantity field and GR Quantity field follow example below:
PO No.| GR Date | PO Quantity | GR Quantity
0001 1/1/2011 300 160
0001 5/1/2011 300 40
0001 7/1/2011 300 100
I want to show in query.
PO No.| GR Date | PO Quantity | GR Quantity | Cumulated GR Quantity | PO OutStanding (PO Quantity - Cumulated GR Quantity)
0001 1/1/2011 300 | 160 | 160 | 140
0001 5/1/2011 300 | 40 | 200 | 100
0001 7/1/2011 300 | 100 | 300 | 0
I want to use technic of Bex for this solution
Can you help me?
Thank you very much.
Edited by: A J on Jan 12, 2011 10:17 AM