UD Date / DateTime fields cannot be nulled from a BPM

Epicor ERP 10
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

21

Did you ever find a solution to this issue? I also have a UD date field that I set to null in a BPM. The date field won’t display as blank until manually refreshing the UI.

22

Check the Ice.zDataField for that field. I believe it was an issue with default value settings. You can log a call with Epicor to get a data fix.