How to access multiple company data in one company for Report

(0) Share

Report

Posted on by NeoMatrix

240

Hi All,

In NAV 2018 there is satandard table "G/L Entry" [17]. I want to create Reprot on that table. But issue is that In my database there are three Companies [ie. A,B,C]. So while Run Reprot I want to access A,B,C comapny Data.

So How can access the data In Multiple company data in One Report.

Thanks in Advance.

Categories:

Development / Customization / SDK

All responses (4)

Answers (1)

NeoMatrix 240 on at

Like (0)

Report

RE: How to access multiple company data in one company for Report

Here is the Link

dynamicsuser.net/.../how-to-display-an-sql-server-view-in-microsoft-dynamics-nav
jsshivalik 3,027 on at

Like (0)

Report

RE: How to access multiple company data in one company for Report

Hi NeoMatix

Can u pls tell how u have attached view .

Thanks
NeoMatrix 240 on at

Like (0)

Report

RE: How to access multiple company data in one company for Report

Thanks for the Reply. I will Try this Function. but I have found another way that is I Create View "G/L Entry" with alm company in SQL Server Database that View is Attached in NAV Table. using that table I am bulid Report.
Verified answer

TeddyH 12,861 Moderator on at

Like (2)

Report

RE: How to access multiple company data in one company for Report

There is a function called changecompany.

docs.microsoft.com/.../changecompany-function--record-