Subject | Re: [IBO] Correct Transaction Handling |
---|---|
Author | doughboypfb |
Post date | 2004-06-22T16:17:48Z |
Isn't the ending balance of each month the same as the starting
balance of the next month? Why store both?
Thanks for your help,
Paul
balance of the next month? Why store both?
Thanks for your help,
Paul
--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> > Could you elaborate how totals are never stored in the database?
> > Where are they stored then? I am thinking each account's first ledger
> > entry could represent past archived transactions from past periods.
> > No?
> >
>
> the running totals are only ever delivered out of the SP. Do a loop
thru the
> records being delivered in the same order each time (datestamp or PK
> ascending) accummulating the running total and creating a return
value on
> the fly.
> The opening and closing account balances for each period are
maintained in a
> separate table. When you close a period which is an administration
task, the
> closing balance of the transactions in question are total and those
totals
> are posted.
>
> >
> > > And make a "rollover" procedure where previous period
> > > accounting transactions are parked away from the "current" set.
> >
> > How parked? In another table? Database? What if a user wants to
> > "void" a check from last period? I assume a period could be as little
> > as a single month. Right?
>
> Parked in another table is the best (another db is not practical)
but I can
> imagine a design with appropriate flags on the records which would
prevent
> you accessing records which are not in the "current" period.
> All transactions in the previous (closed) periods are generally
locked. You
> can enter a reversing transaction but doing so into a closed period will
> require special user access/rights. How tough do you want to be or how
> closely does you system need to be auditable to the highest standard.
> A period is a single calendar month usually.
>
> >
> >
> >
> > How if it is "rolled over?"
>
> Not sure what you mean here?
>
> Alan