Actualling there only some customers having opening amount till Sep -2011 in One Table...
SUB_ACNT_CODE as [Customer No],
SUB_ACNT_CODE as Custcode,
In another table:
month(TD_DOC_DT) as TD_DOC_DT_Month,
year(TD_DOC_DT) as TD_DOC_DT_Year,
date(Date#(year(TD_DOC_DT)&'-'&month(TD_DOC_DT),'YYYY-MMM'),'MMM-YYYY') as TD_DOC_DTYearMonth,
Here I have to add the opening balance to customers who are having DR_CR flag='D' added, if DR_CR='C' is Subtracted....
ACtually this the Logic I am working in Set Analysis Coming Correct....
I need to implement in Back ENd Script Calaculation & I have to bring as Finally bone AMount to a Customer No...
And the If Customer have not DOne any transaction in Any month automtatically previous month Amount Should be Carry Forwarded....
please help , If you want I will post my qvw