Thursday, May 24, 2018

balance brought forward

Hi,
I am working on an accounting app and i needed direction on how to go about calculating the balance brought for a particular day.

What i want to accomplish is being able to display the balance brought forward when the user select a date. i want to be able to display the transaction that happen in a particular date and the balance brought forward from the previous day.

currently i just sum up all the transaction that was done in and then minus the total sum to get the opening balance.

However when ever there is a movement in the account  the brought forward balance on different dates also change.

dailytransaction =Sum(dailytransactions)

openingbalance=totalsum

balancebroughforward=openingbalance-dailytransaction

how to i keep the balance brought forward for each day unchange whenever there is movement on an account each day.

cheer,

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPCf-y79d39D3Yu7_rL5b-AEU5AAsNYLTrd95WOZZwzCifycuw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment