Exchange Rate

Ricky
Member Posts: 4
hey guys, today i have come across with a problem and i just can't find the answer. If you create multiple companies in the same database is it possible if you make a change to the exchange rate amount column and in the adjustment exch. Rate adjustments the rest of the companies to be affected by this change :?:Hope you were able to understand what kind of problem i am facing.
I would really appreciate it if you could help me....
I would really appreciate it if you could help me....

0
Comments
-
Hmm.. If I understand correctly what you want to do is make it so that you only maintain exch.rates in one company and then it will automagically correct the exch. rates in all the rest of the companies....
As I see it you have two options. You could make it so that your currency-table and the associated tables are made to be the same across companies... This is done by setting the property DataPerCompany to NO on the tables that you want to be identical. Be aware that you should use caution when doing this. It is important to maintain consistancy between the tables that you want to alter in this fashion.
Option no. 2 is to create a function that synchronizes the data in all existing companies in the curr. exch. rate table. This can be done via the CHANGECOMPANY-function.
Good luckBest regards
Tommy0 -
DataPerCompany=No should solve your problem.®obi
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯0
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