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 Chriss Miller 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
Joined
Jan 26, 2012
Messages
97
Location
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.
 
Thanx man got it sorted..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top