| Cumulative balance of [message #431120] |
Sun, 15 November 2009 10:20  |
mosab
Messages: 2
Registered: August 2009
Location: iraq
|
Junior Member |
|
|
accno number customer account number
d_date date history of the movement
in_m amount in
Quantity out_m out
How I could know the balance to a specific date, and not the final balance
I mean, for example in the history of 1/1/2009, the balance 1000
30.1.2009 in the history of the balance 2000
How do I make a report that displays the balance group by date in the by date of how the balance of the customer
The report of the movements and balance against it on that day, I was moved, which depends on the previous day, as you know
please help me
like this
report
accno date in out balance
25 1/1/2009 100 0 100
25 1/1/2009 100 50 150
25 30/9/2009 100 50 200
25 5/10/2009 100 20 280
becom final report lik this
group
accno date in out balance
25 1/1/2008 200 50 150
25 30/9/2009 100 50 200
25 5/10/2009 100 20 280
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
