I have created updatable dashboard and I am having few issues with that.
On OrderDtl table, three fields are updatable, date01, number01 and checkbox01. Number01 and checkbox01 are working perfectly fine but having problem with date01. when I update/change the date on dashboard and save it, it saves but when I again try to delete the saved date, it doesn’t allow me to delete it. Even after deleting, previous date show up.
On the dashboard, when I make 1 or 2 changes and save it, it allows to save. when I make changes to multiple orders and hit save, it keeps on spinning for long time and then I need to close the dashboard without saving the changes.
Could anyone please help with these issues?
Any help is much appreciated
We have experienced the same issue with dates, where once a date is entered into a blank date in updateable dashboard, you cannot clear it out and save it. I don’t know how to fix it, but do have same behavior (905702a).
As far a multiple row update goes, do you have the multiple row update checked on the BAQ itself? Does it work ok in the BAQ, aside from the dashboard? Are you doing a normal save on the updateable dashboard, not multithreaded?
For the date related issue, I thought it to be a bug but it seems like it is general behavior of updateable dashboard. If you know, is there any work around for that?
Yes, I have checked multiple row update on the BAQ and it works fine on the BAQ. On the dashboard,I update the fields and do normal save. I don’t do multiple threaded save. Could you please let me know what is multiple threaded save used for?
I think the issue stems from the fact that Epicor doesn’t assign the necessary null value to a date field when it’s cleared, hence it doesn’t provide a valid value for the date field. You can probably work around this by allowing some trigger date (like 1/1/1901) so that you can check for this date in the BPM and change to null or change the action taken.
Your idea works. I created a BPM and added condition that if date is equal to 12/31/2016 (or any date) then set the date to null. Now users would need to set the date to 12/31/2016 on the dashboard to get blank date. Thank you very much.