web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Filter Not Working in FO side for Dual Write

(0) ShareShare
ReportReport
Posted on by 277

Hello Team,

i applied filter in D365 Finance and operations in Dual Write but it is not working

Filter type : Not equal

i also tried below 

(accountnumber ne null)

(accountnumber ne '')

(accountnumber != null)

(accountnumber != '')

please give me any suggestions 

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    305,718 Super User 2026 Season 1 on at

    Hi Ashik,

    Are you applying the filter on the F&O side or Dataverse side? What is the field type you try to filter?

  • Ashik Patel Profile Picture
    277 on at

    I applied filter in F&O side and field type is string

  • André Arnaud de Calavon Profile Picture
    305,718 Super User 2026 Season 1 on at

    In that case, I would expect that accountnumber != "" should work. However, I have not used filters to exclude records where a certain field is empty.

  • ToddB Profile Picture
    Microsoft Employee on at

    Hi Ashik,

    I found the below documentation:

    Customize column mappings, add transforms, and enable filtering

    docs.microsoft.com/.../customizing-mappings

  • Suggested answer
    Sheriffff Profile Picture
    35 on at

    Hi Ashik, this filter in the dual write FO and CE sides worked with me after several tries:

    1. FO side filters:

    A. Equal:

    Single Enum filter: (FieldName == EnumType::Test)
    Multiple Enum filters: ((FieldName == EnumType::Test) && (FieldName != EnumType::Test))

    Single String filter: (FieldName like "Test")
    Multiple String filters: ((FieldName like "Test") && (!(FieldName like "Test")))

    B. Not equal:

    Enum filter: (FieldName != EnumType::None)
    String filter: (!(FieldName like "Test"))

    2. CE side filters:

    A. Equal:

    Single Enum filter: FieldName == ‘Test’
    Multiple Enum filters: FieldName == ‘Test’ and FieldName == ‘Test’

    Single String filter: FieldName eq ‘Test’
    Multiple String filters: FieldName eq ‘Test’ and FieldName eq ‘Test’

    B. Not equal:
    Enum filter: FieldName != ‘Test’ (not sure)
    String filter: FieldName ne ‘Test’

    All experts please feel free to add your inputs here please.

    Don't forget the brackets!

    If this is helping, please mark my answer.

  • Community Member Profile Picture
    on at

    Hi, Can you help me in applying Dataverse filter for Yes/No field?  I have tried field = 1 but not working

  • Ashik Patel Profile Picture
    277 on at

    try this

    Field == '1'

  • Community Member Profile Picture
    on at

    Tried this but not working

  • ToddB Profile Picture
    Microsoft Employee on at

    Hi Mudassar,

    If you are still needing assistance, please start a new thread regarding your filter question.

    Thanks in advance.

  • pierre-olivier.pujol@elca.ch Profile Picture
    93 on at

    Hello,

    What about the records wich are attached to the Customer... When you filter out a customer, if you sync Sales Orders and the Customer is not in CRM, an error will prompt (due to Customer was not sync).

    Is it possible to filter Sales Orders based on a filter on Customer ?

    Thank you for any advice!

    POP

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 565 Super User 2026 Season 1

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 487 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 413

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans