Hello all!
I have a requirement where the Client wants to use a different currency exchange rate when a customer gets a invoice issued in one currency and does the payment for that invoice in some other currency. If both the currencies are same, the we want to use the standard currency exchange rates.
This is the current ledger configuration:
Accounting currency: PEN
Reporting currency: USD
Standard Exch rate: 2 PEN = 1 USD
Custom Exch rate 1: 5 PEN = 1 USD
Custom Exch rate 2: 10 PEN = 1 USD
Now, If I have Invoice in PEN and payment in USD: I will use Custom exch rate 1 and,
If I have invoice in USD and payment in PEN: I will use Custom exch rate 2.
The goal is to put the extra amount (due to difference in Exch rates) in Currency adjustment account.
For this to work, I tried to change the Currency exchange rate on the customer payment journal on a click of a button.
I got success when I had the invoice in PEN and payment in USD. The system settled both and the gain/loss amount is posted as a Currency adjustment transaction.
But when I have the opposite case, i.e. invoice in USD and payment in PEN, the system does not show the intended behavior. It leaves a balance on the Payment transaction and does not create a Currency adjustment transaction.
I tried to figure out what I am missing to modify on the Customer payment journal in order to achieve the goal.
Please let me know if you have any suggestions on this. Thank you.
