Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005616Openbravo ERP09. Financial managementpublic2008-10-22 17:502009-05-04 13:49
Reporterjaime_chamorro 
Assigned Tormorley 
PrioritynormalSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005616: 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.
Steps To Reproduce
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.
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0004267pi acknowledged rmorley Rules driven accounting entries 
Attached Filesdoc Remove negative amounts in posting entries.doc (34,304) 2008-10-22 17:50
https://issues.openbravo.com/file_download.php?file_id=351&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-10-22 17:50jaime_chamorroNew Issue
2008-10-22 17:50jaime_chamorroAssigned To => cromero
2008-10-22 17:50jaime_chamorrosf_bug_id0 => 2187092
2008-10-22 17:50jaime_chamorroFile Added: Remove negative amounts in posting entries.doc
2008-10-25 17:12galderromoNote Added: 0009748
2008-11-10 13:09cromeroAssigned Tocromero => pjuvara
2008-11-17 08:15pjuvaraRelationship addedblocks 0004267
2008-11-17 08:15pjuvaraStatusnew => acknowledged
2008-12-17 11:09pjuvaraAssigned Topjuvara => rmorley
2008-12-24 15:57svnbotCheckin
2008-12-24 15:57svnbotNote Added: 0011739
2008-12-24 15:57svnbotStatusacknowledged => resolved
2008-12-24 15:57svnbotResolutionopen => fixed
2008-12-24 15:57svnbotsvn_revision => 11583
2009-05-04 13:49pjuvaraStatusresolved => closed

Notes
(0009748)
galderromo   
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   
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 [^]