Announcements
No record found.
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
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.
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.
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.
Can u pls help with some code
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
