mibuso.com

Microsoft Business Solutions online community
It is currently Sun May 19, 2013 3:31 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: regarding report in standard navision
PostPosted: Wed Jun 13, 2012 11:30 am 
Offline

Joined: Wed Jan 11, 2012 10:37 am
Posts: 8
Country: India (in)
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


Top
 Profile E-mail  
 
 Post subject: Re: regarding report in standard navision
PostPosted: Wed Jun 13, 2012 11:48 am 
Offline

Joined: Wed Apr 07, 2004 9:39 am
Posts: 338
Location: Bangalore
Country: India (in)
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


Top
 Profile E-mail WWW  
 
 Post subject: Re: regarding report in standard navision
PostPosted: Wed Jun 13, 2012 11:55 am 
Offline

Joined: Wed Jan 11, 2012 10:37 am
Posts: 8
Country: India (in)
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


Top
 Profile E-mail  
 
 Post subject: Re: regarding report in standard navision
PostPosted: Wed Jun 13, 2012 12:03 pm 
Offline

Joined: Wed Apr 07, 2004 9:39 am
Posts: 338
Location: Bangalore
Country: India (in)
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


Top
 Profile E-mail WWW  
 
 Post subject: Re: regarding report in standard navision
PostPosted: Wed Jun 13, 2012 1:13 pm 
Offline

Joined: Wed Jan 11, 2012 10:37 am
Posts: 8
Country: India (in)
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


Top
 Profile E-mail  
 
 Post subject: Re: regarding report in standard navision
PostPosted: Wed Jun 13, 2012 1:49 pm 
Offline

Joined: Fri Sep 25, 2009 6:33 am
Posts: 48
Location: Mumbai, India
Country: India (in)
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


Top
 Profile E-mail  
 
 Post subject: Re: regarding report in standard navision
PostPosted: Tue Jun 19, 2012 7:58 am 
Offline

Joined: Sat Aug 08, 2009 6:28 am
Posts: 158
Location: gujarat
Country: India (in)
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)

_________________
Uday Mer | MS Dynamics NAV Techno-Functional Consultant


Top
 Profile E-mail  
 
 Post subject: Re: regarding report in standard navision
PostPosted: Tue Jun 19, 2012 10:20 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4224
Location: New Delhi
Country: India (in)
nagendra varma wrote:
report number 50048

How can you say this report as standard report?

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Exabot [Bot], Google [Bot] and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: