Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005616
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 09. Financial managementcriticalalways2008-10-22 17:502009-05-04 13:49
Reporterjaime_chamorroView Statuspublic 
Assigned Tormorley 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision11583
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005616: Remove Negative Amounts in Posting Entries

DescriptionThis issue was reported for a localization project and was closed because the manager of this project said that the correct project it should be this one. The issue 0005614.

Openbravo lets make posting entries in the accounting with amounts in negative. This is not correct from the point of view of accounting. That the reason because the accounting has the fields credit and debit.

The posting entries in the accounting cannot accept negative amounts. This is an aberration, at least, from the accounting prospective.

There is a document attached with examples and explanations.
Proposed SolutionMy suggestion to solve it consist of modifying the posting program, so each time the program founds a negative amount in the management document (invoice, bank statement, manual settlement, etc.) record the entry in the “fact_acct” table in the opposite field that it’s recording currently. Getting this on depth, the solution could be to modify the code lines where “fact.createLine” in the java’s for each document that generates accounting (DocInvoice.jave, for example). But this is a solution it has to be analyzed and validated.
TagsNo tags attached.
Attached Filesdoc file icon Remove negative amounts in posting entries.doc [^] (34,304 bytes) 2008-10-22 17:50

- Relationships Relation Graph ] Dependency Graph ]
blocks feature request 0004267pi acknowledgedrmorley Rules driven accounting entries 

-  Notes
(0009748)
galderromo (reporter)
2008-10-25 17:12

In my opinion, not all negative amount should be changed to opposite field but this should be customizable for each document. I mean, probably it makes sense on a invoice but not on a settlement. Furthermore, it also should be customizable for each accounting account. For example, in a invoice, makes sense to allow negative entries on client sales account but not in taxes or retention accounts. All this cases must be taken into account in order to give a good solution.
(0011739)
svnbot (reporter)
2008-12-24 15:57

Repository: openbravo
Revision: 11583
Author: vmromanos
Date: 2008-12-24 15:56:59 +0100 (Wed, 24 Dec 2008)

Fixes bug 0005614: Remove Negative Amounts in Posting Entries
Fixes bug 0005616: Remove Negative Amounts in Posting Entries
Allow negatives in accounting (project merged from 2.3x branch)

---
U trunk/src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_forms/Fact.java
U trunk/src-db/database/model/tables/C_ACCTSCHEMA.xml
A trunk/src-db/database/model/tables/C_ACCTSCHEMA_TABLE_DOCTYPE.xml
U trunk/src-db/database/sourcedata/AD_COLUMN.xml
U trunk/src-db/database/sourcedata/AD_ELEMENT.xml
U trunk/src-db/database/sourcedata/AD_FIELD.xml
U trunk/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
U trunk/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
U trunk/src-db/database/sourcedata/AD_TAB.xml
U trunk/src-db/database/sourcedata/AD_TABLE.xml
U trunk/src-db/database/sourcedata/AD_VAL_RULE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=11583&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-10-22 17:50 jaime_chamorro New Issue
2008-10-22 17:50 jaime_chamorro Assigned To => cromero
2008-10-22 17:50 jaime_chamorro sf_bug_id 0 => 2187092
2008-10-22 17:50 jaime_chamorro File Added: Remove negative amounts in posting entries.doc
2008-10-25 17:12 galderromo Note Added: 0009748
2008-11-10 13:09 cromero Assigned To cromero => pjuvara
2008-11-17 08:15 pjuvara Relationship added blocks 0004267
2008-11-17 08:15 pjuvara Status new => acknowledged
2008-12-17 11:09 pjuvara Assigned To pjuvara => rmorley
2008-12-24 15:57 svnbot Checkin
2008-12-24 15:57 svnbot Note Added: 0011739
2008-12-24 15:57 svnbot Status acknowledged => resolved
2008-12-24 15:57 svnbot Resolution open => fixed
2008-12-24 15:57 svnbot svn_revision => 11583
2009-05-04 13:49 pjuvara Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker