"Error" message using Import to clear user input date data
In a daily replenishment planning model I've recently deployed for a customer, everyday, the planners may need to manually override below line items (format in brackets):
ADS Values (number)
ADS % Changes (%number)
Cancel Order? (boolean)
Manual Order Input (number)
Override Delivery Date (date)
Hence, I created a clearing process to clear out previous day inputs every morning when they refresh the data
1. Built a clearing module with 5 line items matching the same data formats as target line items (listed above)
2. Keep data fields as 0/false/blank
3. Run import from target module to pull data from the clearing module
The actions work perfectly for the first 4 targets. For clearing out the dates, an "error" message attached in screenshot will appear. I double quoted the error because in fact, the dates are cleared out successfully, yet Anaplan is throwing the message.
I have played around with different options with date formats or set as No Data, but the "error" message still exist. For now I put it as the last step of the process so that it won't affect other actions and asked the customer to ignore the message. But definitely this is not a preferred way to handle this.
Not sure anyone encountered such situation before or it is a platform bug. Any insights/workarounds will be appreciated.