Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027089Openbravo ERP03. Procurement managementpublic2014-07-15 19:162014-12-30 23:22
Reportermaite 
Assigned Tofsoto82 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027089: Invoice Date and Accounting Date should be truncated when invoice is created using "Generate Invoice from Receipt" process
DescriptionInvoice Date and Accounting Date should be truncated when invoice is created using "Generate Invoice from Receipt" process
Steps To Reproduce1. Access as System Administrator to Goods Receipt window and "ACTIVE" field "Generate Invoice from Receipt"
2. Compile application and restart tomcat
3. Create Goods Receipt for any Org and BP and Process it.
4. Run "Generate Invoice from Receipt" process
5. In database, verify that "dateinvoiced" and "dateacct" fields are not truncated
Proposed Solutionthese dates should be truncated
Additional Information
TagsNo tags attached.
Relationships
related to defect 00277753.0PR15Q1 closed vmromanos Openbravo ERP Improve performance in TruncInvoiceDate and Issue26826_Org_AllowPeriodControl module scripts 
related to defect 0027886 new Retail Retail Modules Update invoices automatically fixed by TruncInvoiceDate module script 
related to defect 0031888 closed AtulOpenbravo Openbravo ERP Create Order from Sales Quotation is not truncating date fields, thus, payment against invoice is being considered a prepayment 
related to defect 0034371 closed alekosmp86 Openbravo ERP Invoice Date and Accounting Date should be truncated when invoice is created using "Void" process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-15 19:16maiteNew Issue
2014-07-15 19:16maiteAssigned To => dmiguelez
2014-07-15 19:16maiteModules => Core
2014-07-15 19:16maiteTriggers an Emergency Pack => No
2014-07-15 19:17maiteAssigned Todmiguelez => jonalegriaesarte
2014-07-15 19:17maiteResolution time => 1412114400
2014-07-15 19:17maiteIssue Monitored: networkb
2014-07-15 19:18maiteNote Added: 0068656
2014-07-15 19:18maiteProposed Solution updated
2014-07-24 13:50jonalegriaesarteAssigned Tojonalegriaesarte => AtulOpenbravo
2014-09-22 16:36jonalegriaesarteTarget Version3.0PR14Q4 => 3.0PR15Q1
2014-09-25 16:02fsoto82Assigned ToAtulOpenbravo => fsoto82
2014-09-25 16:02fsoto82Statusnew => scheduled
2014-09-25 16:02fsoto82fix_in_branch => pi
2014-10-06 15:18hgbotCheckin
2014-10-06 15:18hgbotNote Added: 0070742
2014-10-06 15:18hgbotStatusscheduled => resolved
2014-10-06 15:18hgbotResolutionopen => fixed
2014-10-06 15:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c3f7b29250f1ff80a94c868b73c715522c37659b [^]
2014-10-06 15:19vmromanosReview Assigned To => vmromanos
2014-10-06 15:19vmromanosNote Added: 0070743
2014-10-06 15:19vmromanosStatusresolved => closed
2014-10-06 17:02vmromanosRelationship addedrelated to 0027775
2014-10-16 13:02vmromanosRelationship addedrelated to 0027886
2014-12-30 23:22hudsonbotCheckin
2014-12-30 23:22hudsonbotNote Added: 0072904
2016-01-14 11:02ngarciaRelationship addedrelated to 0031888
2016-11-03 10:37maiteRelationship addedrelated to 0034371

Notes
(0068656)
maite   
2014-07-15 19:18   
modulescript is required in order to fix already existent erroneous data
(0070742)
hgbot   
2014-10-06 15:18   
Repository: erp/devel/pi
Changeset: c3f7b29250f1ff80a94c868b73c715522c37659b
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Wed Oct 01 21:40:18 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/c3f7b29250f1ff80a94c868b73c715522c37659b [^]

Fixed bug 27089: Generate Invoice from Receipt inserts non truncated dates

Changed stored procedure M_INOUT_CREATEINVOICE to insert truncated dates in c_invoice.
Also created a modulescript to correct this dates previously generated by the process.

---
M src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml
A src-util/modulescript/build/classes/org/openbravo/modulescript/TruncInvoiceDate.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/TruncInvoiceDateData.class
A src-util/modulescript/src/org/openbravo/modulescript/TruncInvoiceDate.java
A src-util/modulescript/src/org/openbravo/modulescript/TruncInvoiceDate_data.xsql
---
(0070743)
vmromanos   
2014-10-06 15:19   
Code review + testing OK
(0072904)
hudsonbot   
2014-12-30 23:22   
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/6525fe229e06 [^]
Maturity status: Test