Does anyone know if there is an equivalent function in the report designer to the @Me function in generic inquiries? I need to restrict salespeople/ users so they only see their sales information.
thanks !
Answer
@Me function in Report Designer
Best answer by vkumar
Hi
You can use ‘AccessInfo’ DAC ( the values in this table are dynamically generated, no permanent data exists in this DAC/table ), and an expression : =Report.GetDefUI('RowAccessInfo.UserName') to fetch the logged on user name (login name).
I have added this column on an AR Invoice report to test and here are relevant screenshots :
Added the DAC on schema builder
Added the UserName field
Hope this helps.
Regards,
+19Hi
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Hi Naveen ,
Thanks for the response. I am able to use the @Me in the generic inquiry. My problem is that i need to use the same function in report design but it doesn’t work in the report designer. So , i am looking for something that will work the same. So i can restrict the current user.
+19.
+19
hope this helps!
Hi
You can use ‘AccessInfo’ DAC ( the values in this table are dynamically generated, no permanent data exists in this DAC/table ), and an expression : =Report.GetDefUI('RowAccessInfo.UserName') to fetch the logged on user name (login name).
I have added this column on an AR Invoice report to test and here are relevant screenshots :
Added the DAC on schema builder
Added the UserName field
Hope this helps.
Regards,
VijayKumarU
thanks vkumar,
That is what i am looking for, but when i put it in my report i get an error Invalid object name 'AccessInfo'. i tried joining using the below two options
Hi
You are right. No need to join, it can be just added to list of selected DACs.
Regards,
Team,
I have a requirement for the report, where I need to obtain the code of the logged user and print it.
Could you please assist with this
Regards
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.