GNOME Bugzilla – Bug 585901
Integration with other systems.
Last modified: 2018-06-29 22:23:26 UTC
I've seen other postgresql based accounting system (SQL Ledger and Xtuple) but I think Gnucash is what we need for our project. The other two systems are oriented to manufacturing with accounting as an afterthought. We are building an attorney's case management system and we would like to post billing generated the case management system into the Gnucash General Ledger. Other systems use Postgresql's SERIAL ID generator for the primary key which makes this easy. I dneed instruction on how to generate a GUID generated by Gnucash. Is there a chance you can publish an interface guide for direct posting into Gnucash from other Postgresql applications? I also need a way to design our own invoices. The attorneys' clients need on the invoice their court's Index Number and the law firm's case number. SQL Ledger has a template system for doing that. Any chance Gnucash can provide something like that? Thanks. It seems you are on the way for a great product!
What would be best (better than you posting directly) would be for you to use the gnucash api. You would open a session, create a transaction, create 2 or more splits, commit them, close the session. Currently, scheme (scm) code generates html which is then displayed and which be exported and/or printed. There is work being done to turn this around so that there is an html template with embedded scm code to fill in information. The plan is that this can be completed for 2.4. This might fill your needs, though I don't know how you would insert custom information (index number/case number). I could also provide you with modifications to the invoice code if you can provide your format.
Is there any documentation on how to open the gnucash api for loading transactions, splits and committing? Sorry, but I don't know anything about the api although I do know a lot about Postgresql. Is it possible for gnc to read input in an XML file and generate transactions, splits, invoices (A/R) and bills (A/P)? If this is not possible, how abut just a few paragraphs in which you describe the updates, inserts and (if necessary) deletes to each Postgersql table to create transactions, splits, invoices and bills? I guess what I'm saying is if you just tell me verbally what has to be in each column of each table when we add a transaction, I could solve this problem very easily. If you want, I can even GPL a c language interface to the gnucash schema. The invoices we use are very specific to our application and it would be unreasonable to expect that built into a public domain product. We're generating our own invoices using a ruby-based product. So thanks and I'll keep an eye out for the generated HTML code to see if we can apply it for other types of billing. Also... Custom information can be linked with an augmentation table in another schema. If we have the guid of any row, anything can be added.
Hi Michael, There seems to be very scant developer documentation on the SQL schema, and I would say with good reason as the 2.3 series where it is introduced is unstable and not recommended for production use. That said, I believe the devs are working on getting 2.4 out the door with improved SQL support and after that's done, they may be able to concentrate on documenting it (limited resources, etc.) For now, the GnuCash wiki has the schema definition (which may be outdated),[1] and the DOxygen developer reference docs have various bits and pieces of information.[2] Hope this helps. [1] http://wiki.gnucash.org/wiki/SQL [2] http://svn.gnucash.org/docs/HEAD/search.php?query=sql
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=585901. Please continue processing the bug there and please update any external references or bookmarks.