I am trying to put the routing to Read-only so that user cannot disable or enable routing on their own. I used the Application Studio and was able to set the field to read-only and saved the layer BUT the screen does not exist in any Menu…so does anyone know how to set the layers over to overwrite the custom one?
To get the Print Inventory Movement Report Screen it will be Receipt Entry > Details > Overflow icon > Print Inventory Movement Report
There is Application Studio in here to make the changes but I have no idea how to set it. Usually I would go to Menu Maintennce and set at the Kinetic Custimzation field but this isn’t a Menu…anyone got any idea on this?
It’s kinda stupid what you have to do, buuuut you’ll need to deployed the report to the menu with your layer selected, create your own button in Receipt Entry, hide/delete the old button, replicate their event and call your added menu path.
I figured out a simpler way for this instead. First I set a default report that all user can print. Then I set the routing that checks who is the user printing the report and if its certain user than it will print the alternate report.
For the alternate report I set the report to hidden so it won’t appear in the dropdown list at all so users can’t pick it.
To add on a bit on why I needed this is basically down to not allowing User to view cost as only certain power users are allowed to print those reports with the cost fields.
And so far as I know there is no security for SSRS report listing to certain security groups so a workaround was needed to fulfill both groups that is allowed/not allowed to print cost report.
In this case the all users knows how to open the drop-down list so I needed a way to stop the users that do not have permission to view cost from printing the reports WITH the cost fields inside.
This is a more generic problem outlined in a few Epicor Ideas. We currently don’t have the ability to mask other data types besides character fields, which would include costs. Masking would reduce a lot required customizations.
Just to update you all as well as to put here as a reference to myself, I found a way to force the routing logic to be enabled I noticed that the ttSysTaskParam.ParamName in the SQL database has a value called SSRSEnableRouting and another field ttSysTaskParam.ParamLogical = 1when I was printing a report with routing enabled.
So in the BPM for SysTaskParam table, I set it to check for the SSRSEnableRouting and to force it to set the field ttSysTaskParam.ParamLogical to true everytime it print. After testing it works even if I uncheck the routing in the print report. As for reports without routing there was no error appearing when I try to print and it prints out fine.
Whether this would slow down printing though as it has to continuous set field in printing I’m not certain though but its nice that I found another way. The below is the image in the sql db for reference. The ParamLogical value is 1 when routing is enabled and 0 when it is not.
