Multicompany Data Upload using Dataport
nav_126
Member Posts: 77
Dear All,
I have a created 3 companies in my database i.e. A,B and C. Now, I have created a dataport which imports some data from a file to Item table.
Now, my query is that if I have opened company A and I run that dataport then is it possible that system import the same data in company B also (at the same time). I do not want to open company B and do the same process again.
Is it possible?
Regards
Navision Developer
I have a created 3 companies in my database i.e. A,B and C. Now, I have created a dataport which imports some data from a file to Item table.
Now, my query is that if I have opened company A and I run that dataport then is it possible that system import the same data in company B also (at the same time). I do not want to open company B and do the same process again.
Is it possible?
Regards
Navision Developer
0
Comments
-
hi
use table property "data per company"
Ashish Gupta
SS Dynamics Solutions Pvt. Ltd.Ashish Gupta
Navision Technical Consultant0 -
use table property data per company
lokesh
ind synergy0 -
lokesh_jan wrote:use table property data per companyAshish Gupta wrote:use table property "data per company"
Please don't. Yes, this is a possible solution. It will cause more pain than it is worth. Search the forum about it and you'll find more of the same. You'll want to add a little bit of code to your dataport involving the CHANGECOMPANY method. You'll also find posts on it and exactly how it is used here in the forums. Also search the help from the NAV Client.0 -
use table property data per company

Follow the solution proposed by matttrax.
My personal opinion is that while you should investigate the CHANGECOMPANY in order to see the possibilities (..and possible pitfalls), the best solution is to run the import for each company in order to follow all system checks. Especially if you are planning to do the same with more than one table.0
Categories
- All Categories
- 73 General
- 73 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 333 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
