Matching with different currencies in 6.1 will not full reconcile invoices

[Alvar Vilu]

Example: base currency is EUR and seller currency is GBP

I have an invoice 50.83 GPB (currency rate is on that day: 0.79805 ; 63.69 EUR)
The day the payment is made currency rate is: 0.8097 - so in reconciliation view i should see match currency amount: 62.77 EUR

The problem is that i am reconciling this payment days after and currency rate is currently (on that day): 0,804900
So in match currency amount i see: 63.15 EUR

This is WRONG... i really should see there either 63.69 (the day the invoice was inserted) or 62.77 (the day the payment was made)
Not the amount 63.15 (the current date, when i am reconciling, with a completely different currency rate)

Best luck :)

[Alvar Vilu (alvar-vilu)]

ps. This is in version 6.1 revno 140

[Stefan Rijnhart (Opener) (stefan-opener)]

Hi Alvar,

thank you for posting this issue. It seems a bit silly indeed to use the moment of reconciliation for checking the currency rate. I uploaded an untested, tentative fix here:

lp:~therp-nl/banking-addons/6.1-lp1073545-meaningful_dates_in_currency_conversion

Would be great if you could test it and indicate what it does for you.

On a side, if I am correct the 'Related branches' tag in Launchpad is for branches that aim at fixing the problem rather than for branches in which the problem occurs. Therefore I will remote the links to the main branch.

Cheers,
Stefan.

[Alvar Vilu (alvar-vilu)]

Hi Stefan,

I made the changes and now it shows for match currency amount: -62,78
It's pretty close to 62.77 (i think i made some rounding problems)

residual is: 0.49

So it solves it :)
Thank You!

[Alvar Vilu (alvar-vilu)]

Now everything is working properly...
the residual 0.49 i wrote-off and the invoice is payd :)
last time there was still 0.12 to pay... but now, ok :)

[Stefan Rijnhart (Opener) (stefan-opener)]

Hi Alvar,

Thanks for testing the proposed fix!

Cheers,
Stefan.