I have to say that this was done with rev 104 so some things might already be fixed in 105.
I have an supplier invoice of 1920.00 USD, invoice date 09/14/2010, exhange rate 1.25 yielding an amount of 1536.00 EUR.
I enter the bank statement with an exchange rate of 1.50 so the EUR amount is now 1280.00 EUR for 1920.00 USD. I had a payment term of 2% cash discount, so I actually paid 1881.60 USD which would come to 1254.40 EUR. So its 38.40 USD/ 25.60 EUR cash discount.
Compare the two attachments. The first one is the move produced by the code, the 2nd one is how it's supposed to be.
Line 5 is correct (except for the partial reconcile).
Line 4 has the discount amount in the company currency instead of the foreign currency. This should be 38.40 USD / 25.60 EUR.
This results in Line 1, 2 and 3 to be incorrect:
Line 1 has a) the invoice amount (1920.00 USD) in the currency amount field instead of the paid amount (1881.60 USD) and b) and incorrect value in the credit field - 1241,60 EUR instead of 1254,40 EUR - due to an incorrect cash discount move line.
Line 2 and 3 also are the result of the incorrect cash discount line as the EUR amount is miscalculated. This should be 256.00 EUR instead of 217.60 EUR with currency amounts of 0.00 USD.
