Updatable Dashboard To Clear Part.Date03

Epicor ERP 9
1

I am trying to use an updatable BAQ / Dashboard to clear a user define date field (Part.Date03). This field has now been moved to an actual User Define table “Part_UD.CreatedDate”.

My plan was to use an updatable dashboard with the copy to excel and paste update back to the dashboard. However, the stubborn date field will not clear!!! I’ve even resorted to modifying the update expression to force the field to blank (null) but nothing I’ve tried so far works. I’ve also tried setting the update expression to ttPart.Date03 = ttPart.Date04 (date04 is an unused date field). But still, I can’t seem to get that date to wipe out.

I’ve ONLY been able to do this from a date / time editor control on a form customization. However, this is impractical because I have about 7,000 rows to clear. My goal is to “scrub” the Part.Date03 field so that it gets left behind when we move to E10. Any help would be greatly appreciated!!!

Running 905.702A, SQL Unicode DB

-Peter

2

Updatable Dashboard

Updateable BAQs/dashboards won’t clear a date field. This post addresses a workaround for the problem. You can enter a specific date such as 01/01/1901 in the dashboard and add a post-processing BPM to move in a null date value when the trigger date (01/01/1901) is found.