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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / BC gives filter proble...
Small and medium business | Business Central, N...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by DebbieG 418
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 (0)
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 8,156 Super User 2025 Season 2 on at
    BC gives filter problem on ( if exist on an item BOM
    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. 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 28,914 Super User 2025 Season 2 on at
    BC gives filter problem on ( if exist on an item BOM
    The system doesn't like symbols in code fields. Rename the item no. to remove the () and it will work. 
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 91,408 Super User 2025 Season 2 on at
    BC gives filter problem on ( if exist on an item BOM
    It looks like a standard problem. You can try removing the '()' to see if the problem still exists.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 19,093 Super User 2025 Season 2 on at
    BC gives filter problem on ( if exist on an item BOM

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,406

#2
Sumit Singh Profile Picture

Sumit Singh 2,852

#3
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,217

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans