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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0025976
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 09. Financial managementmajoralways2014-03-12 19:182014-06-11 17:37
Reportereduardo_ArgalView Statuspublic 
Assigned Toeduardo_Argal 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision3e75e4d92c64
ProjectionnoneETAnoneTarget Version3.0PR14Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Torafaroda
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0025976: 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)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks design defect 0025977 closededuardo_Argal Modules Performance Problems when running Invoice Payment Report for large Fact_Acct tables 
causes defect 00294033.0PR15Q3 closedvmromanos Openbravo ERP Invoice's entry generated against Currency Balancing account instead of Vendor Prepayment account 

-  Notes
(0067662)
hgbot (developer)
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 (developer)
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 (developer)
2014-06-11 17:37

 Code review done

- Issue History
Date Modified Username Field Change
2014-03-12 19:18 eduardo_Argal New Issue
2014-03-12 19:18 eduardo_Argal Assigned To => eduardo_Argal
2014-03-12 19:18 eduardo_Argal Modules => Core
2014-03-12 19:18 eduardo_Argal Triggers an Emergency Pack => No
2014-03-12 19:33 eduardo_Argal Relationship added blocks 0025977
2014-03-31 18:43 eduardo_Argal Target Version PR14Q2 => PR14Q3
2014-06-02 13:35 hgbot Checkin
2014-06-02 13:35 hgbot Note Added: 0067662
2014-06-02 13:35 hgbot Status new => resolved
2014-06-02 13:35 hgbot Resolution open => fixed
2014-06-02 13:35 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3e75e4d92c649e3293c1b6830771b0fba009b2da [^]
2014-06-10 22:23 hudsonbot Checkin
2014-06-10 22:23 hudsonbot Note Added: 0067859
2014-06-11 17:37 rafaroda Review Assigned To => rafaroda
2014-06-11 17:37 rafaroda Note Added: 0067910
2014-06-11 17:37 rafaroda Status resolved => closed
2015-03-30 13:32 vmromanos Relationship added causes 0029403

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker