Unable to upload multi-currency transactions into Projects via Web ADI

Hi all-

We need to be able to upload multi-currency transactions into Projects via Web ADI. The problem we keep running into is that even though we're a multi-currency company, with daily rates populated through the entire year, we're forced to calculate everything manually before the upload.

I have created a Projects Integrator that includes Transaction Currency and Transaction Raw Cost. I can't add Rate Type anywhere to the ADI. I manually added Functional Exchange Rate instead, which is less than ideal, but it could work.

The bigger problem is that Functional Raw Cost is a required field. So I have to manually calculate the Functional Raw Cost of every foreign currency transaction.