Forum OpenACS Q&A: Re: SQL-Modelling Costs and Invoices

Collapse
Posted by Malte Sussdorff on
This might be a little bit brutal, but why don't you just use the SQL Ledger Tables and port the functionality of it into an OpenACS Web based package. After all, it is reknown to be a very good accounting software *and* this would prevent inventing the wheel over and over again. Last but not least, if you go down that road, you might even be able to get some cross support from the developers.

Alternatively, just install SQL-Ledger on AOLserver along with your normal OpenACS installation and let your custom code write accounting information directly into SQL-Ledger by just porting from PERL to TCL the necessary ::create and ::get API.

Either way, I know it might be tempting to start with your own Accounting System, but give it some thought if it the best you can do with your development power, taking into account excellent software like SQL-Ledger.

Collapse
Posted by Frank Bergmann on
Hi Malte,

I think our posts crossed.

Let me reasure you that we're not going to go for a Yet Another Accounting System. Instead, P/O captures costs over the web and allows for the "controlling" stuff (redistributing costs to projects and customers) that is needed by project-oriented organizations (and not provided by SQL-ledger).

The idea is to export these items afterwards to SQL-ledger or similar packages (Quickbook, Conta-Plus, KHK-Kaufmann, ...) to facilitate the creation of balance sheets and income statements are required legally.

I'm already looking at the OfBiz and SQL-Ledger data models. It would be really cool to run OpenACS and SQL-Ledger on the same server...

Frank