Currency Conversion For ERP.GLJrnDtl

Hello,

I am trying to create a BAQ that replicates Chart tracker but my numbers are off due to currency conversion. What is the best way to link the currency exchange rate table to ERP.GLJrnDtl. Or is there a another method, I should use?
Thank you in advance.

It is good to use the columns below for the amount as they have Book and Transaction currency data.