Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025976Openbravo ERP09. Financial managementpublic2014-03-12 19:182014-06-11 17:37
Reportereduardo_Argal 
Assigned Toeduardo_Argal 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q3Fixed in Version 
Merge Request Status
Review Assigned Torafaroda
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025976: Open Balances
DescriptionIt would be nice to have the option to hide those accounting entries which have already been balanced.
When browsing an open balance (for example for receivables account) in the ledger, we can see all entries related to that account and time range.
Having tons of entries some times makes it really difficult to understand where the outstanding amount (open balance) comes from.
Having an option to hide those entries which have already been debited and credited (are no longer open items) can really help to understand where an open balance comes from. User would like to map the open balance for receivables with the outstanding invoices that have not yet been paid.
Steps To ReproduceIt would be nice to have the option to hide those accounting entries which have already been balanced.
When browsing an open balance (for example for receivables account) in the ledger, we can see all entries related to that account and time range.
Having tons of entries some times makes it really difficult to understand where the outstanding amount (open balance) comes from.
Having an option to hide those entries which have already been debited and credited (are no longer open items) can really help to understand where an open balance comes from. User would like to map the open balance for receivables with the outstanding invoices that have not yet been paid.
Proposed SolutionCreate two new columns in fact table.
One to link debits and credits for a certain account (record_ID2)
Another to show when that entry got balanced (databalanced date when this account got balanced, when the invoice got paid for example)
Additional Information
TagsNo tags attached.
Relationships
blocks design defect 0025977 closed eduardo_Argal Modules Performance Problems when running Invoice Payment Report for large Fact_Acct tables 
causes defect 00294033.0PR15Q3 closed vmromanos Openbravo ERP Invoice's entry generated against Currency Balancing account instead of Vendor Prepayment account 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-03-12 19:18eduardo_ArgalNew Issue
2014-03-12 19:18eduardo_ArgalAssigned To => eduardo_Argal
2014-03-12 19:18eduardo_ArgalModules => Core
2014-03-12 19:18eduardo_ArgalTriggers an Emergency Pack => No
2014-03-12 19:33eduardo_ArgalRelationship addedblocks 0025977
2014-03-31 18:43eduardo_ArgalTarget VersionPR14Q2 => PR14Q3
2014-06-02 13:35hgbotCheckin
2014-06-02 13:35hgbotNote Added: 0067662
2014-06-02 13:35hgbotStatusnew => resolved
2014-06-02 13:35hgbotResolutionopen => fixed
2014-06-02 13:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3e75e4d92c649e3293c1b6830771b0fba009b2da [^]
2014-06-10 22:23hudsonbotCheckin
2014-06-10 22:23hudsonbotNote Added: 0067859
2014-06-11 17:37rafarodaReview Assigned To => rafaroda
2014-06-11 17:37rafarodaNote Added: 0067910
2014-06-11 17:37rafarodaStatusresolved => closed
2015-03-30 13:32vmromanosRelationship addedcauses 0029403

Notes
(0067662)
hgbot   
2014-06-02 13:35   
Repository: erp/devel/pi
Changeset: 3e75e4d92c649e3293c1b6830771b0fba009b2da
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Mon Jun 02 12:50:56 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3e75e4d92c649e3293c1b6830771b0fba009b2da [^]

Fixes issue 25976: Open Balances

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS.xml
M referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml
M src-db/database/model/tables/FACT_ACCT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src-test/org/openbravo/test/AllAntTaskTests.java
M src/org/openbravo/erpCommon/ad_forms/AcctServer.java
M src/org/openbravo/erpCommon/ad_forms/DocFINFinAccTransaction.java
M src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java
M src/org/openbravo/erpCommon/ad_forms/DocFINReconciliation.java
M src/org/openbravo/erpCommon/ad_forms/DocInvoice.java
M src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql
M src/org/openbravo/erpCommon/ad_forms/FactLine.java
M src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.html
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
M src/org/openbravo/financial/ResetAccounting.java
A modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/RecordID2Filling.java
A src-test/org/openbravo/test/accounting/RecordID2Test.java
---
(0067859)
hudsonbot   
2014-06-10 22:23   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/763f16c2ad2e [^]
Maturity status: Test
(0067910)
rafaroda   
2014-06-11 17:37   
Code review done