How to access data from another company while logging in?

kashyap_thaker

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.

kriki

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 put

CHANGECOMPANY('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 CHANGECOMPANY

kashyap_thaker

Thanks for the solution it worked