Each individual country enters data in their local currencies. However, for the reporting in USD, it is to be done at Region level only. There is no need for Country level. Right now, I managed to convert at Country level (REP05) and the Region data will automatically be rolled up.
If I do not want to store converted data at Country level and I would just want to report in USD at Region level, how can this be done?
if you are trying to save space, you can't here. your FX is at the country level, so you have to calculate at the lowest level. What you could do is calculate it in a module without summary, so only G3 counts, and then SUM it up to a module that has just G1, but I don't recommend it as you are just reproducing what the auto summary is doing. Only if you are very hungry for space