SQL Querry used for views

[Derek Atkins]

George Osvald <mail at okstudio.com.au> writes:

> I remember someone once told me I could use my existing SQL queries to view my 
> accounts. I believe I could incorporate queries I use at the moment to create 
> Australian BAS and also manipulate my inventory. That way I could add 
> functions that I require without making any changes to the software ( I am 
> not a programmer so I could not do that anyway). 
> I would leave my GST credits as a liability that would be brought back to zero 
> every quarter by making a deposit in my assets account.
> 
> Is this possible?

Nope.  For one thing, the postgres backend does not support the
business features.  For another, there is no way to "plug in SQL" into
gnucash.  Third, the postgres backend is just a datastore and has no
direct relationship to the GUI.  Finally, yes, you COULD store
inventory in the same database as GnuCash uses, but there is no way to
get gnucash to look at it or interface to it without modifying the
gnucash source code.

> Ps: We had a lot of heated discussions about GST lately and a main problem I 
> see is that people are looking at it as a regular tax which it is not (not in 
> Australia anyway). It is simply a liability that has to be sorted out and 
> reported every quarter. Then depending on the portion of exports in my income 
> I either pay or get a refund. That's where GST ends. It does not have to be 
> dealt with at the end of financial year (other than the last BAS).

The current Tax Table infrastructure just does calculations and adds data
to the accounts that you request.  It does not make any assumptions about
what you do with the information.

> Regards,

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available