Different exchange rates on invoices in secondary currency = unable to create valid statement
1) Single Company set of books
2) Company is CAD
3) Invoicing foreign (US) company in USD and payment received in USD, company is
Canadian and books are in CAD
4) Have USD statement journal in addition to CAD statement journal
5) Enter exchange rate for day of invoice for USD
6) Create Invoice in USD
7) Enter exchange rate for next invoice's day for USD
8) Create invoice in USD for another day
9) Enter exchange rate for day of statement for USD
10) Single payment for two invoices, therefore use statement
11) In USD statement journal enter USD payments for the USD invoices
12) Statement fails to validate due to differing amounts due to changing
exchange rates.
13) Attempting to balance statement by modifying total of statement so that new
statement total is USD amount (at statement date's exchange rate) which is
equals the CAD amount of invoices (at each of their exchange rates) and adding
USD amounts (at statement date's exchange rate) equal to CAD amount of invoice
(at each invoice date's exchange rates) also fails because statement fails to
let you associate the amount with the applicable invoice (after entering invoice
number and amount and hitting ENTER, invoice field becomes blank).