From 214f85b47ee964377cc4843359e5164bfb400f1d 2013-11-15 17:02:10 From: Bradley M. Kuhn Date: 2013-11-15 17:02:10 Subject: [PATCH] Merge branch 'master' of oak.sfconservancy.org:npo-acct --- diff --git a/ExistingProjects/EvaluationTemplate.mdwn b/ExistingProjects/EvaluationTemplate.mdwn index 93f33220a0c7b8c90ef2a6449dbf4768e001e3de..d4aaa8a1e79f77040ca8d3c5b598b479979365c7 100644 --- a/ExistingProjects/EvaluationTemplate.mdwn +++ b/ExistingProjects/EvaluationTemplate.mdwn @@ -1,4 +1,4 @@ -## Evaluation of [Reporting|UseCases/GeneratingReports] UseCases +## Evaluation of [[Reporting|UseCases/GeneratingReports]] UseCases - [[Trial Balance Report|UseCases/GeneratingReports#trial-balance]]: FIXME - [[Bank Reconciliation Report|UseCases/GeneratingReports#bank-reconcilation]]: FIXME - [[Chart of Accounts|UseCases/GeneratingReports#chart-of-accounts]]: FIXME @@ -6,7 +6,7 @@ - [[Income Report|UseCases/GeneratingReports#income-report]]: FIXME - [[Expense Report|UseCases/GeneratingReports#expense-report]]: FIXME -## Evaluation of [Reporting|UseCases/GeneratingReports] UseCases for Fund Accounting +## Evaluation of [[Reporting|UseCases/GeneratingReports]] UseCases for Fund Accounting Can each of these reports be generated, confined to a specific temporarily restricted asset type? diff --git a/ExistingProjects/Frontaccounting.mdwn b/ExistingProjects/Frontaccounting.mdwn index 32194953e56a801ab8f543ad6d2a837481cebcfb..c066b2f44573e49ee12625a1b8eb8a234e79d1d9 100644 --- a/ExistingProjects/Frontaccounting.mdwn +++ b/ExistingProjects/Frontaccounting.mdwn @@ -29,7 +29,7 @@ ## Detailed Evaluation -## Evaluation of [Reporting|UseCases/GeneratingReports] UseCases +## Evaluation of [[Reporting|UseCases/GeneratingReports]] UseCases - [[Trial Balance Report|UseCases/GeneratingReports#trial-balance]]: Yes - [[Bank Reconciliation Report|UseCases/GeneratingReports#bank-reconcilation]]: Yes, seems ok - [[Chart of Accounts|UseCases/GeneratingReports#chart-of-accounts]]: Yes @@ -39,7 +39,7 @@ - [[Expense Report|UseCases/GeneratingReports#expense-report]]: Not obviously there, but should be easy given the number of reports available. -## Evaluation of [Reporting|UseCases/GeneratingReports] UseCases for Fund Accounting +## Evaluation of [[Reporting|UseCases/GeneratingReports]] UseCases for Fund Accounting It seems FrontAccounting's "Dimension" feature likely can do all of these, since it seems you can limit any of the above reports by "Dimension". diff --git a/ExistingProjects/GNUEnterprise.mdwn b/ExistingProjects/GNUEnterprise.mdwn index c2a725fe5e4bc5c7d570852fb353fd462390904c..5256a6edcf766a22e64a23dffab93e407e9a3047 100644 --- a/ExistingProjects/GNUEnterprise.mdwn +++ b/ExistingProjects/GNUEnterprise.mdwn @@ -2,5 +2,16 @@ Links - [[!wikipedia GNU_Enterprise]] - Wikipedia - - Project homepage +- - FSF's GNUe page, which http://gnuenterprise.org redirects to. +- - Source code - and has been unreachable on 2013-10-22, 2013-10-23, 2013-10-24. + and has been unreachable on 2013-10-22, 2013-10-23, 2013-10-24. It is reachable as of 2013-11-15. + +## Technical + +## Preliminary evaluation + +- GNUe-dev mailing list is not very active: +- GNUe mailing list is not very active: +- No GNUe announcements since 2009: +- I can get the bazaar repo and then get all the GNUe packages by running `./bin/bzr-get-all`, each of the GNUe packages then have an `INSTALL` file in its subdirectory but I cannot find meta-installation instructions for GNUe anywhere on the web, nor in the main GNUe bazaar repository. diff --git a/ExistingProjects/OpenPetra.mdwn b/ExistingProjects/OpenPetra.mdwn index b0a2c075bd6821e6535c190dc914b7fb2199d4ae..ee421638aea1937597eaec3a302e4440a3a742c7 100644 --- a/ExistingProjects/OpenPetra.mdwn +++ b/ExistingProjects/OpenPetra.mdwn @@ -22,6 +22,7 @@ Links - [Well-commented source code](http://www.ohloh.net/p/openpetraorg) - [Extensibility is core](http://www.openpetra.org/organisation-benefits) - Ledger-specific access control, three access levels. +- using fixed point arithmetic: System.Decimal data type for all money related variables (changed from Double to Decimal in end of 2010: [commit](https://github.com/openpetra/openpetra/commit/a1717237825a6c8f0d5e032c843241ed918e2344)) ### Negative diff --git a/ExistingProjects/Postbooks.mdwn b/ExistingProjects/Postbooks.mdwn index d99669941ef8302e274b4b93e8306aaa38ae8c40..a24a3ea31671845fd44820b25e469ed3327ef6bf 100644 --- a/ExistingProjects/Postbooks.mdwn +++ b/ExistingProjects/Postbooks.mdwn @@ -3,12 +3,84 @@ Josh Berkus: PostBooks is the pure-OSS GL module from xTuple, which was renamed from OpenMFG. It is an ERP system, very strongly aimed at manufacturers, so would require some substantial adaptation to NPOs. However, it benefits from a strong API in the form of PostgreSQL stored procedures, which would make adapting the basic GL functionality to a more complex NPO module feasible, since interaction with the PostBooks GUI would not be required. One possibility would be to use PostBooks as the backend for a system which also supported ledger-cli; that way users could have the choice of SQL or Git backend. Daniel Pocock: + * I've recently packaged it for Debian and Ubuntu, this may help it achieve wider usage than some of the more heavy weight Java-based ERP solutions as they are not easily packaged * Backend is exclusively PostgreSQL for now * No server processes required other than PostgreSQL itself * Front end is C++ Qt client that each user installs, * it seems to run OK over VPN (IPsec) to a remote PostgreSQL +* It has a permissioning system, the PostgreSQL users are Postbooks users * it can be customised by adding fields and buttons to forms and adding custom logic using JavaScript * The developers are also making a full web/mobile Postbooks solution that works with the same database, it is not packaged yet * the developers (xTuple) operate as a software development company maintaining the code, running an annual conference, supporting business deployments, etc * the CPAL license is potentially not GPL compatible, although it is agreed that CPAL is a free license + + +## Evaluation of [[Reporting|UseCases/GeneratingReports]] UseCases +- [[Trial Balance Report|UseCases/GeneratingReports#trial-balance]]: FIXME +- [[Bank Reconciliation Report|UseCases/GeneratingReports#bank-reconcilation]]: FIXME +- [[Chart of Accounts|UseCases/GeneratingReports#chart-of-accounts]]: FIXME +- [[Cash Disbursements Journal|UseCases/GeneratingReports#cash-disbursements]]: FIXME +- [[Income Report|UseCases/GeneratingReports#income-report]]: FIXME +- [[Expense Report|UseCases/GeneratingReports#expense-report]]: FIXME + +## Evaluation of [[Reporting|UseCases/GeneratingReports]] UseCases for Fund Accounting + +Can each of these reports be generated, confined to a specific temporarily +restricted asset type? + +- [[Trial Balance Report|UseCases/GeneratingReports#trial-balance]]: FIXME +- [[Bank Reconciliation Report|UseCases/GeneratingReports#bank-reconcilation]]: FIXME +- [[Chart of Accounts|UseCases/GeneratingReports#chart-of-accounts]]: FIXME +- [[Cash Disbursements Journal|UseCases/GeneratingReports#cash-disbursements]]: FIXME +- [[Income Report|UseCases/GeneratingReports#income-report]]: FIXME +- [[Expense Report|UseCases/GeneratingReports#expense-report]]: FIXME + +## Evaluation of [[Fund Accounting|UseCases/FundAccounting]] UseCases + +- [[Fund-only View|UseCases/FundAccounting#fund-view]] +- [[Funds as part of whole org View|UseCases/FundAccounting#fundless-view]] +- [[Ignore Funds for operations|UseCases/FundAccounting#fundless-view]] + +## [[UseCases/Collaborating]] evaluation +- [[Simultaneous Editing of Ledger|UseCases/Collaborating#simultaneous-ledger-edits]]: FIXME +- FIXME: Other uses cases need rewrite. + +# Evaluation of [[Double-entry Accounting|UseCases/DoubleEntryAccounting]] UseCases + +- Does the system implement pure double-entry accounting? YES + +# Evaluation of [[TrackingDocumentation|UseCases/TrackingDocumentation]] UseCases + +- Does the system [[link up to external documentation|UseCases/TrackingDocumentation#document-link-up]]? + +- Does it have a [[the ability to explore transactions via documentation linkage|UseCases/TrackingDocumentation#document-link-explore]]? + +# Evaluation of [[Handling multiple currencies|UseCases/MultiCurrency]] UseCases + +- Does it support the concept of + [[a single functional currency|UseCases/MultiCurrency]], while still + permitting multi-currency entries? + +# Evaluation of [[draft transaction|UseCases/DraftTransactions]] UseCases + +- Does the system allow + [[generally for draft transactions|UseCases/DraftTransactions#draft-general]] + that can be later approved before officially being posted to the books? + +## Evaluation of WorkFlow UseCases +- Is a [[specific workflow dictated by the system|UseCases/WorkFlow#workflow-dictated]] ? +- Is a [[the workflow configurable|UseCases/WorkFlow#workflow-configurable]] ? +- [[Unaccrued Invoice|UseCases/WorkFlow#unaccrued-invioice]] ? + +# Evaluation of the [[Reading and Reporting API|UseCases/ReadingAPI]] + +FIXME: This is assessment of what the API for manipulating the accounting +data does, so I think it's tough to do it as a list of questions. + +# Evaluation of the [[Storage API|UseCases/StorageAPI]] + +Using PostgreSQL as the back-end + +## [[UseCases/WorkFlow]] evaluation +- [[Unaccrued Invoice|UseCases/WorkFlow#unaccrued-invioice]]: FIXME diff --git a/ExistingProjects/Tryton.mdwn b/ExistingProjects/Tryton.mdwn index b597f790277a44b65030427a4cf74c9490d790cd..81ab6bbaaf70895f5de34b194c8b40a00401894c 100644 --- a/ExistingProjects/Tryton.mdwn +++ b/ExistingProjects/Tryton.mdwn @@ -40,6 +40,7 @@ Links: - Also avaiilable on pypy . - Separated client and server presumably making collaboration easy - Can create reports -- [[!wikipedia Tryton#Technical_features]] +- Using fixed point in Accouting. Decimal is used on server layer and numeric on the database layer. ## [[UseCases/GeneratingReports]] Evaluation