UD Date / DateTime fields cannot be nulled from a BPM

Epicor ERP 10
1

Just ran across this bug which seems to be around for a while (It is present in 10.2.200 and 10.2.300 at least)
If you have a UD Field of data type (DateTime) or (Date) it appears that you cannot NULL out that date from a BPM and have it show refreshed on the screen without refreshing the screen.

Steps to Replicate

  1. Create a Date or Date Time Field (UD)
  2. Set the field on the UI of a form
  3. Populate the field with a date and hit save
  4. Write a BPM that sets that date to null
  5. Go back to the screen and invoke the BPM
    The BPM will run and the field will be nulled out (on the back end) but the UI will not report / refresh any changes
  6. Refresh the UI (The date clears)
2

Does it let you do DBNull.Value

3

On the BPM it won’t let you do Set Field to DbNull It says DateTime? is not compatible with DbNull…
Maybe in custom code casting it to an object first? (Let me try)

4

you might be right, its should be just null Interesting ill have to try it, I use alot of nulls.

ttPartRevRow["Date02"] = null;
quoteRow.tqh.ExpirationDate = null;
5

It does work (from a DB standpoint) it just doesn’t refresh the UI Bound Fields (until you hit refresh again on the UI)

6

Just tried DbNull that didn’t work either :’(

7

Your BPM needs to have a ShowMessage widget that displays:

“Record has been Modified by another user…”

:wink:

8

may i ask what did you use to null the date within your BPM ?

9

Set Field Widget = null
I also tried C# and I tired DBNull

10

could you try this [Default(DataTime?)] and see how the UI behave

image
image.png989Ă—914 63.2 KB

11

No luck , same result.

12

then you are right, it needs to run the refresh command from customisation, it is the same on 10.1.400.20 as well i went round this by hiding the field after setting it to blank

13

Seem like they don’t want nullabe DateTime’s in BPMs.

You can make nullable variables of other valued types, but not DateTime

image

1 Like
14

@josecgomez - Was your problem that you cant set a Date or DateTime to null in a BPM?

Or that it isn’t reflected in the UI without a refresh?

While a MD does not allow setting a DateTime field to null, a DD does. So what might work as a hack would be to have a DD that monitors for a specific date (like 11/24/1966) and then changes it to null when when it matches.

15

It doesn’t reflect in UI until refresh

1 Like
16

I thought I had ran into this before but I just tried it in 10.2.300.19 and it cleared just fine. I added a UD column on Company with a type of Date and null it, using set field, with a pre-processing directive on Update. No screen refresh needed. Seems like the same use case just possibly a different screen/method and version?

1 Like
17

I tried ABCCode and Vendor and 2 different Major versions of Epicor. (10.2.200, 10.2.300)
Are you nulling it on the BPM Side?

18

Yes - I am setting the field to null only in the BPM.

19

That’s strange… and it is a UD Field? What table?

20

image
image.png1804Ă—947 206 KB