Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2019-04-30 13:312019-08-22 14:45
ReporteregoitzView Statuspublic 
Assigned Tocollazoandy4 
PriorityurgentResolutionfixedFixed in Version3.0PR19Q4
StatusclosedFix in branchFixed in SCM revision52183b3014d4
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0040722: MovementDate is filled with time and should contain only with the date

DescriptionIn some customers it has been discover that there are rows in the transaction table containin values with date time on the movement date column when only date should be saved.
Steps To Reproduce-Check the code.

src/org/openbravo/materialmgmt/refinventory/ header.setMovementDate(new Date());

src/org/openbravo/erpCommon/ad_actionButton/ inv.setMovementDate(new Date());

Proposed SolutionTruncate the date:


src/org/openbravo/common/actionhandler/ gmHeader.setMovementDate(DateUtils.truncate(new Date(), Calendar.DATE));

Check if platform team can implement something to automatically truncate the value if the referencce is date (not date/time).
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0040676 closeddmiguelez Valued Stock Report not properly working when movementDate has more precision than days and aggregated data 
depends on design defect 0040905 newAugustoMauch It would be fine to automatically truncate the value if the reference is date 
Not all the children of this issue are yet resolved or closed.

-  Notes
egoitz (developer)
2019-04-30 13:32

Also other modules should be reviewed:
Autobom for retail
collazoandy4 (developer)
2019-08-08 12:36

Test Plan
  Go to Referenced Inventory window, execute the Box process and check in database the movementdate from previous process created in M_Movement is truncated to the current date

Test Plan II - Picking List module
  Enable the Picking List Auto Close preference
  Go to Warehouse and set Rn-1-0-0 as Outbound
  Create and complete a new Sales Order for Cerveza Lager 0,5L
  Go to Warehouse Picking List and create a new record with Document Type: Picking List outbound
    Clic on Sales Order button and select the previous order created
    Clic on Assing button and select Openbravo
    Clic on Confirm button and check in database the M_InOut and M_Movement created has the movement date truncated

Test Plan III - AWO
  Execute the and check in the database the M_Inventory, OBAWO_Inventory_Prop, M_InOut and M_Movement records created today has a movement date truncated
Sandrahuguet (developer)
2019-08-14 12:49

We have decided not to create a modulescript because it can cause performance problems.

Sql to fix data:

update M_Inventory set movementdate =trunc (movementdate);
update M_Movement set movementdate =trunc (movementdate);
update OBAWO_Inventory_Prop set movementdate = trunc (movementdate);
update M_InOut set movementdate = trunc (movementdate);
update M_transaction set movementdate = trunc (movementdate);
hgbot (developer)
2019-08-14 13:30

Repository: erp/devel/pi
Changeset: 52183b3014d42acf9b5708ae90dad8e71720ea23
Author: Armaignac <collazoandy4 <at>>
Date: Wed Aug 14 12:29:32 2019 +0200
URL: [^]

Fixes issue 40722:MovementDate is filled with time and should contain only with
the date

The M_Inventory and M_Movement movementDate was truncated to the date

M src/org/openbravo/erpCommon/ad_actionButton/
M src/org/openbravo/materialmgmt/refinventory/
hgbot (developer)
2019-08-14 13:31

Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 486041f4ab466be99ecd64503b04870696ff34ee
Author: Sandra Huguet <sandra.huguet <at>>
Date: Wed Aug 14 13:30:05 2019 +0200
URL: [^]

Related to issue 40722:Truncated the movement date in M_Inventory, M_InOut,
OBAWO_Inventory_Prop and M_Movement

M src-test/org/openbravo/warehouse/advancedwarehouseoperations/utils/
M src/org/openbravo/warehouse/advancedwarehouseoperations/centralbroker/
M src/org/openbravo/warehouse/advancedwarehouseoperations/centralbroker/
M src/org/openbravo/warehouse/advancedwarehouseoperations/centralbroker/
M src/org/openbravo/warehouse/advancedwarehouseoperations/utils/
Sandrahuguet (developer)
2019-08-14 13:32

code review + testing ok
hudsonbot (developer)
2019-08-22 14:45

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2019-04-30 13:31 egoitz New Issue
2019-04-30 13:31 egoitz Assigned To => Triage Finance
2019-04-30 13:31 egoitz Modules => Core
2019-04-30 13:31 egoitz Triggers an Emergency Pack => No
2019-04-30 13:31 egoitz Issue generated from 0040676
2019-04-30 13:31 egoitz Relationship added related to 0040676
2019-04-30 13:32 egoitz Note Added: 0111386
2019-04-30 16:54 Sandrahuguet Assigned To Triage Finance => nonofrancisco
2019-05-06 15:16 Sandrahuguet Assigned To nonofrancisco => Triage Finance
2019-05-20 08:34 Sandrahuguet Relationship added depends on 0040905
2019-08-06 10:46 Sandrahuguet Assigned To Triage Finance => collazoandy4
2019-08-07 15:16 collazoandy4 Status new => scheduled
2019-08-08 12:36 collazoandy4 Note Added: 0113904
2019-08-14 12:49 Sandrahuguet Note Added: 0114014
2019-08-14 13:30 hgbot Checkin
2019-08-14 13:30 hgbot Note Added: 0114015
2019-08-14 13:30 hgbot Status scheduled => resolved
2019-08-14 13:30 hgbot Resolution open => fixed
2019-08-14 13:30 hgbot Fixed in SCM revision => [^]
2019-08-14 13:31 hgbot Checkin
2019-08-14 13:31 hgbot Note Added: 0114016
2019-08-14 13:32 Sandrahuguet Review Assigned To => Sandrahuguet
2019-08-14 13:32 Sandrahuguet Note Added: 0114017
2019-08-14 13:32 Sandrahuguet Status resolved => closed
2019-08-14 13:32 Sandrahuguet Fixed in Version => 3.0PR19Q4
2019-08-22 14:45 hudsonbot Checkin
2019-08-22 14:45 hudsonbot Note Added: 0114225

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker