Field Level Security

(0) Share

Report

Posted on by Katie Pieczynski

3,225

Hello I am trying to set a security to disable or lockdown the "drop ship item" box in the sales transaction window. We do not do drop ships but sometimes the box will accidently get checked and then we end up invoicing them for it but it did not show up on the picking ticket so it was not shipped. I have tried to create it but I am not sure what field I should use. I tried to create the security using the (L)drop ship field under sales transaction entry. Can someone tell me what field to use?

Thank you,

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Philippe Simoes 380 on at

Like (0)

Report
Copy link

Link copied!
Hi Katie,

I could not find the field in FLS either. If nobody else can point out the field in FLS, there is another way if you have GP2010 or older. You could use the following VBA workaround to prevent users from checking the DropShip :

Open any document in the Sales Transaction Entry window

If your sales Transaction Entry window was never modified, press Ctrl+F11 to add it to VB

Press Shift+F11 to add fields to VB

Click on the DropShip Checkbox to add it to VB

Press Shift+F11 to stop adding fields to VB

Press Alt+F11 to open the VBA editor

In the "SalesTransactionEntryDetail (Grid)" project add the following VBA code :

Private Sub Dropship_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As Boolean)

If Dropship.Value = 1 Then Dropship.Value = 0

End Sub

Your SOP Entry window will be modified, users will need to get access to the modified version if they are not using it already (Alternate/Modified Forms...) .

Once this is done, if a user checks the DropShip box it will automatically uncheck itself.

Regards,

Philippe

Was this reply helpful? Yes No
Suggested answer

Congruent Dynamics 735 on at

Like (0)

Report
Copy link

Link copied!

Hi Katie,

By using the Field Level Security you can set the password for the "Drop Ship field". suppose the check box will accidentally marked the popup window will be opened. You must enter the correct password otherwise the check box will not marked.

By using VBA the above suggestions are better.

Was this reply helpful? Yes No
Philippe Simoes 380 on at

Like (0)

Report
Copy link

Link copied!

I was unable to disable the field, but as Congruent Dynamics suggested, the password on that field will work.

One thing I'd like to point out is that, in my case, I am using a third party window (Ethoseries) and when I try to apply FLS on (L)DropShip, it doesn't work if I choose the product name "Ethoseries". However, it will work if I select the product name "Microsoft Dynamics GP" even if in my "Alternate/Modified forms and reports" I have the Ethoseries window selected to be used.

Was this reply helpful? Yes No