[16.0] account_reconcile_oca currency exchange valuation handling issues

[lk-eska]

Module

account_reconcile_oca

Describe the bug

Currency exchange rates have trash (delete) icon and when clicked new currency exchange lines are created.

To Reproduce

Affected versions: 16.0

Steps to reproduce the behavior:

1. Create an invoice other than the company currency and confirm
2. Create an operation and try to reconcile it with the invoice created in 1
3. Click on the trash icon at the end of the currency rate difference line or click on statement line or click on invoice line.
4. If you try to delete these lines more pops up

Expected behavior Currency exchange difference lines shouldn't have delete option and clicking on lines shouldn't bring new lines.

Additional context There are screenshots of this bug here in this PR:

https://github.com/OCA/account-reconcile/pull/587#issuecomment-1711767810

@etobella thanks

[lk-eska]

An additional problem related to currecy exchange gain/loss lines is that they are left when the invoice is removed.

I believe it is another side-effect of the same problem.

[etobella]

Can you propose a PR fixing it?

[anajuaristi]

Hi @etobella We are experiencing same issue. The problem is that the issue is blocking the ability of reconcile several invoices. We have no idea how to fix it so... maybe you would be interesed in sending us a quotation? If yes, we could contact by email or phone. Thank you!!

[lk-eska]

@etobella https://github.com/OCA/account-reconcile/pull/636 solves this problem.

There are further problems:

1. there is no way to edit the bank statement line -> we added tree views and it works good. we can send PR for this.
2. it gets strange when some lines are deleted. for example when invoice is deleted it becomes a seperate line instead of merging into bank temporary account, foreign currency adjustment line remains there. It is wrong until you click reset reconciliation. -> this needs to be handled.
3. amount in currency in the bank statement line is shown in company currency (this is the same in enterprise so i assume this is a common problem but it would be good to fix this)
4. Currency and amount currency selection on Manual Operation screen is necessary.

I can send detailed issues or pull requests. Let me know @etobella

[etobella]

A PR would be awesome....

What are you talking about deletion?

[lk-eska]

Here's the PR for listing and editing statement lines: https://github.com/OCA/account-reconcile/pull/637

@etobella

[lk-eska]

There are few issues when deleting.

102003 -> bank 120000 -> invoice 656000 -> currency exchange 102999 -> temporary account

1. when invoice is deleted, currency exchange line remains there. shouldn't it be removed?

2. when currency exchange line is deleted, it sometimes create a new line with temporary account. see below:

see the last line. this doesn't always happen, try a few times.

Another issue is that amount currency is actually €120 but it shows 3720₺ in amount in currency. see below:

This is also the same in enterprise.

[lk-eska]

Finally these fields are required IMO:

https://github.com/OCA/account-reconcile/issues/612

[lk-eska]

Should we close this issue or keep it to follow these: https://github.com/OCA/account-reconcile/issues/622#issuecomment-1987968057

@etobella

[github-actions[bot]]

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days. If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.