Force UserID lowercase when adding new

Epicor ERP 10
1

How in the hell do I create a BPM that will convert whatever someone enters as the User ID when creating a new user to be all lowercase?

I’ve tried writing a BPM that checks for added row on the UserFile table and then sets the UserFile.UserID table to the expression BpmFunc.ToLower(UserFile.UserID) (tables simplified for explanation; what’s available is ds… and tt…).

I’ve done this as a Data Directive on the UserFile table and as Pre-, Base-, and Post-Processing on the UserFile/Update method, but i can’t even get a info message to trigger as the first action, other than on the DD.

None of these updates the field to be lowercase. Also, I noticed in running a BAQ on the UserFile and SysUserFile tables that the record doesn’t get added to the table until after a company has been added and the record saved. However, when I input the UserID and Description, then save, the UserID field goes gray.

Traces seem to indicate that I’m using the correct method, table, and field, so what gives??

2

I thought the table that you would be needing was the ICE.SysUserFile?

1 Like
3

You should be able to grab during DD processing as part of the dataset with condition check:

image
image1165×849 151 KB

1 Like
4

Ya I had that part typed up and went to make the pic for him :stuck_out_tongue: You too fast for me :wink:

5

hey isnt it the fastest man alive GIF by Saturday Night Live

3 Likes
6

Guess I should have read the whole post and I could have given the same answer wrong table :wink:

7

That did it. I started there (forgetting that I had), but must have entered something incorrectly, because it didn’t work so I moved on to UserFile.

Either way, should have trusted my instinct and ignored the trace in this case. :man_shrugging: