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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FR Report producing source and functional currency

Status
Not open for further replies.

francis2299

Programmer
Oct 7, 2014
59
TZ
Hi All,

I created an FR report financial statements which produces local currency as well as USD currency. The problem is if the source currency is local in the USD side it produces zero! I expected the system to use the rate in the system to bring the USD equivalent! Is there something I did wrong? I used the fomula below:

"BALYTD","","","USD.S"

Sample Trial balance
LOCAL USD
8160 Depreciation 1,981,500.00 0.00

Your help is highly appreciated.
Regards,
Francis
 
Nope, if the original transaction was in local currency then that is what you will get.
If you want to report in a different currency then you need to do the calculation yourself. You can look at FRRATE as well.

Sage 300 Certified Consultant
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top