We have a testing environment in which I have a customization on the UD40 Table. Several fields are displayed and two fields are bound to Date Fields that were created on the OrderHed Table. Everything works great and displays without errors. I moved this entire UD40 and the customization to another test environment. I also created the OrderHed fields and regenerated the Data model. However when I launch the form I am getting an error on two fields which are date fields. Here is my error:
I have double checked the added field formats in Order Hed match in both environments exactly. I have also double check the Date fields have the exact same properties. Has anyone experienced this before. I even tried remaking one from scratch and binding it in the second test environment and that didn’t work either.
The Proof Date is another Date field that is throwing the error as well.There were two and the setting between them are both the same. I just took a screenshot of the other one. It’s also weird becuase I have another field that was added that is a date field and it is bound to a date time field and it is working fine.
Okay, that worked when I bound the exact same Date Time Field to OrderDtl.RequestDate. I didn’t get any errors and it worked fine. I think I will try deleting those fields I added. Regen the data model. Add the fields again and regen again.
I had to open the BAQ that contained those two fields. I removed them from the Display columns and then readded them. Once I readded them to the Query I loaded the Form again and voila they mapped fine.