Anyone know how to get an accurate tax amount on a...
# generalp
PaulJ
05/01/2019, 11:19 PMAnyone know how to get an accurate tax amount on a foreign currency transaction in a saved search?
Value must be in search results in the foreign currency. I’m finding that base amount * exchange rate is subject to rounding errors. For example, 1000 INR vs an exchange rate of 0.143608 results in $14.36 USD in primary book, which then converts back vs the same exchange rate to 999.94. Any other tricks?
PaulJ
05/02/2019, 1:31 AMThinking more on this it makes sense that tax amount would only show in base currency (because why would you ever report on taxes collected not in base currency?)...but it’s definitely a requirement to report on it in foreign currency and I just may be stuck with the rounding error....
r
rustyshackles
05/02/2019, 1:49 AMisn't there an Tax (Foreign) field? I know there is an Amount (Foreign) field which is the value of the amount in the foreign currency.
p
PaulJ
05/03/2019, 12:38 AMMy solution so far is to set main line to false and use the amount(foreign) on the tax line and then use some formula trickery to add a ‘tax column’ and ‘amount column’. But I’d take any other ideas if there are any...
2 Views