Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005614Openbravo ERP09. Financial managementpublic2008-10-22 14:152009-05-04 13:49
jaime_chamorro 
rmorley 
normalcriticalalways
closedfixed 
5
 
 
Core
No
0005614: Remove Negative Amounts in Posting Entries
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.
My 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.
Localization
blocks feature request 0004267pi acknowledged rmorley Rules driven accounting entries 
doc Remove negative amounts in posting entries.doc (34,304) 2008-10-22 14:15
https://issues.openbravo.com/file_download.php?file_id=350&type=bug
Issue History
2008-10-22 14:15jaime_chamorroNew Issue
2008-10-22 14:15jaime_chamorroAssigned To => dalsasua
2008-10-22 14:15jaime_chamorroFile Added: Remove negative amounts in posting entries.doc
2008-10-22 17:21dalsasuaStatusnew => closed
2008-10-22 17:21dalsasuaNote Added: 0009688
2008-10-22 17:21dalsasuaResolutionopen => no change required
2008-10-22 17:45jaime_chamorroStatusclosed => new
2008-10-22 17:45jaime_chamorroResolutionno change required => open
2008-10-22 17:45jaime_chamorroNote Added: 0009689
2008-10-22 17:48dalsasuaProject@14@ => Openbravo ERP
2008-10-22 17:48dalsasuaAssigned Todalsasua => cromero
2008-11-10 13:09cromeroAssigned Tocromero => pjuvara
2008-11-17 08:13pjuvaraStatusnew => acknowledged
2008-11-17 08:13pjuvaraCategory => 09. Financial management
2008-11-17 08:14pjuvaraRelationship addedblocks 0004267
2008-12-02 13:02jaimetorresf_bug_id0 => 2377107
2008-12-17 11:09pjuvaraAssigned Topjuvara => rmorley
2008-12-22 14:22rmorleyTag Attached: Localization
2008-12-24 15:57svnbotCheckin
2008-12-24 15:57svnbotNote Added: 0011738
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
(0009688)
dalsasua   
2008-10-22 17:21   
Dear Jaime.

I recomend you to create a feature request in Openbravo ERP project. Localizer's support project is just for giving support to localizers in theirs projects.

Thank you.

Regards.
(0009689)
jaime_chamorro   
2008-10-22 17:45   
This is feature request has a CRITICAL status in Severity field. If the proyect asigned is not the correct one I would appreciate you reassigne to the project one instead of closing it.

Thanks.
(0011738)
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 [^]