Changeset - 214f85b47ee9
[Not reviewed]
Merge
0 7 0
Bradley Kuhn (bkuhn) - 8 years ago 2013-11-15 17:02:10
bkuhn@ebb.org
Merge branch 'master' of oak.sfconservancy.org:npo-acct
6 files changed with 90 insertions and 5 deletions:
0 comments (0 inline, 0 general)
ExistingProjects/EvaluationTemplate.mdwn
Show inline comments
 
## 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
 
- [[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
 
## 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
ExistingProjects/Frontaccounting.mdwn
Show inline comments
...
 
@@ -20,35 +20,35 @@
 
- [Most recent release 2013-09-05](http://frontaccounting.com/wb3/pages/posts/release-2.3.18193.php)
 
- Themable
 
- Seemingly easy to deploy (Looking at their source release, structure looks similar to wordpress, for good or worse)
 

	
 
### Negative
 

	
 
- It seems to be built from scratch and not leverage any frameworks.
 
- Seems like a messy codebase: Table-based design. No templating, HTML is `echo`-ed to stdout.
 
- Uses the [deprecated](http://php.net/manual/en/function.mysql-connect.php) PHP `mysql_*` functions.
 

	
 
## 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
 
- [[Cash Disbursements Journal|UseCases/GeneratingReports#cash-disbursements]]: Yes, looks like GL Account Transactions works for this
 
- [[Income Report|UseCases/GeneratingReports#income-report]]: Not obviously
 
  there, but should be easy given the number of reports available.
 
- [[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".
 

	
 
## Evaluation of [[Fund Accounting|UseCases/FundAccounting]] UseCases
 

	
 
- [[Fund-only View|UseCases/FundAccounting#fund-view]]: No, seems to be no way to
 
restrict a user to a specific Dimension.
 
- [[Funds as part of whole org View|UseCases/FundAccounting#fundless-view]]:
 
  Yes, dimensions appear to be purely informative.
 
- [[Ignore Funds for operations|UseCases/FundAccounting#fundless-view]]:
 
  Yes, dimensions appear to be purely informative.
ExistingProjects/GNUEnterprise.mdwn
Show inline comments
 
Links
 

	
 
- [[!wikipedia GNU_Enterprise]] - Wikipedia
 
- <http://www.gnuenterprise.org> - Project homepage
 
- <http://www.gnu.org/software/gnue/gnue.html> - FSF's GNUe page, which http://gnuenterprise.org redirects to.
 
- <http://bzr.savannah.gnu.org/lh/gnue/> - Source code
 

	
 
<http://www.gnuenterprise.org> and <http://gnuenterprise.org> has been unreachable on 2013-10-22, 2013-10-23, 2013-10-24.
 
<http://www.gnuenterprise.org> and <http://gnuenterprise.org> 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: <http://lists.gnu.org/archive/html/gnue-dev/>
 
- GNUe mailing list is not very active: <http://lists.gnu.org/archive/html/gnue/>
 
- No GNUe announcements since 2009: <http://lists.gnu.org/archive/html/gnue-announce/>
 
- 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.
ExistingProjects/OpenPetra.mdwn
Show inline comments
...
 
@@ -13,24 +13,25 @@ Links
 

	
 
- [Started in 2009](http://www.ohloh.net/p/openpetraorg)
 

	
 
### Positive
 

	
 
- i18n, l10n
 
- Supports server-client deployments as well as standalone deployment.
 
- [Actively developed](http://www.ohloh.net/p/openpetraorg)
 
- [35 contributors](http://www.ohloh.net/p/openpetraorg)
 
- [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
 

	
 
- In BETA state, presently used by at least two organizations, one for accounting, one for contact management.
 
- [Decreasing Y-O-Y commits](http://www.ohloh.net/p/openpetraorg) <pre>2013-11-13 16:10:00     christiank      joar: I have checked for the source of increased commits in January 2011: It is a mixture of a huge bug-fixing spree and the result of a merge-into-trunk of a Sideline Branch, which then still needed more development</pre>
 

	
 

	
 
## [[UseCases/FundAccounting]] evaluation
 

	
 
- Supports multiple ledgers
 

	
 
<pre>
ExistingProjects/Postbooks.mdwn
Show inline comments
 
### Comments
 

	
 
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
ExistingProjects/Tryton.mdwn
Show inline comments
...
 
@@ -31,24 +31,25 @@ Links:
 

	
 
- Documented modules
 
- Modular application, wide range of modules
 
  - Official modules: <http://hg.tryton.org/modules/>
 
  - Comunity modules available on bitbucket, see
 
    - <http://bitbucket.org/trytonspain>
 
    - <http://bitbucket.org/zikzakmedia>
 
    - <http://bitbucket.org/nantic>
 
    - <http://bitbucket.org/pokoli>  (and others).
 
    - Also avaiilable on pypy  <https://pypi.python.org/pypi?%3Aaction=search&term=tryton&submit=search>.
 
- 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
 

	
 
### Positive
 
- Capable of Trial Balance and Chart of Accounts reports.
 
- Probably capable of Expense, Income reports with minor, semantic[report templates] development effort.
 
- Possible to create [custom reports](http://doc.tryton.org/3.0/trytond/doc/topics/reports/index.html)
 

	
 
### Negative
 
- Does not seem to support funds, thus it is not possible to generate reports for a specific fund.
 

	
 
### Examples
0 comments (0 inline, 0 general)