Skip to main content

Notifications

Announcements

No record found.

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

Account Category error

Posted on by 12
Hello
 
I am getting an error when trying to update my account subcategory in my chart of accounts in BC365. The error reads /The filter /116000|222000..223001|223003..223009|223011..223028|223031..223041|223045..223047|223049..223050|223200..223451|223472|223500..223505|223507..223548|223600..223603|223733|225500|226500..226501|226505..226506|226508|226512|226515|226518|226523|226526|/ is not valid for the G/L Account No. field on the G/L Entry table. The right side of '|' operators cannot be empty./
 
I understand that I need to clear out the last /|/ but I cannot find where to do that. When I pull up the G/L Account Categories screen I get the same error and the system states that it has nothing to display.
 
Can anyone help me understand how/where to fix this?
 
Thanks!
Categories:
  • AP-10051526-0 Profile Picture
    AP-10051526-0 12 on at
    Account Category error
    Thanks for the reply ZHU. Would you be able to explain how that could be done using the configuration package? I am not familiar with that funcitonality.
     
    Thanks,
    Alex
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    Account Category error
    Hi, how about using Configuration Package to clear this value? (Assign blank value)
     
    Thanks.
    ZHU
  • AP-10051526-0 Profile Picture
    AP-10051526-0 12 on at
    Account Category error
    Hi Saurav,
     
    I've attempted to complete the correction on this screen as well, but when I pull it up I get the same error message. I am able to view my groupings for assets, expenses, revenue, etc but I am unable to view the liabilities which is where the error is. I'm not sure where else to try and attempt to clear this out if the system is not letting me get to the category ranges to correct them.
     
     
    Thanks again for your replies,
    Alex
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,965 Super User 2024 Season 2 on at
    Account Category error
    Hi Alex,
     
    Open G/L Account Categories page and review Value in G/L Account in Categories.
     
    Correct the value in that field and try again.
     
    Regards,
    Saurav Dhyani
     
     
  • AP-10051526-0 Profile Picture
    AP-10051526-0 12 on at
    Account Category error
    Hi @Saurav,
     
    Thanks for the reply. I am getting this error when I am trying to update the account subcategory in the chart of accounts screen. We are looking to map accounts to specific subgroups for our financial statements. When I click the three dots to select an account sub-category, that is where this message comes up.
     
    Thanks,
    Alex
  • Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,965 Super User 2024 Season 2 on at
    Account Category error
    Hi,
     
    What action you are performing which is generating this error.
     
    Can you please share steps which end up with this error message?
     
    Regards,
    Saurav Dhyani

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans