Small and medium business | Business Central, N...

BC gives filter problem on ( if exist on an item BOM

(1) Share

Report

Posted on by DebbieG

480

Hi All,

I have a customer that has ( ) in her item codes and production BOMS. They've never noticed it before and I dont know if was always an issue, but if I edit a BOM with these characters in it, if gives me an error on filtering

The filter "CELS190GF(42)" is not valid for the No. field on the Production BOM Header table. An error occured while interpreting the filter: Did not expect '('. For more information, see https://go.microsoft.com/fwlink/?linkid=2158058.

Categories:

Dynamics 365 Business Central

I have the same question (1)

All responses (4)

Answers (0)

Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (2)

Report

same issue raised before:https://community.dynamics.com/forums/thread/details/?threadid=1ee38ff5-d3a6-4108-8183-ff0388d5217b
https://learn.microsoft.com/en-us/answers/questions/1460798/business-central-error-the-filter-004428-gp(v)-292

Is there any customization on it?

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

It looks like a standard problem. You can try removing the '()' to see if the problem still exists.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (0)

Report

The system doesn't like symbols in code fields. Rename the item no. to remove the () and it will work.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,200 Super User 2025 Season 2 on at

Like (0)

Report

not sure if you get the error when trying to import the boms into BC, but as experts commented, you need to clean up the data before bringing it in.

Was this reply helpful? Yes No