Get Currency Rate in Report writing

02-02-10, 04:08 AM

Ringo

Hi All

I am a beginner in NAV. Have somebody can tell me how to get a currency rate
in report writing?

02-02-10, 07:07 PM

Savatage

You need to provide more details than that.

What have you tried? Where is the rate # you want? What report do you want
it on.

etc etc.

02-03-10, 03:49 AM

Ringo

eg.

I write the report to use sales invoice line to get data with posting date,
currency and Amount. eg. 1st line is 2 Dec 2009, YEN $2000 , 2nd line is 2
Feb 2010, YEN $2000

The rate is US for YEN from 1 Dec to 31 Dec = 97.276265, AND 1 Jan to Now =
90.9090

How can I change currency to US?

Thanks

"Savatage" wrote:
[..]

02-12-10, 11:58 AM

Nilesh Shelar

Hi,
Currency exchange rate work on posting date. It will check posting date of
invoice and apply factor to amount.
In sales invoice line "Amount" and "Amount $" columns are present, you can
use that for report.

"Ringo" wrote:
[..]

Similar Threads
Changing Base Currency And Tax Rate I want to use Accounting Profesional 2008 In Spain. My problem is that all of my customers are English but all transactions are done in Euros. Is it possible to have the UK...
FRX Multi Currency - Historical Rate in FRX Currency Translation R Is there any work around when FRX DAX is not working as it is used to work with FRX Currency Translation Reporting? When using more than one data/record in DAX Table in one...
Currency Rate Hi I have table called Curr_table and the fields are Curr_code , and the items under that (USD /GBP/EUR) Curr_rate , and the rates (0.295 /0.595 /0/335) and another table...
How to record a currency exchange rate in a trend/report? Hello! I'm using Money 2004 and got a simple one here. How can I record/monitor the exchange rate of different currencies? In fact I want to compare USD with EURO and their...
Currency Rate Hello All, I am writing a script than connects to my database and pulls prices in pounds, does anyone know how I can get the current exchange rate so I can have a dual...