Re: Carry forward balance of account
- From: "pietlinden@xxxxxxxxxxx" <pietlinden@xxxxxxxxxxx>
- Date: Sun, 6 Jul 2008 22:41:20 -0700 (PDT)
On Jul 7, 12:32 am, Glynn <Gl...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
In my Accounting application I need to carry forward the balances of account,
at year-end close, to the new year, as Opening Balances in each ledger
account.
At present I achieve this by:
1) Copying the old batabase File to a back-up file - so as to
preserve to old
year in its entirety - all its transactions and reporting.
2) Deleting all the transactions in the current DB file - so as
to have a clean
start for the new year.
3) Manually entering Debit or credit entries to each Ledger
account, as
Opening balances for the new year.
This is not very smart - time consuming, and prone to unacceptable error.
There must be a way to programmatically 'carry forward' the balances of each
Ledger account from the old year to the new year. The 'balances' are
calculated amounts, being [Total Credits minus Total Debits] for each Ledger.
I would appreciate code, or being pointed in the right direction.
--
Glynn
How do you do this when you do it manually? Is it just your ending
balance from the previous year? If so, then you can create a query to
calculate the ending balance from the previous year and then appending
that record/those records (in the case of multiple accounts) to a
table in another database. One way to do it would be to use an append
query (turn your summary query that you use to get the ending balance
into an append or make table query and specify the destination
database.).
You could either use a linked table (flexible, but would require
caution) or hard code the destination database in SELECT INTO...
statement.
.
- Prev by Date: Carry forward balance of account
- Next by Date: Re: Carry forward balance of account
- Previous by thread: Carry forward balance of account
- Next by thread: Re: Carry forward balance of account
- Index(es):
Relevant Pages
|
Loading
