Although the original Pbooks had invoices and bills, I took them out when I started to redesign the database, as I wanted to get the data model just right for the sole purpose of bookkeeping before getting more detailed.
After examining the Wordpress data model, I decided to use their strategy to connect invoices and bills with accounting transactions. That is, keeping all the core financial data in the entry and transaction tables, and using a "meta data" table to allow a transaction to be "special" - a bill, invoice, equity contribution, etc., and contain the information about the transaction, like who is getting invoiced.
We can easily tailor the application for both business minded people and accountants, as well as make it industry specific (real estate, service, inventory, etc.), without creating a monster of a data model (a problem which I feel has plagued previous open source accounting projects). This also allows the system to be more modular, so that it can be cleanly integrated with programs like SugarCRM.
I'll be adding the invoices again very soon.
TODO:
- Use a simple XML flat file CRM database for hooking up to PBooks for purposes of developing invoicing and billing functionality
- Bills
- Checks
- Invoices
