Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0027089
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementminoralways2014-07-15 19:162014-12-30 23:22
ReportermaiteView Statuspublic 
Assigned Tofsoto82 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionc3f7b29250f1
ProjectionnoneETAnoneTarget Version3.0PR15Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tovmromanos
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027089: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00277753.0PR15Q1 closedvmromanos Openbravo ERP Improve performance in TruncInvoiceDate and Issue26826_Org_AllowPeriodControl module scripts 
related to defect 0027886 newRetail Retail Modules Update invoices automatically fixed by TruncInvoiceDate module script 
related to defect 0031888 closedAtulOpenbravo 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 closedalekosmp86 Openbravo ERP Invoice Date and Accounting Date should be truncated when invoice is created using "Void" process 

-  Notes
(0068656)
maite (developer)
2014-07-15 19:18

modulescript is required in order to fix already existent erroneous data
(0070742)
hgbot (developer)
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 (manager)
2014-10-06 15:19

Code review + testing OK
(0072904)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2014-07-15 19:16 maite New Issue
2014-07-15 19:16 maite Assigned To => dmiguelez
2014-07-15 19:16 maite Modules => Core
2014-07-15 19:16 maite Triggers an Emergency Pack => No
2014-07-15 19:17 maite Assigned To dmiguelez => jonalegriaesarte
2014-07-15 19:17 maite Resolution time => 1412114400
2014-07-15 19:17 maite Issue Monitored: networkb
2014-07-15 19:18 maite Note Added: 0068656
2014-07-15 19:18 maite Proposed Solution updated
2014-07-24 13:50 jonalegriaesarte Assigned To jonalegriaesarte => AtulOpenbravo
2014-09-22 16:36 jonalegriaesarte Target Version 3.0PR14Q4 => 3.0PR15Q1
2014-09-25 16:02 fsoto82 Assigned To AtulOpenbravo => fsoto82
2014-09-25 16:02 fsoto82 Status new => scheduled
2014-09-25 16:02 fsoto82 fix_in_branch => pi
2014-10-06 15:18 hgbot Checkin
2014-10-06 15:18 hgbot Note Added: 0070742
2014-10-06 15:18 hgbot Status scheduled => resolved
2014-10-06 15:18 hgbot Resolution open => fixed
2014-10-06 15:18 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c3f7b29250f1ff80a94c868b73c715522c37659b [^]
2014-10-06 15:19 vmromanos Review Assigned To => vmromanos
2014-10-06 15:19 vmromanos Note Added: 0070743
2014-10-06 15:19 vmromanos Status resolved => closed
2014-10-06 17:02 vmromanos Relationship added related to 0027775
2014-10-16 13:02 vmromanos Relationship added related to 0027886
2014-12-30 23:22 hudsonbot Checkin
2014-12-30 23:22 hudsonbot Note Added: 0072904
2016-01-14 11:02 ngarcia Relationship added related to 0031888
2016-11-03 10:37 maite Relationship added related to 0034371


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker