Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0034551 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | major | always | 2016-11-17 10:28 | 2016-12-16 18:38 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | alekosmp86 | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0PR17Q1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | c876c12bb791 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | aferraz | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Advanced Payables and Receivables Mngmt | |||||||
| Support ticket | 44321 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0034551: Transaction Date and Ending Date not truncated when reconciliation is created using "Reconcile" process | |||||||
| Description | Reconciliations created using manual reconciliation process (Reconcile button) have not truncated dates | |||||||
| Steps To Reproduce | 1. Access Financial Account "Caja" 2. Create new transaction setting any gl item and amount. Process transaction 3. Run Reconcile process, select previous transaction, set proper ending balance and process 4. Via database, verify that Transaction Date and Ending Date are not truncated (which is affecting reconciliation's report) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0091724) alekosmp86 (viewer) 2016-11-21 22:09 |
Test Plan Log in the backend using F&B International Group Admin Go to Financial Account screen Select the record with name "Caja" Go to Transaction tab Create a new document Transaction Type: BP Deposit G/L Item: Capital Social Deposit Amount: 100 Save the document Process the transaction Run the Reconcile process Select the previously created transaction Adjust the ending balance with the proper value Click on Reconcile button Via database, go to FIN_Reconciliation table and notice that fields "dateto" and "statementdate" now have their dates truncated |
|
(0091800) hgbot (developer) 2016-11-24 18:53 |
Repository: erp/devel/pi Changeset: c876c12bb7913ce7da34862b7eeae382d41b206f Author: Alejandro <alekosmp86 <at> gmail.com> Date: Mon Nov 21 14:04:51 2016 -0600 URL: http://code.openbravo.com/erp/devel/pi/rev/c876c12bb7913ce7da34862b7eeae382d41b206f [^] Fixes issue 34551: Dates not truncated when using "Reconcile" process Reconciliations created using manual reconciliation process (Reconcile button) were not inserted with truncated dates. When setting the properties for the reconciliation record being saved, the TransactionDate and EndingDate properties were being filled with the current date and time. Now those fields are filled only with the date. --- M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/Reconciliation.java --- |
|
(0091801) aferraz (viewer) 2016-11-24 18:53 |
Code review + Testing OK |
|
(0091856) alekosmp86 (viewer) 2016-11-25 17:05 |
Run this query in order to fix the wrong data created by this issue: alter table fin_reconciliation disable trigger all; update fin_reconciliation set dateto=trunc(dateto), statementdate=trunc(statementdate); alter table fin_reconciliation enable trigger all; |
|
(0092657) hudsonbot (viewer) 2016-12-16 18:38 |
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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-11-17 10:28 | maite | New Issue | |
| 2016-11-17 10:28 | maite | Assigned To | => Triage Finance |
| 2016-11-17 10:28 | maite | OBNetwork customer | => Yes |
| 2016-11-17 10:28 | maite | Modules | => Advanced Payables and Receivables Mngmt |
| 2016-11-17 10:28 | maite | Support ticket | => 44321 |
| 2016-11-17 10:28 | maite | Resolution time | => 1480806000 |
| 2016-11-17 10:28 | maite | Triggers an Emergency Pack | => No |
| 2016-11-18 09:38 | aferraz | Assigned To | Triage Finance => collazoandy4 |
| 2016-11-21 17:01 | alekosmp86 | Assigned To | collazoandy4 => alekosmp86 |
| 2016-11-21 22:09 | alekosmp86 | Note Added: 0091724 | |
| 2016-11-24 18:53 | hgbot | Checkin | |
| 2016-11-24 18:53 | hgbot | Note Added: 0091800 | |
| 2016-11-24 18:53 | hgbot | Status | new => resolved |
| 2016-11-24 18:53 | hgbot | Resolution | open => fixed |
| 2016-11-24 18:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c876c12bb7913ce7da34862b7eeae382d41b206f [^] |
| 2016-11-24 18:53 | aferraz | Review Assigned To | => aferraz |
| 2016-11-24 18:53 | aferraz | Note Added: 0091801 | |
| 2016-11-24 18:53 | aferraz | Status | resolved => closed |
| 2016-11-24 18:53 | aferraz | Fixed in Version | => 3.0PR17Q1 |
| 2016-11-25 17:05 | alekosmp86 | Note Added: 0091856 | |
| 2016-12-16 18:38 | hudsonbot | Checkin | |
| 2016-12-16 18:38 | hudsonbot | Note Added: 0092657 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |