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
Hi Stefano
Can u pls help with some code
Thanks
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,275 Most Valuable Professional
nmaenpaa 101,156