shan sverige wrote: >I want to do budgeting. AFAIK this is currently not possible. >Should/can I extend the schema with a few tables or is there >a "best practice" for extending SQL-Ledger? > >aku > > I don't know why you couldn't already use it for budgeting.
Create another company/dataset called something like budget02 - use the same chart of accounts as your company's books. You could load a journal entry of budget data each month with whatever level of account detail you wish. You could reflect changes with journal entries. Then your actual and budget reports will be comparable. You could write something to extract the data you want to files if you want to show budget and actual together on a spreadsheet. There's an api at http://www.sql-ledger.org/feature/api.html if you want add your own stuff. Good luck, Steve ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
