Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034582Retail ModulesWeb POSpublic2016-11-18 14:122016-12-09 11:08
Reportermaite 
Assigned Toranjith_qualiantech_com 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR17Q1 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket44321
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034582: "Transaction Date" and "Accounting Date" needs to be truncated when creating transactions from Cash Up process
DescriptionFinancial Account Transaction document is currently created with HH:MM:SS <> 00:00:00, which is worng and affecting in reporting
Steps To Reproduce1. Run cash up process
2. Execute following statement directly in the database and realize that your transactions are created with HH:MM:SS <> 00:00:00

select * from fin_finacc_transaction where statementdate <> trunc(statementdate) or dateacct <> trunc(dateacct)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0034583 closed ranjith_qualiantech_com "Transaction Date" and "Accounting Date" needs to be truncated when creating transactions from Cash Management process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-11-18 14:12maiteNew Issue
2016-11-18 14:12maiteAssigned To => Retail
2016-11-18 14:12maiteOBNetwork customer => Yes
2016-11-18 14:12maiteSupport ticket => 44321
2016-11-18 14:12maiteResolution time => 1480806000
2016-11-18 14:12maiteTriggers an Emergency Pack => No
2016-11-18 14:12maiteIssue Monitored: networkb
2016-11-18 14:14maiteRelationship addedrelated to 0034583
2016-11-30 11:08ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2016-11-30 11:08ranjith_qualiantech_comStatusnew => scheduled
2016-12-06 10:43hgbotCheckin
2016-12-06 10:43hgbotNote Added: 0092111
2016-12-06 10:43hgbotCheckin
2016-12-06 10:43hgbotNote Added: 0092112
2016-12-06 10:43hgbotStatusscheduled => resolved
2016-12-06 10:43hgbotResolutionopen => fixed
2016-12-06 10:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d5ec6376a9c142621e8e6c7a5b668964185dac4a [^]
2016-12-06 10:44hgbotStatusscheduled => resolved
2016-12-09 11:08marvintmReview Assigned To => marvintm
2016-12-09 11:08marvintmStatusresolved => closed
2016-12-09 11:08marvintmFixed in Version => RR17Q1

Notes
(0092111)
hgbot   
2016-12-06 10:43   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d5ec6376a9c142621e8e6c7a5b668964185dac4a
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Dec 06 15:07:22 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d5ec6376a9c142621e8e6c7a5b668964185dac4a [^]

Fixes issue 34582 : Removing time from date in financial transaction columns "Transaction Date" and "Accounting Date"

* while doing cashup or cash management process, time was removed in "Transaction Date" and "Accounting Date" of financial transaction table

---
M src/org/openbravo/retail/posterminal/CashCloseProcessor.java
M src/org/openbravo/retail/posterminal/ProcessCashMgmt.java
---
(0092112)
hgbot   
2016-12-06 10:43   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d5ec6376a9c142621e8e6c7a5b668964185dac4a
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Dec 06 15:07:22 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d5ec6376a9c142621e8e6c7a5b668964185dac4a [^]

Fixes issue 34582 : Removing time from date in financial transaction columns "Transaction Date" and "Accounting Date"

* while doing cashup or cash management process, time was removed in "Transaction Date" and "Accounting Date" of financial transaction table

---
M src/org/openbravo/retail/posterminal/CashCloseProcessor.java
M src/org/openbravo/retail/posterminal/ProcessCashMgmt.java
---