Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034662Openbravo ERP09. Financial managementpublic2016-12-01 09:182016-12-16 18:39
ReporterSanjota 
Assigned ToSanjota 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q1 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034662: If we launch costing migration process the last day of a month, PeriodClosedForMMI error is thrown
DescriptionIf we launch costing migration process the last day of a month, PeriodClosedForMMI error is thrown
Steps To ReproduceAs system admin role:
   Install the 3.0MP12.2 version
   Upgrade it to pi
   Note: I need to launch the following command as the Costing Algorithms were not present in the system after recompiling it:
      ant apply.module -DforceRefData=true
      ant smartbuild
As group admin roles:
   Create 2016 year and periods for all the legal with accounting organizations in the system
   Open them
As system admin role:
   Launch the Costing Migration process for last day of the month
   Check it launches a warning that there are transactions without cost
   Set as inactive the 'Products with transactions without available cost on date.' alert
   Launch the Costing Migration process again
   Check that 'PeriodClosedForMMI' error is thrown.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0034563 closed Sanjota Index: 0, Size: 0 error when launching Costing Migration Process 
related to defect 0034564 closed Sanjota Duplicated records in m_transactioncost table after launching the Costing Migration Process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-12-01 09:18SanjotaNew Issue
2016-12-01 09:18SanjotaAssigned To => Triage Finance
2016-12-01 09:18SanjotaModules => Core
2016-12-01 09:18SanjotaTriggers an Emergency Pack => No
2016-12-01 09:58aferrazRelationship addedrelated to 0034563
2016-12-01 09:59aferrazRelationship addedrelated to 0034564
2016-12-01 10:20SanjotaAssigned ToTriage Finance => Sanjota
2016-12-01 10:20SanjotaStatusnew => scheduled
2016-12-01 11:47SanjotaNote Added: 0091959
2016-12-01 14:44hgbotCheckin
2016-12-01 14:44hgbotNote Added: 0091968
2016-12-01 14:44hgbotStatusscheduled => resolved
2016-12-01 14:44hgbotResolutionopen => fixed
2016-12-01 14:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6c3e95c4b2af13c06a6a3200165d829851a1c376 [^]
2016-12-01 14:45aferrazReview Assigned To => aferraz
2016-12-01 14:45aferrazNote Added: 0091971
2016-12-01 14:45aferrazStatusresolved => closed
2016-12-01 14:45aferrazFixed in Version => 3.0PR17Q1
2016-12-16 18:39hudsonbotCheckin
2016-12-16 18:39hudsonbotNote Added: 0092675

Notes
(0091959)
Sanjota   
2016-12-01 11:47   
Test plan :
As system admin role:
   Install the 3.0MP12.2 version
   Upgrade it to pi
   Note: I need to launch the following command as the Costing Algorithms were not present in the system after recompiling it:
      ant apply.module -DforceRefData=true
      ant smartbuild
As group admin roles:
   Create 2016 year and periods for all the legal with accounting organizations in the system
   Open them
As system admin role:
   Launch the Costing Migration process for last day of the month
   Check it launches a warning that there are transactions without cost
   Set as inactive the 'Products with transactions without available cost on date.' alert
   Launch the Costing Migration process again
   Observe that there is no error :'PeriodClosedForMMI' and the process will cbe completed with success status
(0091968)
hgbot   
2016-12-01 14:44   
Repository: erp/devel/pi
Changeset: 6c3e95c4b2af13c06a6a3200165d829851a1c376
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Thu Dec 01 16:28:49 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/6c3e95c4b2af13c06a6a3200165d829851a1c376 [^]

Fixes issue 34662: Error due to date and time comparision

Resolved issue with Costing Migration process.
"PeriodClosedForMMI" error due to date comparision on last day of month fixed.

---
M src/org/openbravo/costing/CostingMigrationProcess.java
---
(0091971)
aferraz   
2016-12-01 14:45   
Code review + Testing OK
(0092675)
hudsonbot   
2016-12-16 18:39   
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/dc8bf00badd0 [^]
Maturity status: Test