Hi
I am currently battling on with a database to handle organisational budgets. This is quite similar to any accounting system, for the purposes of tracking and reporting on estimates for different activities for the present year and five forward years.
My current problem is this: I can calculate an operating result for a financial year ina report, or in a form, as the balance of expenses and revenue account amounts. I want add this operating result into the accumulated result for the year and permenantly record this into the main account transaction database with all other general ledger account transactions.This will enable me to display the total accumulated result in my balance sheet reports/queries. So far I am having no luck in doing this. Any pointers as to the best way of doing this, or general discoragement from wasting my time would be appreciated.
Thanks
I am currently battling on with a database to handle organisational budgets. This is quite similar to any accounting system, for the purposes of tracking and reporting on estimates for different activities for the present year and five forward years.
My current problem is this: I can calculate an operating result for a financial year ina report, or in a form, as the balance of expenses and revenue account amounts. I want add this operating result into the accumulated result for the year and permenantly record this into the main account transaction database with all other general ledger account transactions.This will enable me to display the total accumulated result in my balance sheet reports/queries. So far I am having no luck in doing this. Any pointers as to the best way of doing this, or general discoragement from wasting my time would be appreciated.
Thanks
