0034583: "Transaction Date" and "Accounting Date" needs to be truncated when creating transactions from Cash Management process

Description

Financial Account Transaction document is currently created with HH:MM:SS <> 00:00:00, which is wrong and affecting in reporting

Steps To Reproduce

1. Run cash management 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)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0034582

closed

ranjith_qualiantech_com

"Transaction Date" and "Accounting Date" needs to be truncated when creating transactions from Cash Up process

Notes
(0092140) ranjith_qualiantech_com (viewer) 2016-12-06 13:43	Fixed in https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d5ec6376a9c142621e8e6c7a5b668964185dac4a [^]

Issue History
Date Modified	Username	Field	Change
2016-11-18 14:14	maite	New Issue
2016-11-18 14:14	maite	Assigned To	=> Retail
2016-11-18 14:14	maite	OBNetwork customer	=> Yes
2016-11-18 14:14	maite	Support ticket	=> 44321
2016-11-18 14:14	maite	Resolution time	=> 1480806000
2016-11-18 14:14	maite	Triggers an Emergency Pack	=> No
2016-11-18 14:14	maite	Relationship added	related to 0034582
2016-11-18 14:15	maite	Issue Monitored: networkb
2016-11-30 11:08	ranjith_qualiantech_com	Assigned To	Retail => ranjith_qualiantech_com
2016-11-30 11:08	ranjith_qualiantech_com	Status	new => scheduled
2016-12-06 13:43	ranjith_qualiantech_com	Note Added: 0092140
2016-12-06 16:45	marvintm	Status	scheduled => resolved
2016-12-06 16:45	marvintm	Resolution	open => fixed
2016-12-09 11:09	marvintm	Review Assigned To	=> marvintm
2016-12-09 11:09	marvintm	Status	resolved => closed
2016-12-09 11:09	marvintm	Fixed in Version	=> RR17Q1