How to: AP: Foreign Currency Invoice with Tiered Rates
We have the following requirement:
Calculate Exchange rate based on Tiers - for example, if the USD Converted Amount was $0-$5000, the CAD-USD Rate is 1.20; if the USD converted amount was between $5001-$1000, then the exchange rate that needs to be used is 1.15
How do we achieve this?
Apart from this, the Exchange rate needs to be recalculated during Payment time as the Payment may be done 1 week after the Invoice is generated.