Keeping with his recent purchasing theme, checkout this SQL View To Return Purchasing Transactions With Multicurrency from Ian Grieve
SQL View To Return Purchasing Transactions With Multicurrency | azurecurve
SQL & DataSales, Purchasing & InventoryGeneral Ledger & Financials
Archived post from 2015. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.