Hi,
I have a lof of companies in one installation and I’m looking to solution for my problem.
I created custom menu on a frame which start quick report. And the question is: It is possible that in the company_id parameter aytomatically includes the company which I’m logged in.
Hello
You need to combine report with user_finance view. In where clause you can add following syntax. This will only show result for the companies connected to user who is running the report
WHERE COMPANY IN (SELECT COMPANY FROM USER_FINANCE WHERE USERID = IFSAPP.FND_SESSION_API.GET_FND_USER())Hope this helps
Thanks a lof but i need to show only for this one which I’m logged in.
Hello again
I got your question wrongly. Global company parameter is set on the instance (application level), you won’t have that information in DB. Therefore I don’t think that you could have as a parameter in the query of the report.
I am not aware of any function to pass the global company value to a quick report. May be
Hope this helps
+20
Hi
You can use USER_FINANCE_API.GET_DEFAULT_COMPANY_FUNC() to get the default company of the logged in user. Similarly, you can get the user default site by USER_ALLOWED_SITE_API.GET_DEFAULT_SITE()
Hope it helps!
Damith
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.