Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040304Openbravo ERPJ. Demo datapublic2019-03-01 08:272019-06-24 12:47
ReporterSandrahuguet 
Assigned ToAtulOpenbravo 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version3.0PR19Q3 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040304: Delete records from FACT_ACCT and AD_PROCESS_REQUEST
DescriptionMaintaining task in the sampledata: delete records from FACT_ACCT and AD_PROCESS_REQUEST.

- Delete records in FACT_ACCT before 2017
- exclude+cleanup AD_PROCESS_REQUEST <> SCH/UNS
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0040234 scheduled AtulOpenbravo Is not possible to close 2015 year in F&B US, Inc organization 
related to defect 0040360 closed AtulOpenbravo Sample data (F&B International Group Client) for 3.0PR19Q2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-03-01 08:27SandrahuguetNew Issue
2019-03-01 08:27SandrahuguetAssigned To => AtulOpenbravo
2019-03-01 08:27SandrahuguetOBNetwork customer => No
2019-03-01 08:27SandrahuguetModules => Core
2019-03-01 08:27SandrahuguetTriggers an Emergency Pack => No
2019-03-01 08:27SandrahuguetRelationship addedrelated to 0040234
2019-03-12 15:44SandrahuguetRelationship addedrelated to 0040360
2019-03-20 09:21AtulOpenbravoStatusnew => scheduled
2019-06-21 08:24hgbotCheckin
2019-06-21 08:24hgbotNote Added: 0112929
2019-06-21 08:24hgbotStatusscheduled => resolved
2019-06-21 08:24hgbotResolutionopen => fixed
2019-06-21 08:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f38e68c88ad7189c4d54781d247a793a05dd6747 [^]
2019-06-21 08:24hgbotCheckin
2019-06-21 08:24hgbotNote Added: 0112930
2019-06-21 12:54hudsonbotCheckin
2019-06-21 12:54hudsonbotNote Added: 0112935
2019-06-21 12:54hudsonbotCheckin
2019-06-21 12:54hudsonbotNote Added: 0112936
2019-06-24 12:47SandrahuguetReview Assigned To => Sandrahuguet
2019-06-24 12:47SandrahuguetNote Added: 0112974
2019-06-24 12:47SandrahuguetStatusresolved => closed
2019-06-24 12:47SandrahuguetFixed in Version => 3.0PR19Q3

Notes
(0112929)
hgbot   
2019-06-21 08:24   
Repository: erp/devel/pi
Changeset: f38e68c88ad7189c4d54781d247a793a05dd6747
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Mar 20 23:11:44 2019 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/f38e68c88ad7189c4d54781d247a793a05dd6747 [^]

Fixes Issue 0040304:Delete records from FACT_ACCT and AD_PROCESS_REQUEST

** Delete records from fact_acct till 31-12-2016 in F&B International
Group client

---
M referencedata/sampledata/F_B_International_Group/AD_ORG_CLOSING.xml
M referencedata/sampledata/F_B_International_Group/A_AMORTIZATION.xml
M referencedata/sampledata/F_B_International_Group/C_INVOICE.xml
M referencedata/sampledata/F_B_International_Group/C_PERIOD.xml
M referencedata/sampledata/F_B_International_Group/C_PERIODCONTROL.xml
M referencedata/sampledata/F_B_International_Group/C_PERIODCONTROL_LOG.xml
M referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml
M referencedata/sampledata/F_B_International_Group/FIN_FINACC_TRANSACTION.xml
M referencedata/sampledata/F_B_International_Group/GL_JOURNAL.xml
M referencedata/sampledata/F_B_International_Group/M_INOUT.xml
M referencedata/sampledata/F_B_International_Group/M_INVENTORY.xml
M referencedata/sampledata/F_B_International_Group/M_MATCHINV.xml
---
(0112930)
hgbot   
2019-06-21 08:24   
Repository: erp/devel/pi
Changeset: c306246daf555cafea08d73c2dfcf3c81efc4298
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Jun 20 00:26:30 2019 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c306246daf555cafea08d73c2dfcf3c81efc4298 [^]

Related To Issue 40304:Delete records from FACT_ACCT & AD_PROCESS_REQUEST

Exclude AD_PROCESS_REQUEST records before 01-01-2017 having status
<> SCH/UNS

---
M referencedata/sampledata/F_B_International_Group/AD_PROCESS_REQUEST.xml
---
(0112935)
hudsonbot   
2019-06-21 12:54   
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/44c767ef7fd4 [^]
Maturity status: Test
(0112936)
hudsonbot   
2019-06-21 12:54   
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/44c767ef7fd4 [^]
Maturity status: Test
(0112974)
Sandrahuguet   
2019-06-24 12:47   
code review + testing ok