Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Data from 2 companies

Posted on by 3,027

Hi

   I have 2 Companies . In a report request page dropdown variable i want to display distinct G/L Accounts from G/L Account table of 2 companies .

Thanks

*This post is locked for comments

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Data from 2 companies

    Hi Stefano

        Can u pls help with some code

    Thanks

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,160 Most Valuable Professional on at
    RE: Data from 2 companies

    In the OnLookup trigger of your field added in the request page, you could load a temporary table (based on G/L Account table) where you load the G/L Accounts from the 2 companies and then you can display the G/L Account List page where SourceTableView is your temporary table.

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Data from 2 companies

    Hi Stefano

      That's o.k . But i want to display on a request page so that user can select any G/L account. How i can show them and on which trigger data has to be stored in some variable or file.

    Thanks

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,160 Most Valuable Professional on at
    RE: Data from 2 companies

    You need to create a custom report that reads G/L Accounts from 2 companies. You can do that by using the CHANGECOMPANY C/AL command.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans