0014874: "Standard" matching algorithm requirement for date to be removed

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0014874	Openbravo ERP	Z. Others	public	2010-10-14 12:42	2011-05-19 16:11

Reporter	rmorley
Assigned To	eduardo_Argal
Priority	high	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Platform		OS	20	OS Version	Community Appliance
Product Version	2.50
Target Version	2.50	Fixed in Version
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
Modules	Advanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency Pack	No

Summary	0014874: "Standard" matching algorithm requirement for date to be removed
Description	The "Standard" matching algorithm requirement for a match on date should be removed.
Steps To Reproduce	The "Standard" matching algorithm currently requires a match on date for both a soft match and a hard match to be achieved. The problem with this is that the date in the system is the "Deposited" or "Withdrawn" date, whereas the date on the bank statement is the date the bank actually clears the transaction. For example, I receive a cheque from a customer and I deposit it today. That results in today's date being captured for the "Deposited Date" in Openbravo. The bank receives the cheque from me today, but then has to wait a couple of days for the cheque to be cleared by the issuing bank. When the cheque clears it then appears on my bank statement. The date on the bank statement is the date the cheque cleared, not the date the cheque was originally deposited. There is then no match between the deposited date in Openbravo and the cleared date on the bank statement. Similarly, when making payment today, the "Withdrawn Date" in Openbravo is today's date. I then send the cheque to my supplier. The supplier has up to six months to present the cheque to their own bank for payment. Their bank then requests that my bank clear the cheque. When this happens it is the date that the cheque cleared that appears on the statement from my bank, so again there is no relationship between the "Withdrawn Date" in Openbravo and the Cleared Date on the statement from my bank.
Proposed Solution	The match on date in the "Standard" matching algorithm must be removed because users will never get a match in reality.
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change
2010-10-14 12:42	rmorley	New Issue
2010-10-14 12:42	rmorley	Assigned To	=> eduardo_Argal
2010-10-14 18:34	eduardo_Argal	Status	new => scheduled
2010-10-14 18:34	eduardo_Argal	fix_in_branch	=> pi
2010-10-14 23:53	hgbot	Checkin
2010-10-14 23:53	hgbot	Note Added: 0031868
2010-10-14 23:53	hgbot	Status	scheduled => resolved
2010-10-14 23:53	hgbot	Resolution	open => fixed
2010-10-14 23:53	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.advpaymentmngt/rev/f4b3bd4d873615f3fa9357d010e21d3077812096 [^]
2011-05-19 16:11	mirurita	Status	resolved => closed

Notes