Hi,
May I know how to lock the unit price for the selected users in Order Entry screen?
I tried it in the Field Security Maintenace screen as below, but no changes happen. the field is still enabled. Is there any other way?
@anon51084001, Try Changing access for UnitPrice, DocInUnitPrice, and DocUnitPrice field in Field Security Maintenance.
Hi,
I change the access for UnitPrice, DocInUnitPrice, and DocUnitPrice to None. the unit price is still enable.
the field you able to see on form is “DocDspUnitPrice” and this is not available in db, so based my knowledge field security will not work on this situation. use service security method for “ChangeUnitPrice”
create BPM - method directives maintenance?
Use Extended properties to make the respective field read only.
I did something similar on OrderHed table. I stopped sales user to reopen order once it is shipped/invoiced.
In your case maybe you can use if DocDspUnitPrice <> 0 and use this condition in data directive, that might help!
You might need to create a security user group and give access to users as required.
Can this be locked to certain groups? Having a big issue with this one. The company wants it locked down but the Sales Group needs to enter prices from time to time.
Yes you can lock it for certain groups. You can keep on adding condition under the same widget.
If you’d prefer, you can do this with a Kinetic Customization (App Studio).
Add “UserFile” as a Dataview (so you can reference the User’s GroupList).
Create an Event (After Form_OnLoad) Rest-ERP to populate the dataview where dcdUserID = CallContextClientData.CurrentUserId
Then use row rules to control the state of the DocDspUnitPrice if the user is not in a specific Group.
1 Like