> When we enter donations in Gnucash, we enter them as a lump sum ($1,000) > as a tranfer from Income:donations to Bank:checking. > > In Rapport, we store each donation separately, so that $1,000 is broken > down into many donations. >
> I definitely don't want to track each donation separately in Gnucash. That > really doesn't help with anything, and makes our accounts much more > confusing. That's good to learn. At what level are donations aggregated into a single GNUCash record? I mean --- every month, every year, etc? > What might be nice is a way to associate each donation in Rapport with > some sort of "deposit id" or Gnucash record transaction id, so that for a > given donation in Rapport, we can find it's corresponding (lumped > together) transaction in Gnucash. Sounds like a good idea. Then the set of donations under one depositid should add up to the GNU Cash line of that depositid. There would need to be some kind of "dirty" bit. When you periodically synch with GNUCash, you transfer over any records marked as dirty. > Adding such a field is obviously trivial. Automating any sort of > connection between the two things is obviously much more complicated, and > that's where I get stuck. What are the problems involved? Is it possible to connect to the GNU Cash data store? Maybe I can help in researching ways this can be done. (I once did an accounting system integration that involved using Windows events to simulate mouse clicks on Quicken. This was necessary because Intuit kept breaking third-party ODBC drivers to its backend database, and encrypting it instead. Definitely the integration from hell). There's been talk of a GNU Cash SQL-based backend. I don't know where that's gone, but here's an initial lead... http://www.pbooks.org/blog/2007/07/21/gnucash-sql-backend/ And that brings up something I hadn't heard about before --- pbooks, an open source accounting package! Apparently it's based on experience with GNUCash and its licensed AGPL. http://www.pbooks.org/blog/about/ Maybe we should talk seriously about getting behind pbooks, then we could just reach directly into its MySQL database. It would be interesting to know whether pbooks can fulfill the animal rights group's accounting needs; and if so, how painful the conversion from GNU Cash might be. Does anyone here have any experience with PBooks? As I mentioned before, Quasar might be another option. But it currently has no community, it's just a big bunch of C++/Qt code that compiles on Linux. -- Bob _______________________________________________ software mailing list [EMAIL PROTECTED] http://lists.flossfoundations.org/mailman/listinfo/foundations-software
