Wildcard searches in account numbers

(0) Share

Report

Posted on by createplayact

We are starting to plan out our (six digit) account number structure for conversion to D365 BC, and I had a question about how wildcards can be used in the search interface.

In BC, can I do any of these kinds of searches to find all account numbers where "3" is the third digit of a six digit number?

**3

**3*

**3***

Thanks for your thoughts on this.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Brad_P 1,549 on at

Like (1)

Report

You can use wildcards when filtering; searches will do a match on what is typed.

If you're looking for a 'wildcard' filter you can use both '?' and '*'

2* - account that begins with a 2

2?5* - account that begins with a 2, has any character, followed by a 5 and any combination afterwards

2?5?? - account that begins with a 2, has any character, followed by a 5 and any two characters

* is any and ? is individual.

Was this reply helpful? Yes No
createplayact 5 on at

Like (0)

Report

Perfect, that's good to hear.

So, in my case this would give me what I need:

??3*

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Just adding to Brad's reply.

You can find all info from the following MS docs.

https://docs.microsoft.com/en-us/dynamics365/business-central/ui-enter-criteria-filters#fine-tuning-the-search-with-filter-criteria

And Business Central - Productivity tips:

https://trinsoft.com/wp-content/uploads/2020/04/BC-Productivity-Tips.pdf

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No