Dual Write Error - Query extended range failure: Syntax error near 94

The error "Query extended range failure: Syntax error near 94" was showing up when a Vendor was created in D365 FO. The setup includes Global Address Book with Vendor Concept based on Accounts.

The root cause of the issue was a typo in the Filter Condition - Left Hand Side - FO.

(((VendorPartyType == "Organization") || (VendorPartyType == "Person")) && (VendorGroupID != 'ABC'))

As described in the Filter documentation (Link), double quotes must be used for string instead of single quotes. The following query works fine.

(((VendorPartyType == "Organization") || (VendorPartyType == "Person")) && (VendorGroupID != "ABC"))

Cheers!