| Description |
*Overview:*
In cash receipts we are dealing with two rates. The rate on the invoice and the rate on the payment. the gain or loss comes from the difference between the rate at the time of invoice and the rate at the time of payment. (see the below example). At the time of payment you want to apply the current exchange rate vs the old exchange rate to calculate the gain or loss.
This is an extension of the test string AR-7616 - after we created an invoice we are trying to pay the invocie. when we pay the invocie I am expecting a post preview of :
|Account|Foreign Debit|Foreign Credit|Debit|Credit|Calc|
|Cash|1000| |760
| |1000*.76 Foreign amount * current transaction rate
|
|AR| |1000| |560|1000*.56 Foreign amount * orignial rate|
|Gain or Loss - this account should be the realized gain or loss account from the company configuration.|0|0| |200|Debt - Credit - this is to account for the change in exchange rate - rate moved in a good direction so it is a credit or a gain.
.76-.56=.20 (new rate less old )
.20*1000=1000
|
{color:#ff0000} *Acceptance:* {color}
* {color:#ff0000}Currency Rate was overridden at time of transaction from .53 to .76{color}
** {color:#ff0000}rate in currency tables was ,56 and wehn I changed thte rate on the transaction the GL was not changed.{color}
* {color:#ff0000}but posting still used the rate from the currency rate tables not fromt he receive payments screen. {color}
* {color:#ff0000}current rate should default from the rate table but allow override.{color}
* {color:#ff0000}Detail line rate should be the rate on the historic transaction from the invoice.{color}
!pastedImage_d98264_0.png! !pastedImage_d98264_1.png!
|