[GENERAL] Chart of Accounts

2008-10-12 Thread James Hitz
Dear All, I have just started experimenting with PGSQL, with a view to migrate from the SQL server I use currently. I am trying to implement an "intelligent" Chart of Accounts for an accounting program. The following is long-winded but please bear with me: I have a table coa (chart of accoun

Re: [GENERAL] Chart of Accounts

2008-10-16 Thread James Hitz
As I said earlier, I am quite green with PGSQL, so please bear with me when I ask "Stupid" questions... --- On Mon, 13/10/08, justin <[EMAIL PROTECTED]> wrote: > I just redid the accounting side of an application we have > access to > source code, so been here and done this. > > If i was not

Re: [GENERAL] Chart of Accounts

2008-10-23 Thread James Hitz
Sorry for the silence. Have been away on official duty. Please see inline: --- On Mon, 13/10/08, justin <[EMAIL PROTECTED]> wrote: > > > Create Table general_ledger_transactions( > transaction_id serial not null > coad_id integer, > accounting_period integer, > debit nu