I am trying to develop a forecasting system to bolt onto Sage, i have currently linked all of the required tables and written querys to give a running balance of inputs and outputs.
My query currently shows several transaction dates throughout over a period of time, a plus or minus figure showing which way the money is going and a running sum.
What i would like to do now is to have this running balance start from a given figure. i.e. i want to input a start balance into a text box, and then have the running sum reduce or increase the figure dependant on the incoming or outgoings.
My query currently shows several transaction dates throughout over a period of time, a plus or minus figure showing which way the money is going and a running sum.
What i would like to do now is to have this running balance start from a given figure. i.e. i want to input a start balance into a text box, and then have the running sum reduce or increase the figure dependant on the incoming or outgoings.
