regarding report in standard navision

nagendra_varma

hi all


I am new to navision .
I do have a small issue in report
In sales register we get complete amount in both local and other country currency
but
currency which is of other country should be converted in local currency and should be showing in report

do i hav to write any code or else any way to solve it?




regards
varma

Chinmoy

Which report Id? Also, if you are reading the amount from G/L Entry for a posted sales invoice the amount is already converted into LCY. Do you need to report in both LCY and FCY - in this case you can activate the additional currency and NAV will store the amounts in both LCY and FCY in the G/L Entry table.

Chn

nagendra_varma

hi cnn



report number 50048

see i net both amount domestic and foregin but at the same time i need foregin amount to be converted to domestic amount and should be desplayed

Chinmoy

In that case both amounts will be same isn't it?
I mean what I understand is the report columns are something like this:

Inv No. Amount (FCY) Amount (LCY) Currency
0001 1000.00 54000.00 USD
0002 1000.00 70000.00 EUR

If FCY is converted to LCY then the report will look like:


Inv No. Amount (FCY) Amount (LCY) Currency
0001 54000.00 54000.00 USD
0002 70000.00 70000.00 EUR

Did I get something wrong here?

Chn

nagendra_varma

see

inv no 001 100INR FOR Domestic
inv no 002 100$ for foregn this particular USD amount ashould be converted to INR and desplayed in the report beside USD AMount
like 100$ 10000INR INV no

faizguy84

nagendra varma wrote:

see

inv no 001 100INR FOR Domestic
inv no 002 100$ for foregn this particular USD amount ashould be converted to INR and desplayed in the report beside USD AMount
like 100$ 10000INR INV no

Which Table is used in your report. Is it customer ledger entry or GL entry.
Customer ledger entry has two fields Amount and Amount(LCY) as per ur example, Amount will 100 and Amount (lcy) 1000 (Assuming INR is local )
GL entry amount will always be in LCY so it will show 1000.

Regards,
Faisal Bukhari

udayrmer

Hi,

If your report is customized then you have to write code, other wise you can take reference of standard report, which have option like "Show amount in LCY" eg. report 105, 106 (Customer Summary aging /Detailed Aging)

mohana_cse06

nagendra varma wrote:

report number 50048

How can you say this report as standard report?