I am trying to create connections to MS Business Central (BC) using the web service URLs provided in BC. These are ODATA V4 end points and I am using the ODATA connector in CDS. When I use this method to create a new entity it errors out saying
Load to Common Data Service failed. Details: Bad Request {"error":{"code":"0x80040239","message":"DateTime is less than minumum value supported by CrmDateTime. I believe this is occurring because some of the date records are null in BC. Despite the error, the entity is still created.
The resulting entity consists of 2 columns in the data tab, my primary key (Job Number) and the date on which the entity was created (i.e. today). When I select the entity and look at the fields tab, all of the field names, data types and CDS type (custom or standard) are populated. The issue is when I look at the data tab which is where I am only seeing the two columns listed above. My ask is:
1) Can I correct the date error without having to backfill the dates in BC (aka. allow null values)
2) Will that correct the issue with my fields not pulling in or is there something else going on here?
See attached for a screenshot of my resulting data tab and fields tab for this entity.
