arate from any
> >>> accounts receivable, it is a retainer liability account).
> >>>
> >>> I tried digging through the account piechart.scm and the taxinvoice.scm
> >>> to
> >>> see if I can come up with a way to query the account something lik
>
>>> I would like to update our invoice .scm template to include a balance from
>>> an account containing the customer's name (this is separate from any
>>> accounts receivable, it is a retainer liability account).
>>>
>>> I tried digging through the
e (this is separate from any
> > accounts receivable, it is a retainer liability account).
> >
> > I tried digging through the account piechart.scm and the taxinvoice.scm to
> > see if I can come up with a way to query the account something like this:
> >
account).
>
> I tried digging through the account piechart.scm and the taxinvoice.scm to
> see if I can come up with a way to query the account something like this:
>
> gnc:account-get-comm-balance-at-date append("Liabilities::Retainers::"
> coyname)
First, you
if I can come up with a way to query the account something like this:
gnc:account-get-comm-balance-at-date append("Liabilities::Retainers::" coyname)
But I'm not sure how to pass today's date. It's been years since I've
written scheme so any help would be greatly appreciated!
-Eri
Dear Whoever
I use Gnucash for a volunteer organisation and I have hidden an account that
I don't want to use anymore, but I can't unhide it to see the historic
information in it. Is there a way of showing it again?
I would be most appreciative if you could help me with this.
Many thanks for
On 29 April 2011 16:11, Philip Gordon phi...@philipgordon.co.uk wrote:
Dear Whoever
I use Gnucash for a volunteer organisation and I have hidden an account
that I don't want to use anymore, but I can't unhide it to see the historic
information in it. Is there a way of showing it again?
On
Hi Ayaz,
Am Donnerstag, 17. März 2011 um 07:19:56 schrieb ayaz ahmad:
Hi,
I am using GNUcash widows 2.4.4 and want to know how can i set up Vat so
GNUcash automaticall calculate vat on every invoices i enter
Does
Am Samstag, den 20.06.2009, 12:00 -0400 schrieb
gnucash-devel-requ...@gnucash.org:
Message: 1
Date: Fri, 19 Jun 2009 12:52:37 -0400
From: Phil Longstaff plongst...@rogers.com
Subject: Re: Another problem with scheme query and SQL backend
To: gnucash-devel@gnucash.org
Message-ID
On May 31, 2009 12:41:13 pm Phil Longstaff wrote:
On May 31, 2009 06:53:23 am Erwin Rieger wrote:
Hi,
i have another funny problem with querying data from scheme with the
(my)sql backend.
The query from my previous posts do only return transactions that
are/were shown in the gui
Hi,
i have another funny problem with querying data from scheme with the
(my)sql backend.
The query from my previous posts do only return transactions that
are/were shown in the gui (ledger)!
Steps to reproduce:
* install config.user from my previous post in ~/.gnucash
* open
On May 31, 2009 06:53:23 am Erwin Rieger wrote:
Hi,
i have another funny problem with querying data from scheme with the
(my)sql backend.
The query from my previous posts do only return transactions that
are/were shown in the gui (ledger)!
Steps to reproduce:
* install config.user
Hi,
i've noticed a different behavior of gnucash-backends when running
querys from scheme. If a query is setup without accounts the xml backend
selects data from all accounts, the sql backend coredumps with the same
query (see backtrace below). If the query is setup with accounts, the
query
Version i've testet ist latest svn, 18095.
--
Mit freundlichen Gruessen Erwin Rieger
| Ingenieurbuero Rieger, Software Entwicklung
| EMail: erwin.rie...@ibrieger.de
Hi Erwin,
how do you install and use these?
Phil
On May 30, 2009 11:30:02 am Erwin Rieger wrote:
Hi,
i've noticed a different behavior of gnucash-backends when running
querys from scheme. If a query is setup without accounts the xml backend
selects data from all accounts, the sql backend
hello GNUcash, I plan to use this software for my own business, just for
credibility, may i please have at least five well known companies that uses
this software? thank you and good day.
-
Looking for last minute shopping deals? Find them fast with
Jiaan co [EMAIL PROTECTED] writes:
hello GNUcash, I plan to use this software for my own business, just for
credibility, may i please have at least five well known companies that uses
this software? thank you and good day.
I don't think we have such a list.
You'd probably do better
I have the basic split query working. I receive the query:
(1) SELECT * FROM splits WHERE account_guid = 'XXX'
and convert it to:
(2) SELECT * FROM transactions WHERE guid IN
(SELECT DISTINCT tx_guid FROM splits WHERE account_guid = 'XXX')
Then, for each transaction, I load
Phil Longstaff [EMAIL PROTECTED] writes:
On Sun, 2006-12-11 at 15:18 -0500, Derek Atkins wrote:
Not only that -- you need to check whether the transaction content in the
DB is newer than the cache in the engine. E.g. in a multi-user situation
one user may have modified the contents of a
On Wed, 2006-15-11 at 13:33 -0500, Derek Atkins wrote:
Yes. Keep in mind that once you get to the point of getting told
object is locked, it's already too late.. There's no error code
returned from begin_edit() that could get displayed to the user. In
this case I think it's last writer
Phil Longstaff [EMAIL PROTECTED] writes:
On Wed, 2006-15-11 at 13:33 -0500, Derek Atkins wrote:
Yes. Keep in mind that once you get to the point of getting told
object is locked, it's already too late.. There's no error code
returned from begin_edit() that could get displayed to the user.
On Sun, 2006-12-11 at 15:18 -0500, Derek Atkins wrote:
Not only that -- you need to check whether the transaction content in the
DB is newer than the cache in the engine. E.g. in a multi-user situation
one user may have modified the contents of a transaction, so when another
user performs a
as children of the transactions. The
set of splits matching the initial query are put into the query's result
set.
I haven't looked at the sorting in the initial query, so I don't know
how it would translate to a transaction SELECT
I guess I had better check that a transaction hasn't already been
the query.
But you clearly need to perform multiple SQL Queries for this QofQuery.
In particular you clearly need to do three things:
1) Find all Splits that match the QofQuery
2) Find all Transactions that contain the Split response
3) Find all Splits from all those Transactions.
How you do
,
No doubt this will seem a trival and perhaps a 'obvious' query but ...
I pull down the latest build using CVS for the current development,
then './autogen.sh --enable-ofx --enable-opt-style-install
--prefix=/opt/gnucash.'
After various warnings then the build stops:
'
Running automake --gnu
Dear all,
No doubt this will seem a trival and perhaps a 'obvious' query but ...
I pull down the latest build using CVS for the current development, then
'./autogen.sh --enable-ofx --enable-opt-style-install
--prefix=/opt/gnucash.'
After various warnings then the build stops:
'
Running
Quoting Andrew Wood [EMAIL PROTECTED]:
Dear all,
No doubt this will seem a trival and perhaps a 'obvious' query but ...
I pull down the latest build using CVS for the current development,
then './autogen.sh --enable-ofx --enable-opt-style-install
--prefix=/opt/gnucash.'
After various
,
Is there anything special in how gnc-query-list and gnc-reconcile act as
lists? I want to replace their implementation with the new GtkTreeView
stuff and it would be a bit easier knowing why these two lists were
created.
Stephen
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Hi,
I've noticed some intermittent memory corruption in HEAD (and g2).
It's not 100% reproducible, but does seem to occur about 25% of the
time in my body of personal tests. In particular, test-query seems to
fail. I tried running under gdb and this is what I got.
Unfortunately running
More information... I was running (g2 branch) on my FC2 test
system. It apparantly has a fixed version of libltdl so running
with EFence works. It died in a difference place. I'm fairly
sure this is due to EFence signalling access to free()'d data,
but it's hard to tell which commodity is
Hi Jim,
Back in the good-ol xml v.1 days, I'd added routines to read and write
the Query struct. This allowed two things:
-- save and restore of the query state for Bill's transaction finder.
Presumably, this would allow users to create custom reports
(e.g. find me all transactions
to the Query scheme, perhaps thus:
module Query {
enum SortBy { STANDARD, DATE, DATEENTERED, DATERECONCILED, NUM,
AMOUNT, MEMO, DESC, RECONCILE, NONE };
enum QueryOp { AND, OR, NAND, NOR, XOR };
enum pdtypet { DATE, AMOUNT, ACCOUNT, STRING, CLEARED, MISC };
enum acctmatcht
to consider how adding the ability to calculate
totals to the Query API might work?
Anyway, I'm pleased to have this working, and as soon as Rob and I
sort out a new g-wrap release I'll send out the patch.
Robert Merkel
I'm looking at the new query engine
with the goal of using it in the transaction report.
It appears that the query code has
a) not been wrapped for use from Scheme, and
b) wrapping it isn't exactly trivial :)
Amongst other things, a general solution for mapping C enumerations
to Scheme
I'm looking at the new query engine
with the goal of using it in the transaction report.
It appears that the query code has
a) not been wrapped for use from Scheme, and
b) wrapping it isn't exactly trivial :)
Amongst other things, a general solution for mapping C enumerations
Robert Graham Merkel [EMAIL PROTECTED] writes:
a) not been wrapped for use from Scheme, and
Is this on anyone's agenda ATM?
It's on mine. I don't actually think it will be that hard to g-wrap
up... I'll have a look this weekend.
b.g.
--
Gnucash Developer's List
To unsubscribe send empty
rebalancing multisplit
transactions being tied up with this somehow but the details escape
me.
Anyways, I'd like to be able to save a query in a budget line,
modify the dates to correspond with the report parameters, and get a
list of Split*'s all from my scheme budget report.
You're most
There's support for user-provided query predicates, which I engineered
with Scheme in mind; if you have a user filter-pred that's a scheme
thunk, it's possible to add it to queries also. I just need to write
a little C wrapper to call it.
I definitely don't need this, as the find dialog
Bryan Larsen [EMAIL PROTECTED] writes:
2. Transactions can appear more than once. That seems pretty durn wacky.
Dave: what did we decide about this? Is it a problem with the Split**
I am generating, or a natural side effect of the way the register
works? I remember that discussion
On Fri, 21 Apr 2000, Dave Peticolas wrote:
Bryan Larsen [EMAIL PROTECTED] writes:
2. Transactions can appear more than once. That seems pretty durn wacky.
Dave: what did we decide about this? Is it a problem with the Split**
I am generating, or a natural side effect of the way the
On Fri, 21 Apr 2000, Bryan Larsen wrote:
I've run up against the exact same problem in the "transactions 2" report.
I haven't done anything about it, but it was my opinion that duplicates
should only be removed if:
1) in a multi-line report format, and
2) are in the same subsection.
the
Are you saying that I should NEVER have multiple lines of a split transaction
which "duplicate" other lines of the transaction?
I was talking about something else entirely. But thanks for the excellent
example that illustrates the problem.
If you use the find dialog, and search on
On Thu, 06 Apr 2000 16:22:43 MDT, the world broke into rejoicing as
Bryan Larsen [EMAIL PROTECTED] said:
What I really want is a way to save views into reports. For example,
I want a user defined report that gives me my budget status for the last
30 days, a report that gives me the "balance"
43 matches
Mail list logo