Multiple companies

BVG

Hello All,

I have a typical requirement regarding multiple companies, the database have five companies, the user needs that while generating the reports the system should give an option list that from which companies the data needs to be used, it can be one, two , three or all. The report should include the data from the selected companies.

Is it possible to this in Navision. Has anyone tried this before?

Thanks a lot!!

BVG

tinoruijs

If your looking for a report on financial data, maybe the consolidation-functionality is what you are looking for.
You'll find it in Financial management, General ledger, Periodic activities, consolidation.
For more information about consolidation, take a look in help (F1).

Joeri

I would also recommend using one consilidation company. But if this isn't an option you can create code that can select the necessary data.

You have a table called "Company", in which all the companies are stored. A user could select from the request form a company. Then you have to use the <Rec>.CHANGECOMPANY(CompanyName) to set the record to look at the correct company.

Keep in mind that you have to use the CHANGECOMPANY function per record you want to look in a different company. So if you have an Item record and Customer record and want data from a different company for both records, you need to use CHANGECOMPANY on both records.

BVG

Thanks a lot.

This information would be very helpful.