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!