In NAV 2018 there is satandard table "G/L Entry" . 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.
There is a function called changecompany.
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.
Can u pls tell how u have attached view .
Here is the Link
Business Applications communities