Microsoft has made a lot of improvements for Dynamics GP Management Reporter, however it can still be difficult to achieve what seems like a simple result.
Always a hot topic with lots of quirks: Dynamics GP: Currency Translation and Management Reporter