Hello,
We are regularly getting the attached error when trying to updates addresses on the sales side of things. It's a Dual Write error saying Unable to write to Finance and Operations apps due to following error(s): {"Write failed for entity CDS postal address history V2 with unknown exceptionFor information on troubleshooting see https://go.microsoft.com/fwlink/?linkid=2244045. - Cannot create a record in Addresses (LogisticsPostalAddress). Invalid value specified for 'Expiration'. It cannot be less than the 'Expiration' of the last record."}
We know this is due to the validto date on the address being updated being newer than the most recent address on the LogisticsPostalAddress table in F&O but we do not know how to rectify this. We have attempted to delete the old expiration dates but we cannot.
Can someone help as to how to update these expiration dates in bulk? We need to correct thousands of them.
Also, we'd like to confirm what tables would even need to be updated in F&O and what the corresponding table names are in Sales.
Any help would be most appreciated as we can't get answers to this and we've tried several consultants and Microsoft.
thanks!
Bryan
