Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005979Openbravo ERP09. Financial managementpublic2008-11-15 17:142013-03-18 12:49
Reportergalderromo 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
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
Summary0005979: Parametrize accounting processes (Generate and Delete Accountin) by date
DescriptionFinancial Management -> Accounting -> Transaction -> Generate accounting or Delete accounting.

Nowadays the accounting data creation or deletion can only be filtered by document type. It will also be very interested and usefull to have the choice of filtering by date: FROM DATE and TO DATE.

Take into account, sometimes, regenerating all the accounting information may take too long.
Steps To Reproduce
Proposed Solution
Additional Information
Tagsperformance2.40scrum, ReleaseCandidate
Relationships
related to feature request 00042872.50 closed rmorley Add organization filter to the accounting create and delete processes 
related to defect 0005787 closed shuehner Accounting 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-15 17:14galderromoNew Issue
2008-11-15 17:14galderromoAssigned To => rafaroda
2008-11-15 17:14galderromosf_bug_id0 => 2291868
2008-11-16 07:43pjuvaraAssigned Torafaroda => pjuvara
2008-11-17 15:58pjuvaraTag Attached: ReleaseCandidate
2008-11-17 15:59pjuvaraStatusnew => acknowledged
2008-11-17 15:59pjuvaraSummaryFilter accounting massive process and remove accounting data by date => Parametrize accounting processes (Generate and Delete Accountin) by date
2008-11-17 15:59pjuvaraDescription Updated
2008-11-20 17:12shuehnerRelationship addedrelated to 0005787
2008-11-20 19:52shuehnerNote Added: 0010472
2008-11-20 21:00galderromoNote Added: 0010475
2008-12-01 19:26galderromoNote Added: 0010856
2008-12-01 20:20pjuvaraRelationship addedrelated to 0004287
2008-12-01 20:20pjuvaraNote Added: 0010857
2008-12-02 10:08pnudingTag Attached: Performance
2008-12-02 10:08pnudingTag Attached: performance2.40scrum
2008-12-02 10:08pnudingTag Detached: Performance
2008-12-16 16:37svnbotCheckin
2008-12-16 16:37svnbotNote Added: 0011423
2008-12-16 16:37svnbotsvn_revision => 11253
2008-12-16 16:59shuehnerNote Added: 0011430
2008-12-17 11:09pjuvaraAssigned Topjuvara => rmorley
2013-03-18 12:38SandrahuguetStatusacknowledged => scheduled
2013-03-18 12:38SandrahuguetAssigned Tormorley =>
2013-03-18 12:38Sandrahuguetfix_in_branch => pi
2013-03-18 12:49SandrahuguetNote Added: 0057297
2013-03-18 12:49SandrahuguetStatusscheduled => closed
2013-03-18 12:49SandrahuguetResolutionopen => duplicate

Notes
(0010472)
shuehner   
2008-11-20 19:52   
Some notes after checking:

Reset accounting only resets the accounting information for periods which are not closed. So this case can be handled by closing the periods you don't want to reset, as it seems you don't want to touch them anymore.

For Accounting data creation, this period closing could be used as work-around until the feature request is adressed for this process.

Please check if with this info the feature request is only valid for the creation or if it is still valid for the reset accounting process.
(0010475)
galderromo   
2008-11-20 21:00   
It is not valid for reset accounting process neither creation process.

What I would like is to be able to reset all the accounting related to invoices from date X to date Y.

Or create accounting notes for all invoices from date X to date Y.

Why?

Think I have 2.000.000 invoices accounted from last 3 years. And the application users have created the accounting notes with a wrong accounting setup during the last 3 weeks (they introduced a new product ant set up incorrectly, all together: 1.500 invoices). If I reset all the accounting and create it again I need too much time. Instead, if I could filter de reset process by dates, I won't have to delete accounting related to 1.998.500 invoices.
(0010856)
galderromo   
2008-12-01 19:26   
Being able to filter by organization will also be interesting.
(0010857)
pjuvara   
2008-12-01 20:20   
Ability to filter by organization has been added in 2.50 as part of feature request 4287.
(0011423)
svnbot   
2008-12-16 16:37   
Repository: openbravo
Revision: 11253
Author: huehner
Date: 2008-12-16 16:37:15 +0100 (Tue, 16 Dec 2008)

Issue 5791
- Change behavior of the accounting process when launched via Posting by DB tables (not the background process)
  In this case now all available documents are processed without 10s sleep-time every 50 documents, to achieve
  a much greater throughput.
Issue 5979
- Prepare the accounting process for a new parameter to filter by fromDate and toDate.
  Just preparation here, not a complete implementation

---
U branches/r2.40performance/src/org/openbravo/erpCommon/ad_background/PeriodicAcctServer.java
U branches/r2.40performance/src/org/openbravo/erpCommon/ad_forms/AcctServer.java
U branches/r2.40performance/src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11253&sc=1 [^]
(0011430)
shuehner   
2008-12-16 16:59   
Note: The last commit 11253 prepares part of this feature request, so that for "Posting by DB tables" only the gui has to be extended to implement this feature. The internals are now already changed to allow this.
Reset accounting if however not touched/prepared by this commit.
(0057297)
Sandrahuguet   
2013-03-18 12:49   
* Reset accounting process has the availability to filter by dates (Starting Date and Ending Date)
https://issues.openbravo.com/view.php?id=22300 [^]

* It is added date from and date to, to filter dates in gl posting by db tables. (From date and To date)
https://issues.openbravo.com/view.php?id=23295 [^]