0005979: Parametrize accounting processes (Generate and Delete Accountin) by date

Notes
(0010472) shuehner (administrator) 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 (reporter) 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 (reporter) 2008-12-01 19:26	Being able to filter by organization will also be interesting.

(0010857) pjuvara (reporter) 2008-12-01 20:20	Ability to filter by organization has been added in 2.50 as part of feature request 4287.

(0011423) svnbot (reporter) 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 (administrator) 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 (developer) 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 [^]

Issue History
Date Modified	Username	Field	Change
2008-11-15 17:14	galderromo	New Issue
2008-11-15 17:14	galderromo	Assigned To	=> rafaroda
2008-11-15 17:14	galderromo	sf_bug_id	0 => 2291868
2008-11-16 07:43	pjuvara	Assigned To	rafaroda => pjuvara
2008-11-17 15:58	pjuvara	Tag Attached: ReleaseCandidate
2008-11-17 15:59	pjuvara	Status	new => acknowledged
2008-11-17 15:59	pjuvara	Summary	Filter accounting massive process and remove accounting data by date => Parametrize accounting processes (Generate and Delete Accountin) by date
2008-11-17 15:59	pjuvara	Description Updated
2008-11-20 17:12	shuehner	Relationship added	related to 0005787
2008-11-20 19:52	shuehner	Note Added: 0010472
2008-11-20 21:00	galderromo	Note Added: 0010475
2008-12-01 19:26	galderromo	Note Added: 0010856
2008-12-01 20:20	pjuvara	Relationship added	related to 0004287
2008-12-01 20:20	pjuvara	Note Added: 0010857
2008-12-02 10:08	pnuding	Tag Attached: Performance
2008-12-02 10:08	pnuding	Tag Attached: performance2.40scrum
2008-12-02 10:08	pnuding	Tag Detached: Performance
2008-12-16 16:37	svnbot	Checkin
2008-12-16 16:37	svnbot	Note Added: 0011423
2008-12-16 16:37	svnbot	svn_revision	=> 11253
2008-12-16 16:59	shuehner	Note Added: 0011430
2008-12-17 11:09	pjuvara	Assigned To	pjuvara => rmorley
2013-03-18 12:38	Sandrahuguet	Status	acknowledged => scheduled
2013-03-18 12:38	Sandrahuguet	Assigned To	rmorley =>
2013-03-18 12:38	Sandrahuguet	fix_in_branch	=> pi
2013-03-18 12:49	Sandrahuguet	Note Added: 0057297
2013-03-18 12:49	Sandrahuguet	Status	scheduled => closed
2013-03-18 12:49	Sandrahuguet	Resolution	open => duplicate