Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Currency variance on payments with foreign currency from bank account isn't calculated

Description

I common scenario is to make international payments from the company's main account which is in the local currency.

The invoice which is paid is registered in foreign currency.
The payment must also then be registered in the foreign currency.

The payment is then reconciled with the bank account and recalculated to local currency.
Almost always the currency rate that the bank gave is different than what was calculated in the system.
This difference isn't automatically adjusted by iDempiere which leaves a difference on the bank in transit account.
See attached screen shot.
Note that the actual local currency amount can be adjusted when the bank account is reconciled (and this is how it's supposed to be).

Environment

None

Attachments

1

Activity

Show:

Carlos Ruiz July 30, 2020 at 7:25 PM

Closing as potential-idea after 7 years of inactivity.

At this moment I think the accountant can do a GL Journal to match those currency adjustments, the proposal here doesn't sound like a bug, but more like a feature request to avoid the GL Journal and do it automatically.

Thomas Bayen December 7, 2013 at 6:58 PM

At the moment it is possible to change the transaction amount to be different from the payment. This problem does not depend on a foreign urrency but it is related to this issue so I wanted to note it here.

My idea is that in all cases the transaction amount should be equal to the payment amount. And the sum of chargeAmt + trxAmt + interestAmt
should be equal statementAmt. We should check that before posting the statement. Everything else creates differences on bank in transit account.

For a discussion of this topic see https://groups.google.com/forum/#!topic/idempiere/ReyOp7N-B4Q

Incomplete

Details

Assignee

Reporter

Labels

Original estimate

Time tracking

No time logged4h remaining

Priority

Created November 27, 2013 at 3:54 PM
Updated September 4, 2020 at 8:52 PM
Resolved July 30, 2020 at 7:25 PM