Changeset - da30e8b51d99
[Not reviewed]
0 1 0
https://www.google.com/accounts/o8/id?id=AItOawmustbjdiqBYPMP0TkDPDLz9_iEK8nWQfo Rushabh@web - 10 years ago 2013-11-26 04:58:27

Updated features - mainly Cost Centers can be tuned to manage Funds
1 file changed with 22 insertions and 12 deletions:
0 comments (0 inline, 0 general)
ExistingProjects/ERPNext.mdwn
Show inline comments
...
 
@@ -21,4 +21,8 @@ Not using a database abstraction model such as SQLAlchemy reduces storage portab
 

	
 
Update: SQLAlchemy has a severe performance penalty based on our testing. Plus, SQL reduces the code complexity in many instances and has much better performance too. - *Rushabh*
 

	
 
In those places I have seen, no input sanitation was performed, although they were only SELECT queries. I suspect that you could alter database contents by modifiying a SELECT query, but I have not managed to do so myself.
 

	
 
Update: The library does not allow multiple SQL Queries to be executed, hence altering is not possible. There is possibility of overriding certain conditions. We will fix these on priority. - *Rushabh*
 

	
 
### Evaluation of [[Reporting|UseCases/GeneratingReports]] UseCases
...
 
@@ -36,10 +40,12 @@ restricted asset type?
 

	
 
**It does not seem like it**. There are 'Cost Centers', but they do not seem to be usable in fund accounting.
 
*It does not seem like it*. There are 'Cost Centers', but they do not seem to be usable in fund accounting.
 

	
 
Update: *Yes*. Cost Centers can be easily extended to manage funds. Each Income / Expense is tagged against cost center, so you can accurately track per Fund. Some of the terminology can be fixed if required - *Rushabh*
 
   
 
- [[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
 
- [[Trial Balance Report|UseCases/GeneratingReports#trial-balance]]: YES
 
- [[Bank Reconciliation Report|UseCases/GeneratingReports#bank-reconcilation]]: YES
 
- [[Chart of Accounts|UseCases/GeneratingReports#chart-of-accounts]]: YES
 
- [[Cash Disbursements Journal|UseCases/GeneratingReports#cash-disbursements]]: YES
 
- [[Income Report|UseCases/GeneratingReports#income-report]]: YES
 
- [[Expense Report|UseCases/GeneratingReports#expense-report]]: YES
 

	
...
 
@@ -47,3 +53,5 @@ restricted asset type?
 

	
 
**No**. It does not seem like 'Cost Centers' can be used this way.
 
*No*. It does not seem like 'Cost Centers' can be used this way. 
 

	
 
Update: *Yes*. Please see earlier comment, each fund can be a cost center and invoices, expenses can be booked against it. Even budgeting can be done against a cost center. - *Rushabh*
 

	
...
 
@@ -77,3 +85,3 @@ restricted asset type?
 
  [[generally for draft transactions|UseCases/DraftTransactions#draft-general]]
 
  that can be later approved before officially being posted to the books? No
 
  that can be later approved before officially being posted to the books? Yes. Each transaction has a Draft and Submitted status. And separate rights can be given to separate roles for doing approvals. Plus rule based approvals based on properties also exist.
 

	
...
 
@@ -81,4 +89,4 @@ restricted asset type?
 
- Is a [[specific workflow dictated by the system|UseCases/WorkFlow#workflow-dictated]] ? Yes
 
- Is a [[the workflow configurable|UseCases/WorkFlow#workflow-configurable]] ? No
 
- [[Unaccrued Invoice|UseCases/WorkFlow#unaccrued-invioice]] ? No
 
- Is a [[the workflow configurable|UseCases/WorkFlow#workflow-configurable]] ? Yes - there is a workflow system [User Docs](https://docs.erpnext.com/workflows.html)
 
- [[Unaccrued Invoice|UseCases/WorkFlow#unaccrued-invioice]] ? Exists - You can check in Accounts Receivable
 

	
...
 
@@ -108,2 +116,4 @@ stated license of the project, it's not worth further evaluation of the codebase
 
since this policy is just not acceptable.  bkuhn has
 
[raised the issue on the ERPNext Developers' Forum](https://groups.google.com/forum/?_escaped_fragment_=msg/erpnext-developer-forum/jfsURU8Ew9A/HVDX1z3vvkgJ#!msg/erpnext-developer-forum/jfsURU8Ew9A/HVDX1z3vvkgJ).
 
[raised the issue on the ERPNext Developers' Forum](https://groups.google.com/forum/?_escaped_fragment_=msg/erpnext-developer-forum/jfsURU8Ew9A/HVDX1z3vvkgJ#!msg/erpnext-developer-forum/jfsURU8Ew9A/HVDX1z3vvkgJ). 
 

	
 
Udpate: **FIxed** - Rushabh
0 comments (0 inline, 0 general)