Issues Printing FX Rates To Dashboard

Kinetic ERP
1

Hello Epicor Community!

I am trying to add the FX rates to a dashboard for my accounting team, however it does not have a DB field. When I use the CurrExRate table’s CurrentRate field this does not match the Exchange Rate Entry field. Does anyone have any clever tricks for being able to query one of these fields in a BAQ?

Thanks!

Screenshot 2024-04-12 090039
Screenshot 2024-04-12 090039775×339 14.7 KB

2

You need to bring in the ScaleFactor from the Currency table. So join CurrExRate with Currency. You can find all the details in the Field Level Help.

image