How to access data from another company while logging in?

kashyap_thaker
Member Posts: 13
Hi all,
The client has a typical requirement.
Client has one database with 5 different companies, one of the company among this is a Consolidated company for all the companies. The consolidated company has no Customers, Vendors in it but when user logs in he/she should be able to see customers and vendors as well as other data from another company in the consolidated company, Is it possible in Navision. If yes please let me know the procedure how.
Thanks in advance.
The client has a typical requirement.
Client has one database with 5 different companies, one of the company among this is a Consolidated company for all the companies. The consolidated company has no Customers, Vendors in it but when user logs in he/she should be able to see customers and vendors as well as other data from another company in the consolidated company, Is it possible in Navision. If yes please let me know the procedure how.
Thanks in advance.
0
Comments
-
The tables have a property "DataPerCompany". If you put this to Yes, this table is the same for ALL companies.
If this is not possible, in the "OnInit"-trigger of the forms, you can putCHANGECOMPANY('Some Other Company');
IMPORTANT: if the user changes the record with the CHANGECOMPANY to another company and in the table-triggers are referenced other records (for testing, updating something), these other records STILL POINT TO THE CURRENT COMPANY AND NOT TO THE COMPANY OF THE CHANGECOMPANYRegards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Thanks for the solution it worked0
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