By using this website, you agree to our Terms of Use (click here)
Hey Guys,
Long time lurker, you have all helped me immeasurably so thank you all for your unknowing help so far 😀
However this one I could not find an answer for.
What I am trying to do is provide a report for my staff which lists all of our incoming stock landing in to our separate warehouses along with the promised date.
However due to security concerns we have had to restrict general staff from accessing some suppliers as well as other warehouses via Row Level Security.
I have managed to generate a Generic Inquiry that will show stock landing in to the separate warehouses but I have not found a solution for adding in the Promised Date. From what I can tell this information is only stored in the POLine table. I can see the promised dates but the staff can not.
Does anyone have any ideas on how (if) I can get around this?
I solved the warehouse problem by using the INSITESTATUS table as opposed to the POLINE table.
Thanks heaps.
Steve
Hi @stevem79,
Long time lurkers welcome 🙂
The problem is that the Row Level Security is associated with the Data Access Class (DAC). That's why it kicks in even when you drop the DAC on a Generic Inquiry or Report.
The "easiest" way that I know of to get around this at this point is to create a SQL View and link the SQL View to a custom DAC.
You can follow the steps in this post to see how to create a SQL View and link it to a custom DAC:
OK thanks for that Tim. Unfortunately that is a little beyond my ability/what I am comfortable changing in our system. I will point our consulting team to the article though.
Thanks heaps
Steve