Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Filter Not Working in ...
Finance forum
Suggested answer

Filter Not Working in FO side for Dual Write

Posted on by 267

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 

Categories:
  • RE: Filter Not Working in FO side for Dual Write

    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

  • ToddB Profile Picture
    ToddB on at
    RE: Filter Not Working in FO side for Dual Write

    Hi Mudassar,

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

    Thanks in advance.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Filter Not Working in FO side for Dual Write

    Tried this but not working

  • Ashik Patel Profile Picture
    Ashik Patel 267 on at
    RE: Filter Not Working in FO side for Dual Write

    try this

    Field == '1'

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Filter Not Working in FO side for Dual Write

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

  • Suggested answer
    Sheriffff Profile Picture
    Sheriffff 35 on at
    RE: Filter Not Working in FO side for Dual Write

    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.

  • ToddB Profile Picture
    ToddB on at
    RE: Filter Not Working in FO side for Dual Write

    Hi Ashik,

    I found the below documentation:

    Customize column mappings, add transforms, and enable filtering

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

  • Andre Arnaud de Calavon Profile Picture
    Andre Arnaud de Cal... 283,414 Super User on at
    RE: Filter Not Working in FO side for Dual Write

    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.

  • Ashik Patel Profile Picture
    Ashik Patel 267 on at
    RE: Filter Not Working in FO side for Dual Write

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

  • Andre Arnaud de Calavon Profile Picture
    Andre Arnaud de Cal... 283,414 Super User on at
    RE: Filter Not Working in FO side for Dual Write

    Hi Ashik,

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

Helpful resources

Quick Links

Upcoming TechTalk: Copilot Capabilities…

Review the Copilot features that are currently available in Dynamics 365 Finance…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,414 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,394 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans