Item Ledger Entries - wildcard search

(1) Share

Report

Posted on by AR-30040419-0

Kindly suggest me how I can use wildcard option in /Item ledger entries/ to search for specific characters at the beginning ?

Eg.
I want to search and filter all characters that begin with VMA07 in the /Document No/ filed

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (3)

Suggested answer

YUN ZHU 81,183 Super User 2025 Season 1 on at

Like (0)

Report

Item Ledger Entries - wildcard search

Hi, you can download the Productivity tips below, which contains many tips.

https://learn.microsoft.com/en-us/dynamics365/business-central/media/cheat_sheet.pdf

Hope this helps.

Thanks.

ZHU
Verified answer

Ben Baxter 5,611 Super User 2025 Season 1 on at

Like (1)

Report

Item Ledger Entries - wildcard search

Also, you don't have to filter. If you are only searching by a single field, you can just type vma07 in your search and it will find your information. The filter options are good if you need to save the results or if you need to filter by multiple fields.

The Search field doesn't require special characters it adds: @*SEARCH* where SEARCH is what you searched for. The filter is much more data specific, so if you type a lowercase value it will only look for lowercase.

Your filter would be: VMA07* you could also use @vma07*

Both should provide the results you're looking for.

I hope this was helpful, and if so please mark it as a Verified Answer to help other Users.

Best Regards,

Ben Baxter

Accent Software Inc
Verified answer

KasparsSemjonovs 4,177 Super User 2025 Season 1 on at

Like (1)

Report

Item Ledger Entries - wildcard search

Enter:
VMA07*
Verified answer

Judy Microsoft Employee on at

Like (1)

Report

Item Ledger Entries - wildcard search

Hi, Moved to Business central Forum.
You can use the filter criteria"VMA07*", For more information on sorting, searching, and filtering in Business Central:

Sorting, Searching, and Filtering Lists - Business Central | Microsoft Learn

Best Regards,

Judy