Does anyone know how to query from a custom-made crystal report the company ID (current company) in which the user is registered after login in EPICOR? The menu item that we add in the E10 menu links to a single rpt which in turn points to the same ODBC regardless of the company to which the user i…

IF the user is only related to only one company then you could get their current userID from windows, use that to query the UserFile table and then link back to the User in the CompanyList field

Jose, thank you for your response. Well, it could be more than one company that the user is authorized to use, so eventually he or she has to be prompted to pick one, but only for those companies the user is entitled to use. But looking at the UserFile you mentioned, now I see that there is a colum…

You can link them in user file. Link the windows and the user ID

The best way to handle this would be to create an external datasource link and external BAQ linking to a view in the target database, which should allow for filtering on current company. If this is not possible in your version of Epicor, the way I might handle this problem would be to create an opt…

@Daniel In User Account Maintenance in Epicor you can set the Domain / Windows User ID and Link it to the Epicor account [image] Then you should be able to pretty easily look up the current user in windows and figure out which user they are in Epicor. Now if you are using a “Shared” Computer whe…

@josecgomez.trigemco There is no problem in doing the link (most users have the ID on that field. The problem is that I need to know the Windows User ID when running the CR and match it with the field “Domain User ID”. So far, I have tried a bunch of functions / formulas but the don’t work.

Create a connection to NT Current Event Log [image] Use [LOCAL] For the source computer , pick Application [image] Then Filter the User Type / Domain and you should have it.

I’ve only followed this topic on my phone in between vape breaks so forgive me if this less than helpful, but if you are calling report from code you could use this to get that data and potentially pass a parameter: Use the System.Security.Principal.WindowsIdentity class. Then to get the informa…

It’s s link from the epicor menu (no code)

I am just a script kiddie - but I would suggest starting with a BAQ Report - only include the Company table and you will then have the Company and UserID and anything else you want. Then in Crystal you will have the BAQ Report XML that has your user context i.e. Name, company, Plant, etc. and then …

Passing current Company ID to Crystal Report

Epicor ERP 10

Topic		Replies	Views
Crystal Reports Epicor ERP 10 crystal , report , crystal-report-probl	57	3573	January 6, 2020
Pass Current CompanyID into SSRS Epicor ERP 10	0	721	January 16, 2017
New data coming from MES into an SSRS report Epicor ERP 10 ssrs	3	644	July 18, 2019
Printing UserID on SSRS reports Epicor ERP 10 ssrs	14	5533	August 31, 2020
Current logged in user & company in Vantage Yahoo Archive	1	387	January 13, 2008

Passing current Company ID to Crystal Report

Related topics