xml/sql conversion and balance sheet report rollup issue

[Phil Longstaff]

I believe that debug level output is still automatically turned on for the sql backend, so if you look at the gnucash.trace file, you should see it.  Among the output will be all SQL statements executed.  Look for "insert into prices" lines.

 Phil
---------
I used to be a hypochondriac AND a kleptomaniac. So I took something for it.




________________________________
From: "hasmeta at yahoo.com" <hasmeta at yahoo.com>
To: gnucash-user at gnucash.org
Sent: Thu, June 10, 2010 11:14:23 AM
Subject: xml/sql conversion and balance sheet report rollup issue

Hi,

I am running gnucash 2.3.14 with the xml data store. Almost all transactions are in USD, except for a few in EUR, HKD etc. The xml price database has some value for every currency and fund at some point in time. There aren't too many datapoints, but they suffice.

When I save this datastore in sqlite3, I see that no price info has been saved; i.e., Tools|Price Editor shows nothing. Account hierarchy appears to be the same. However, some accounts are missing transactions; sometimes only debit, sometimes only credit.

Also, when I run the balance sheet report against the xml data store, totals aren't rolled up at all. For instance, every account under Assets:Current has a positive or zero USD balance, but Assets:Current rollup is 0.

Is there a tool that checks the internal consistency of the xml/sql data stores?

How can I run gnucash in debug mode to see warnings?

--Hasmet

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.