Dynamics Community Forum Thread Details

Modifier GP 2010 - GL Transaction Entry

I would like to set the description field on the Scrolling window:Transaction_Scroll in the GL Transaction Entry Window to be a required field. I have set the properties to Required = True however it is not being enforced during data entry. The modified form has been selected. Is it possible to make this field required given that it is in a scrolling window?

Any guidance appreciated.

David

David,

I doubt in this particular case only by setting the field property to Required = True might not help you.

In GL Transaction Entry window scrolling window change event GP is not validating for required fields, instead they are specifically validating for Account Number and Debit/Credit amount is empty or not and that is the reason even if you change the property to true it is not being enforced. These are specific to each windows and not common to scrolling windows. Example: if you try to set a new field required in Purchase Order Entry scrolling window , it will work the way you want.

So I would suggest you either write a small customization through Dex or VBA to validate the description field is empty or not, if empty show message.

Please find below a small piece of code I wrote in VBA, this should help you achieve the result.

Private Sub Grid_BeforeLineChange(KeepFocus As Boolean)

If Description.Empty = True Then

MsgBox "Please Enter Distribution Reference"

Description.Focus

KeepFocus = True

End If

End Sub

Note: - You need to add that particular window to Visual Basic and also add field "Distribution Reference" to Visual Basic.

Hope this helps, let me know if you require any more assistance.

Cheers,

Shyam.