Share
ReportHi
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’re offline. This is a read only version of the page.
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
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.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (