RE: database with yearly split data
- From: Fred <Fred@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 2 Sep 2008 06:47:13 -0700
On the money side, are you running a full GL (General Ledger) accounting in
your application (e.g. includes posting of all income and expenses) or just
the two described transaction categories (A/R & A/P)?
"cyrus05 via AccessMonster.com" wrote:
hi folks.
i am designing a database for a firm that has annual period of the accounting.
where they close all accounts at the end of each year. Balances are then
transfered as the initials (first) records to the next year. e.g
balances of the suppliers and customers accountings
total number of stock in hand for each item
etc.
Does anyone have any idea how to handle the data yearly? Filtering the
records is not a very good idea as for large database it will take time
opening every form that is bounded to data. I have seen one software in
Delphi that creates a seperate database in SQL server for the next year, and
transfer all the data from the previous year database with all the balances
as the first records in the new database accounting tables and stock tables.
bwefore logging in the software, you select the database (year) to work in.
in previous years all the new/edit/delete options are unavailable, only you
can browse the data but the new database can use the data from previous
databases as well as the current one. I have been working in access for years,
Any idea how to manage this, please explain in detail.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200808/1
- References:
- database with yearly split data
- From: cyrus05 via AccessMonster.com
- database with yearly split data
- Prev by Date: database with yearly split data
- Next by Date: RE: recursive relationships
- Previous by thread: database with yearly split data
- Next by thread: RE: database with yearly split data
- Index(es):
Relevant Pages
|
