David Robertson
Reputable Poster
I've written a process to import currency rates into JDE from an external service.
I'm using the rates along with the supplied closing date as the effective date into JDE.
Is this correct? This mean basically that there is never a "current" rate, the best at any given time is "yesterdays rate".
Not a huge issue, but causes some inconsistency with back dated month end adjustments for example, using a different rate than transactions entered on the actual day.
(i.e Transactions entered on 30/06/2015 would use the rate for 29/06/2015, transactions entered later as 30/06/2015 would use the rate for 30/06/2015)
Should I instead be using the closing date +1?
Transactions on a given day would actually still use the same actual rate, but backdated transactions to that date would use the same rate = consistency!
I'm using the rates along with the supplied closing date as the effective date into JDE.
Is this correct? This mean basically that there is never a "current" rate, the best at any given time is "yesterdays rate".
Not a huge issue, but causes some inconsistency with back dated month end adjustments for example, using a different rate than transactions entered on the actual day.
(i.e Transactions entered on 30/06/2015 would use the rate for 29/06/2015, transactions entered later as 30/06/2015 would use the rate for 30/06/2015)
Should I instead be using the closing date +1?
Transactions on a given day would actually still use the same actual rate, but backdated transactions to that date would use the same rate = consistency!