Is there a report that shows the currency rate used in a transaction? If not can QBO please allow this filed to be available from the database please?

Hello there, @finance186.

Yes, you're right. When running a report, it'll show the transactions with home currency. What we can do is run a Transactions Detail by Account. It'll enable the Currency column and remove the customers or vendors who were using a home currency.

Here's how: 

1. Go to the Reports menu.
2. In the search bar, type Transactions Detail by Account.
3. Click the Customise button.
4. Expand the Rows/Columns section, then click the Change columns link.
   
   
5. Check Currency.
6. Go to the Filters section.
7. Check either Vendors or Customers. Then, select the profiles you want to show the report. 
8. Hit Run report.
   
   

I have some additional articles about managing a wide range of reports in QuickBooks:

• Run reports
• Memorise reports
• Customise reports

Let me know if you have other questions about running reports in QuickBooks. I'm always here to help. Take care.