We're updating the issue view to help you get more done. 

Can't get a conversion rate if conversionDate is not set

Description

Hi,

MConversionRate.getRate has a major issue because if ConvDate param is not set, iDempiere uses System.currentTimeMillis() - means with hour-minutes-seconds...
And the sql query fails to retrieve data (in my case a rate is valid since first to last day of month).
Thus '2019-07-31 11:09:13.131' is NOT between ValidFrom (07/01) AND ValidTo (07/31)

Attached patch fixes it.

Regards,

Nicolas

Environment

None

Status

Assignee

Nicolas Micoud

Reporter

Nicolas Micoud

Labels

Tested By

None

Priority

Blocker