Hello, Anyone can point me how to get GST/HST and PST from invoice in saved search in currency of transaction? I am able to the amoun in USD, but the transaction is in Canadian $ and cannot seems to find field that gives me the Tax Values in CAD, I am able to get transaction amount ( net of tax ) in CAD
l
Luis
10/29/2024, 8:56 PM
Maybe divide that USD amount by the forex rate
a
Amit Gupta
10/29/2024, 8:56 PM
Luis: I thought about that, exchange rate does not give me the rate, wondering what is the field to get exchange rate in system
Amit Gupta
10/29/2024, 9:02 PM
Never mind, I think I can get exchange rate by calculating it myself.
Amit Gupta
10/29/2024, 9:02 PM
I have USD amount and CAD amount, that gives me exchange rate and then I can ccalculate the CAD TX
Amit Gupta
10/29/2024, 9:02 PM
thanks!
c
C_Billings
10/30/2024, 11:32 PM
you should have line level exchange rates but it will only be against your base sub currency.