CR新手,使用CR v10和SQL Server2000。
对于第一条记录,即期初余额,计算的是从输入日期开始的sum(字段),我在SP中将其计算为BegDateSum
但对于组下的其余记录,计算应为previous(balance)+IN+OUT
已给出示例:
Date Doc Descrip IN OUT Balance
Group Header-------- Beginning Balance-------------- 50 <---- sum(field) from my inputdate
3/2/2012 A -1
我试图选择上个月的期末余额,并将其作为下个月的期初余额,但我似乎没有得到正确的结果。
我已经使用此代码来选择其他列并获得平衡:
SELECT Year1,StockNumber,InventoryName,Month1,
SUM(ABS(RECEIVE_FROM_PO)) AS RPO,SUM(ABS(RECEIVE_XFER))AS XEFR,
SUM(ABS(RECEIVE_ADJ)) as RDJ,SUM(ABS(RETURN1)) AS RET,
SUM(ABS(TRANSFER)) as TSFR,SUM(ABS(ISSUE)) as