Retrieving Data from Navision
tfranzen
Member Posts: 25
Hi!
I have the challenge to retrieve data from about 30 different companies (one NAV-Database) and to validate data into NAV at runtime. The external application knows which company to use but I have no idea how to tell NAV to change into the appropiate company when validating the data. Has anyone a good idea?
Thomas
I have the challenge to retrieve data from about 30 different companies (one NAV-Database) and to validate data into NAV at runtime. The external application knows which company to use but I have no idea how to tell NAV to change into the appropiate company when validating the data. Has anyone a good idea?
Thomas
0
Comments
-
Hi,
which application should validate the data, NAV or the external?
If its Navision just use the changecompany method...
Greetings0 -
What method are you using?
Changecompany it is tricky because validate trigger happens in current company.0 -
Changecompany is not a good idea if the validate code uses other tables they happen in the unchanged company (as nunomaia said).
Depending on what you want achieve you could write the data into import tables in every company. Changecompany works fine here. After importing you can use another process (ExpandIT LaunchUtility for example) to start the posting or whatever in each respective company.
Hope this helps
Thomas0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 250 Dynamics CRM
- 102 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions