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!

Currency Translation in Financial Reporter

Status
Not open for further replies.

johnhugh

Technical User
Mar 24, 2010
702
SG
Hello,

In Accpac 5.6, is it possible to write a FR report which translates from my functional currency USD to ZMK?
In the manual, I've found the FRRATE option which seems to let me get the exchange rate which I can then multiply by the cell with the USD value (F10)
=(F10*FRRATE(ʺUSDʺ,ʺJPNʺ,ʺAVʺ,DATEVALUE(FR(ʺENDʺ)))) 

Is this how it's done?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top