Filipe Fernandes wrote:
[snip]
Martin Winsler wrote:
Does anybody have any experience or knowledge of building
financial accounting databases?
[snip]
I too was thinking about building a double entry accounting system and
I've been following this thread closely,
On 2/26/07, Filipe Fernandes [EMAIL PROTECTED] wrote:
[snip]
Martin Winsler wrote:
Does anybody have any experience or knowledge of building
financial accounting databases?
[snip]
I too was thinking about building a double entry accounting system and
I've been following this thread closely,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/26/07 01:39, Karl O. Pinc wrote:
On 02/25/2007 06:21:45 PM, Kenneth Downs wrote:
Martin Winsler wrote:
[snip]
The above proposal takes care of the data
structure/referential integrity
issues, but does not solve the data integrity
Kenneth Downs wrote:
So far so good. Now we have AR invoices, and AP vouchers. Let's
My apologies if this is a stupid question, but what do AR and AP
stand for? I'm following this thread with interest.
Ray.
---
Raymond
On Feb 26, 2007, at 19:32 , Raymond O'Donnell wrote:
Kenneth Downs wrote:
So far so good. Now we have AR invoices, and AP vouchers. Let's
My apologies if this is a stupid question, but what do AR and
AP stand for? I'm following this thread with interest.
Accounts Receivable and
Karl O. Pinc wrote:
On 02/25/2007 06:21:45 PM, Kenneth Downs wrote:
Martin Winsler wrote:
This is a real world situation where referential
integrity needs to be broken in theory, I believe. Does anybody
have any experience or knowledge of building financial accounting
databases? Am I
[snip]
Martin Winsler wrote:
Does anybody have any experience or knowledge of building
financial accounting databases?
[snip]
I too was thinking about building a double entry accounting system and
I've been following this thread closely, learning a few tricks on the way :)
I've been gathering
On 02/26/2007 07:40:17 AM, Kenneth Downs wrote:
Karl O. Pinc wrote:
On 02/25/2007 06:21:45 PM, Kenneth Downs wrote:
Martin Winsler wrote:
This is a real world situation where referential
integrity needs to be broken in theory, I believe.
The problem is that with double entry accounting
Karl O. Pinc wrote:
You can put triggers into the financial transaction detail table
that says that the batch id has to be valid if it exists
to get your referential integrity right.
Right.
You can also not allow new rows to be inserted if there
is already a batch row, thus the insertion of
On 02/26/2007 11:41:18 AM, Kenneth Downs wrote:
You can also not allow new rows to be inserted if there
is already a batch row, thus the insertion of a
batch row closes the batch.
Not sure what you mean, but you can in fact have any number of open
batches, on the assumption that it is a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/26/07 10:35, Filipe Fernandes wrote:
[snip]
Martin Winsler wrote:
Does anybody have any experience or knowledge of building
financial accounting databases?
[snip]
I too was thinking about building a double entry accounting system and
Look at SQL-Ledger and LedgerSMB
[snip]
Ledger SMB (http://www.ledgersmb.org/about/) might be a place to start.
Thanks Ron and Brent for the suggestion... very much appreciated.
filipe
---(end of broadcast)---
TIP 3: Have you checked our
Martin Winsler wrote:
I hope this isn't too far off topic. I've noticed some discussion
about referential integrity, the use of nulls, and database design
recently here. This is a real world situation where referential
integrity needs to be broken in theory, I believe. Does anybody have
On 02/25/2007 06:21:45 PM, Kenneth Downs wrote:
Martin Winsler wrote:
This is a real world situation where referential
integrity needs to be broken in theory, I believe. Does anybody
have any experience or knowledge of building financial accounting
databases? Am I wrong about this?
I hope this isn't too far off topic. I've noticed some discussion about
referential integrity, the use of nulls, and database design recently here.
This is a real world situation where referential integrity needs to be broken
in theory, I believe. Does anybody have any experience or
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/23/07 20:35, Martin Winsler wrote:
I hope this isn't too far off topic. I've noticed some
discussion about referential integrity, the use of nulls, and
database design recently here. This is a real world situation
where referential
16 matches
Mail list logo