Foreign Curreny Balance

shahidt
Member Posts: 61
I want to use a GL Account as a Foreign Currency Account, where I want to deposit some amount in Dollars and pay for certain indirect expenses using the same. The basic idea is to know how much dollars do I have in my Cash box. Going further this needs to support other currencies as well, preferably in the same GL.
What is the best way in which I can do this. In our test environment I tried passing a Cash Payment Voucher using USD in th currency code. However, the transaction in the Chart of Accounts shows in LCY, and the Foreign Currency Balance report does not show any transaction. Is there anything addition I need to do to make this work?
What is the best way in which I can do this. In our test environment I tried passing a Cash Payment Voucher using USD in th currency code. However, the transaction in the Chart of Accounts shows in LCY, and the Foreign Currency Balance report does not show any transaction. Is there anything addition I need to do to make this work?
0
Comments
-
Hello shahidt,
NAV standard functionality has bank accounts which can be held in a different currency. The bank account card shows the balance in FCY, too. However this is only valid for one currency. if you post multiple currencies on the same bank account, this field won't show anything useful.
The GL account itself cannot hold the FCY balance, though. At least not without adding code. If you only want to use it for payments in FCY I would recommend to go with the bank account functionality.
with best regards
Jens0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions