Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FR reports in different currency

Status
Not open for further replies.

Boris10

IS-IT--Management
Jan 26, 2012
97
KE
Hi,

How can you create any FR report based on a specified currency. The problem is in allowing the user to input the exchange. I am thinking of using a form to do so. Thus, the user is promted to enter the rate and the FR (e.g. Balance Sheet report) is produced with that specified currency.

I tried creting excel forms, however, the xlsm format is not supported by the Financial reporter. How else can i do this.
 
The user _shouldn't_ be allowed to input the exchange rate, that's not how multicurrency accounting works. But if you really want to, just add a cell with a constant, then divide or multiply all the other FR cells by it. Or, multiple by the FRRATE function.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top