SBX - Search With Button

SBX - Forum Post Title

How to access multiple company data in one company for Report

Microsoft Dynamics NAV Forum

NeoMatrix asked a question on 14 Jun 2019 12:20 AM

Question Status

Verified

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.

Reply
Teddy Herryanto responded on 16 Jun 2019 5:36 AM
My Badges
Verified Answer

There is a function called changecompany.

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

Reply
NeoMatrix responded on 17 Jun 2019 1:01 AM

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.

Reply
jsshivalik responded on 18 Jun 2019 12:07 AM
My Badges

Hi NeoMatix

   Can u pls tell how u have attached view . 

Thanks

Reply
Teddy Herryanto responded on 16 Jun 2019 5:36 AM
My Badges
Verified Answer

There is a function called changecompany.

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

Reply

SBX - Two Col Forum

SBX - Migrated JS